Reconcile Balance Sheet Accounts: A Month-End Method
Quick Answer: To reconcile a balance sheet, take each asset, liability and equity line at month end and tie its ledger balance to a supporting schedule or outside statement: bank statements for cash, an aging for receivables, a lender statement for loans, a register for fixed assets. Then roll retained earnings forward by the period's net income and distributions to prove the balance sheet and income statement agree.
A balance sheet is reconciled when every line on it has a document behind it that someone outside the ledger could check. You work top to bottom, one account at a time, building a small schedule for each, and you finish with the equity section, where retained earnings must equal last period's figure plus this period's profit minus anything paid out to owners.
Drop your bank statement here
PDF or OFX · Max 4.4 MB
Uploaded over an encrypted connection. We never ask for your bank login. Privacy
Preview free with no account. Free account to download.
Why reconcile the balance sheet and not just the bank?
Income statement accounts reset every year; balance sheet accounts carry their errors forward forever. A deposit miscoded to a loan account in February is still sitting in that loan balance in December, and your profit for the year is understated by the same amount. Because every journal entry has two sides, an unexplained balance on the balance sheet almost always means an income or expense figure is wrong somewhere too.
Reconciling cash alone catches only the errors that touch cash. Accruals, depreciation, payroll withholdings and prepaid expenses never touch the bank on the day they are booked, so they need their own checks.
How do you reconcile a balance sheet, account by account?
Print or export the balance sheet as of the last day of the period, then build a support file with one tab or page per line. Each tab shows three numbers: the ledger balance, the supported balance and the difference, with the difference itemized.
| Balance sheet line | What supports it | What to look for |
|---|---|---|
| Cash and bank accounts | Bank statements and a bank reconciliation | Outstanding checks older than 90 days, unrecorded fees |
| Accounts receivable | Aged receivables report from the subledger | Control account not equal to aging total; old credits |
| Inventory | Physical count or perpetual inventory valuation | Shrinkage, items received but not billed |
| Prepaid expenses | Schedule of each prepayment with monthly amortization | Insurance or software paid annually but fully expensed or never expensed |
| Fixed assets and accumulated depreciation | Fixed asset register with additions, disposals and depreciation | Assets sold but still on the books |
| Accounts payable | Aged payables report; vendor statements for large suppliers | Duplicate bills, payments recorded but bill missing |
| Credit cards | Card issuer statement | Charges after the statement cutoff |
| Accrued liabilities | List of expenses incurred but not invoiced | Last year's accrual never reversed |
| Payroll liabilities | Payroll provider reports and tax deposit confirmations | Balances left after taxes were paid |
| Sales tax payable | Sales tax return for the period | Filed amount not matching the liability |
| Loans and notes payable | Lender statement and amortization schedule | Whole payment booked to principal, interest never expensed |
| Owner equity, contributions, distributions | Bank evidence of each contribution or draw | Personal expenses coded as business costs |
| Retained earnings | Rollforward from the prior year-end balance | Changes outside of year-end close |
You do not need a formal document for every line every month. A business with two fixed assets can update the depreciation tab quarterly. But every line should be supported at year end, and anything material should be supported monthly.
Reconciling the cash lines
Start here because the evidence is the cleanest. For each bank and card account, compare the statement's closing balance with the ledger and list outstanding items. If your statements arrive only as PDFs, you can download CSV activity from most online banking portals for recent months; for older periods a tool like QuickBankConvert reads the statement PDF into rows (date, description, amount, running balance) and shows the opening and closing balance it read, which gives you something to tick against. The detailed bank procedure is in the guide to doing an account reconciliation.
Reconciling receivables and payables
Run the aging report as of the same date as the balance sheet. The total must equal the ledger balance to the cent. When it does not, someone posted a journal entry straight to the control account instead of through a customer or vendor. Find it, reverse it and re-enter it against the right customer or vendor.
Then read the aging itself. Credits on a receivable aging are often payments applied to the wrong invoice. Debits on a payable aging are often vendor refunds or prepayments that need a separate asset account.
Reconciling loans
Ask the lender for a statement showing principal outstanding at your period end. If your ledger shows more than the lender, you probably expensed principal as interest; if it shows less, you booked whole payments to principal. Correct the split with a journal entry between the loan account and interest expense.
How do you reconcile the balance sheet and income statement?
The two statements meet in retained earnings. The income statement shows profit for the period; that profit closes into equity. So the check is a rollforward:
Opening retained earnings + net income for the period − distributions or dividends = closing retained earnings (before the next close)
A worked example for a calendar-year company at December 31:
| Item | Amount |
|---|---|
| Retained earnings, January 1 | $84,300 |
| Add: net income for the year (income statement) | $41,750 |
| Less: owner distributions declared from retained earnings | ($30,000) |
| Expected retained earnings, December 31 | $96,050 |
| Retained earnings plus current-year earnings on the balance sheet | $96,050 |
| Difference | $0 |
Most accounting software shows current-year profit as a separate "net income" line inside equity until the year is closed, then moves it into retained earnings automatically. If the January 1 figure in your software is different from the December 31 figure you filed last year, someone changed a transaction in a closed year. That is the single most useful check a bookkeeper can run in January.
Also confirm the basic identity: total assets equal total liabilities plus equity. Software enforces this, but spreadsheets and manually prepared statements can break it, and when they do, the gap is often exactly the net income that was never carried across.
What order should month-end reconciliations follow?
When time is short, reconcile in the order that catches the biggest and most frequent errors first:
- Bank and credit card accounts, because nearly every other account depends on cash being right.
- Clearing accounts such as undeposited funds or payment processor accounts. These should be near zero; a growing balance means deposits are not being recorded against the payments they represent.
- Payroll and sales tax liabilities, since mistakes there have penalties attached.
- Receivables and payables, tied to their agings.
- Loans, prepaid expenses, accruals and fixed assets.
- Equity, with the retained earnings rollforward last.
Close the period in your software after the review so nobody edits reconciled months. Keep the support file with the statements; the IRS recordkeeping guidance asks you to keep records as long as they are needed to support your return.
What does a difference on one line usually mean?
Because of double entry, a variance on one balance sheet line has an offsetting error somewhere else. Intuit's explanation of how debits and credits affect each account type is a handy reference when you are working out which side to correct. Some patterns repeat:
- Cash too high and an expense too low: a payment recorded twice as a deposit reversal, or a check voided after it cleared.
- Receivables too high and income too high: an invoice entered for a sale that was later cancelled.
- Payables too high and expenses too high: a bill entered, then paid by card or bank transfer without being applied to the bill.
- Loan too high and interest too low: principal and interest not split.
Write the explanation on the support tab, post the correcting entry, and the line is reconciled.
If you work in QuickBooks, the companion guide to reconciling balance sheet accounts in QuickBooks shows which of these accounts the Reconcile tool handles and which need a schedule.
Related guides
Frequently Asked Questions
How often should you reconcile balance sheet accounts?
Reconcile cash, credit cards and clearing accounts every month. Lower-activity accounts such as fixed assets or a single loan can be done quarterly, but every line should be supported at year end.
What is a balance sheet reconciliation template?
It is a page per account showing the ledger balance, the balance per supporting document, the difference and an itemized explanation, plus the preparer's and reviewer's initials and dates. A spreadsheet with one tab per account works well.
Why doesn't my retained earnings match last year's?
Usually because a transaction dated in a prior, closed year was added, edited or deleted. Run an audit log or a transaction list for the old year and compare it with the filed figures.
Do I need to reconcile equity accounts?
Yes. Contributions and distributions should match bank evidence, and retained earnings should roll forward from the prior year by net income less distributions. Personal expenses coded as business costs often surface here.
Ready to convert your bank statement?
Free to preview. No bank login. Results in about a minute.
Convert a statement