Yo have answered journal entries. Please manage to do all the answer asked in the questions. I don't know how to do it. You can do it in copy click picture and send it to me

Anment?listrans G C C Study One Colima plugntile.php/249061/mod resource/content/2/ACCSOC. 20Assignment".02.20 .20transaction excel.20mport inst Task description T Consider the information provided for real Financial Services and use Feel te 1. Record the journal entries for lune transactions include narrations 2. Record adjusting entries for the end of hone, inchide narrations. 3 Construct the "T"formatted ledger accounts Prepare the profe and is statement for the year ended 30 June 2020 S Prepare the classified narrative formatted bwance sheet as at 30 June 2020 You must formula to construct the leger accounts, profit and loss statement, and balance sheet. Use excel to answer the assignment requirements. The excel sheets must be linked to each other. You CANNOT just enter the data into the financial statements. You must enter the data once and in the excel sheets to produce the financial reports Peak Financial Services Unadjusted Trial Balance as at 1st May 2020 Accumulated depreciation office equipment ble du 11 December 2013 12,500 213.700 750 6,400 300,00 Desktop egment 2 fin trans x G solved question of journal entre X C Chegg Study Order Confirmatio * + infile.php/2490638/mod resource/content/2/ACC5000%20Assignment%202%20Fin%20transaction excel.20reports lune transactions: 1/06/2020 2/06/2020 5/06/2020 9/06/2020 12/06/2020 15/05/2020 22/06/2020 24/06/2020 26/06/2020 28/06/2020 297062020 S06/2020 30/06/2020 30 2020 Transaction Amount Cash receipts from customers for moneys Owed $19,800 Purchased a work van paying a 20% cash deposit and taking out a 4- year 6% loan to cover the balance Purchased office supplies on credit, due 15 July $2,200 Received a cash deposit upfront from a customer for financial $4,730 advisory work to be completed during July 2020 Cash receipts from customers for money owed 1522165 Paid all outstanding accounts payable from previous month Received gas bill 5330 Paid lune salaries to this date $2,400 Received and paid mobile phone and internet bill for month of June 5374 Sette revious month GST with ATO Cash receipts from customers for money owed Record all June Sales on credit 521.340 Herceived bank interest S230 One customer was declared bankrupt during their debt is 52,310 juded to be non-recoverable a bad debit. 151250 Additional information All are credit sales o days Unless stated all amounts GST inclusive of GST interest of 5227 has accrued in lume on the canvas Aphyl count office suppiesn e s 2000 of supplen und Du tion of the equipment this is estimates to be 0.400 Depreciation of the motor whicle will be determined using the traght line method. The 59.000 gment Fintro G old question of journaliex | Cowgg Stuty Order Confirmation + Nile.php/2490638/mod resource/content/?/ACCS000%.20Asm ent%202%20in%20transaction excel%20report%20instruct 30/09/2010 Record al lune Sales on credit $21,340 30/06/2020 Received bank interest $230 30/09/2000 One Customer was declared bankrupt during June. Their debt is 59,310 udged to be coverable a bad det) Additional Information . All sales are credit sales (30 days) Unless stated al amounts are GST include or GST exempt Interest expense of $227 has accrued in lune on the loans payable. A physical count of office supplies on 30 june shows $2400 of unused supplies on hand. Depreciation of the office equipment this year is estimated to be $9.400. Depreciation of the motor vehicle will be determined using the straight line method. The business estimates the useful life of the van to be 5 years, and the residual value to be $16,000. Based on these values, the business estimates annual depreciation on the van to be $9,000 per year Prepaid insurance was paid on the of April 2020 and covered a period of 6 months Prepaid rent balance as at 1 July 2020 should be $2,800 Of the uneamed bees balance as at 31 May, Gox were refunded to a customer as the business was unable to complete the work prior to 30 lune as previously agreed, the remainder of the unrhed Tees were eamed during lune. Salaries expense acred for the last week in June amounts to $2,800. Ignore PAYGrelated to salaries The fuel expense for lune of approximately 500 has not been recorded or paid. At the end of the month A Peak withdrew $4,500 for his own use. . Due Date 20 of April 2020 6m Ustime. Parts rance Desktop Anment?listrans G C C Study One Colima plugntile.php/249061/mod resource/content/2/ACCSOC. 20Assignment".02.20 .20transaction excel.20mport inst Task description T Consider the information provided for real Financial Services and use Feel te 1. Record the journal entries for lune transactions include narrations 2. Record adjusting entries for the end of hone, inchide narrations. 3 Construct the "T"formatted ledger accounts Prepare the profe and is statement for the year ended 30 June 2020 S Prepare the classified narrative formatted bwance sheet as at 30 June 2020 You must formula to construct the leger accounts, profit and loss statement, and balance sheet. Use excel to answer the assignment requirements. The excel sheets must be linked to each other. You CANNOT just enter the data into the financial statements. You must enter the data once and in the excel sheets to produce the financial reports Peak Financial Services Unadjusted Trial Balance as at 1st May 2020 Accumulated depreciation office equipment ble du 11 December 2013 12,500 213.700 750 6,400 300,00 Desktop egment 2 fin trans x G solved question of journal entre X C Chegg Study Order Confirmatio * + infile.php/2490638/mod resource/content/2/ACC5000%20Assignment%202%20Fin%20transaction excel.20reports lune transactions: 1/06/2020 2/06/2020 5/06/2020 9/06/2020 12/06/2020 15/05/2020 22/06/2020 24/06/2020 26/06/2020 28/06/2020 297062020 S06/2020 30/06/2020 30 2020 Transaction Amount Cash receipts from customers for moneys Owed $19,800 Purchased a work van paying a 20% cash deposit and taking out a 4- year 6% loan to cover the balance Purchased office supplies on credit, due 15 July $2,200 Received a cash deposit upfront from a customer for financial $4,730 advisory work to be completed during July 2020 Cash receipts from customers for money owed 1522165 Paid all outstanding accounts payable from previous month Received gas bill 5330 Paid lune salaries to this date $2,400 Received and paid mobile phone and internet bill for month of June 5374 Sette revious month GST with ATO Cash receipts from customers for money owed Record all June Sales on credit 521.340 Herceived bank interest S230 One customer was declared bankrupt during their debt is 52,310 juded to be non-recoverable a bad debit. 151250 Additional information All are credit sales o days Unless stated all amounts GST inclusive of GST interest of 5227 has accrued in lume on the canvas Aphyl count office suppiesn e s 2000 of supplen und Du tion of the equipment this is estimates to be 0.400 Depreciation of the motor whicle will be determined using the traght line method. The 59.000 gment Fintro G old question of journaliex | Cowgg Stuty Order Confirmation + Nile.php/2490638/mod resource/content/?/ACCS000%.20Asm ent%202%20in%20transaction excel%20report%20instruct 30/09/2010 Record al lune Sales on credit $21,340 30/06/2020 Received bank interest $230 30/09/2000 One Customer was declared bankrupt during June. Their debt is 59,310 udged to be coverable a bad det) Additional Information . All sales are credit sales (30 days) Unless stated al amounts are GST include or GST exempt Interest expense of $227 has accrued in lune on the loans payable. A physical count of office supplies on 30 june shows $2400 of unused supplies on hand. Depreciation of the office equipment this year is estimated to be $9.400. Depreciation of the motor vehicle will be determined using the straight line method. The business estimates the useful life of the van to be 5 years, and the residual value to be $16,000. Based on these values, the business estimates annual depreciation on the van to be $9,000 per year Prepaid insurance was paid on the of April 2020 and covered a period of 6 months Prepaid rent balance as at 1 July 2020 should be $2,800 Of the uneamed bees balance as at 31 May, Gox were refunded to a customer as the business was unable to complete the work prior to 30 lune as previously agreed, the remainder of the unrhed Tees were eamed during lune. Salaries expense acred for the last week in June amounts to $2,800. Ignore PAYGrelated to salaries The fuel expense for lune of approximately 500 has not been recorded or paid. At the end of the month A Peak withdrew $4,500 for his own use. . Due Date 20 of April 2020 6m Ustime. Parts rance Desktop