Can you please help with the following?
General Journal 21.01.18 Debit Motor vehicle Equipment at cost Credit 10,500 700 Capital 11,200 (Owner introduced assets into the business) 23.01.18 Equipment at cost GST paid 1,500 150 Accounts payable 1,650 (Purchased equipment from John Deere on credit) 31.01.18 Accounts receivable Late Fee Revenue (Late fee charged on Trendy Tricks Pty Ltd account ) Authorised: Jenny Chee 31.01.18 10 10 Sales Journal Invoice no. Sold to: 05.01.18 1214 Solid Solutions Ltd 1020.00 102.00 1122.00 09.01.18 1256 Allen's Accounting 620.00 62.00 682.00 10.01.18 1259 Gumby Footy Club 755.00 75.50 830.50 11.01.18 CN554 Allen's Accounting -40.00 -4.00 -44.00 15.01.18 1285 GDT Pty Ltd 230.00 23.00 253.00 24.01.18 1304 S Smith 154.00 15.40 169.40 31.01.18 1324 Goodfield SHS 140.00 14.00 154.00 $2879.00 $287.90 $3166.90 Totals Authorised: Jenny Chee 31.01.18 * All credit sales include GST. Sales* GST collected Accounts receivable Date Purchases Journal Date Invoice no. 04.01.18 100471 Coca Cola Ltd 485.00 48.50 533.50 04.01.18 56594 Donaldson's Dairy 124.00 0 124.00 05.01.18 2201 Allen's Confection 260.00 26.00 286.00 07.01.18 567 Allen's Confection -20.00 -2.00 -22.00 08.01.18 5546 Clear Springs 155.00 0 155.00 13.01.18 56596 Donaldson's Dairy 146.00 5.50 151.50 15.01.18 102484 Coca Cola Ltd 845.00 84.50 929.50 19.01.18 44494 Coca Cola Ltd -42.00 -4.20 -46.20 20.01.18 8997 Smart Golf 62.00 6.20 68.20 30.01.18 56657 Donaldson's Dairy 180.00 18.00 198.00 $2195.00 $182.50 $2377.50 Totals Authorised: Jenny Chee 31.01.18 Bought from: Purchases GST paid Accounts payable Cash Receipts Journal * Cash sales include GST Free sales and taxable sales. Date Ref no. Particulars Folio/ account 06.01.18 215 Cash sales Sales 142.00 1510.00 08.01.18 216 Cash sales Sales 135.00 1,410.50 12.01.18 217 Cash sales Sales 5.00 50.00 12.01.18 218 Cash sales Sales 36.40 387.20 13.01.18 219 Rent received Rent 110.00 14.01.18 220 Solid Solutions A/C Rec 18.01.18 221 Cash sales Sales 21.01.18 222 Gumby Football Club A/C Rec 22.01.18 223 Cash sales Sales 29.01.18 224 S Smith A/C Rec 29.01.18 225 Cash sales Sales 30.01.18 226 Owner contribution Capital 31.01.18 227 Cash sales Sales Totals Authorised: Jenny Chee 31.01.18 GST Collected Sales* Other accounts Accounts receivable Discount Allowed B 1,100.00 1122.00 62.50 690.10 830.50 40.00 JK 18/07 400.00 169.40 35.00 380.00 2,000.00 121.00 1,245.00 $686.90 $6072.80 $3100.00 $2121.90 $1 Cash Payments Journal Discount Received Particulars Folio/ Account 01.01.18 45 Coles Purchases 35.60 384.20 419.80 04.01.18 46 Ready Rewards Purchases 100.00 1,000.00 1,100.00 11.01.18 47 Coca Cola Ltd A/C Pay 11.01.18 48 Telephone Telephone 11.01.18 49 Donaldson's Dairy A/C Pay 13.01.18 50 Cash purchases Purchases 13.01.18 51 Wages Wages 14.01.18 52 Clear Springs Various 22.01.18 53 Coca Cola Ltd A/C Pay 26.01.18 54 Harvey Norman Equipment 27.01.18 55 Wages Wages 31.01.18 56 Donaldson's Dairy A/C Pay Authorised: Not Authorised (s/be Jenny Chee 31/1/18) Purchases Accounts payable Ref no. Totals GST Paid Other accounts Date 533.50 32.40 533.50 324.00 356.40 124.00 4.30 124.00 43.00 47.30 430.00 -0.50 430.00 155.00 -5.00 883.30 230.00 1427.20 149.50 883.30 2,300.00 2,530.00 510.00 510.00 198.00 $401.80 Bank $3564.00 $1893.80 198.00 ($5.00) $7281.80 b) Subsidiary Ledgers Accounts Receivable Subsidiary Ledger Allen's Accounting Date Details Opening balance (In01/01/2018 voice date 18/12/17) 09/01/2018 11/01/2018 GDT Pty Ltd Date 15/01/2018 Sales, GST Sales RTN, GST Details Sales, GST Folio Debit 1-2001 Credit Balance 540.00 DR SJ1 SJ1 Folio SJ1 682.00 44.00 Debit 230.00 Goodfields SHS Date Details 31/01/2018 Sales, GST Folio SJ1 Debit 154.00 Gumby's Footy Club Date 10/01/2018 Sales, GST 21/01/2018 Cash Rec Folio SJ! CRJ1 Debit 830.50 1-2012 Credit 1-2014 Credit 1-2018 Credit 830.50 1222.00 DR 1178.00 DR Balance 230.00 DR Balance 154.00 DR Balance 830.50 DR 0.00 Solid Solutions Pty Ltd 1-2025 Date Details Folio Debit 05/01/2018 Sales, GST SJ1 1122.00 14/01/2018 Cash Rec CRJ1 S Smith Date 24/01/2018 29/01/18 Details Sales, GST Cash Rec Trendy Tricks Pty Ltd Date Details Opening balance (In1/01/2018 voice date 05/12/17) Folio SJ1 CRJ1 Folio Credit Balance 1122.00 DR 1122.00 Debit 169.40 Debit 1-2026 Credit 0.00 169.40 Balance 169.40 0.00 1-2030 Credit Balance 870.00 DR DR Accounts Payable Subsidiary Ledger Allen's Confection Date Details 05/01/2018 Purchase, GST Folio PJ1 Debit 07/01/2018 PJ1 22.00 Part CRED Purch, Rtn Clear Springs 2-2001 Credit 286.00 Balance 286.00 CR 264.00 CR 2-2013 Date Details Opening balance (In- 1/01/2018 08/01/2018 14/01/2018 voice dated 24/12/17) Purchase Purchase, Disc taken Folio PJ1 CPJ1 Debit Credit 155.00 149.50 Coca Cola Date 04/01/2018 11/01/2018 15/01/2018 19/01/2018 Details Purchase,GST Cash Payment Purchase,GST Part CRED Pur, RTN Folio PJ1 CPJ1 PJ1 PJ1 22/01/2018 Cash Payment CPJ1 883.30 Folio 2-2020 Credit Donaldson's Dairy Date Details Debit 2-2014 Credit 533.50 533.50 929.50 46.20 Debit Balance 155.00 CR 310.00 CR 160.50 CR Balance 533.50 CR 0.00 929.50 CR 883.30 CR 0.00 Balance Opening balance (In1/01/2018 04/01/2018 11/01/2018 13/01/2018 30/01/2018 31/01/2018 Smart Golf Date 20/01/2018 John Deere Date voice dated 28/12/17) Purchase Cash Pmt(inv 28/12/17) Purchase, GST Purchase, GST Cash Pmt Inv 56657 Details Purchase,GST Details PJ1 CPJ1 PJ1 PJ1 CPJ1 Folio PJ1 Folio 124.00 124.00 151.50 198.00 198.00 Debit Debit 124.00 CR 248.00 CR 124.00 275.50 473.50 275.50 CR CR CR CR 2-2040 Credit 68.20 Balance 68.20 CR 2-2018 Credit Balance The Bank Statement for January 2018 Jolly Amusements 2018 Withdrawals Deposits Balance 1 Jan Opening balance 25,154.68 Cr 4 Jan Deposit 4 Jan Withdrawal - Chq 000043 176.00 26,234.68 Cr 5 Jan Withdrawal - Chq 000045 419.80 25,814.88 Cr 7 Jan Deposit 1,652.00 27,466.88 Cr 9 Jan Deposit 1,545.50 29,012.38 Cr 12 Jan Withdrawal - Chq 000047 533.50 28,478.88 Cr 12 Jan Withdrawal - Chq 000046 1,100.00 27,378.88 Cr 12 Jan Deposit 12 Jan Withdrawal - Chq 000048 356.40 27,501.08 Cr 13 Jan Withdrawal - Chq 000049 124.00 27,377.08 Cr 13 Jan Deposit 15 Jan Withdrawal - Chq 000051 15 Jan Deposit 17 Jan Withdrawal - Chq 000052 149.50 29,129.58 Cr 18 Jan Direct debit Loan - The Bank 230.00 28,899.58 Cr 21 Jan Deposit 752.60 29,652.18 Cr 21 Jan Deposit 830.50 30,482.68 Cr 1,256.00 478.60 1210.00 430.00 26,410.68 Cr 27,857.48 Cr 28,587.08 Cr 28,157.08 Cr 1122.00 29,279.08 Cr 22 Jan Deposit 440.00 27 Jan Withdrawal - Chq 000054 29 Jan Deposit 31 Jan Bank charges 31 Jan Withdrawal - Chq 000055 31 Jan Interest on account 2,530.00 28,958.58 Cr 510.00 28,448.58 Cr Balance as per Bank Statement Credit 279.00 783.00 521.30 17439.50 22534.48 41035.98 $25,154.68 28,977.08 Cr 18.50 22.28 Debit 26234.68 1410.00 12870.00 Bank Reconciliation as at 31/12/2017 28,392.68 Cr 584.40 Trial Balance as at 31 December 2017 Account Cash at bank Accounts receivable Equipment at cost Accounts payable GST Collected GST Paid Loan - The Bank Capital 30,922.68 Cr 41035.98 28,470.86 Cr Plus Outstanding Deposits 31.12.17 1,256.00 26,410.68 Less Unpresented Cheques Chq no. 000043 Balance as per GL c) Bank Reconciliation as at 31/01/2018 Balance as per Bank Statement Plus Outstanding Deposits Less Unpresented Cheques Balance as per GL e) General Ledger accounts 176.00 $26,234.68 Account Name: Sales Account Name: Cash at bank Date 01.01.18 Details Opening balance Folio Account No.100 Account Name: GST collected Details Debit Date Credit Balance Date 01.01.18 Details Opening balance Folio 26,234.68 Folio dr Debit Credit Account No.230 Balance Debit Credit Balance 783.00 cr Account Name: Rent received Account No.110 Account Name: Accounts receivable Date 01.01.18 Details Opening balance Account No.400 Folio Details Debit Date Credit Account Name: PurchasesBalance Account Name: GST paid Date Date 01.01.18 Account No.455 Folio Debit Credit Balance Account No.500 Debit Debit Credit Credit Account No.125 Balance Balance 1410.00 dr Details Details Opening balance Folio Folio 521.30 dr Account Name: Interest received Account Name: Equipment at cost Date 01.01.18 Details Opening balance Account No.460 Account No.170 Account Name: Bank Charges Date Details Folio Debit Date Credit Details Balance Folio Folio 12,870.00 dr Debit Credit Account No.602 Balance Debit Credit Balance Account Name: Loan - The Bank Account Name: Motor Vehicles at cost Date Details Folio Date Details Account Name: Telephone 01.01.18 Opening balance Account No.670 Date Details Account No.174 Debit Credit Balance Date Folio Debit Account Name: Wages Details Date 01.01.18 Details Opening balance Folio Debit Folio Debit Credit Balance Account No.650 17,439.50 cr Folio Debit Credit Balance Credit Balance Account Name: Discount Account Name: Capital received Date Date 01.01.18 Account Name: Accounts payable Account No.270 Details Details Opening balance Account No.210 Credit Account No.465 Account No.300 Folio Folio Debit Debit Credit Credit Balance Balance 22,534.48 cr Balance 279.00 cr Account Receivable Reconciliation 31 January 2018 Account NumAccount Name Total Due ber Current 0 - 30 days Grand Totals Balance per GL Variance $ $ 31 - 69 Days 61 - 90 Days 90+ day s Account Payable Reconciliation 31 January 2018 Account Account Name Total Due Number Grand Totals Balance as per GL Variance $ $ Current 0 - 30 days 31 - 69 Days 61 - 90 Days 90+ days g) Trial Balance of Jolly Amusements as at 31 January 2018 Account Number Account Name Debit Credit h) Income Statement for the period ended 31 January 2018 JOLLY AMUSEMENTS Income Statement for the period ended 31 January 2018 Revenue Sales Revenue $ Less COGS $ GROSS PROFIT Add Other Revenue Rent Received Interest Received Discount Received $ Late Fee Revenue $ $ $ $ $ $ Less Operating Expenses Bank Charges Telephone Wages NET PROFIT $ $ $ $ $ i) Balance Sheet as at 31 January 2018 JOLLY AMUSEMENTS Balance Sheet as at 31 January 2018 Current Assets Cash at bank $ Accounts Receivable Control Non-current Assets Motor Vehicles at Cost $ Equipment at Cost TOTAL ASSETS $ Current Liabilities GST Collected Less GST Paid Accounts Payable Control $ $ $ $ $ $ $ $ $ Non-current Liabilities Loan - The Bank $ TOTAL LIABILITIES $ NET ASSETS $ OWNERS' EQUITY Capital $ Net Profit (From Income Statement) $ $
