Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can not get my credits and debits to balance for this question, can you please help me to point out where I have done

I can not get my credits and debits to balance for this question, can you please help me to point out where I have done wrong

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Task 5 20 marks The following information has been extracted from the records of Sing & Smile Ltd: RIGHT Bank Statement of Account Account Name: Sing & Smile Ltd As at: 31/12/18 Bank Statement Statement Page: 6 Date Transaction Debits Credits Balance Balance brought forward 21,011.00 Cr Dec 2 Deposit 1,240.00 22,251.00 Cr Cheque 732 115.00 22,136.00 Cr 3 Debit Card #1122567 2,156.00 19,980.00 Cr 5 Direct Deposit A Cove 5,216.00 25,196.00 Cr Cheque 733 235.00 24,961.00 Cr 10 Nat Aus PoS 4.3 4,211.00 29,172.00 Cr Debit Card #109876 752.00 28,420.00 Cr Direct debit-Optus 299.00 28,121.00 Cr 12 Cash / Chq Deposit 1,620.00 29,741.00 Cr 17 Direct Deposit W Butler 2,166.00 31,907.00 Cr 18 BPay S Byford 432.00 31,475.00 Cr Dividend - ABC Ltd 780.00 32,255.00 Cr 19 Cheque 736 696.00 31,559.00 Cr Cash / Chq Deposit 1,349.00 32,908.00 Cr 20 B Pay J Moran 866.00 32,042.00 Cr 23 Dishonour 870.00 31,172.00 Cr Dishonour fee 25.00 31,147.00 Cr Cash/Chq Deposit 2,966.00 34,113.00 Cr Cheque 737 1,100.00 33,013.00 Cr 24 Direct debit - Quality Realty 3,300.00 29,713.00 Cr Debit card #222280 5,481.00 24,232.00 Cr BPay M Banford 433.00 23,799.00 Cr 31 Interest 52.50 23,851.50 Cr Bank charges 70.00 23,781.50 Cr Closing balance 23,781.50 CrAdditional information: The dishonoured cheque on 23 December relates to a cheque deposited on 17 December. Bank Reconciliation as at 30 November 2018 $ Credit balance as per bank statement 21,011.00 Add: Outstanding deposits 1,240.00 22,251.00 Less: Un-presented cheques and payments 732 115.00 733 235.00 734 327.00 677.00 Debit balance as per cash book 21,574.00 Books of Sing & Smile Ltd (Extract) Cash Receipts Journal (Extract) Cash Payments Journal Date S Date Cheque/ Pymnt S 4/12 A Cove 5,216.00 2/12 D/ card #109876 752.00 9/12 Nat Aus Pos 4,211.00 D/Card #1122567 2,156.00 11/12 Receipts 1,620.00 4/12 Cheque 735 1,105.00 16/12 W Butler 2,166.00 12/12 J Moran 866.00 18/12 Receipts 1,349.00 16/12 S Byford 432.00 20/12 Receipts 2,966.00 18/12 Cheque 736 696.00 30/12 Receipts 4,000.00 22/12 M Banford 433.00 18/12 Cheque 737 1,100.00 Cheque 738 840.00 20/12 D/Card #222280 5,481.00 27/12 Cheque 739 1,025.00 21,528.00 14,886.00 Required: Complete the extracts of the Cash Receipts & Cash Payment Journals Complete the Cash Balance Summary Prepare bank reconciliation as at 31 December 2018.Books of Sing & Smile Extract) Cash Book (ledger account) Sing & Smile Pty Ltd Receipts Payments Date Rec No Particulars Amt $ Date 16,000 Particulars Amt $ 4/12/18 A Cove 5 216.00 2/12/18 280000 D/ card # 109876 752 9/12/18 Nat Aus POS 4.21 1.00 15,500 D/Card # 1122567 2,156.00 11/12/18 Receipts 1,620.00 4/12/18 735 500 1,105.00 16/12/18 W Butler 2,166.00 12/12/18 J Moran 366 18/12/18 Receipts 1,349.00 16/12/18 2,500 S Byford 132 20/12/18 Receipts 2,966.00 18/12/18 65,500 Cheque 696 30/12/18 Receipts 4,000.00 22/12/18 120,000 133 Subtotal 21,528.00 18/12/18 737 Cheque 1,100.00 18/12/18 Dividend - ABC Ltd 780.00 738 Cheque 840 31/12/18 Interest 52.50 20/12/18 D/Card #222280 5,481.00 27/12/18 739 Cheque 1,025.00 Subtotal 14,886.00 10/12/18 Direct debit-Optus 299.00 23/12/18 Dishonour 870.00 24/12/18 Dishonour fee 25.00 24/12/18 Direct debit - Quality Real 3,300.00 31/12/18 Bank charges 70.00 Total 22,360.50 Total 19450 Cash Balance Summary, use the table below: Opening bank account ledger balance at 1.12.2018 21,574.00 FNSACC311 Process Financial Transactions and Extract Interim Reports Ed 2 Assignment 5 Template Add header Add: Total receipts for the month 22,360.50 13,934.50 Less: Total payments for the month 19,450.00 Closing bank account ledger balance at 31.12.2018 24,484.50Bank Reconciliation as at 31 December 2018 Credit Balance as per bank statememnt $23,781.50 Outstanding deposits - 31/12/18 4000 27 781.50 Outstanding cheques Cheque 734 327 Cheque 735 1 105 Cheque 738 840 Cheque 739 1025 2 272.00 $25,509.50

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information For Business Decisions

Authors: Loren A Nikolai, Billie Cunningham, John D Bazley

3rd Edition

1111066884, 9781111066888

More Books

Students also viewed these Accounting questions

Question

f. What subspecialties and specializations does the person list?

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago