Balance sheet account reconciliations at month-end compare each balance sheet account's ledger balance with outside support, rank accounts by risk, and clear differences above a set threshold. Run them in risk order, attach evidence to each, and have a second person review before close. Old reconciling items are the ones to watch.
Which balance sheet accounts need reconciliations every month?
Every balance sheet account with real activity or a meaningful balance should be reconciled at each close, and the rest on a slower cycle. Rank the accounts by risk: how many transactions flow through, how large the balance is, and how easily an error could hide. High-risk accounts come first, every month.
A month-end program starts with a list. Take the trial balance, list every balance sheet account, and give each one a risk rating of high, medium or low. Three things drive the rating:
- Volume. An account with hundreds of entries a month, such as cash or a credit card, collects errors faster than one with a single entry.
- Size. A large balance can hide a large mistake, and a small balance cannot.
- Judgment. Accruals and reserves rest on estimates, so they deserve a closer look than an account backed by a third-party statement.
Putting the list together
Most small and mid-sized companies land on a similar split: cash, cards, receivables and payables every month, and slow accounts such as fixed assets and long-term debt at quarter end. The frequency rules for each account type set that out account by account.
Revisit the ratings once a year, and whenever something changes. A new payment processor, a new subsidiary or a switch of accounting systems can turn a low-risk account into a high-risk one.
A month-end checklist
The table below is an example checklist. Ratings, thresholds and owners are placeholders to adapt, not recommendations for every company.
| Account | Risk | Threshold (example) | Evidence | Owner |
|---|---|---|---|---|
| Operating checking | High | 0.00 unexplained | Bank statement | Staff accountant |
| Credit card payable | High | 25.00 | Card statement, receipts | Staff accountant |
| Accounts receivable | High | 100.00 | Customer aging, customer statements | AR clerk |
| Accounts payable | High | 100.00 | Vendor statements, open bills list | AP clerk |
| Payroll liabilities | Medium | 50.00 | Payroll register, tax filings | Payroll lead |
| Prepaid expenses | Medium | 250.00 | Invoices, amortization schedule | Senior accountant |
| Accrued liabilities | Medium | 250.00 | Contracts, later invoices | Senior accountant |
| Fixed assets | Low | 500.00 | Asset register, depreciation schedule | Controller |
| Long-term debt | Low | 0.00 unexplained | Lender statement | Controller |
The monthly timetable for the cash accounts in that list, and when each should be finished in the close, is covered in monthly bank reconciliation deadlines.
Setting materiality thresholds for balance sheet reconciliations
A materiality threshold is the size of difference below which you accept an unreconciled amount without further work. Setting one tells the team which differences are worth chasing today. Cash should have a threshold of zero. Accounts built on estimates can tolerate a higher one.
Without a threshold, preparers either chase every small difference, which wastes the close, or stop whenever they feel tired, which is arbitrary. A written threshold removes the guesswork and gives the reviewer something to test against.
How to choose the number
There is no universal figure. Companies commonly set thresholds as a small share of the account balance, a fixed amount, or whichever is lower. A few principles help:
- Match the threshold to the source. A bank statement gives an exact figure, so any difference means a real item exists. Set cash at zero unexplained.
- Tighten for accounts prone to fraud or theft. Cash and card accounts attract misuse, so small differences deserve an answer.
- Loosen for estimates. An accrual for utilities is a best guess. A gap of a few dollars between the estimate and the invoice is not a finding.
- Apply the rule to the net unexplained amount. A threshold covers what is left after all identified reconciling items are listed. It does not excuse leaving known items unlisted.
Your auditors will have their own view of materiality for the financial statements, and that is a separate number. The reconciliation threshold is an internal control setting. It is normally much smaller than the audit figure, because many small differences can add up.
What a threshold does not allow
A threshold is not permission to plug. If the account is 40.00 out and the threshold is 100.00, you may leave the difference unexplained and note it. You may not hide it in a miscellaneous account to make the schedule show zero. A difference you accepted should be visible on the workpaper, with the threshold stated.
Supporting evidence for each balance sheet reconciliation
Supporting evidence is the document that proves the balance, and it must come from outside the ledger wherever possible. A reconciliation without attached evidence is only a claim. For each account, name the document in advance so the preparer knows what to collect and the reviewer knows what to look for.
Evidence falls into a few types:
- Third-party statements: bank, credit card, lender and vendor statements.
- Subledger reports: a customer aging, a vendor aging, a fixed asset register.
- Calculated schedules: an amortization schedule for prepaid expenses or a depreciation schedule, with the invoices or contracts behind it.
- Counts and confirmations: an inventory count sheet or a customer confirmation.
What to attach, account by account
For cash, attach the statement and the reconciliation that ties it to the ledger. For credit cards, attach the statement and the matched receipts, as shown in the guide to reconciling credit card statements in Excel. For receivables, attach the aging report dated at month end and a note on any customer disputes. For accruals, attach the contract, the timesheet or the later invoice that supports each line.
Dating and tracing the evidence
Evidence must match the balance date. A bank statement for the wrong period, or an aging report run on the 3rd instead of the 31st, supports a different number. Write the evidence date on the workpaper. Also keep a reference that lets a reviewer find the source quickly, such as a file name or document number. If the reviewer cannot trace a figure in a few minutes, the evidence is too loose.
What should a balance sheet reconciliation reviewer check?
A reviewer checks that the reconciliation is complete, supported and honest, which is a different job from preparing it. The preparer matches items. The reviewer tests whether the match is believable. A good review takes minutes per account and focuses on the places where errors usually sit.
A short reviewer checklist
- The ledger balance agrees to the trial balance at the stated date, to the cent.
- The supporting balance agrees to the attached document, with the same date.
- The arithmetic foots. Ledger balance plus or minus reconciling items equals the supporting balance.
- Every reconciling item has a reason, an amount and a date, and the reason is specific.
- Old items are explained. Any item that has appeared before gets a note on why it is still open.
- The preparer and reviewer are different people, and both have signed and dated.
- Round numbers and plugs are questioned. An unexplained difference of exactly 1,000.00 deserves a look.
Preparing is not reviewing
Preparers know the account and may overlook their own habits. A reviewer sees only what is on the page, which is the point. If the page cannot explain the account to a stranger, it is not finished. The reviewer should also compare this month with last month: a copied reconciliation with the dates changed is a common warning sign, and the template guide on mistakes like unsupported plugs and copied months shows what that looks like.
Balance sheet accounts carrying stale reconciling items
A stale reconciling item is a difference that has stayed open past the time it should take to clear. Reviewers look for it first, because an old item rarely stays a timing difference. It usually means an error nobody has fixed, or a transaction nobody can explain.
Different accounts go stale at different speeds. An outstanding check normally clears within a few weeks, so one open for months is suspect. A receivables credit memo that has sat unapplied for a quarter points to a process gap. An accrual for a bill that was already paid will sit forever, because nothing reverses it.
An aging rule
Give every reconciling item an open date and report its age at each close, so an item past 90 days forces a decision instead of another month on the list. The age formula, the bands and the three possible decisions are set out in listing and aging reconciling items on the GL template.
Why old items matter
Stale items hide two kinds of problem. They can be real errors that grow harder to trace with time, because staff move on and memory fades. They can also be a place to park differences, so a long list of old items on one account suggests the account is being managed to look clean. Review the age column first when you open a workpaper.
A balance sheet reconciliation example for prepaid expenses
A prepaid expenses reconciliation ties the ledger balance to a schedule built from the invoices that created each prepayment. The figures below are an example. They show the ledger, the schedule, one reconciling item and the conclusion, which is what a finished workpaper should contain.
The ledger shows prepaid expenses of 14,350.00 at March 31. The schedule lists three prepayments:
| Item | Invoice amount | Service period | Remaining at March 31 |
|---|---|---|---|
| Insurance | 12,000.00 | Jan 1 to Dec 31 | 9,000.00 |
| Software license | 6,000.00 | Feb 1 to Jan 31 | 5,000.00 |
| Trade show deposit | 350.00 | Event in June | 350.00 |
| Schedule total | 14,350.00 |
The totals agree, so no reconciling item is needed this month, and the workpaper records that the difference is zero. Had the ledger shown 14,550.00, the 200.00 gap would need a named item, perhaps an amortization entry posted twice or an invoice booked to prepaid that has no schedule line.
Note what makes this a reconciliation and not a rollforward. The schedule was built from the invoices and service periods, not from the ledger's prior balance. The preparer attached the three invoices, and the reviewer can recompute the remaining months in a minute. For the single-account template that this workpaper follows, see which fields belong in a general ledger reconciliation template.
Accounts that cross entities
Some balances do not have an outside source at all, because the other side sits in another entity of the same group. Intercompany balances need a different method, with both sides compared and eliminated. That method is covered in matching intercompany balances, due to versus due from.
Where software helps
The slowest accounts to reconcile are the ones backed by long transaction lists, usually bank and card accounts. PreciseBankFlow checks that each statement foots and matches the lines to your ledger, then lists what cleared and what did not, which feeds the evidence for those accounts. It is in early access, and the review and sign-off stay with you.