Nova Ledgers insights

Step-by-Step Guide to Reconciling Bank Statements

A practical, step-by-step guide to reconciling bank statements for Canadian small businesses and freelancers.

Reconciling your bank statements is one of the most important bookkeeping tasks you can perform. It involves comparing your internal financial records with your bank’s records to confirm that transactions are complete, accurate, and properly recorded.

Regular reconciliation helps catch errors, identify missing or duplicate transactions, detect unusual activity, and ensure that your financial statements reflect your actual cash position. Skipping this step can lead to incorrect reports, cash-flow surprises, and unnecessary stress at tax time.

What is bank reconciliation?

Bank reconciliation is the process of matching the transactions in your accounting records to the transactions shown on your bank statement for a specific period. The goal is to explain any differences between your book balance and the bank’s balance and to make any necessary adjustments.

This process applies to chequing accounts, savings accounts, credit cards, and sometimes payment-processor accounts such as PayPal or Stripe, depending on how you record those balances.

1

Gather the necessary documents

Before you begin, collect everything you will need for the reconciliation period. Having all documents ready makes the process faster and reduces the chance of missing something.

  • Your bank statement for the period you are reconciling
  • Your internal transaction records (accounting software, ledger, or register)
  • Supporting documents such as receipts, invoices, deposit slips, and cancelled cheques
  • Prior reconciliation reports, if available
Practical step: Create a standard “reconciliation folder” for each account and period, either digitally or physically. Store statements, reports, and supporting documents together so they are easy to find later.
2

Review the bank statement carefully

Start by reading your bank statement from beginning to end. Look at the opening balance, closing balance, and every transaction in between. Pay attention to deposits, withdrawals, transfers, fees, interest, and any items you do not recognize.

Make a note of unusual transactions, such as unexpected fees, duplicate charges, or payments you cannot immediately identify. These will need further investigation.

Practical step: Highlight or flag any unfamiliar items on the statement before you start matching transactions. This keeps your focus on items that require follow-up.
3

Mark off cleared transactions

Go through your internal records and mark each transaction that appears on the bank statement. This includes deposits, cheques, electronic transfers, debit-card purchases, automatic payments, and any other items that have cleared the bank during the statement period.

Most accounting software includes a reconciliation module that lets you tick off transactions as you match them. If you use spreadsheets or manual ledgers, create a simple “cleared” column to track which items have been matched.

Practical step: Work in chronological order, starting with the opening balance and moving through each transaction until you reach the statement’s closing date.
4

Identify discrepancies

After marking off cleared transactions, you will have two lists of items to investigate: transactions in your records that do not appear on the bank statement, and transactions on the bank statement that do not appear in your records.

These differences are called reconciling items. Common examples include outstanding cheques, deposits in transit, bank fees, interest income, automatic payments you forgot to record, or data-entry errors.

Practical step: Create a simple discrepancy list that shows each unmatched item, the amount, and a brief description. This becomes your working document for the rest of the reconciliation.
5

Investigate each discrepancy

For every reconciling item, review your supporting documentation and try to determine the cause. Ask yourself whether the difference is due to timing, an omission, a duplicate entry, or an error in amount or account classification.

Common causes of discrepancies include timing differences between when you record a transaction and when the bank processes it, bank fees or interest you did not expect, missed or duplicate entries, and transposed numbers or other data-entry mistakes.

Practical step: For each discrepancy, note the cause and the action required. If you cannot identify the cause, contact your bank or payment processor for clarification before making adjustments.
6

Make necessary adjustments

Once you understand the cause of each discrepancy, update your internal records accordingly. This may involve recording missing transactions, correcting amounts, removing duplicates, or adding bank fees and interest that were not previously captured.

Be careful to distinguish between items that require an adjustment in your books and items that are simply timing differences, such as outstanding cheques or deposits in transit, which do not need to be re-recorded.

Practical step: Document each adjustment with a clear description and reference to supporting documents. This makes future reviews and audits much easier.
7

Reconcile the balances

After making all necessary adjustments, compare your adjusted book balance to the bank statement’s closing balance. If your reconciliation is complete and accurate, the two balances should agree once you account for outstanding items.

If the balances still do not match, re-check your work. Look for transposed numbers, missed transactions, double-counted items, or incorrect opening balances. Sometimes a small error in one transaction can throw off the entire reconciliation.

Practical step: Use a reconciliation summary that shows the bank statement balance, plus deposits in transit, minus outstanding cheques, adjusted for any other reconciling items, to arrive at your book balance.
8

Document and file your reconciliation

Once the reconciliation is complete and the balances agree, save your reconciliation report and all supporting documents. This includes the bank statement, your internal reports, your discrepancy list, and notes about any adjustments made.

Good documentation helps you identify patterns or recurring issues, supports your records during reviews or audits, and makes future reconciliations faster and more reliable.

Practical step: File reconciliations by account and period, either in your accounting software or in a secure digital folder. Retain records according to CRA guidance, generally for six years from the end of the last tax year they relate to. [246][248][249]

Common bank reconciliation issues

Even with careful work, discrepancies can occur. Understanding common issues helps you resolve them more quickly.

Timing differences

Transactions recorded in your books before the bank processes them, such as outstanding cheques or deposits in transit, create temporary differences that resolve in future periods.

Bank fees and interest

Monthly fees, transaction charges, overdraft fees, and interest income may appear on the bank statement but not yet in your records.

Missing or duplicate entries

Transactions that were never recorded, or were recorded twice, will cause your book balance to differ from the bank balance until corrected.

Data-entry errors

Transposed numbers, incorrect amounts, or postings to the wrong account can create discrepancies that require careful review to identify.

Recordkeeping reminder: The CRA generally expects businesses to keep complete, reliable books and records, including bank reconciliations and supporting documents, for six years from the end of the last tax year they relate to. [246][248][249]

How often should you reconcile?

The ideal frequency depends on your transaction volume and business needs. Many small businesses reconcile at least monthly, when bank statements are issued. Businesses with higher transaction volume or tighter cash-flow management may reconcile weekly or even daily.

Signs you should reconcile more often

  • You have many daily or weekly transactions
  • Cash flow is tight and you need up-to-date balances
  • You have had issues with fraud, errors, or missing transactions in the past
  • You manage multiple accounts or payment processors
  • You want cleaner records for tax time and financial reporting

The bottom line

Reconciling bank statements is a fundamental bookkeeping task that protects the accuracy of your financial records. By following a consistent step-by-step process, you can identify errors, prevent small issues from becoming large problems, and maintain confidence in your financial information.

Make reconciliation a regular habit, document your work, and seek professional support if your accounts become complex or consistently difficult to balance. Over time, this discipline will save you time, reduce stress, and provide a stronger foundation for managing your business finances.

Need help with your bank reconciliations?

Nova Ledgers provides practical bookkeeping support to help small businesses and freelancers keep accurate records, reconcile accounts regularly, and prepare for tax time with confidence.

Request a Consultation

Disclaimer: This article provides general educational information only and is not tax, legal, financial, or accounting advice. Recordkeeping, reporting, and compliance obligations depend on your business structure, activities, and circumstances. Consult the CRA and qualified professionals for advice specific to your business.

Share your love
Nadeem Usmani
Nadeem Usmani
Articles: 21

Newsletter Updates

Enter your email address below and subscribe to our newsletter