Task 1 You have been provided with an Excel File which contains the General Journal and Ledger Accounts. The necessary accounts as well as blank accounts to be used if needed have been included. You will need to complete this task by entering the relevant information into the excel spreadsheet provided. To set up Minnie's new system, enter the information below from the chart of accounts and schedules as an Opening Entry into the General Journal and post the relevant information to the General Ledger Accounts provided in the excel file. Min Armim Wasteage : Chart of Accounts as at 1 July 2020 090 091 610 611 111 113 115 116 140 141 150 151 160 161 800 205 210 220 299 820 Bank Petty Cash Accounts Receivable Control Allowance for Bad and Doubtful Debts Inventory Stationery on Hand Prepaid Insurance Prepaid Rent Equipment Acc. Depreciation - Equipment Premises Accumulated Depreciation - Premises Vehicle Acc. Depreciation - Vehicle Accounts Payable Control Office Supplies Owing Internet and Telephone Expenses Payable Wages Expense Payable Big 4 Bank Mortgage Loan (5-year) GST Capital - Minnie Armin 3860 210 13585 462 3090 130 1800 10000 6400 1460 140000 21000 23000 229 7887 186 481 862 123000 950 45558 900 Additional Notes Acc. No. 61001 61003 61005 61007 Schedule of Accounts Receivable as at 1 July 2020 Unplugged Limited 726 The Charity Stores 2.310 Developing Naturally 4.455 Hotels United 6,094 13,585 80001 80003 80005 Schedule of Accounts Payable as at 1 July 2020 Get Connected Limited 4,180 Reduce, Reuse, Get Rich 1,760 Flooded Industries 1,947 7,887 You will need to enter this information into the appropriate subsidiary ledger accounts. A B C D E Date Details Posting Reference DR CR 1 2 3 5 6 7 8 9 10 11 12