prepare financial reports

when you have finished, save the file. Part 2 - Preparation of final accounts For Part 2 of this case study you are provided with the following e provided with the following excel spreadsheet file BSBFIA401 Part 2 Final Accounts You are required to complete a series of tasks to produc accounts excel file. Use the appropriate templates. This excel your student email account. Series of tasks to produce the final BSBFIA401 part 2 final e appropriate templates. This excel file will be emailed to you through The following Trial Balance was extracted from the records of Micro System 30th June 2019. extracted from the records of Micro Systems, for the year ended Required Task 2.1 - Prepare the General Ledgers by entering the opening balances from the Trial Balance provided on the next page Micro Systems Trial Balance as at 30th June 2019. Debit Credit 2,160 7,000 3,000 100 130,695 31,600 8,400 DY Account Name Preciation Accumulated Depreciation - equipment Accumulated depreciation - motor vehicle Advertising Allowance for doubtful debts Sales Capital - John Franklin Cash at bank Accounts Payable Control Accounts Receivable Control Drawings - John Franklin Equipment at cost GST Collected GST Paid Residential Rent Received Loan to Martha Stewart Motor Vehicle - at cost Provision for Annual Leave Purchases of inventory Insurance Repairs and maintenance - equipment Stock of inventory (1 July 2018) Office expenses Wages 4,500 9,000 5,400 32,200 3,560 2,165 11,500 10,000 22,000 500 54,000 2,600 1,450 5,000 6,400 30,000 191,615 191,615 when you have finished, save the file. Part 2 - Preparation of final accounts For Part 2 of this case study you are provided with the following e provided with the following excel spreadsheet file BSBFIA401 Part 2 Final Accounts You are required to complete a series of tasks to produc accounts excel file. Use the appropriate templates. This excel your student email account. Series of tasks to produce the final BSBFIA401 part 2 final e appropriate templates. This excel file will be emailed to you through The following Trial Balance was extracted from the records of Micro System 30th June 2019. extracted from the records of Micro Systems, for the year ended Required Task 2.1 - Prepare the General Ledgers by entering the opening balances from the Trial Balance provided on the next page Micro Systems Trial Balance as at 30th June 2019. Debit Credit 2,160 7,000 3,000 100 130,695 31,600 8,400 DY Account Name Preciation Accumulated Depreciation - equipment Accumulated depreciation - motor vehicle Advertising Allowance for doubtful debts Sales Capital - John Franklin Cash at bank Accounts Payable Control Accounts Receivable Control Drawings - John Franklin Equipment at cost GST Collected GST Paid Residential Rent Received Loan to Martha Stewart Motor Vehicle - at cost Provision for Annual Leave Purchases of inventory Insurance Repairs and maintenance - equipment Stock of inventory (1 July 2018) Office expenses Wages 4,500 9,000 5,400 32,200 3,560 2,165 11,500 10,000 22,000 500 54,000 2,600 1,450 5,000 6,400 30,000 191,615 191,615