please solve it in excel and screen shoot it

Weekly practice This section of the practical is designed to allow you to compare how a basic General Journal and Ledger System operates with a system of Specialised Journals. You should be taking note of the different data entry processes and the efficiencies that can be achieved as well as any difficulties that arise with the more complex system 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. The opening and reversing entries have been completed for you You will be re-entering the transaction data from Completion Point 1 as well as a number of new transactions into the "new" system using specialised journals Task 1 Using the excel file provided for Completion Point 2 you must enter the transactions below into the Specialised Journals and then update the Ledger accounts as required. (The transactions below include previous transactions that you have completed using only the General Journal and a number of new transactions) Transactions July 1 July 2 July 5 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST) Received a cheque for S575 from Vin Walker as part payment of their account July 8 July 12 July 13 Issued Cheque number 718 to Flooded Industries. The cheque amount was $782.10 and a discount of $86.9 (including GST of $7.90) was received for early payment. Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a total freight charge of $50 and total GST of $85 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report. Purchased 1000 Energy Saving light globes for $3 each from Get Connected Ltd. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST) July 15 Transactions continued July 16 July 16 July 20 July 20 Paid wages of $1,680 to Minnie's two part time employees Lei Zhee and Ena Jetic Made a cash purchase of $160 stationery (net of GST) from Little M department store. Cash Sale to Mr D Rock of 5 LED Lighting Kits for a total of $275 (including GST) Received a cheque from Unplugged Ltd of $1100 being full settlement of their account The office supplies account of $186 was paid in full in cash. Minnie Armim withdrew $1,050 cash for personal use Made a cash payment of $672.10 (including GST) to The Big Telco for telephone usage. July 23 uly 25 July 27 A stocktake on July 31 reveals $10 540 worth of inventory on hand Task 2 Once you have completed the data entry above, you will need complete Schedules for Accounts Receivable and Accounts Payable and you will need to create a Balance Sheet dated 31 July 2018 Remember at this point accuracy of data entry is being checked, however the majority of the marks will be awarded based on the fact that all transactions have been entered osting Reference DR CR Details 205 862.00 Wages Expense Payable Accrued Telephone Expense Office Supplies Owing GST Payable Big 4 Bank Mortgage Loan (5-year) Capital Minnie Armin 210 481.00 220 186.00 1,950.00 123,000.00 75,369.00 299 250 303 Opening Entry 205 862 Wages Expense Payable 505 862 Wages Expense Reversing Entry Details CR Reference DR Cash I 103 250.00 Bank 105 3,860.00 107 15,038.00 Unprugged Ltd- 660 Vin Walker-1795 The Stores - 480 6111 Dental Services SA-2552 Hotels United 3440 Inventory on Hand 8,208 on Hand 113 130.00 115 1,800.00 Rent 116 10,000 Premises 140 140,000. Vehicle 150 23,000 160 6,400.00 GST Receivable 199 Allowance for Bad and Doubtful Debts 109 462 ACC tion-Vehicle 151 229.00 Accumulated tion E 161 1460 Accounts Payable Control 207 ,687.0 Get Connected Ltd- 4250 Reduce, Reuse, Get Rich-568 Flooded Industries 869 Weekly practice This section of the practical is designed to allow you to compare how a basic General Journal and Ledger System operates with a system of Specialised Journals. You should be taking note of the different data entry processes and the efficiencies that can be achieved as well as any difficulties that arise with the more complex system 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. The opening and reversing entries have been completed for you You will be re-entering the transaction data from Completion Point 1 as well as a number of new transactions into the "new" system using specialised journals Task 1 Using the excel file provided for Completion Point 2 you must enter the transactions below into the Specialised Journals and then update the Ledger accounts as required. (The transactions below include previous transactions that you have completed using only the General Journal and a number of new transactions) Transactions July 1 July 2 July 5 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST) Received a cheque for S575 from Vin Walker as part payment of their account July 8 July 12 July 13 Issued Cheque number 718 to Flooded Industries. The cheque amount was $782.10 and a discount of $86.9 (including GST of $7.90) was received for early payment. Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a total freight charge of $50 and total GST of $85 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report. Purchased 1000 Energy Saving light globes for $3 each from Get Connected Ltd. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST) July 15 Transactions continued July 16 July 16 July 20 July 20 Paid wages of $1,680 to Minnie's two part time employees Lei Zhee and Ena Jetic Made a cash purchase of $160 stationery (net of GST) from Little M department store. Cash Sale to Mr D Rock of 5 LED Lighting Kits for a total of $275 (including GST) Received a cheque from Unplugged Ltd of $1100 being full settlement of their account The office supplies account of $186 was paid in full in cash. Minnie Armim withdrew $1,050 cash for personal use Made a cash payment of $672.10 (including GST) to The Big Telco for telephone usage. July 23 uly 25 July 27 A stocktake on July 31 reveals $10 540 worth of inventory on hand Task 2 Once you have completed the data entry above, you will need complete Schedules for Accounts Receivable and Accounts Payable and you will need to create a Balance Sheet dated 31 July 2018 Remember at this point accuracy of data entry is being checked, however the majority of the marks will be awarded based on the fact that all transactions have been entered osting Reference DR CR Details 205 862.00 Wages Expense Payable Accrued Telephone Expense Office Supplies Owing GST Payable Big 4 Bank Mortgage Loan (5-year) Capital Minnie Armin 210 481.00 220 186.00 1,950.00 123,000.00 75,369.00 299 250 303 Opening Entry 205 862 Wages Expense Payable 505 862 Wages Expense Reversing Entry Details CR Reference DR Cash I 103 250.00 Bank 105 3,860.00 107 15,038.00 Unprugged Ltd- 660 Vin Walker-1795 The Stores - 480 6111 Dental Services SA-2552 Hotels United 3440 Inventory on Hand 8,208 on Hand 113 130.00 115 1,800.00 Rent 116 10,000 Premises 140 140,000. Vehicle 150 23,000 160 6,400.00 GST Receivable 199 Allowance for Bad and Doubtful Debts 109 462 ACC tion-Vehicle 151 229.00 Accumulated tion E 161 1460 Accounts Payable Control 207 ,687.0 Get Connected Ltd- 4250 Reduce, Reuse, Get Rich-568 Flooded Industries 869