Reconciliations prove that a balance is right, not just that two numbers agree. These guides cover bank, supplier statement, balance sheet, intercompany, suspense, payables and receivables reconciliations, how to treat reconciling items, and Excel matching methods.
Common bank reconciliation items explained: outstanding cheques, deposits in transit, bank charges and errors, with how to treat each and when to clear them.
A general account reconciliation template in Excel that works for any balance sheet account, with reconciling items, evidence, ageing and a sign-off gate.
A risk-based way to decide which balance sheet accounts to reconcile monthly, quarterly or yearly, with a simple scoring sheet and a written policy.
Use INDEX and MATCH to look up account balances, supplier details and prior-period figures in Excel, with exact matching and checks for missing items.
Why Excel reconciliations show tiny differences like 0.01 or 0.0000001, and how ROUND, precise totals and a tolerance check stop them hiding real errors.
How to reconcile payroll monthly: payroll report to ledger, net pay to bank, and deduction control accounts to amounts paid over.
Reconcile the VAT or sales tax control account to the return and payments, find common causes of differences and keep an audit trail.
Reconcile inventory: count to stock records, stock records to the ledger, and how to investigate variances, cut-off and slow stock.
How to reconcile clearing and transit accounts: match entries in and out in Excel, age what is left and keep the balance near zero.
Reconcile the fixed asset register to the ledger by class: cost and depreciation separately, a movement schedule and common differences.
A checklist for reviewing balance sheet reconciliations: balance agreement, evidence, aged items, judgement areas, red flags and sign-off.
Reconcile a foreign currency bank account in its own currency, then revalue the balance and handle exchange differences, transfers and fees.
How accountants use XLOOKUP: supplier and account lookups, not-found handling, latest-match lookups, multiple criteria and two-way lookups, with examples.
What a good bank reconciliation template in Excel must do, and how free, paid and AI-assisted options compare on matching, controls, cost and effort.
What AI matching in bank reconciliation software actually does, where it helps, what it can't do for you and the questions to ask before you buy.
Match bank statement lines to cash book entries in Excel: one sign convention, a unique matching key for repeated amounts, date windows and batched deposits.
How small businesses can automate bank reconciliation: bank feeds and rules, Excel formulas or AI matching, plus the checks automation still needs.
A repeatable bank reconciliation system for bookkeepers with many clients: one standard workbook, a client tracker with status formulas and a review routine.
What supplier statement reconciliation software should do, the features that save time, the questions to ask and when a controlled Excel method is enough.
How US accounts payable teams reconcile a vendor statement to the AP subledger: open items, checks and ACH in transit, credit memos and the reconciliation.
Reconcile a supplier statement to your ledger: match payments and invoices, classify every difference, agree the balance and spot red flags.
A step-by-step bank reconciliation in Excel: the layout, matching formulas, adjusting both balances, ageing open items and the review that makes it a control.
How to run balance sheet reconciliations every month: account ownership, risk rating, the evidence each account needs, handling reconciling items and review.
What a suspense account is, why balances build up in it, and a monthly routine to clear every item to the right account before the books are signed off.
How to reconcile intercompany balances between group companies, agree differences before consolidation and stop the same mismatches recurring every month.
Match bank, ledger or supplier transactions in Excel with a matching key, COUNTIFS and XLOOKUP, including repeated amounts, and list what is left unmatched.
How to reconcile the accounts payable subledger to the general ledger control account, find the usual causes of differences and sign off a clean reconciliation.
Reconcile the receivables subledger to the ledger every month, deal with unapplied cash and credit balances, and tie the result to your bad debt provision.
Run petty cash on an imprest system, count and reconcile it on a fixed schedule, and record top-ups so the float always agrees to cash plus vouchers.
Paste or upload your invoice list and see likely duplicates in seconds. Runs in your browser; nothing is uploaded.
The Bank Reconciliation Template reconciles up to five bank accounts across eight transaction categories, with an allocation check that confirms every transaction is coded before the reconciliation counts as clean. Excel, no macros, one-time price.
The Supplier Statement Reconciliation Template keeps payments in transit, credit notes not yet on the statement and statement items not yet in your ledger as three separate reconciling items, and logs genuine queries instead of netting them into one difference. Excel, no macros, one-time price.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
Accounts Payable · Payment Fraud · Month-End Close · Cash & Credit · Fixed Assets · Expenses · Comparisons · Glossary
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.