The business is registered for GST. Mike's TV Solutions specialises in the installation of brand-new televisions that the client has purchased elsewhere and requires a tradesperson to install the TV, wall mount if required, install an antenna, tune the TV and set the channels etc. The business provides other services such as repairing existing televisions, installing Pay TV dishes, setting up media rooms etc. Mike has a variety of clients including lucrative contracts with large builders and rental property managers with whom he has built up strong relationships. He offers them terms of 30 days. Mike submits his Business Activity Statement (BAS) monthly on an accruals basis and pays GST and PAYG Tax monthly. The next payment is due on May 31 st . The business is operated from a commercial shed which was purchased by Mike for $696,000 three years ago. To finance this purchase Mike took out a loan over a fifteen-year period at a variable interest rate

A. looking at the jounal entries perepared in excel youn are supposed to prerpare just the general ledger in excel link below

https://mail.google.com/mail/u/0?ui=2&ik=80d277b2d4&attid=0.1&permmsgid=msg-a:r4812426573669355515&th=17dae488392c868b&view=att&disp=safe&realattid=f_kx34s1ci0

the journal trasactions are below just for reference

Transaction 1 b. Transactions for the operations of Mike's TV Solutions for the month of May Note: All amounts are GST inclusive unless otherwise stated. Mike's TV Solutions allow terms n30. Date May-01 Details 2 Paid insurance for the vehicles for 12 months in advance $13,200. May-02 Paid Accounts Payable $36,876. 3 May-04 Purchased TV Installation Supplies on credit $7,700. 456 May-06 5 May-08 Received amount owing from Mel Smith Property Management for April installations $79,200. Invoiced Rey Whyte for installations $114,180. 6 May-10 Purchased new TV Installation Equipment $211,200. Paid $19,200 cash and increased the Loan from the Bank to cover the balance. 7 May-12 8 May-12 9 Paid monthly mobile phone and internet account $550. Paid for Advertising $330. Purchased a new all-in-one scanner, photocopier, printer, for the office May-13 $3,850 from Officewerx on credit. 10 May-14 11 May-14 12 May-15 13 May-16 14 15 16 17 18 19 20 21 22 23 24 25 May-19 Wages expense of $23,520 incurred for the past fortnight which included PAYG tax of $3,120 - paid staff amount owing. Recorded cash for TV installation services delivered to date $58,080. Received amount owing from Rey Whyte Real Estate $37,800. Mike withdrew cash from the business $150,000. Signed a contract with a new client Qld Housing Services for installation of televisions for Government Houses in Roma. Large involves 50 houses to have TV's installed during June. Received the sum of $26,400 in advance of work to be performed in June. May-21 Paid fuel bill $2,200. Wages expense of $23,520 incurred for the past fortnight which included PAYG tax of $3,120 - paid staff amount owing. May-28 May-28 Purchased TV Installation Supplies for cash $2,112. May-28 Invoiced Bell Property for TV Installations $105,732. May-28 Paid for TV Installation Supplies purchased on May 4th. May-29 Received payment from Rey Whyte for Invoice of 8th May. May-30 Recorded cash for TV Installation services provided to date $66,264. May-30 Purchased TV Installation Supplies $5,126 from Mitre 15 for cash. May-31 The bank Statement revealed bank charges of $113 had been deducted. May-31 Paid monthly repayment on Bank Loan of $3,500. The interest component included in the repayment amount is $1,415. May-31 Returned TV Installation Supplies $275 to Mitre 15 and received a refund. 26 May-31 Paid GST and PAYG amounts owing from previous month.