Part C – Cash Book Reconciliation and Bank Reconciliation

a) Prepare a cash book reconciliation and a bank reconciliation for the period ended 31 March 20XX. Make any required entries to the cash book receipt and payment side for March below. 

c) The trust bank reconciliation must be prepared by comparing with the bank statement 

BANK RECONCILIATION FEBRUARY

Bank statement balance as at   28/02/20XX

Add Outstanding Deposits $92,410

Receipt #672 $4,800

$97,210

Less Unpresented cheques (list them)

Cheque #513 $4,150

Cheque # 514  $350 $4,500

Less Adjustments (if bank made a mistake) $..............................

Cash available as at                        28/02/20XX                 $92,710

TRUST CASH BOOK – MARCH-SIMPLIFIED LAYOUT

Receipts

1 FEBRUARY BALANCE B/FWD 92,710

Date Receipt no. $

4 March 673 10,000

6 674 4,000

29 675 30,000

30 676 4,000

  Total Receipts $

TRUST CASH BOOK- MARCH-SIMPLIFIED LAYOUT Payments

Date Cheque number $

2 515 20,000

7 516 15,000

15 517 3,200

18 518 7,100

29 519 500

  Total Payments $

Balance C/Fwd to April  

BANK ACCOUNT STATEMENT MARCH 

Date Details Debit Credit Balance

March $ $ $

1 Balance B/Fwd 92,410

1 Receipt 672 4,800 97,210

2 Chq 515 20,000 77,210

4 Receipt 673 10,000 87,210

6 Receipt 674 4,000 91,210

7 Chq 516 15,000 76,210

8 Chq 514 350 75,860

10 Direct Deposit 2,000 77,860

15 Chq 517 3,200 74,660

18 Chq 518 7,100 67,560

25 Dishonoured Chq 1,200 66,360

29 Receipt 675 30,000 96,360

30 Direct Deposit 2,000 98,360

30 Closing Balance 98,360

CASH BOOK RECONCILIATION MARCH

Balance brought forward as at 01 /03/20XX $...............................

Add receipts this period $............................... $...............................

Less payments this period $...............................

Balance carried forward as at 31/03/20XX 

BANK RECONCILIATION MARCH $...............................

Bank statement balance as at 31/03/20XX

  $...........................

Add Outstanding Deposits (list them)  $...........................

Add Bank Charges 

Less Unpresented cheques (list them) Cheque # $ 

  $...........................

$............................

$..........................

Cash available as at                            31/03/20XX $..........................