Reconcile cash at month-end

Reviewed by Ijaz Ali, ACCA · Updated November 2026

You are the staff accountant at North Harbour Fixtures Ltd. The controller wants the June 30 reconciliation for the company’s Canadian-dollar bank account. The prior month is reconciled.

June 30 balances
SourceCAD balance
Bank statement18,640
General ledger19,125
Items identified during matching
EvidenceCAD amountWhere recorded
June 30 deposit D-309, credited July 21,500Ledger only
Supplier EFT 618, cleared July 31,050Ledger only
June bank service charge85Bank only
Customer EFT, remittance confirms existing AR invoice50Bank only

Your tasks

  1. Reconcile the statement balance to adjusted bank cash.
  2. Identify which reconciling items require book entries and post the corrections.
  3. Reconcile book cash to the same total and report your findings to the controller.

Check your figures

  1. Adjusted bank balance
  2. Net book adjustment (use a minus sign for a decrease)
  3. Adjusted book balance

Make the decision

Which entries belong in June’s ledger?

Reveal worked solution

Bank side: $18,640 + $1,500 deposit in transit − $1,050 outstanding EFT = $19,090. Book side: $19,125 − $85 bank fee + $50 customer EFT = $19,090. The book adjustment is a net $35 reduction. The deposit and outgoing EFT are timing items already posted in the ledger.

June 30 correcting journal entries (CAD)
EntryAccountDebitCredit
Bank service chargeBank charges$85—
Cash—$85
Customer EFT against an existing invoiceCash$50—
Accounts receivable—$50

Document your recommendation

Write a short note to the controller that explains the reconciliation, entries and evidence to retain.

Compare with a model controller note

Both June cash balances reconcile to $19,090. Please approve the $85 bank fee and $50 customer receipt entries. The $1,500 deposit and $1,050 outgoing EFT were already recorded and cleared in July. I have retained the bank statement, remittance and July clearing evidence.

In the workplace

  1. Attach the July clearing evidence to the June reconciliation and follow up on older uncleared items.
  2. Use SAP electronic bank statement matching and have a reviewer approve exceptions and resulting journal entries.

What’s next

Try another case:

Review the related lesson: Bank reconciliation

Want one-to-one help with month-end close or SAP? Book a free 30-minute intro

All companies, people and figures in this case are fictional and for study purposes only.

About the tutor

Ijaz Ali is an ACCA-qualified Senior Accountant with over 10 years of experience in financial reporting, month-end close and SAP FICO. He is a former SAP FICO instructor and runs The Accounting Nest YouTube channel.

Watch on YouTube