Published March 10, 2026 ยท Updated May 13, 2026
Balance sheet reconciliation is one of the most important parts of the accounting close process. It ensures that the balances reported on a company's balance sheet are accurate, complete, and supported by underlying documentation.
Every balance sheet account should be reconciled regularly โ typically monthly โ to verify that the recorded balance agrees with supporting records such as bank statements, subledgers, schedules, or external confirmations. The balance sheet reconciliation Excel template is the tracker. This page is the procedure. For a QuickBooks Online book balance, see balance sheet reconciliation software for QuickBooks Online.
Balance sheet reconciliation is the process of verifying that each account on the balance sheet agrees with supporting documentation or subledgers. Accountants compare the general ledger balance to a source of truth, such as:
If differences are identified, they must be investigated and corrected through adjusting entries or corrections in the accounting system. Balance sheet reconciliation is critical for ensuring:
Organizations rely on balance sheet reconciliations to confirm that their financial records are correct before financial statements are finalized. Without regular reconciliation, companies risk:
For this reason, most accounting teams perform balance sheet reconciliations as part of their month-end close process.
Not all accounts are reconciled the same way. Different account types require different reconciliation methods depending on the underlying data source. Common balance sheet account categories include:
Each type requires a specific reconciliation approach.
Cash accounts are typically reconciled against external bank statements.
Bank reconciliations are usually performed monthly, although some companies reconcile high-volume accounts weekly.
Accounts receivable accounts should reconcile to the AR aging report from the subledger.
AR reconciliations help confirm that customer balances are accurate and collectible.
Accounts payable accounts reconcile to the AP aging report.
This reconciliation ensures that liabilities are properly recorded and prevents duplicate or missed payments.
Fixed asset accounts reconcile to the company's fixed asset register or schedule.
Supporting schedules should clearly show: asset cost, accumulated depreciation, and net book value.
Prepaid accounts represent expenses that have been paid but not yet recognized.
Examples include: prepaid insurance, prepaid software subscriptions, and prepaid rent.
Accrued liabilities represent expenses incurred but not yet paid. Examples include: payroll accruals, bonuses, interest payable, and utilities.
Loan accounts should reconcile to the lender's statement.
Equity accounts reconcile to historical transactions and corporate records. Examples include: retained earnings, owner contributions, and dividends or distributions.
Clearing accounts temporarily hold transactions until they are allocated to the correct accounts. Examples include: payroll clearing, credit card clearing, and payment clearing accounts.
Ideally, clearing accounts should return to zero each month.
Accounting teams should follow consistent procedures to ensure reconciliations are reliable and auditable. Best practices include:
Many accounting teams use specialized software to manage these workflows.
Manual reconciliations often rely on spreadsheets, emails, and disconnected systems. This can lead to delays and errors during the close process. Automation tools help accounting teams:
CloseFlow helps accounting teams automate balance sheet reconciliations alongside other close tasks such as approvals, workflows, and reporting.
CloseFlow helps accounting teams automate the month-end close process, including reconciliation workflows, task management, approvals, and reporting.
Start Your Free Trial