A Practical Guide to Bookkeeping Reconciliations Guide

Reconciliations are the backbone of trustworthy books. They connect what third parties say you owe or have collected (banks, card processors, lenders, vendors, payroll providers) with what your general ledger (GL) shows. Done well, reconciliations prevent small posting errors from snowballing into misstated financial statements, cash surprises, or year‑end delays.

Important limitation: This guide is for general information only. It is not accounting, tax, or legal advice. For your specific situation, consult a qualified professional.

Why reconciliations matter

Reconciling ensures that every dollar entering or leaving your business is recorded once, in the right place, and at the right time. It provides a structured way to detect:

• Timing differences (e.g., deposits in transit, outstanding cheques, undeposited funds)
• Data entry errors (transposed numbers, duplicate postings, missing transactions)
• System sync gaps (bank feeds, payment gateways, POS integrations)
• Unusual activity requiring follow‑up (unknown charges, unexpected fees, reversed payments)

Consistent reconciliations also create a clean audit trail, speed up monthly reporting, and make year‑end adjustments smaller and easier to understand.

Core reconciliation types

Most businesses benefit from a standard set of reconciliations. Tailor this list to match your accounts and transaction volume.

• Bank accounts: Match the GL cash account(s) to monthly bank statements. Track deposits in transit, outstanding cheques, bank fees, and interest.
• Credit cards: Tie each card account to its statement. Watch for duplicate charges, refunds not yet posted, and auto‑payments.
• Payment processors: Reconcile gateways (e.g., merchant accounts, e‑commerce platforms) to sales and cash received. Bridge gross sales to net deposits, accounting for processing fees and chargebacks.
• Accounts receivable (A/R): Agree the A/R subledger or ageing to the GL control account. Investigate unapplied receipts, credit memos, and write‑offs.
• Accounts payable (A/P): Tie the A/P subledger or ageing to the GL control account. Resolve unvouchered receipts, duplicate bills, and credits awaiting application.
• Payroll clearing and liabilities: Reconcile gross payroll, deductions, employer costs, and remittances to the GL and to third‑party reports from payroll systems.
• Inventory: Match inventory subledger or counts to the GL. Review cost flows (e.g., average, FIFO), shrinkage, and pending receipts not yet invoiced.
• Fixed assets and depreciation: Reconcile additions, disposals, and accumulated depreciation. Confirm that capitalized items meet policy thresholds.
• Prepaids and accruals: Roll forward schedules and ensure amortization or accrual reversals occur as planned.
• Intercompany and shareholder loans: Confirm balances and reciprocal entries across entities or parties.
• Petty cash and undeposited funds: Count on hand and match to recorded balances, clearing items to the bank upon deposit.
• Sales taxes collected/payable: Reconcile sales tax accounts (e.g., GST/HST as applicable) to revenue records and filings.

Monthly reconciliation workflow

Use this consistent five‑phase process to close the month with confidence.

1. Prepare source records
   • Download bank, credit card, and processor statements for the full period.
   • Freeze inputs by agreeing on a cut‑off date/time for posting.
   • Export subledgers (A/R, A/P, inventory, payroll) and any POS summaries.
   • Update roll‑forward schedules (prepaids, accruals, fixed assets).
2. Match transactions
   • Start with cash: tick deposits and withdrawals to the GL.
   • Flag timing differences: deposits in transit, outstanding cheques, unsettled batches.
   • Record missing items: bank fees, interest, service charges, processor fees.
   • Clear suspense or undeposited funds to the correct account.
3. Investigate and correct
   • Research unmatched or duplicate items; correct coding or dates.
   • Post accruals/adjustments for cut‑off (received not invoiced, earned not billed).
   • Apply cash to open invoices/bills; resolve unapplied credits.
   • Escalate unknown charges for approval or dispute.
4. Summarize reconciliation
   • Prepare a reconciliation statement showing GL balance, statement balance, and reconciling items.
   • Attach supporting documents: statements, reports, schedules, and screenshots as needed.
   • Note open items, owners, and due dates in a tracker.
5. Review and lock
   • Secondary review: verify math, footing, dates, and explanations.
   • Lock the period in your accounting system when policy allows.
   • Archive the final package in a dated folder with standardized naming.

Checklists and templates

Adopt simple, repeatable tools. The following templates can be recreated in your preferred software.

Bank reconciliation template (essentials)

• Statement ending balance: $____
• Add: Deposits in transit (list by date/amount)
• Less: Outstanding cheques/withdrawals (list by date/amount)
• Adjusted statement balance: $____
• GL cash balance: $____
• Reconciling items (fees, interest, errors): $____
• Difference to resolve: $____ (target = $0)
• Notes on exceptions and next steps

A/R reconciliation template

• GL A/R ending balance: $____
• Subledger/ageing total: $____
• Variance: $____
• Breakdown: unapplied cash $____; credit memos $____; write‑offs pending $____
• Customer exceptions (with IDs, amounts, owners)

A/P reconciliation template

• GL A/P ending balance: $____
• Subledger/ageing total: $____
• Variance: $____
• Unvouchered receipts $____; duplicate bills $____; credits to apply $____
• Vendor exceptions (with IDs, amounts, owners)

Controls and policies that stick

Practical guardrails make reconciliations faster and more reliable.

• Close calendar: Define cut‑off dates, role ownership, and SLA targets for each account.
• Materiality: Set thresholds for investigation (e.g., research any variance over $X or older than Y days).
• Documentation standards: Require statements, screenshots, tick marks/legends, and sign‑offs.
• Segregation of duties: Where possible, separate preparer and reviewer roles.
• Naming conventions: Use predictable folder and file names: YYYY‑MM Account Name Reconciliation.
• Version control: Save working drafts distinctly from the final, signed package.
• Access management: Limit who can post after cut‑off; monitor late entries with a change log.
• Exception tracker: Centralize open items with owners, due dates, and status.
• Policy for stale items: Escalate any reconciling item older than one close cycle.

Common pitfalls and fixes

• Relying solely on bank feeds: Feeds can miss or duplicate transactions. Always reconcile to the actual statement.
• Posting to wrong periods: Use clear cut‑offs and lock periods once closed.
• Letting suspense grow: Assign owners and deadlines for clearing suspense or undeposited funds.
• Ignoring small differences: Pennies add up. Use your materiality policy—and document waivers if applicable.
• Not tying subledgers: Always agree A/R, A/P, and inventory subledgers to GL controls monthly.
• Skipping secondary review: A fresh set of eyes catches drift, especially in high‑volume accounts.

How to handle timing differences

Not every mismatch means an error. Some items simply cross periods. Classify and track them transparently.

• Deposits in transit: Cash received and recorded, but not yet on the bank statement. List dates and amounts; verify they clear next period.
• Outstanding cheques/withdrawals: Cheques or payments recorded but not yet presented. Follow up on items older than expected clearing times.
• Unsettled card batches: Processor shows pending funds; recognize when reasonable and reverse if they do not settle.
• Accruals and deferrals: Record expenses or revenues in the right period with reversing entries if policy requires.

Error detection patterns

Use quick heuristics to spot issues fast:

• Round‑number bias: Many round entries can signal estimates or placeholders; verify support.
• Unusual vendor/customer names: One‑off or unfamiliar names deserve a closer look.
• Large or month‑end‑dated entries: Review for proper authorization and documentation.
• Negative balances where uncommon: Negative A/R or inventory often indicates misapplications.
• Uncleared items aging: Anything older than one cycle merits escalation.

Metrics to monitor

• Close timing: Days from period end to reconciliation completion by account.
• Exception volume: Count and dollar value of reconciling items carried forward.
• Adjustments per close: Number and size of post‑close entries.
• Subledger tie‑out quality: Variance between GL and subledgers (target zero).

Tools and file organization

Use a simple, documented structure so anyone can follow the trail months later.

• Folder hierarchy: Company → Year → Month → Reconciliations → (Account folders)
• Inside each account folder:
  • 01 Statement(s)
  • 02 Subledger/Reports
  • 03 Working Papers
  • 04 Journal Entries
  • 05 Final Reconciliation (signed)
• Naming: YYYY‑MM Account Name v1.xlsx (working), YYYY‑MM Account Name FINAL.pdf (final)

Scaling your process

As transaction volume grows, increase structure rather than complexity.

• Prioritize risk: Reconcile high‑risk accounts first (cash, processors, payroll, A/R, A/P).
• Automate matching: Use rule‑based matching where available, but maintain human review for exceptions.
• Standardize memos: Write journal entry descriptions so a new team member can understand them without context.
• Quarterly tune‑ups: Revisit policies, thresholds, and templates to reflect current operations.

Next steps