Good Morning,
Can you please help with the following, I have tried to send this one in once before, but not sure if it has been received correctly or if the attached document is opening?
I hope this uploads correctly this time?
Thanks
\fTo complete the January accounting for Jolly Amusements you are required to: a) Check that all journals have been properly authorised in accordance with the Organisational Policies and Procedures. Add the name of the au thoriser if not already included. (Note: The Organisational Policies and Procedures require that journals be signed and dated by the accounts manager prior to being posted to the General ledger.) b) Check that the total of the opening balances in the Accounts Receivable and Accounts Payable Subsidiary ledgers match the Accounts Receivable and Accounts Payable General Ledger opening balance and make any necessary corrections. Record all relevant transactions into the Accounts Receivable and Accounts Payable Subsidiary Ledger accounts. c) Check the opening Bank Balance in the General Ledger and ensure that it agrees with the Bank Reconciliation as at 31 December 2017 as provided. Reconcile the bank account and prepare a Bank Reconciliation Statement as at 31 January 2018 d) Total and balance the journals as required. e) Ensure all opening balances in the General Ledger (refer to Templates provided) match the December Trial Balance provided. If they don't then you need to enter the balance from the December Trial Balance. Post the journals to the General Ledger accounts. f) Complete the Accounts Receivable and Accounts Payable reconciliations for 31 January 2018. g) Prepare the Trial balance as at 31 January 2018. h) Prepare the Income Statement for the period ended 31 January 2018 on the template provided. i) Prepare the Balance Sheet as at 31 January 2018 on the template provided. 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. Particulars Folio/ account 06.01.18 215 Cash sales Sales 142.00 1510.00 1,652.00 08.01.18 216 Cash sales Sales 135.00 1,410.50 1,545.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 Authorised: Jenny Chee 31.01.18 Sales* Other accounts Discount Allowed Ref no. Totals GST Collected Accounts receivable Date 478.60 1,100.00 1,210.00 1122.00 62.50 1,122.00 690.10 752.60 830.50 40.00 Bank 400.00 JK 18/07 830.50 440.00 169.40 35.00 380.00 584.40 2,000.00 121.00 1,245.00 $686.90 $6072.80 2,000.00 1,366.00 $3100.00 $2121.90 $11981.60 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 Account Name: PurchasesBalance Debit Date Credit Account Name: GST paid Date Date 01.01.18 Details Details Opening balance Account No.455 Folio Debit Credit Balance Account No.500 1410.00 dr Folio Folio Debit Debit Credit Credit Account No.125 Balance Balance 521.30 dr Account Name: Interest received Account Name: Bank Charges Account No.170 Date Details Account Name: Equipment at cost Date 01.01.18 Details Opening balance Account No.460 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 Date Details Account Name: Telephone 01.01.18 Opening balance Account No.670 Date Details Account Name: Wages Account Name: Motor Vehicles at cost Date Details Folio Debit Date Folio Debit Details Credit Debit Credit Balance Account No.650 17,439.50 cr Folio Debit Credit Balance Account No.174 Balance Details Details Opening balance Account Name: Accounts payable Details Opening balance Folio Credit Balance Account Name: Discount Account Name: Capital received Date Date 01.01.18 Date 01.01.18 Account No.270 Account No.465 Account No.300 Folio Folio Debit Credit Credit Credit Balance Balance 22,534.48 cr Account No.210 Folio Debit Debit 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) $ RECEIPT Jolly Amusements $ 222 No. Date 21/01/2018 Received from Gumby Football Club Amount in words Eight hundred and thirty Fifty Dollars Cents $ For payment of Invoice 1259 X Received by C Clown 830.50 Cash Cheque Other JK 18/7 RECEIPT Jolly Amusements 223 No. Date 22/01/2018 Received from Cash Amount in words Four hundred and forty Nil Dollars Cents For payment of Sales (Including GST $40) Received by RECEIPT $ X C Clown Jolly Amusements 440.00 Cash Cheque Other 224 No. Date 29/01/2018 Received from S Smith Amount in words One hundred and sixty nine Forty Dollars Cents $ SALES (INC GST $15.40) For payment of IN# 1304 X Received by C Clown 169.40 Cash Cheque Other JK 18/07 RECEIPT Jolly Amusements 225 No. Date 29/01/2018 Received from Cash Amount in words Four hundred and fifteen Nil Dollars Cents For payment of Sales (Including GST $35) Received by RECEIPT $ X C Clown Jolly Amusements 415.00 Cash Cheque Other 226 No. Date 30/01/2018 Received from Cash Amount in words Two thousand Nil For payment of Capital contributed by owner Received by C Clown Dollars Cents $ X 2000.00 Cash Cheque Other RECEIPT Jolly Amusements 227 No. Date 31/01/2018 Received from Cash Amount in words One thousand three hundred and sixty six Nil For payment of Sales (Including GST $121) Received by C Clown Dollars Cents $ X 1366.00 Cash Cheque Other
