task 2.1. prepare the general ledger by enetring the opening balanc from trial balane

Task 1.3 - Prepare a depreciation schedule for 30/6/2019 Using the information that you prepared in your assets registers please compie depreciation schedule for the year ended 30/6/2019, located in the excel file u depreciation Sch tab ted in the excel file under the 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 excel spreadsheet file BSBFIA401 Part 2 Final Accounts You are required to complete a series of tasks to produce the final BSBFIA401 part 2 final accounts excel file. Use the appropriate templates. This excel file will be emailed to you through your student email account. The following Trial Balance was extracted from the records of Micro Systems, for the year ended 30th June 2019. Required Task 2.1 - Prepare the General Ledgers by entering the opening balances from the Trial Balance provided on the next page Task 2.2 - Prepare General Journal entries to record the balance day adjustments as at 30th June 2019 and post to the General Ledger, Task 2.3 - Prepare General Journal entries to close the relevant ledgers on 30th June 2019 and post to the General Ledger. Task 2.4 - Prepare a post-closing Trial Balance as at 30th June 2019 Micro Systems Trial Balance as at 30th June 2019. Debit Credit 2,160 7,000 3,000 100 130,695 31,600 8,400 4,500 DY Account Name Depreciation Accumulated Depreciation - equipment Accumulated depreciation - motor vehicle Advertising Allowance for doubtful debts Sales Capital - John Franklin Dipol GCash 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 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 Yersinn 30/1/2020