Transaction Matching and Reconciliation: A Bookkeeper's Working Method

Reconciliation is where a clean set of books proves itself. Every balance on the trial balance should trace to something outside the ledger: a bank statement, a supplier statement, a loan schedule, a payroll report. Transaction matching is the mechanical heart of that process. This article sets out how we approach both, in a sequence you can repeat every month.

What reconciliation actually asserts?

A reconciliation does not say the balance is right. It says the ledger balance and the external evidence differ only by items you can name and date. That is a subtle but important distinction. A reconciled account can still contain misposted amounts, duplicated invoices or wrong nominal codes. Matching catches those; reconciliation alone does not.

So we treat the two as separate steps. First match the individual transactions. Then reconcile the balances. Doing it in that order means the reconciliation becomes a summary of explained differences rather than a hunt for them.

Where does matching fit in the month-end close?

Matching belongs early in the close, not at the end. The sequence we follow is:

1. Lock off the bank feed and import statements for the period.
2. Match statement lines to ledger entries, one account at a time.
3. Investigate unmatched items on both sides.
4. Post correcting journals for genuine errors, with a working-paper reference.
5. Reconcile the closing balance and file the reconciliation with the statement.

Running it this way means the corrections land before the management accounts are drafted. Errors found after reporting goes out cost far more time than errors found on day two.

A worked example: the bank account

Suppose the ledger shows a closing bank balance of 12,480. The statement shows 12,150. The difference is 330. You list the reconciling items:

• A cheque issued for 410, recorded in the ledger, not yet presented.
• A customer receipt of 180 paid in on the last day, not yet on the statement.
• A bank charge of 100 on the statement, not yet posted.

Check the arithmetic: 12,480 minus 410 plus 180 minus 100 equals 12,150. The reconciliation balances. You post the bank charge journal, keep the other two as timing items, and file the statement with the working paper. Next month those two items should clear; if the unpresented cheque is still there after two months, that is a stale item worth chasing.

How do you tell an error from a timing difference?

This is the judgement call that separates experienced reconcilers from software operators. A timing difference is dated, expected and self-clearing: a payment in transit, a card settlement lag, a month-end cut-off. An error is none of those.

Ask three questions of every unmatched item. Is there a plausible reason it appears on one side only? Will it clear next period without action? Is the amount or counterparty what you expected? A yes to all three suggests timing. A no to any of them suggests a posting error, a duplicate, or something missing entirely, and it needs a journal or an investigation, not patience.

Which accounts need the full treatment?

Bank and credit card accounts get full matching every month; that is non-negotiable. Beyond those, prioritise by risk. Supplier statements for major trade creditors, the payroll control accounts, VAT or sales tax control accounts, and any intercompany balances deserve regular reconciliation. Prepayments, accruals and fixed asset registers reconcile on a longer cycle, but each close should still prove the balance moves only by amounts you can explain.

Control accounts are the ones that bite. A payroll control account that never reconciles is usually absorbing small errors month after month. Clear it fully once, then reconcile it monthly, and it stays quiet.

What evidence should you keep?

Every reconciliation should be filed with the statement or schedule it was reconciled against, the list of reconciling items, and references for any journals posted. The test we apply: could a colleague pick up the file in six months and understand every difference without asking you? If not, the working paper is not finished.

Where automation tools do the matching for you, the evidence obligation does not change. Review logs, exception lists and the sign-off record are part of the working papers. Automation shifts your effort from ticking to investigating, and the exceptions are where your attention belongs.

When does a mismatch stop being bookkeeping?

Some differences point to data problems rather than posting problems. If matching rules keep misfiring, opening balances do not agree with anything you can trace, or transactions appear duplicated after a migration or conversion, the ledger itself may be damaged. Preserve a backup or verified copy before anyone edits further, and note exactly what you observed.

At that point the work has moved beyond routine bookkeeping. Our QuickBooks data recovery service handles damaged company files, and our accounting data migration specialists deal with balances that went wrong in a move between systems. Hand over the evidence you preserved; it makes the repair faster and cheaper.