Month-end close & reportingBalance Sheet Reconciliation: The Report Nobody Reads Until It Is Too Late

There's a popular myth in small business bookkeeping: if the bank account is reconciled, the books are reconciled.

It's a comforting myth. It's also a bit like saying the house is clean because the kitchen counter is wiped. Meanwhile there's a closet (let's call it "Payroll Liabilities") that nobody has opened since 2023.

Balance sheet reconciliation is the habit of opening every closet, every month. It's not glamorous. It's also the single best way we know to stop small errors from turning into a weekend with your CPA. Here's what it involves and how to do it without losing your mind.

What is balance sheet reconciliation?

Your balance sheet lists what the business owns (assets), what it owes (liabilities) and what's left for the owners (equity) on a specific date. Balance sheet reconciliation is checking each of those account balances against proof.

For a bank account, proof is the bank statement. For a loan, it's the lender's statement. For accounts receivable, it's the A/R aging report, which lists every unpaid customer invoice. For prepaid expenses, it's a small schedule showing what's left to expense.

If you're still getting comfortable with the report itself, start with how to read a balance sheet without falling asleep. Then come back. The closets will wait.

Which accounts need an account reconciliation each month?

Short answer: all of them with a balance. Longer answer, in rough order of how often they cause trouble:

• Bank, savings and credit card accounts
• Undeposited funds or payments clearing accounts
• Accounts receivable and accounts payable
• Payroll liabilities (taxes withheld and owed, benefits)
• Loans and lines of credit
• Prepaid expenses and accrued expenses
• Fixed assets and accumulated depreciation
• Sales tax payable, if you collect it
• Equity accounts, including Opening Balance Equity

Each account reconciliation should answer one question: "What is this number made of, and can I prove it?"

How to reconcile a balance sheet, step by step

1. Run the balance sheet as of the last day of the month, after bank reconciliations and adjusting entries are done.
2. For each account, gather the outside proof: a statement, an aging report, a payroll register or a schedule you maintain.
3. Compare the two numbers. Write down the difference, even if it's zero.
4. Investigate any difference. Common causes are timing (a payment in transit), duplicates, missing entries, or something posted to the wrong account.
5. Fix the entry, or document why the difference is legitimate and when it'll clear.
6. Have someone other than the preparer do a balance sheet review before reports go out.
7. Save the support. Next month starts from this month's proof.

A worked example: a contractor's six closets

Imagine you run a six-person HVAC company. The bank reconciles perfectly every month, so you assume the books are fine. A reviewer opens the balance sheet for June and finds this:

• Undeposited funds: $6,200. That's three customer checks recorded as received in March and never matched to a deposit. They were deposited. They were just recorded again when they hit the bank, so revenue is overstated by $6,200.
• Equipment loan: books say $31,400, lender says $32,615. Every payment was posted entirely to principal, with no interest split out. The $1,215 difference is interest expense that never showed up on the P&L.
• Prepaid insurance: $3,600 on the books. The policy schedule says $1,800 should remain. Six months of expense were never recorded.
• Payroll liabilities: $2,140 sitting there from an old quarter. It turns out a tax payment was recorded as an expense instead of clearing the liability.
• Opening Balance Equity: $9,870. Nobody knows why. (This one gets its own article: opening balances in QuickBooks and the setup mistake that follows every report around.)
• Accounts receivable: matches the aging report. A small victory. Celebrate with a sandwich.

None of these show up on a bank reconciliation. All of them change what the P&L says about profit.

What happens when nobody reconciles for months?

Errors compound. A wrong entry in January affects every balance after it, and by December, untangling it means reopening months that were supposedly finished. It's like discovering a sock in the dryer after six loads of whites.

We wrote about what tends to turn up in books that haven't been reconciled for months. Short version: it's rarely fraud and almost always duplicates, misposted payments and forgotten accounts.

Who should do the balance sheet review?

The person who prepared the books shouldn't be the only one checking them. That's no comment on anyone's skill. Fresh eyes simply catch things familiar eyes skip.

In a well-run accounting department, the bookkeeper prepares the reconciliations and a controller reviews them, asks about anything odd and signs off. That review layer is the core of our controller services, and it's the difference between books that look done and books you can rely on.