How do you use a bookkeeping reconciliation guide?

Bank reconciliation is the monthly check that makes sure the cash numbers in your books match the bank’s records. When done correctly it catches timing differences, bookkeeping mistakes, and signs of fraud before they become larger problems. For a straightforward explanation of what reconciliation is and why it matters, see the Hivebooks guide and QuickBooks Canada’s guide. For a worked stepwise method and checklist, consult the BookkeepingFlow resource.

Why reconcile your bank accounts and how often to run reconciliation

Reconciliation protects cash accuracy, supports payroll controls, and creates audit-ready documentation you can show to the CRA or an external reviewer. Reconciliation helps you spot discrepancies caused by timing differences, bookkeeping errors, or fraud and prevents simple mistakes from cascading into tax or payroll reporting problems.

Recommended frequency depends on activity level. Most small businesses reconcile monthly at minimum. High-volume operations, businesses with frequent deposits, or payroll-heavy firms should reconcile weekly or at each payroll cycle. Reconcile before preparing GST/HST reports, payroll remittances, or year-end financials so the numbers you file are based on agreed balances.

Prepare before you start: what to gather and initial checks

Before you begin, gather these items and complete a quick pre-check:

• Latest bank statement (PDF) or the online statement period you will reconcile.
• Your last reconciliation report and the reported closing balance for the account.
• Access to your cloud accounting system and confirmation that bank feeds have been imported.
• A list of outstanding cheques, uncleared deposits, and pending transfers.
• Source documents for any unusual items: deposit slips, payment advices, vendor invoices, and pay stubs.

Stop if the opening balance in your books does not match the bank’s opening balance. That difference must be investigated first, because reconciling with a wrong opening balance will not resolve the true underlying issue. Perform a top-down check for prior-period adjustments or mis-posted balances before continuing.

Step-by-step reconciliation workflow with explicit stop points

Workflow steps (set dates, match transactions, identify reconciling items, post adjustments, finalise and sign off)

1. Set the statement period and confirm opening balance.

   Enter the bank statement end date and opening balance in your accounting software’s reconciliation module. If the opening balance differs from your records, pause and trace prior reconciliations or prior-period journal entries that might have been changed.

2. Import or confirm the bank feed and clear obvious matches.

   Use your bank feed to match deposits, withdrawals, and card charges. Tick or mark items that are identical in amount and date. Do not edit bank-imported transactions before attempting a match; editing imported items can create reconciliation mismatches.

3. Identify timing differences and expected uncleared items.

   Flag cheques issued but not yet cashed, direct deposits that arrived after the statement date, and items in transit. Record these as reconciling items on your working paper so they are visible for the next period.

4. Add missing bank charges, interest, or NSF items.

   Enter bank fees, interest income, or returned item charges that appear on the bank statement but are not recorded in your books. Attach a scanned copy of the bank statement line or bank notice as supporting documentation before posting these entries.

5. Investigate unmatched items and duplicate entries.

   If a transaction exists in both places but with a different amount, trace the source document: invoice, payment stub, or deposit slip. For duplicates, identify which entry is incorrect and delete or correct the duplicate. Stop and resolve differences that cannot be explained by timing or simple categorization before posting journal adjustments.

6. Post adjustments with supporting evidence only.

   Post journal entries for bank charges, interest, or corrections only when you have documentary support. Avoid posting balancing entries to force a zero difference unless you can cite evidence. Record corrections with clear memos and attach the bank statement lines used to justify the entry.

7. Confirm the reconciliation, generate the report, and sign off.

   Once the difference equals zero, generate the reconciliation report and save it with the bank statement and any working papers. Have the bookkeeper or reviewer sign or initial the reconciliation in your cloud file or PDF metadata to create an audit trail.

Troubleshoot common reconciliation discrepancies and how to resolve them

Common causes of a reconciliation difference and practical resolution steps are:

• Timing differences — outstanding cheques or deposits in transit. Resolution: list as reconciling items and verify next-period clearance.
• Duplicate entries — the same receipt or payment recorded twice. Resolution: identify and remove the duplicate, keeping the original source document.
• Missing entries — bank charges, interest, or third-party payments not recorded. Resolution: post supported journal entries and attach bank evidence.
• Wrong amounts or mis-categorization — amount keyed incorrectly or expense posted to the wrong account. Resolution: correct the amount or reclassify using a supporting invoice or deposit slip.
• Inter-account transfers — transfers between your accounts recorded inconsistently. Resolution: ensure both sides of the transfer are recorded and use a clearing account if needed.
• Bank errors or fraud — unauthorized withdrawals or bank posting mistakes. Resolution: contact the bank immediately, document communications, and escalate to an accountant if fraud is suspected.

Many reconciling differences are routine timing issues. Only escalate after you have traced entries back to source documents and attempted the standard corrections described above.

Quick software tips for QuickBooks, Xero, FreshBooks and Wave

• Use bank feeds and rules to reduce manual matching. Set rules for recurring supplier payments or regular deposits so transactions import categorised consistently.
• Prefer the reconciler or statement view when ticking items rather than editing bank-imported transactions, because editing imports can change the original feed and cause confusion later.
• Keep a clearing account for transfers between your own bank accounts to avoid double counting when both accounts are reconciled separately.
• Attach supporting documents to transactions in your cloud accounting system so the next reviewer can see proof without searching email or filing cabinets.
• Save the reconciliation report and a copy of the bank statement in the same secure cloud folder for audit readiness.

For product-specific details, consult each platform’s help pages. The QuickBooks Canada resource provides a practical overview of handling timing and feed issues in that system.

When to escalate: decision criteria for calling an accountant

Call an accountant when one of these conditions applies:

• You cannot reconcile a persistent difference after tracing prior-period adjustments and verifying source documents.
• There are complex intercompany or multi-currency transactions that require accounting judgement.
• You suspect bank fraud, unauthorized transfers, or repeated bank errors.
• Payroll or GST/HST control accounts do not reconcile and you need adjustments before filing returns.
• You are preparing for an audit or a CRA inquiry and need audit-ready reconciliations and supporting schedules.

When you contact an accountant, have the bank statement, reconciliation report, trial balance, and copies of source documents ready. Verma Accounting & Financial Services offers clean-up, recurring reconciliations, and audit support. Learn more about the firm’s services on the bookkeeping page or request a free consultation via the firm website.

Reconciliation checklist, documentation and how to store sign-off

Use this concise checklist each cycle and store the signed files in a secure cloud folder for the period required by your retention policy.

1. Confirm statement period and opening balance match the last reconciliation.
2. Import bank feed and match all clear transactions where amounts and dates align.
3. List outstanding cheques, deposits in transit and inter-account transfers as reconciling items.
4. Post bank charges, interest, and NSF entries with supporting documentation attached.
5. Resolve duplicates, mis-postings, and amount mismatches using source documents.
6. Post only supported journal entries and document the reason in the memo field.
7. Confirm the reconciliation difference is zero, generate the reconciliation report, and attach the bank statement.
8. Save the report and supporting documents in the cloud and record the reviewer’s sign-off.

Keep reconciliations and supporting documents grouped by year and account in secure cloud storage to ensure audit readiness and easy retrieval for CRA compliance or third-party review.

Local help in Ontario and next steps if you need professional support

If you prefer to outsource reconciliations or need help cleaning up a backlog, Verma Accounting & Financial Services provides remote bookkeeping and reconciliation services across Canada and local support from Nepean/Ottawa. Verma operates with cloud-based systems for secure, audit-ready records and offers a free consultation plus a three-step onboarding process that covers consultation, setup and review, and ongoing support. See the firm’s bookkeeping page to request a consultation.