DeepLedger
Menu

Bookkeeping

Balance Sheet Reconciliation: Steps, Template and AI Review

Balance sheet reconciliation ties every account to independent evidence at period end. Steps, a template by account, the reports to pull and AI review.

Published by DeepLedger12 min read

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.

AccountTie it toEvidence to keepCommon differencesWho signs
Bank and credit card accountsStatement ending balanceStatement and reconciliation reportUncleared items, missing fees or interest, a changed reconciled transactionPreparer, then reviewer
Undeposited funds or clearing accountsZero, or a list of items in transit at period endList of open items with datesPayments never grouped into a deposit, duplicate deposits, old itemsPreparer, then reviewer
Accounts receivableAged receivables total on the same dateAging summary and detail, notes on old itemsUnapplied payments and credits, journal entries posted to receivables, cut-offPreparer, then reviewer
Prepaid expensesPrepaid schedule balanceSchedule with invoice, term and monthly releaseRelease not posted, new prepayment expensed in full, wrong termPreparer, then reviewer
Fixed assets and accumulated depreciationFixed asset registerRegister, purchase invoices, depreciation calculationAdditions expensed, disposals not removed, depreciation not postedPreparer, then senior reviewer
Accounts payableAged payables total on the same dateAging summary and detail, vendor statements for large vendorsUnapplied bill payments, duplicate bills, journal entries posted to payablesPreparer, then reviewer
Accrued liabilitiesAccrual scheduleCalculation and support for each accrual, reversal checkAccrual not reversed, invoice later booked as a bill as wellPreparer, then reviewer
Payroll liabilitiesPayroll provider's liability reportPayroll reports and tax payment confirmationsPayments coded to expense, timing of tax depositsPreparer, then reviewer
Sales tax or VAT/GST payableThe filed or prepared returnReturn, payment confirmation, tax liability reportPayments coded to expense, manual adjustments, rate errorsPreparer, then tax reviewer
Loans and lines of creditLender statementStatement and an interest and principal splitWhole payment booked to interest or to principal, missing interestPreparer, then reviewer
Suspense and Uncategorized accountsZeroDecision and support for each item clearedBank items with no category, unexplained receiptsPreparer, then reviewer
Equity and opening balance equityPrior year-end close and owner recordsYear-end balances, owner contribution and draw supportBalances in opening balance equity, prior-year changes after closeSenior 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 needQuickBooks OnlineXero
Balance per accountBalance SheetBalance Sheet
Every account in one listTrial BalanceTrial Balance
Transactions in one accountGeneral Ledger, or Transaction Detail by AccountAccount Transactions
Open customer balancesAccounts receivable aging summary and detailAged Receivables Summary and Detail
Open vendor balancesAccounts payable aging summary and detailAged Payables Summary and Detail
Fixed assets against the registerYour register outside the ledgerFixed 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.

  1. Record the ledger balance from the Balance Sheet or Trial Balance as of period end.
  2. Record the evidence balance from the statement, aging total, schedule or return.
  3. Calculate the difference. Ledger minus evidence, with the sign.
  4. Open the account's transactions. Run the General Ledger (QuickBooks Online) or Account Transactions (Xero) from the last reconciled date to period end.
  5. Explain each part of the difference. Look for timing items, wrong accounts, duplicates, missing entries and changes to earlier periods.
  6. Propose corrections. Prepare each adjusting entry with its support, as in AI journal entries in QuickBooks.
  7. Get approval and record. The reviewer approves each entry before it is recorded.
  8. Re-run the reports. The balance should now equal the evidence, apart from documented open items.
  9. 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?

RiskWhat it looks likeHow to check
Wrong companyBalances that do not match the company you meantAsk which company the AI is in before the first prompt
Wrong date or basisAging and balance sheet that differ by timingCheck the date and basis printed on every report
Evidence the AI did not haveA "reconciled" row with no statement or schedule behind itRequire a named source document for every evidence balance
Invented or rounded numbersA total in the AI's summary that is not on any reportOpen the report in the ledger and compare the figure
DuplicatesTwo bills or deposits for one paymentCheck source documents before you accept either
Cut-offSeptember invoices dated October, or the reverseCompare 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.

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.

Ready to get started?

Connect QuickBooks and try your first task with an AI agent.

Create an Account

With your permission, Google Analytics measures visits to our public website and blog. Essential cookies work either way. Change your choice in Cookie settings. Privacy policy