Balance Sheet Reconciliation Template

This Balance Sheet Reconciliation Template is built for controllers, accounting managers, and staff accountants who need a structured, repeatable way to reconcile every balance sheet account at month-end in a single worksheet. Use it to compare each GL balance to its supporting source, document the reconciling items behind any difference, and record preparer and reviewer sign-off account by account.

Read our full overview on balance sheet reconciliation here.

What Is a Balance Sheet Reconciliation?

A balance sheet reconciliation is the process of comparing GL account balances to supporting documentation (subledgers, bank statements, third-party records) to verify that every asset, liability, and equity balance is accurate and complete. It's a core account reconciliation practice applied across the full balance sheet rather than to a single account.

It's also a control, not just a check. Balance sheet reconciliations are a core month-end close control and a key SOX requirement: if a balance doesn't match its support, every reconciling item must be identified, explained, and resolved before statements go out.

How to Use This Template

Template Purpose: Summarize and document the reconciliation of each balance sheet account, comparing the GL balance to the supporting balance, with reconciling items and sign-offs recorded per account.

Template Sources: GL trial balance, plus supporting sources per account (bank statements, AR/AP subledgers, amortization schedules, fixed asset registers, etc.).

Process Overview

Balance sheet reconciliation at month-end involves referencing:

1. The trial balance from your GL
2. Supporting documentation for each account
3. Reconciling items and known adjustments

Make a copy of this template and follow these procedures:

1. On the Reconciliation Template tab, review the pre-built Chart of Accounts and delete any account names and numbers not in use
2. Enter each account number and name from your Chart of Accounts in columns A and B, positioning each under the correct category in column C (add rows as needed)
3. Enter the general ledger balance for each account in column D
4. Enter the supporting balance in column E: the third-party documentation confirming the balance, like bank statements, vendor invoices, or loan documents
5. Column F calculates the difference (D − E) automatically. Investigate every variance and note the reason in the Explanation/Notes column (column G)
6. Add the preparer's name in column H and the reviewer's name in column I
7. Mark each account's status in column J: Complete, Complete but needs review, or Open

The template ships with example data for a cash account: a GL balance of $5,200 against a bank statement balance of $4,950, with the $250 difference explained by outstanding checks and deposits in transit.

If using Numeric: Add this sheet as a reconciliation source and Numeric will automatically pull in the trial balance from your GL and the balances in the tab labeled "Numeric" for you to tie out each month.

If not using Numeric: Cross-reference worksheet totals against your downloaded trial balance each month-end, and delete the tab labeled "Numeric".

See a full list of account reconciliation templates here.

What's Included in This Template

This balance sheet reconciliation template is built for accounting teams that need a structured, repeatable way to reconcile every balance sheet account at month-end in a single worksheet.

Structure

The template has three tabs. Cover & Instructions holds the template's purpose, sources, process overview, and step-by-step procedures; new users should start here. Reconciliation Template is the main worksheet: a consolidated schedule covering the full chart of accounts, where every balance is compared and every difference explained. Numeric holds one row per GL account with month-end balance columns; Numeric reads this tab to tie out against the GL trial balance each month, and teams not using Numeric should delete it.

Accounts are pre-organized into category sections:

• Current Assets: Cash, Inventory, Accounts Receivable, Prepaid Assets
• Non-Current Assets: Fixed Assets
• Current Liabilities: Accounts Payable, current portion of long-term debt
• Non-Current Liabilities: Long-Term Debt
• Equity: Common Stock, Additional Paid-in Capital, Retained Earnings
• Revenue and Expenses: for teams that reconcile P&L-linked accounts

Delete unused rows and add your own accounts under each category.

Key Fields

The Reconciliation Template worksheet includes the following columns:

• Account Number and Account Name
• Account Type / category
• GL Balance (column D)
• Supporting Balance (column E)
• Difference (D − E)
• Explanation / Notes for reconciling items
• Prepared By and Reviewed By
• Status (Complete / Review / Open)

Underlying Formulas

The core logic is one calculation: Difference = GL Balance − Supporting Balance. A zero difference means the account reconciles; any non-zero difference must be investigated and explained in the Notes column.

The template's built-in example shows how this plays out: a cash GL balance of $5,200 against a supporting bank statement balance of $4,950 produces a $250 difference, explained by outstanding checks and deposits in transit.

Status Logic and Outputs

Each account carries one of three statuses: Complete and reviewed, Complete but needs review, or Open. Every reconciling amount must be reviewed and resolved before financial statements can be generated.

One pattern to watch, built into the template's own instructions: if the number of accounts with GL-vs-supporting differences is increasing month over month, that can signal a material weakness in internal controls.

Balance Sheet Accounts to Reconcile

The reconciliation approach varies by account type, because each account has a different supporting source and different common reconciling items:

• Cash and bank accounts: vs. bank statements. Watch for outstanding checks and deposits in transit (see our bank reconciliation template)
• Accounts receivable: vs. the AR subledger. Watch for unapplied payments and credit memos (see our AR reconciliation guide)
• Accounts payable: vs. the AP subledger. Watch for unrecorded invoices and duplicate payments
• Prepaid expenses: vs. amortization schedules (see our prepaid expense workpaper)
• Fixed assets: vs. the asset register. Watch for additions, disposals, and depreciation (see our fixed asset reconciliation guide)
• Inventory: vs. physical counts. Watch for shrinkage and costing differences
• Accruals: vs. supporting calculations
• Equity: vs. board resolutions and stock ledgers

Balance Sheet Reconciliation Example

Cash is the most relatable account to walk through, and it's the example built into the template. Account #1000, Cash in bank: the GL shows $5,200 and the bank statement shows $4,950. Neither number is wrong; the $250 difference is timing. Here's how that row looks in the template:

‍

The preparer investigates the difference, documents the explanation in the Notes column, and both preparer and reviewer sign off. For the item-level detail behind a cash difference like this one (each individual outstanding check and deposit in transit), pair this schedule with our bank reconciliation template, which tracks those items to clearance.

Why Balance Sheet Reconciliation Matters

1. Financial Accuracy: Reconciling every account confirms balances are complete and correctly stated before statements go out, so the numbers leadership and investors see reflect reality.
2. Fraud and Error Detection: Comparing the GL to independent sources surfaces unauthorized transactions and entry errors early, before they compound across periods.
3. Audit and SOX Readiness: Documented reconciliations with preparer and reviewer sign-offs are a key internal control. When auditors arrive, the support is already organized, which cuts audit back-and-forth significantly.

When to Move Beyond Templates

Spreadsheet templates are a practical starting point for balance sheet reconciliation. They're free, flexible, and the whole team already knows how to use them. But they have limits, and the data makes the case: more than 90% of spreadsheets used for business decisions contain errors. Here's a simple framework, by company size, for knowing when you've hit the wall.

Small Businesses and Early-Stage Companies

A spreadsheet template works well when account count and transaction volume are low and one person can own the process end to end. At this stage, a single consolidated worksheet like this one covers the whole balance sheet without much overhead.

Mid-Sized and Growth-Stage Companies

At this stage, templates become the bottleneck. High-volume accounts like cash, AR, and AP are error-prone to reconcile manually, documentation scatters across drives and email, and version control breaks down as more people touch the file. These teams benefit most from automated matching and exception flagging.

Enterprises and Multi-Entity Organizations

Enterprise teams generally require reconciliation software with deep ERP integration, multi-entity support, and audit-ready documentation built into the workflow. That's beyond what a spreadsheet can do, no matter how well it's maintained.

Knowing When to Re-evaluate

If your team spends more time maintaining templates than reconciling accounts, it's time to evaluate what's next. Many growing teams shift toward continuous reconciliation that happens throughout the month rather than in one concentrated push at close.

How Numeric Helps with Balance Sheet Reconciliation

• Automate matching at the transaction level: Numeric's account reconciliation product syncs transaction-level data from your ERP in real time, auto-matches against supporting sources, and flags only the exceptions that need a human decision.
• Stay organized and audit-ready: Preparer and reviewer assignments, comments, and approvals are logged in a complete audit trail tied to the month-end close checklist, so documentation builds itself as you work.
• Prior-period balance monitoring: If a journal entry posts after an account is signed off, Numeric alerts the preparer and highlights the exact transactions that changed the balance.

Schedule a demo to see how Numeric reconciles the full balance sheet from trial balance to sign-off.

FAQs About the Balance Sheet Reconciliation Template