Account reconciliation means comparing the balance in your ledger with an independent record of the same account, then explaining every difference. The meaning reaches past bank accounts to receivables, payables, prepaid expenses and accruals. A reconciled account is one where the ledger balance, the outside evidence and a short list of reconciling items all agree.
What does account reconciliation mean in accounting?
Account reconciliation is the process of proving that a general ledger balance is correct by matching it to a second source that did not come from the ledger. The second source might be a bank statement, a customer aging report, a loan schedule or a vendor statement. The result is either agreement, or a list of named differences.
Most people first meet the term through the bank. A bank reconciliation compares the cash account in your books with the statement the bank sends. That is one case of a wider idea. Any account on the balance sheet holds a number that someone should be able to support, and reconciliation is how you support it.
The three parts of every reconciliation
Every reconciliation, whatever the account, has the same three parts:
- The ledger balance, taken from the trial balance at a stated date, such as the last day of the month.
- The supporting balance, taken from the independent source at the same date.
- Reconciling items, the specific transactions that explain why the two numbers differ, each with an amount, a date and a reason.
When the ledger balance plus or minus the reconciling items equals the supporting balance, the account is reconciled. If it does not, the unexplained amount is a problem to chase, not a number to hide.
What reconciliation is not
Reconciliation does not mean the ledger is correct in every detail. It means the balance has been tested against outside evidence on a given date. A receivables account can agree with the customer aging and still contain an invoice booked to the wrong customer. Reconciliation narrows the places an error can hide. It does not remove the need for review.
It also differs from simply running a report. A report that shows the ledger balance proves nothing by itself, because it comes from the same system that holds the error. The comparison with something outside the ledger is what gives the exercise its value.
For the bank case in depth, including what a finished bank reconciliation proves and who signs it, see what a bank reconciliation proves. This post stays with the wider meaning.
Which accounts need a reconciliation, and how often?
Any balance sheet account with a balance that matters should be reconciled, and the frequency should follow the risk. Cash and credit cards are usually done every month. Slow-moving accounts such as fixed assets or long-term debt can be done quarterly. The more transactions flow through an account, the more often it needs checking.
Two questions set the frequency. How many transactions move through the account, and how bad is an error that sits unnoticed for a quarter? A checking account with hundreds of lines a month needs a monthly tie-out, because a missed deposit or a duplicate payment compounds fast. A note payable with one payment a month and a lender statement is easy to confirm, so a quarterly check may be enough for a small business.
Rules of thumb for setting frequency
- Monthly for cash, credit cards, receivables, payables, payroll liabilities, sales tax payable and any clearing account that should be near zero.
- Monthly or quarterly for prepaid expenses, accrued liabilities and inventory, depending on how many entries post to them.
- Quarterly or at year end for fixed assets, long-term debt, equity and accounts that rarely change.
A firm that closes the books monthly often reconciles everything it can at each close, because one routine is easier to keep than three. Where staff time is short, rank the accounts by risk and cover the high ones first. The method for that ranking, with thresholds and owners, is in which balance sheet accounts need reconciliations every month.
The table of eight account types
The table below is an example set of accounts with the independent source each one ties to and a suggested frequency. Treat the frequencies as starting points, not rules.
| Account | Independent source | Suggested frequency |
|---|---|---|
| Checking and savings | Bank statement | Monthly |
| Credit card payable | Card statement and receipts | Monthly |
| Accounts receivable | Customer aging report and customer statements | Monthly |
| Accounts payable | Vendor statements and the open bills list | Monthly |
| Prepaid expenses | Invoices and the amortization schedule | Monthly or quarterly |
| Accrued liabilities | Contracts, timesheets and later invoices | Monthly or quarterly |
| Fixed assets | Asset register and depreciation schedule | Quarterly or yearly |
| Long-term debt | Lender statement and loan schedule | Quarterly |
Account reconciliation examples: cash, receivables and accruals
An account reconciliation example is easiest to see as one line from each of three accounts. In each, the ledger says one thing, an outside source says another, and a single reconciling item closes the gap. The figures below are examples only, chosen to keep the arithmetic short.
Cash
The ledger shows a checking balance of 18,400.00 on March 31. The bank statement closes at 19,150.00. The difference of 750.00 is a check for 750.00 written on March 30 that has not yet cleared. Subtract that outstanding check from the bank balance, and the adjusted bank balance agrees with the books. The reconciling item is the check, with its number, date and payee.
Accounts receivable
The ledger shows receivables of 52,300.00. The customer aging report totals 52,800.00. The gap of 500.00 is a credit memo dated March 31 that was posted in the ledger but not applied to the customer in the subledger. The reconciling item is the credit memo, and the fix is to apply it in the subledger. Here the reconciliation found a real error rather than a timing difference.
Accrued liabilities
The ledger shows accrued expenses of 9,600.00. The support schedule lists a contractor accrual of 4,000.00, an accrued bonus of 5,000.00 and a utility estimate of 400.00, which adds to 9,400.00. The 200.00 gap is an old accrual for a bill that arrived and was paid in February but was never reversed. The reconciling item is the stale accrual. Accruals are where the source is least obvious, so the support has to be built from contracts and later invoices.
These three examples share a pattern. Each starts from a ledger number, finds a source outside the ledger, and ends with a named item. The first is a timing difference that will clear by itself. The second is an error to correct. The third is a stale entry to reverse. Telling those three kinds apart is most of the skill in reconciling accounts.
For a single-account workpaper laid out field by field, including a filled accrued liabilities example, see the guide to a general ledger reconciliation template in Excel.
Reconciling an account to an independent source or to another ledger
The source of comparison matters because a reconciliation is only as strong as the evidence it uses. An independent source, such as a bank or a vendor, was produced by another party and cannot repeat your mistake. Another ledger, such as a subledger, comes from your own system and proves consistency, not truth.
Independent sources
An independent source gives the strongest proof. A bank statement exists whether or not your bookkeeper recorded the deposit. A lender's statement shows the debt balance whether or not you booked the last payment. If the outside figure and your figure disagree, one of the two records is wrong, and the dispute has a clear place to be settled.
Reconciling to another ledger
Many balances are reconciled to a subledger instead. The general ledger holds one accounts receivable total, and the subledger holds the invoice-level detail behind it. If the two totals disagree, a journal entry probably posted straight to the control account, bypassing the invoices. This check is worth running, but be clear on what it shows: the two records are consistent with each other. It does not show that the invoices themselves are right. A subledger reconciliation should be paired with a check of the subledger against outside evidence, such as customer statements or confirmations.
Choosing between them
Use the strongest source available. Where a third party issues a statement, use it. Where only an internal schedule exists, as with prepaid expenses or accruals, make the schedule traceable by attaching the invoices, contracts or calculations that build it. A schedule with no attached support is closer to a rollforward than to a reconciliation, which is the next problem.
When an account reconciliation is only a rollforward
A rollforward takes last month's balance, adds this month's activity and reports the result. It looks like a reconciliation, but it compares the account with itself. If an error entered the account in an earlier month, the rollforward carries it forward unchanged, and the schedule still "agrees" with the ledger.
Here is how that goes wrong in practice. A prepaid insurance schedule starts at 12,000.00 in January. Each month the preparer subtracts 1,000.00 of amortization and notes that the ledger agrees. In May a renewal invoice for 6,000.00 is paid and coded to expense instead of prepaid. The schedule never sees it. The ledger and the schedule still agree each month, so the work passes, yet the true prepaid balance is wrong by 6,000.00.
How to tell the difference
A real reconciliation has an input that the ledger did not generate. Ask of any schedule: where does the closing balance come from? If the answer is "last month's closing balance plus this month's entries from the ledger", it is a rollforward. If the answer is "an invoice, a statement, a count or a calculation based on a contract", it is a reconciliation.
Rollforwards are useful. They show movement and help a reviewer see what changed. The point is to avoid mistaking one for proof. For an account like prepaid expenses, the fix is to rebuild the closing balance from the underlying invoices and their service periods each month, then compare that rebuilt number with the ledger.
How does account reconciliation differ from variance analysis?
Account reconciliation proves that a balance is supported by outside evidence at a point in time. Variance analysis explains why a number moved compared with a budget, a prior period or a forecast. Reconciliation asks whether the balance is right. Variance analysis asks whether the movement makes sense.
The two answer different questions and catch different errors. Suppose rent expense is the same every month and then doubles in March. Variance analysis flags the jump, and a reviewer discovers a duplicate posting. But if rent expense stays flat while a landlord invoice is missing from the books, variance analysis sees nothing odd, and only a comparison with the lease or the landlord's statement exposes the gap.
When to use each
- Use reconciliation for balance sheet accounts that have an outside source: cash, receivables, payables, debt, and accruals backed by contracts.
- Use variance analysis for income statement lines and for any account where the question is "why did this change?"
- Use both at close. Reconcile first so the balances are trustworthy, then run variance analysis on the results so unusual movements get an explanation.
Doing variance analysis on unreconciled balances wastes effort, because you may be explaining an error. Reconcile first, then analyze.
Where a statement-matching tool helps
Bank and credit card accounts are the ones where the outside source is a long list of transactions, so the matching takes the most time by hand. PreciseBankFlow reads statement PDFs, checks that each statement foots and matches its lines to your ledger or register, then lists what cleared and what did not. It is in early access, and it does not replace the judgment about what each difference means. That stays with the person who signs.