Skip to main content

Balance Sheet Reconciliation, Explained: How to Reconcile Every General Ledger Account Each Month

Published 12 min readMike ThriftMike Thrift
Balance Sheet Reconciliation, Explained: How to Reconcile Every General Ledger Account Each Month
On this page

You send your balance sheet to the bank to renew your line of credit, and the loan officer asks one question you cannot answer: "Prove the $48,000 in accounts receivable is real." You open the ledger, and there it is — a single number, $48,000, with no list of who owes it, no aging, no tie-out to a single invoice. That number might be exactly right, or it might include invoices paid months ago, credits never applied, and a customer who went out of business last year. Without a reconciliation, nobody — not you, not the bank, not your auditor — can tell the difference.

Every balance on your balance sheet is a claim about reality. Reconciliation is the monthly work of proving each claim: taking the closing balance of an account, comparing it to an independent source that shows what the balance should be, and explaining or fixing every gap. This guide walks through the account-level process, the supporting schedule each balance sheet account needs, how to set review and sign-off discipline, and how to clear the stale reconciling items that quietly accumulate.

What "Reconciled" Actually Means​

A reconciled account has three things attached to it, and the ledger balance alone is none of them.

First, a supporting schedule: an independent listing of what makes up the balance. For cash, that is the bank reconciliation; for receivables, the aged AR report; for a loan, the lender's amortization schedule. Second, a tie-out: the schedule's total agrees with the general ledger balance, or every difference between them is listed as a reconciling item with an explanation. Third, a trail: who prepared it, who reviewed it, and when — so that six months later you can show your work instead of reconstructing it from memory.

Note what this definition excludes. A balance that "looks about right" is not reconciled. A balance that matches last month is not reconciled. Reconciliation is a comparison against something outside the ledger, because the ledger agreeing with itself proves nothing.

Why the Balance Sheet Gets This Treatment (and the Income Statement Mostly Doesn't)​

Income statement accounts reset to zero every year. If you misclassify a repair expense in March, the error stings for one year and then washes out at year-end close. Balance sheet accounts never reset. An unreconciled difference in a balance sheet account sits there forever, compounding with next month's difference, until someone investigates a balance that has quietly drifted thousands of dollars from reality.

That permanence is why auditors start here and why lenders ask about receivables rather than revenue. Cash, receivables, inventory, prepaids, payables, accrued liabilities, debt, equity — each one carries its history forward, so each one needs a monthly proof that its history is clean.

The Five-Step Account-Level Process​

Work through every balance sheet account in the same order each month. The consistent sequence matters: it turns reconciliation from detective work into a checklist, and it catches the errors each step is designed to find.

1. Match the beginning balance to last month's reconciliation​

Start by confirming the account's opening balance equals the ending balance on last month's signed-off reconciliation. If they differ, someone posted into a closed period, restated history, or changed the account mapping — stop and find out which before touching the current month. A surprising share of "this month's" mysteries are actually prior-period edits nobody announced. Lock closed periods in your accounting system so this step stays boring.

2. Tie current-period activity to its source​

Match the transactions posted to the account during the month against the underlying activity. For cash, that means deposits and withdrawals against the bank statement. For receivables, invoices issued and payments received against the AR subledger. For inventory, purchases and shipments against receiving reports and sales records.

This is the step where timing differences surface. Verify your detail reports cover exactly the reporting period — a report that runs "through today" instead of through month-end will disagree with a month-end balance by every transaction in between, and you can burn hours reconciling the wrong date range. Confirm the period first, then compare.

3. Review every adjusting journal entry​

Read each adjusting entry posted to the account this month and ask whether it belongs. Adjustments are the highest-risk postings in the ledger because a human composed them by hand: check for debits and credits flipped the wrong way, wrong account numbers, transposed digits (writing $4,231 as $4,321 creates a difference divisible by nine — the classic tell), and amounts that look like estimates carried forward unchanged for the fifth straight month.

4. Confirm reversals actually reversed​

Accruals booked last month that should have reversed this month — payroll accruals, estimated utilities, monthly retainer accruals — need a deliberate check. A forgotten reversal double-counts the expense when the real invoice arrives and pays. Keep a standing list of reversing entries and tick each one off; "I think it reversed" is how duplicate expenses survive to year-end.

5. Verify the ending balance against the detail​

Confirm the account's ending balance equals the total of its supporting detail, listing any difference as a reconciling item. Each item needs three attributes: what it is, why it exists, and when it clears. "Outstanding check #4821, mailed Oct 28, clears November" is a reconciling item. "Difference, $312" is a confession that the reconciliation is not finished.

The Supporting Schedule Each Account Needs​

The schedule depends on the account. Keep this mapping posted where whoever closes the books can see it:

  • Cash — bank reconciliation per account: ledger balance, plus deposits in transit, minus outstanding checks, adjusted for bank charges and errors, tied to the bank statement.
  • Accounts receivable — aged AR report by customer, tied invoice by invoice, with credits and unapplied payments listed rather than netted into oblivion.
  • Inventory — quantity-on-hand valuation or a cost rollforward, tied to receiving and shipping records; investigate negative quantities immediately, since they always indicate a recording failure rather than a counting one.
  • Prepaid expenses — amortization schedule per prepaid item showing original amount, monthly amortization, and remaining balance.
  • Fixed assets — fixed asset register with cost, placed-in-service date, depreciation method, accumulated depreciation, and net book value per asset.
  • Accounts payable — aged AP report by vendor, with unmatched receiving reports and unentered invoices called out.
  • Accrued liabilities — calculation or estimate support per accrual: payroll days accrued times daily rate, invoice expected but not received, interest accrued per the loan schedule.
  • Debt — lender statements and amortization schedules, split between current and long-term portions.
  • Equity — rollforward of contributions, distributions, and retained earnings tied to board minutes and prior-year tax returns.

If an account has no natural schedule — some equity accounts, some clearing accounts — the reconciliation is a written statement of what the balance represents and why it is correct. A zero-balance clearing account reconciles by being zero; anything else in it is, by definition, an unresolved item.

Match Frequency to Risk, Not Ambition​

Not every account needs the same cadence, and pretending they do is how teams fall behind and then reconcile nothing. Set frequency by activity and risk:

  • Weekly or even daily: operating cash, payroll liabilities, merchant clearing accounts — high volume, high fraud exposure, and the accounts where a problem compounds fastest.
  • Monthly at close: receivables, payables, inventory, accruals, debt — the standard close population, reconciled before the books are declared final.
  • Quarterly: fixed assets, prepaids, long-term liabilities, equity — stable accounts where monthly review adds little, provided something still monitors them for unexpected postings between reviews.

The rule that matters more than any schedule: reconciliations are done when they are reviewed and signed off, not when they are prepared. An unreviewed reconciliation sitting in a drawer (or an unread shared folder) at month-end plus three weeks is the same as no reconciliation. Set a sign-off deadline — five business days after month-end is the common standard — and treat a missed deadline as the exception it is.

Review and Sign-Off: The Control That Makes It Real​

The person who prepares a reconciliation should not be the person who approves it. Segregating preparation from review is the cheapest internal control in accounting: the preparer knows the account's details, the reviewer brings skepticism, and fraud or error has to get past both. In a one-person finance function, the reviewer is the owner — which is uncomfortable for ten minutes a month and invaluable the one time it catches something.

A useful review checks four things: the schedule ties to the ledger (recompute the footing, don't just read it), every reconciling item has an explanation and an expected clearance date, the adjustments are supported, and last month's open items either cleared or have a current status. The sign-off itself records reviewer, date, and conclusion. "Reviewed" with no date is decoration; "Reviewed, Oct 28, two open items carried with clearance dates" is a control.

Clearing Stale Reconciling Items Before They Fossilize​

Every reconciliation produces items that legitimately carry forward — outstanding checks, deposits in transit, timing differences. The discipline is aging them. The moment a reconciling item passes its expected clearance date, it graduates from timing difference to problem: the check that never cleared was lost, the "deposit in transit" was recorded twice, the unapplied credit belongs to a customer who overpaid in spring.

Run an aging of open reconciling items each month alongside the reconciliations themselves. Escalate anything outstanding past 60 days, and anything past 90 days gets a decision: clear it with a correcting entry, write it off through the proper approval if it is immaterial and unresolvable, or assign it to a named person with a date. What you must never do is let the list grow silently. A reconciliation with forty carried items that nobody questions is a document that exists to be filed, not to find anything — and auditors read a growing stale-item list as evidence the whole process is theater.

Small-balance write-offs deserve their own policy: a threshold (say, $25 or $50) below which the preparer may clear an unresolvable difference to a miscellaneous account, with reviewer approval and a monthly report of everything cleared that way. Without a policy, small differences either linger forever or get cleared invisibly; neither is acceptable.

The Errors You Will Actually Find​

Across thousands of reconciliations, the findings cluster into a short list. Learn it and you will diagnose most differences in minutes:

  • Wrong period. Detail reports run through the wrong dates — the single most common cause of a reconciliation that "won't tie." Confirm the date range before investigating anything else.
  • Flipped debit and credit. A journal entry posted backwards doubles the error: the account is off by twice the entry amount. If your difference is exactly double a recent entry, you have found it.
  • Transposed digits. $4,231 entered as $4,321. Differences divisible by nine point here; divide the difference by nine to estimate which digit pair swapped.
  • Duplicate entries. Two people booking the same accrual, or one person booking it twice because there is no standard close checklist. A standardized list of recurring entries, ticked off each month, nearly eliminates this.
  • Postings to the wrong account. The expense is real but lives in a sibling account — office supplies in computer equipment, one vendor's invoice under another vendor. Search the amount across accounts before assuming it is missing.
  • Unrecorded bank activity. Service charges, interest, automatic debits, and returned items the bank knows about and you don't — found only because the bank statement is the independent source.

Booking What the Reconciliation Finds: A Plain-Text Example​

Finding a difference is only half the job; the other half is recording the correction so next month starts clean. Suppose your October bank reconciliation turns up a $12 service charge the bank took but you never entered. The correcting entry records the fee and brings the ledger to the statement:

2026-10-31 * "First Bank" "October account service charge"
  Expenses:Bank-Fees         12.00 USD
  Assets:Checking           -12.00 USD
 
2026-10-31 balance Assets:Checking  31412.55 USD

That last line is the quiet superpower of keeping books in plain text: a balance assertion that fails the whole file if the computed balance disagrees with the statement amount. It turns next month's cash tie-out from a manual comparison into an automatic check — the machine re-performs step 5 every time the file loads. The documentation covers balance assertions and the close workflow in detail, and the dashboard gives the same balances a visual review surface for the monthly sign-off.

Your Month-End Reconciliation Routine​

Put the process on one page and run it in the same order every month:

  1. Lock the prior period so beginning balances cannot shift under you.
  2. Reconcile cash first — it is the highest-risk account and the one every other proof leans on.
  3. Work the remaining balance sheet accounts against their supporting schedules, oldest reconciling items first.
  4. Age the open reconciling items; escalate everything past its clearance date.
  5. Have the reviewer recompute tie-outs, challenge the open items, and sign off with a date — within five business days of month-end.
  6. File each reconciliation where next month's preparer will actually find it, attached to the close checklist.

Start this month with the account you trust least — usually receivables or the account nobody has reconciled in quarters. Prove that one balance against its independent source, clear or age every difference, and get a dated sign-off. Then add the next account next month. A complete monthly proof of every balance sheet account is the destination, but the habit of proving one balance at a time is what gets you there.

Source: https://beancount.io/blog/2026/10/28/balance-sheet-reconciliation-explained-general-ledger-accounts-guide

Published: October 28, 2026