Bank Reconciliation Checklist: A Step-by-Step Guide for Canadian Businesses

Use this bank reconciliation checklist to match records, investigate differences, document adjustments, and keep Canadian business books review-ready each month.

Bank Reconciliation Checklist: A Step-by-Step Guide for Canadian Businesses

A bank reconciliation compares your accounting records with the bank statement for the same account and period. The goal is not simply to make the numbers agree. It is to explain every difference, record supported adjustments, and retain enough evidence for another person to follow your work.

This checklist is a practical bookkeeping control for Canadian businesses, freelancers, and administrators. It is not an official CRA form or prescribed Ontario template, but it can help identify problems before tax preparation or year-end.

Quick summary

Reconciliation checklist, receipts, calculator, and highlighted bank statement entries on an office desk
  • Gather the bank statement, general ledger, prior reconciliation, and supporting transaction records.
  • Confirm the statement period, account, opening balance, and prior adjusted book balance.
  • Match cleared deposits, withdrawals, transfers, fees, cheques, and electronic payments.
  • Classify every difference as a timing item, omission, duplicate, coding error, amount error, or possible bank issue.
  • Post only supported adjustments, document unresolved items, and confirm that the adjusted book balance agrees with the statement.

What you need before starting

Prepare the complete bank statement for the period, including its opening and closing balances. You also need the matching general ledger or reconciliation screen, the previous completed reconciliation, and access to invoices, receipts, deposit records, payment confirmations, and transfer details.

Include credit card, merchant, payment-platform, or online payment records when those accounts feed into the books. A broader account reconciliations process should cover every account that affects your financial statements, not just the main operating bank account.

Make sure the book period and statement period align. If the statement covers September 1 to September 30 but the ledger includes October transactions, the comparison will not produce a meaningful result.

CRA guidance identifies bank statements, deposit slips, cancelled cheques, ledgers, journals, financial statements, and working papers as records that can support business transactions. Keep these documents organized with the reconciliation rather than treating the final balance as the only evidence. CRA recordkeeping guidance provides further detail.

The bank reconciliation checklist

Bookkeeper reviewing cloud-based financial records and supporting documents during monthly close
TaskEvidence to checkCompletion signal
Confirm the period and accountStatement, account name, and statement datesThe statement and ledger cover the same account and period.
Verify the opening balancePrior reconciliation and current statementThe opening balance agrees with the prior adjusted balance.
Match cleared transactionsDeposits, withdrawals, cheques, transfers, fees, and payment recordsCleared items agree by amount and reference.
Investigate differencesReceipts, invoices, deposit slips, confirmations, and ledger detailsEach difference has a documented explanation.
Post supported adjustmentsEvidence for fees, interest, corrections, or omitted transactionsAdjustments are recorded in the correct period and account.
List outstanding itemsUncleared cheques, deposits in transit, and pending transactionsTiming items are separated from errors and monitored.
Review and retainReconciliation report, statement, working papers, and supportThe adjusted book balance agrees with the statement.

1. Confirm the period and opening balance

Check the bank account identity, statement dates, opening balance, and closing balance. Then compare the current opening book balance with the prior reconciliation’s adjusted book balance.

An incorrect opening balance is a foundational problem. Do not compensate for it by adding an unsupported adjustment to the current period. Trace the difference to the prior reconciliation, an opening entry, a deleted transaction, or a transaction posted to the wrong account.

2. Match cleared transactions

Work through the statement and ledger systematically. Match deposits, withdrawals, cheques, electronic payments, transfers, bank charges, interest, and card activity using the amount, date, payee or payer, and transaction reference.

A bank feed can speed up data entry, but it is not the same as a completed reconciliation. Check whether transactions were imported twice, omitted, categorized incorrectly, or matched to the wrong invoice. Compare the ledger with the statement rather than relying only on a cleared status.

Pay particular attention to deposits in transit and payments recorded in the books that have not yet appeared on the statement. These may be legitimate timing differences, but they should have a clear source document and reasonable explanation.

3. Investigate every difference

When the balances do not agree, create a difference log. Record the amount, date, account, suspected cause, evidence reviewed, person responsible, and next action.

A useful CRA compliance checklist connects bank and credit card reconciliations with source-document retention, discrepancy resolution, review controls, and filing readiness.

  • Timing item: The transaction is correctly recorded but has not cleared the bank, such as an outstanding cheque or deposit in transit.
  • Omitted transaction: The bank shows activity missing from the ledger, such as a service charge or customer deposit.
  • Duplicate: The same transaction appears twice in the books or was imported and entered manually.
  • Coding error: The amount is present but posted to the wrong account, category, customer, or vendor.
  • Amount or date error: The transaction was recorded with incorrect details.
  • Possible bank issue: The statement or bank record may need clarification after the books and support have been checked.

Never force the reconciliation to balance with a vague miscellaneous entry. That can hide the original problem and distort expenses, income, tax accounts, or the bank balance.

4. Record supported adjustments and track outstanding items

Post an adjustment only when you know what it represents and have suitable support. Common examples include bank fees, interest income, an omitted deposit, a duplicated entry, or a transfer recorded in the wrong account.

Use the correct transaction date and account, then attach or reference the evidence. If the adjustment affects GST/HST, payroll, revenue, or an expense claim, review the related tax and reporting records as well.

Outstanding items are different from errors. An uncleared cheque can remain if it is valid, properly recorded, and expected to clear. A deposit in transit can remain if it is supported and appears in the next statement. Keep these items on an exceptions list and investigate anything that becomes stale or recurs unusually often.

For unresolved items, document what you know instead of changing the books simply to reach zero. A reviewer should be able to see the amount, reason, evidence, owner, and planned follow-up.

5. Apply the completion test and retain evidence

A reconciliation is complete when the adjusted book balance agrees with the bank statement balance after legitimate reconciling items are considered. Every remaining difference should be listed, explained, and supported. The report should also show the account, period, preparer, completion date, and reviewer where applicable.

Retain the completed reconciliation, bank statement, transaction detail, adjustment entries, exception log, and supporting documents together. CRA materials identify bank reconciliation statements, transaction journals, accounts receivable and payable lists, payroll journals, and GST/HST records as examples of financial records.

Canadian businesses must keep records that support income and expense claims and are generally required to retain them for at least six years. Maintain records in a clear, readable format and confirm the requirements that apply to your circumstances. CRA business-record guidance explains this general requirement.

How often should you reconcile?

There is no single frequency for every business. Choose a cadence based on transaction volume, account complexity, cash sensitivity, reporting deadlines, and how quickly an error would affect operations.

  • Lower-volume business: Monthly reconciliation may be practical when there are few transactions and limited payment activity.
  • Moderate-volume business: A weekly review followed by a formal monthly reconciliation can keep records current.
  • Higher-volume or cash-sensitive business: More frequent matching may be appropriate with daily deposits, multiple payment channels, or payroll activity.

Building routine reconciliation into the bookkeeping schedule helps errors surface promptly and keeps reports, tax records, and cash decisions based on reconciled information.

Common reconciliation problems and what to check

  • Duplicate transaction: Search for matching dates and amounts, then check whether an import duplicated a manually entered item.
  • Missing deposit: Compare the deposit slip, sales records, merchant report, and following statements.
  • Bank fee or interest: Check for statement charges or credits that were never entered in the ledger.
  • Transfer recorded twice: Check both sides of the transfer so it does not become a second expense or deposit.
  • Stale cheque: Confirm whether the payment remains valid, was replaced, or should be reversed.
  • Incorrect opening balance: Revisit the prior reconciliation and opening entries rather than making an unexplained current-period adjustment.
  • Unmatched merchant activity: Compare gross sales, fees, refunds, payouts, and settlement dates.

Why reconciliation matters beyond the bank balance

Reliable reconciliations support financial statements because cash, revenue, expense, receivable, payable, and transfer balances are based on reviewed activity. They also make it easier to prepare GST/HST information, provide records for tax preparation, investigate unusual transactions, and assemble audit-ready working papers.

Reconciliation does not guarantee tax savings, CRA acceptance, or error-free books. It is one control within a broader process that includes source-document capture, appropriate coding, review, filing calendars, and retention.

Verma Accounting describes its bookkeeping work as including organized ledgers and reconciliations that support audits, tax preparation, and informed business decisions.

Using cloud-based records without losing control

Cloud-based recordkeeping can make statements, receipts, reconciliation reports, and adjustment support available to the people responsible for preparing and reviewing the books. It can also support consistent folders, document attachments, and shared questions.

Access alone does not create control. Use clear file names, defined user permissions, a consistent close checklist, and a documented review process. Keep an accessible copy of important records according to your retention and continuity procedures.

When to manage reconciliations internally and when to get support

Internal reconciliation may be suitable when transaction volume is manageable, the account structure is simple, supporting documents are captured consistently, and someone has enough time and confidence to investigate exceptions.

Structured bookkeeping support may be useful when reconciliations are routinely delayed, several bank or payment accounts are involved, exceptions remain unresolved, opening balances are uncertain, or financial reports are needed for tax, lending, management, or year-end deadlines.

Ask any provider to define the scope, cadence, accounts included, document workflow, review responsibilities, reporting deliverables, and handoff process. A clear monthly close checklist should identify what is complete, what remains outstanding, and who owns the next step.

Frequently asked questions

A bank statement is issued by the financial institution and lists account activity. A bank reconciliation is your documented comparison of that statement with the accounting records, including explanations for timing items and adjustments.

Yes, if they are valid, recorded correctly, and have not yet cleared. Follow up if they become stale, are replaced, or no longer represent a payment that should proceed.

Stop and create a difference log. Recheck the opening balance, statement period, duplicates, missing transactions, transfers, fees, and amount errors. Do not post an unsupported adjustment merely to make the difference disappear.

Businesses are generally required to retain records supporting income and expense claims for at least six years. Keep the reconciliation with the statement and supporting working papers.

No. Bank feeds can assist with importing and matching transactions, but you still need to compare the books with the official statement, investigate exceptions, verify support, and save evidence.

Conclusion

A strong bank reconciliation is an explained and supported control, not just a zero difference on a screen. Start with the correct period and opening balance, match every cleared transaction, separate timing items from errors, record supported adjustments, and retain the evidence a reviewer would need.

If the process is consistently delayed or exceptions are difficult to resolve, the issue may be the bookkeeping workflow rather than the checklist itself. Verma Accounting & Financial Services provides bookkeeping, reconciliations, financial accounting, and cloud-based support for individuals and businesses across Ontario and Canada. Verma Accounting & Financial Services can discuss a structured approach based on your records and reporting needs.