please please do it in excel, dont do it as hand writting, cause it's difficult to read for some reason
https://docs.google.com/file/d/19OEkdZAtXPLAEbwZEyHwj3C4E6MAsFGW/edit?usp=docslist_api&filetype=msword
here is link drive for more detail
Practical Completion Point 2 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. July 2 Task 1 Using the excel file provided for Completion Point 2 you must enter the transactions below into the Spesialises 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 Sold 40 Energy Saving light globes on credit to Unplugged Lad for $440 (including GST) Received a cheque for $2475 from Developing Naturally as part payment of their account. Sold 2 Smart Meters to The Charity Stores for $350 cach plus a $50 delivery fee (all amounts are not of GST) Issued Cheque number 718 to Flooded Industries. The cheque amount was $1752.30 and a discount of $194.7 (including GST of $17.70) was received for early payment. July 8 Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a freight charge of $50 and total GST of $85. July 12 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report. July 13 Purchased 500 Energy Saving light globes for $3 each from Get Connected Lid. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726. July 4 July 6 July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 cach (net of GST). Transactions continued y 16 July 16 July 19 July 20 July 20 Padwages of $1.680 to Miank's we part in comployees Labor and Eos Letis Midea dich purchase of story of () Tom Little M deputet store Purchased IS LED Lighting Kits for a total of 8330 (GST inchesive) from Flooded Industries Cash Sale to Mr D Rock of LED Lighting Kits for a total of $275 (including GST) Received a cheque from Unplugged Lad of S1166 being full settlement of their Account Sold 100 meters of premium low voltage cable to Unplugged Lad for $20 per meter (niet of GST) the office supplies account of ST 86 was paid in full in cash. Minnie Arun withdrew SLOSU cash for personal use. Sold 3 Set Meters to Hotels United for 350 each plus a delivery fee of $100 and are net of GST) Paid all amounts owing to Reduce, Reuse. Get Rich. Made a cash payment of 5921 (including S40 GST) to The Big Telco for the last two months telephone and internet usage. July 21 July 23 July 25 July 27 July 29 July 30 Astocktake on July 31 reveals S4 140 worth of inventory on band and S114 of stationery on hand, Prepaid insurance was paid for 3 months in advance on June 30, 2020. Prepaid rent was paid for 6 months in advance on 1 June, 2020 Dayton Lawly calculated at the end of the financial war and adjustments are nequired for these account Task 2 Once you have completed the data by above. You will need complete Schedules for Accounts Receivable and Accounts Payable and you wneed to create a Balance Sheet dated 31 July 2020, 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 transactions have been entered Submission Requirements Once you have completed the data entry in the above two tasks you will need to upload your acel le to learpooline so they can be checked for completeness. At this part orurety of data entry is being checked but is not the prime for the making The majority of marks are awarded to transaction Move been entered by following the content reports how been rly created as prited the steen war to achieve the correct result which they can then compare to the feedback provided after all Submissions are Det CR 11 619 . . Devergry-4455 115 50 Posted Cash Payments al Dube Parts Dit Accounts Payable Other Pan 113 EPE 14 1/ 111 Armud Depression from 191 LE 30 DOROT 205 110 270 120 GA 000 350 DO 45.55.00 Sales freight DAT Date Power Postel GM 22 GST Date Postal Purchases Returns Date Pout het Pre Return Free 200 LMH0 Wage Wap os Les 550 41 201 200 Swing 10 Reven Account No.001 DATE POST RET DET CREDITS PE 210 DATE DUPLARATION POST CREDITS TOP ANGLO BALANCE DA LANAON POST DEBITS DAN CREDIT TES va Entry Afer Band Det Debts Ace 63 BALANCES CREDO DEBITS EXPLANATION POST DATE A 111 Related Depreciation - Premis DATE BEPLANATION POSTRE DETS AGEN 151 BALANCES CREDITS Openingstry GI 21000 21000 Vehicle DATE DARATION DERIT CREDIT Account No. 150 LALANCE 151 Opening Estry GI 21000 DATE POSTER BALANCE GRID MON enery DATE EXPLANATION POSTER DET CREDIT NI Acumulated Depreciation. Veiche DXPLANATION Account No. 161 BALANCE POSTER DENT CREDITS 22 Equipment DETS POST REA CREDITS DATE MALANCE DEPLANATION Mei CREDIT BALANCE DATE DURANTIR POSTE DET 1800 CRED MUNCESE DATE PLANATO DEBITIS 10000 100 DATE BALANCE DUPLANATION POSTRES CREDIT 150 DEBIT (51 we 1400 Opening Entry Acumulated Depreciation. Event Account No. 141 BALANCE DATE DIPLANATION DEBIT (52 CREDITS NO 1450 14 Account N. 199 LALANCE DATE DOPLANATION POST REF DEBITS CREDITS General ledger-ABUITIES Accounts Payable Account No. 100 BALANCE 15 DATE EXPLANATION POST REF DERIT SI CREDIT 151 767 TART Opening Entry Wages Expene Payable Big 4 Bank Mortgage Loan DATE EXPLANATION POST REF DEBIT (5) CREDITS Account No. 250 BALANCE (5) -01 Opening Cetry 123000 1000 DATE EXPLANATION POST REF DEBIT 1 CREDITS Account BALANCE (S1 General ledger -INCOME Ne be CH 481 GAT 1 Telem A No MALANCE DATE EXPLANATION POSTAL DENTS CREDITS Account BALANCE 51 DATE EXPLANATION POST REF DEBIT (SI CREDIT (51 General ledger-ENSE ENPLAN DIT CREO Om Spring EXPLANATION STANE Mei Me 1 peetan 18 10 GAST DATE EXPLANATION POTRE DENT CREDIT LALANCES NOL G wie PURCHASES DATE EXPLANATION POSTER . DEBITCH CREDITS Account No MALANCE Freight werde DATE EXPLANATION POST REF DEBIT SI CREDITS Account BALANCE SI Wapen tape DATE EXPLANATION POST REF. DEBITS CREDITS Account No. 505 MALANCE BUTY PO CREDITS relo POSTRE DET CREDIT Hotel United Recent ho 100T BALANCE 99 DATE EXPLANATION POSTRE DETS CREDITS Opening Entry GOS 6094 De Subsidiary ledger PAYABLE Get Coated heute. O BALANCES DATE EXPLANATION POSTRE DENTIS CREDIT Opening Entry 4110 411 GF Reduce, Reve, Get Rich 53001 CR50 DATE EXPLANATION Account No 80003 BALANCE SI DATE EXPLANATION POST REF DEBIT (5) CREDITS CH MM-01 Opening Entry 1780 FLOODED INDUSTRIES Account N 0005 BALANCES DATE EXPLANATION POST REF. DEBIT (5 CREDITS IND Opening Entry Dr GI 726 726 N-01 Opening Entry The Charity Stores Account No. 61003 BALANCE (S1 DEBIT (5) CREDIT (5) DATE EXPLANATION POST REF. Dr GJ 2310 2310 101 Opening Entry Developing Naturally Account No. 61005 BALANCE (5) DATE EXPLANATION POST REF DEBIT (5) CREDIT (5) 4455 Dr Jul-01 Opening Entry 4455 Body DI 14 B Practical Completion Point 2 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) July 2 July 6 Transactions July 1 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST). Received a cheque for $2475 from Developing Naturally as part payment of their account. July 4 Sold 2 Smart Meters to The Charity Stores for $350 each plus a $50 delivery fee (all amounts are net of GST) Issued Cheque number 718 to Flooded Industries. The cheque amount was $1752.30 and a discount of S194.7 (including GST of $17.70) was received for early payment Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a 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. July 13 Purchased 500 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. July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST). July 8 July 12 Transactions continued July 16 July 16 Paid wages of $1,680 to Minnie's two part time employees Lei Zhee and Ena Jclic Made a cash purchase of $60 stationery (net of GST) from Little M department store Purchased 15 LED Lighting Kits for a total of $330 (GST inclusive) from Flooded Industries July 19 July 20 July 20 July 21 July 23 July 25 July 27 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 S1166 being full settlement of their account Sold 100 meters of premium low voltage cable to Unplugged Ltd for $20 per meter (net of GST) The office supplies account of $186 was paid in full in cash. Minnie Amnim withdrew $1,050 cash for personal use. Sold 3 Smart Meters to Hotels United for $350 each plus a delivery fee of $100 (all amounts are net of GST) Paid all amounts owing to Reduce, Reuse, Get Rich. Made a cash payment of $921 (including S40 GST) to The Big Telco for the last two months telephone and internet usage. July 29 July 30 A stocktake on July 31 reveals 54 140 worth of inventory on hand and $114 of stationery on hand Prepaid insurance was paid for 3 months in advance on June 30, 2020. Prepaid rent was paid for 6 months in advance on 1 June, 2020. Depreciation is only calculated at the end of the financial year and so no adjustments are required for these accounts. 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 2020. Remember of 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, Submission Requirements Once you have completed the data entry in the above two tasks, you will need to upload your excel file to leacoaglios, so they can be checked for completeness. At this point accuracy of data entry is being checked but is not the primary focus of the marking. The majority of marks are warded if all transactions have been entered by following the correct fx Cash Receipts Journal Cash Receipts Journal OST Date Cash Payments Journal GST Posted Dune Sales Journal Accounts Rova Du Particulars GST Sales Returns Journal Sales Pole GST Purchases Journal Acco Payable Purchases Returns lournal Purcate Account GST Practical Completion Point 2 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. July 2 Task 1 Using the excel file provided for Completion Point 2 you must enter the transactions below into the Spesialises 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 Sold 40 Energy Saving light globes on credit to Unplugged Lad for $440 (including GST) Received a cheque for $2475 from Developing Naturally as part payment of their account. Sold 2 Smart Meters to The Charity Stores for $350 cach plus a $50 delivery fee (all amounts are not of GST) Issued Cheque number 718 to Flooded Industries. The cheque amount was $1752.30 and a discount of $194.7 (including GST of $17.70) was received for early payment. July 8 Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a freight charge of $50 and total GST of $85. July 12 Received $450 cash (net of GST) from Ms Elvia Marks for a full house inspection and energy usage report. July 13 Purchased 500 Energy Saving light globes for $3 each from Get Connected Lid. The delivery charge was $100. All amounts are net of GST. Their invoice No: 726. July 4 July 6 July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 cach (net of GST). Transactions continued y 16 July 16 July 19 July 20 July 20 Padwages of $1.680 to Miank's we part in comployees Labor and Eos Letis Midea dich purchase of story of () Tom Little M deputet store Purchased IS LED Lighting Kits for a total of 8330 (GST inchesive) from Flooded Industries Cash Sale to Mr D Rock of LED Lighting Kits for a total of $275 (including GST) Received a cheque from Unplugged Lad of S1166 being full settlement of their Account Sold 100 meters of premium low voltage cable to Unplugged Lad for $20 per meter (niet of GST) the office supplies account of ST 86 was paid in full in cash. Minnie Arun withdrew SLOSU cash for personal use. Sold 3 Set Meters to Hotels United for 350 each plus a delivery fee of $100 and are net of GST) Paid all amounts owing to Reduce, Reuse. Get Rich. Made a cash payment of 5921 (including S40 GST) to The Big Telco for the last two months telephone and internet usage. July 21 July 23 July 25 July 27 July 29 July 30 Astocktake on July 31 reveals S4 140 worth of inventory on band and S114 of stationery on hand, Prepaid insurance was paid for 3 months in advance on June 30, 2020. Prepaid rent was paid for 6 months in advance on 1 June, 2020 Dayton Lawly calculated at the end of the financial war and adjustments are nequired for these account Task 2 Once you have completed the data by above. You will need complete Schedules for Accounts Receivable and Accounts Payable and you wneed to create a Balance Sheet dated 31 July 2020, 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 transactions have been entered Submission Requirements Once you have completed the data entry in the above two tasks you will need to upload your acel le to learpooline so they can be checked for completeness. At this part orurety of data entry is being checked but is not the prime for the making The majority of marks are awarded to transaction Move been entered by following the content reports how been rly created as prited the steen war to achieve the correct result which they can then compare to the feedback provided after all Submissions are Det CR 11 619 . . Devergry-4455 115 50 Posted Cash Payments al Dube Parts Dit Accounts Payable Other Pan 113 EPE 14 1/ 111 Armud Depression from 191 LE 30 DOROT 205 110 270 120 GA 000 350 DO 45.55.00 Sales freight DAT Date Power Postel GM 22 GST Date Postal Purchases Returns Date Pout het Pre Return Free 200 LMH0 Wage Wap os Les 550 41 201 200 Swing 10 Reven Account No.001 DATE POST RET DET CREDITS PE 210 DATE DUPLARATION POST CREDITS TOP ANGLO BALANCE DA LANAON POST DEBITS DAN CREDIT TES va Entry Afer Band Det Debts Ace 63 BALANCES CREDO DEBITS EXPLANATION POST DATE A 111 Related Depreciation - Premis DATE BEPLANATION POSTRE DETS AGEN 151 BALANCES CREDITS Openingstry GI 21000 21000 Vehicle DATE DARATION DERIT CREDIT Account No. 150 LALANCE 151 Opening Estry GI 21000 DATE POSTER BALANCE GRID MON enery DATE EXPLANATION POSTER DET CREDIT NI Acumulated Depreciation. Veiche DXPLANATION Account No. 161 BALANCE POSTER DENT CREDITS 22 Equipment DETS POST REA CREDITS DATE MALANCE DEPLANATION Mei CREDIT BALANCE DATE DURANTIR POSTE DET 1800 CRED MUNCESE DATE PLANATO DEBITIS 10000 100 DATE BALANCE DUPLANATION POSTRES CREDIT 150 DEBIT (51 we 1400 Opening Entry Acumulated Depreciation. Event Account No. 141 BALANCE DATE DIPLANATION DEBIT (52 CREDITS NO 1450 14 Account N. 199 LALANCE DATE DOPLANATION POST REF DEBITS CREDITS General ledger-ABUITIES Accounts Payable Account No. 100 BALANCE 15 DATE EXPLANATION POST REF DERIT SI CREDIT 151 767 TART Opening Entry Wages Expene Payable Big 4 Bank Mortgage Loan DATE EXPLANATION POST REF DEBIT (5) CREDITS Account No. 250 BALANCE (5) -01 Opening Cetry 123000 1000 DATE EXPLANATION POST REF DEBIT 1 CREDITS Account BALANCE (S1 General ledger -INCOME Ne be CH 481 GAT 1 Telem A No MALANCE DATE EXPLANATION POSTAL DENTS CREDITS Account BALANCE 51 DATE EXPLANATION POST REF DEBIT (SI CREDIT (51 General ledger-ENSE ENPLAN DIT CREO Om Spring EXPLANATION STANE Mei Me 1 peetan 18 10 GAST DATE EXPLANATION POTRE DENT CREDIT LALANCES NOL G wie PURCHASES DATE EXPLANATION POSTER . DEBITCH CREDITS Account No MALANCE Freight werde DATE EXPLANATION POST REF DEBIT SI CREDITS Account BALANCE SI Wapen tape DATE EXPLANATION POST REF. DEBITS CREDITS Account No. 505 MALANCE BUTY PO CREDITS relo POSTRE DET CREDIT Hotel United Recent ho 100T BALANCE 99 DATE EXPLANATION POSTRE DETS CREDITS Opening Entry GOS 6094 De Subsidiary ledger PAYABLE Get Coated heute. O BALANCES DATE EXPLANATION POSTRE DENTIS CREDIT Opening Entry 4110 411 GF Reduce, Reve, Get Rich 53001 CR50 DATE EXPLANATION Account No 80003 BALANCE SI DATE EXPLANATION POST REF DEBIT (5) CREDITS CH MM-01 Opening Entry 1780 FLOODED INDUSTRIES Account N 0005 BALANCES DATE EXPLANATION POST REF. DEBIT (5 CREDITS IND Opening Entry Dr GI 726 726 N-01 Opening Entry The Charity Stores Account No. 61003 BALANCE (S1 DEBIT (5) CREDIT (5) DATE EXPLANATION POST REF. Dr GJ 2310 2310 101 Opening Entry Developing Naturally Account No. 61005 BALANCE (5) DATE EXPLANATION POST REF DEBIT (5) CREDIT (5) 4455 Dr Jul-01 Opening Entry 4455 Body DI 14 B Practical Completion Point 2 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) July 2 July 6 Transactions July 1 Sold 40 Energy Saving light globes on credit to Unplugged Ltd for $440 (including GST). Received a cheque for $2475 from Developing Naturally as part payment of their account. July 4 Sold 2 Smart Meters to The Charity Stores for $350 each plus a $50 delivery fee (all amounts are net of GST) Issued Cheque number 718 to Flooded Industries. The cheque amount was $1752.30 and a discount of S194.7 (including GST of $17.70) was received for early payment Purchased 200 metres of premium low voltage cabling from Get Connected for $4 per metre, plus a 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. July 13 Purchased 500 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. July 15 Cash Sale of 12 Energy Saving light globes to Ms Christa Heathers for $10 each (net of GST). July 8 July 12 Transactions continued July 16 July 16 Paid wages of $1,680 to Minnie's two part time employees Lei Zhee and Ena Jclic Made a cash purchase of $60 stationery (net of GST) from Little M department store Purchased 15 LED Lighting Kits for a total of $330 (GST inclusive) from Flooded Industries July 19 July 20 July 20 July 21 July 23 July 25 July 27 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 S1166 being full settlement of their account Sold 100 meters of premium low voltage cable to Unplugged Ltd for $20 per meter (net of GST) The office supplies account of $186 was paid in full in cash. Minnie Amnim withdrew $1,050 cash for personal use. Sold 3 Smart Meters to Hotels United for $350 each plus a delivery fee of $100 (all amounts are net of GST) Paid all amounts owing to Reduce, Reuse, Get Rich. Made a cash payment of $921 (including S40 GST) to The Big Telco for the last two months telephone and internet usage. July 29 July 30 A stocktake on July 31 reveals 54 140 worth of inventory on hand and $114 of stationery on hand Prepaid insurance was paid for 3 months in advance on June 30, 2020. Prepaid rent was paid for 6 months in advance on 1 June, 2020. Depreciation is only calculated at the end of the financial year and so no adjustments are required for these accounts. 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 2020. Remember of 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, Submission Requirements Once you have completed the data entry in the above two tasks, you will need to upload your excel file to leacoaglios, so they can be checked for completeness. At this point accuracy of data entry is being checked but is not the primary focus of the marking. The majority of marks are warded if all transactions have been entered by following the correct fx Cash Receipts Journal Cash Receipts Journal OST Date Cash Payments Journal GST Posted Dune Sales Journal Accounts Rova Du Particulars GST Sales Returns Journal Sales Pole GST Purchases Journal Acco Payable Purchases Returns lournal Purcate Account GST
