Balance sheet reconciliation is the period-end check that every balance sheet account ties to independent evidence, such as a statement, an aging report or a supporting schedule, with every difference explained and signed off by a person. This guide gives you a balance sheet reconciliation template with one row per common account, the steps for reconciling one account, the QuickBooks Online and Xero reports to pull, and how an AI connected to the books can prepare the work for your review. It is written for bookkeepers, accountants and finance teams who close several companies each month.
What is balance sheet reconciliation, and why does it matter?
A balance sheet reconciliation proves each balance against something outside the ledger. In accounting, this is called a tie-out: you tie the ledger balance to a source the ledger did not produce, such as a bank or lender statement, an aged receivables report, a fixed asset register or a filed tax return. If a balance sheet account is wrong, the profit and loss is usually wrong too, because the other side of the error sits in income or expense.
The automated bank reconciliation guide covers the bank account in QuickBooks Online, which is one part of this work. Balance sheet reconciliation covers every other account as well, from prepaid expenses to opening balance equity. It is a core step of the accounting month-end close checklist. Reconcile active accounts every month.
Before you start
- Fix the date and basis. Pick the period-end date, for example September 30, 2026, and the accounting basis. Use accrual basis for the balance sheet when you compare it with aging reports, because aging reports list open invoices and bills.
- Finish the bank and card reconciliations first. Many other accounts depend on cash being right.
- Collect the outside evidence. Bank, card and loan statements, payroll liability reports, the sales tax or VAT/GST return, and the firm's prepaid, accrual and fixed asset schedules.
- Save the starting reports. Keep a copy of the balance sheet and trial balance before you change anything.
Balance sheet reconciliation template
Copy this account reconciliation template into your working file, and add columns for the ledger balance, the evidence balance and the difference. A row with a difference and no explanation is not finished.
| Account | Tie it to | Evidence to keep | Common differences | Who signs |
|---|---|---|---|---|
| Bank and credit card accounts | Statement ending balance | Statement and reconciliation report | Uncleared items, missing fees or interest, a changed reconciled transaction | Preparer, then reviewer |
| Undeposited funds or clearing accounts | Zero, or a list of items in transit at period end | List of open items with dates | Payments never grouped into a deposit, duplicate deposits, old items | Preparer, then reviewer |
| Accounts receivable | Aged receivables total on the same date | Aging summary and detail, notes on old items | Unapplied payments and credits, journal entries posted to receivables, cut-off | Preparer, then reviewer |
| Prepaid expenses | Prepaid schedule balance | Schedule with invoice, term and monthly release | Release not posted, new prepayment expensed in full, wrong term | Preparer, then reviewer |
| Fixed assets and accumulated depreciation | Fixed asset register | Register, purchase invoices, depreciation calculation | Additions expensed, disposals not removed, depreciation not posted | Preparer, then senior reviewer |
| Accounts payable | Aged payables total on the same date | Aging summary and detail, vendor statements for large vendors | Unapplied bill payments, duplicate bills, journal entries posted to payables | Preparer, then reviewer |
| Accrued liabilities | Accrual schedule | Calculation and support for each accrual, reversal check | Accrual not reversed, invoice later booked as a bill as well | Preparer, then reviewer |
| Payroll liabilities | Payroll provider's liability report | Payroll reports and tax payment confirmations | Payments coded to expense, timing of tax deposits | Preparer, then reviewer |
| Sales tax or VAT/GST payable | The filed or prepared return | Return, payment confirmation, tax liability report | Payments coded to expense, manual adjustments, rate errors | Preparer, then tax reviewer |
| Loans and lines of credit | Lender statement | Statement and an interest and principal split | Whole payment booked to interest or to principal, missing interest | Preparer, then reviewer |
| Suspense and Uncategorized accounts | Zero | Decision and support for each item cleared | Bank items with no category, unexplained receipts | Preparer, then reviewer |
| Equity and opening balance equity | Prior year-end close and owner records | Year-end balances, owner contribution and draw support | Balances in opening balance equity, prior-year changes after close | Senior reviewer |
Some rows have their own guides: the prepaid expense schedule, clearing uncategorized transactions in QuickBooks Online, and ruling out duplicate bills and invoices before you accept a receivables or payables difference.
In QuickBooks Online, the undeposited funds account is also called Payments to deposit, per Intuit's default accounts article, as of November 2026.
Which reports do I pull in QuickBooks Online and Xero?
Run every report for the same company, period-end date and basis.
| What you need | QuickBooks Online | Xero |
|---|---|---|
| Balance per account | Balance Sheet | Balance Sheet |
| Every account in one list | Trial Balance | Trial Balance |
| Transactions in one account | General Ledger, or Transaction Detail by Account | Account Transactions |
| Open customer balances | Accounts receivable aging summary and detail | Aged Receivables Summary and Detail |
| Open vendor balances | Accounts payable aging summary and detail | Aged Payables Summary and Detail |
| Fixed assets against the register | Your register outside the ledger | Fixed Asset Reconciliation |
In QuickBooks Online, go to Reports → Standard reports and find each report by name. Intuit's guides cover the General Ledger and Transaction Detail by Account, the accounts receivable aging reports under Who owes you, and the payables aging reports in the year-end guide.
In Xero, go to Reporting → All reports and open each report by name. Xero Central describes the Trial Balance, Account Transactions, Aged Receivables Summary, Aged Payables Summary and Fixed Asset Reconciliation reports. In the US region, Xero names the aging reports the Accounts Receivable Aging Summary and the Accounts Payable Aging Summary. Menu labels are as of November 2026.
How do I reconcile one balance sheet account?
Use the same steps for every row of the template.
- Record the ledger balance from the Balance Sheet or Trial Balance as of period end.
- Record the evidence balance from the statement, aging total, schedule or return.
- Calculate the difference. Ledger minus evidence, with the sign.
- Open the account's transactions. Run the General Ledger (QuickBooks Online) or Account Transactions (Xero) from the last reconciled date to period end.
- Explain each part of the difference. Look for timing items, wrong accounts, duplicates, missing entries and changes to earlier periods.
- Propose corrections. Prepare each adjusting entry with its support, as in AI journal entries in QuickBooks.
- Get approval and record. The reviewer approves each entry before it is recorded.
- Re-run the reports. The balance should now equal the evidence, apart from documented open items.
- Sign off. The preparer marks the row ready. The reviewer signs it off with the date.
An example with hypothetical numbers: receivables on the balance sheet show $48,000 and the aging total shows $46,500. The $1,500 traces to a journal entry that debited receivables with no customer. The fix is a reviewed correction of that entry, not a write-off.
How do I handle a difference I cannot explain?
Do not post a plug. A plug forces the account to agree by moving the unknown amount into another account, usually expense or suspense. The cause stays in the books and the difference tends to come back.
Instead, document the amount and which side is higher, what you checked, the likely cause (for example, "possible duplicate deposit, waiting for deposit detail"), the owner and next action, and the reviewer's decision: carry it as an open item, or approve a specific entry with its reason.
Materiality decides urgency, not whether you document. The firm sets the threshold for each company. For example, with a hypothetical $100 threshold, a $40 difference can be carried as an open item with a note. A $40 difference that appears every month is a pattern worth finding.
How can AI help with balance sheet reconciliation?
An AI app connected to the books can pull the balance sheet, trial balance and aging reports as of period end, read each account's transactions, compare balances with the evidence you give it, list every difference and propose adjusting entries for a person to approve. It should never make an account agree with a balancing entry.
Start read only, naming the company and period. The prompts use Pinebridge Studio, a fictional company.
Read only. For Pinebridge Studio, pull the Balance Sheet and Trial Balance as of September 30, 2026, accrual basis. List every balance sheet account with its balance. Do not change any records.
Read only. For Pinebridge Studio, compare accounts receivable on the September 30, 2026 balance sheet with the accounts receivable aging summary as of the same date. Show both totals, the difference, and any transactions in the receivables account with no customer or with an unapplied payment or credit. Do not change any records.
When the differences are known, ask for proposals, not postings:
Prepares for approval. For Pinebridge Studio, September 2026: for each difference you found, propose the adjusting entry with accounts, amounts, the source evidence and your reasoning. Mark any difference you cannot explain as an open item instead of proposing an entry. Do not record anything until I approve each entry.
What can go wrong, and how do I review the AI's work?
| Risk | What it looks like | How to check |
|---|---|---|
| Wrong company | Balances that do not match the company you meant | Ask which company the AI is in before the first prompt |
| Wrong date or basis | Aging and balance sheet that differ by timing | Check the date and basis printed on every report |
| Evidence the AI did not have | A "reconciled" row with no statement or schedule behind it | Require a named source document for every evidence balance |
| Invented or rounded numbers | A total in the AI's summary that is not on any report | Open the report in the ledger and compare the figure |
| Duplicates | Two bills or deposits for one payment | Check source documents before you accept either |
| Cut-off | September invoices dated October, or the reverse | Compare document dates with transaction dates near period end |
Review the reports, not the summary. The AI's table is a working paper; the ledger reports and statements are the evidence. Open each report in QuickBooks Online or Xero, confirm the balance and spot-check a few transactions the AI cited. After entries are recorded, ask the AI to re-read the balances and show the new differences. The reconciliation is finished when the reviewer signs it off, not when the AI says the numbers agree.
Where DeepLedger fits
DeepLedger connects AI apps such as Claude and ChatGPT to QuickBooks Online and Xero through one MCP address. For balance sheet reconciliation:
- A close checklist per company. When you ask, the AI proposes a close checklist built from the books, with one item for each account to reconcile and other items only where the books show the activity. Each item has a cadence, a due business day, an owner and the evidence to keep. A person approves the checklist in the portal. The AI can never approve or activate one.
- Bank and card reconciliations. The AI prepares a reconciliation from the statement you provide, or, for a QuickBooks company, from DeepLedger's bank feed. It will not mark it ready until both differences are 0.00, every statement line is matched and nothing is flagged. A person signs off and finishes it in the ledger. In Xero, DeepLedger reads only transactions recorded in Xero, and a person finishes matching in Xero's Reconcile screen.
- No plugs. A fee missing from the books stays flagged with its proposed entry until a person approves it and it is booked and matched.
- Questions go to Tasks. What the AI is not sure about becomes a question in the company's Tasks for a person, instead of an entry in the books.
- Company rules. Ask the AI to read the company's AI Brain and skills first. The AI Brain can hold the capitalisation policy for the fixed asset row.
Reconciliation sign-off is always a person's. Every write must name its company, or DeepLedger refuses it and nothing is written. For the rest of the close, see the accounting month-end close checklist.
Frequently asked questions
What is balance sheet reconciliation?
Balance sheet reconciliation is the period-end check that each balance sheet account agrees with independent evidence, such as a bank statement, an aging report, a lender statement or a supporting schedule. Each difference is explained, corrected with an approved entry or carried as a documented open item. A preparer does the work and a reviewer signs it off.
What does tie out mean in accounting?
To tie out an account means to show that its ledger balance equals the total on an independent source for the same date. For example, accounts receivable ties out when the balance sheet figure equals the aged receivables total as of the same day. A tie-out is the core of every balance sheet reconciliation.
Should I post a plug entry to clear a small difference?
No. A plug hides the cause, and the difference usually returns in a later month. Document the difference, what you checked and the reviewer's decision, and record a real adjusting entry only when the cause is known and the entry is approved.
Which QuickBooks Online reports do I need for a balance sheet reconciliation?
Run the Balance Sheet and the Trial Balance as of period end, the General Ledger or Transaction Detail by Account for each account, and the accounts receivable and accounts payable aging summary and detail reports. Use the same date and accounting basis on every report. Each one can be found by name under Reports, then Standard reports.
Can AI reconcile balance sheet accounts?
AI connected to the books can pull balances and reports, compare them with the evidence, list differences and propose adjusting entries. A person approves each entry and signs off each reconciliation. Through DeepLedger, the AI cannot sign off a reconciliation, and a fee missing from the books stays flagged with its proposed entry until a person approves it, instead of being plugged.
Related guides
- Accounting month-end close checklist for QuickBooks
- Automated bank reconciliation for QuickBooks
- Build a prepaid expense schedule
- Fix uncategorized transactions in QuickBooks
- Review AI-prepared journal entries
Connect your AI app on AI Platforms & Integrations, then try one account: ask the AI to compare last month's receivables aging with the balance sheet, read only, and review the difference it finds.