Balance sheet reconciliation: Process, template, and examples

Balance sheet reconciliation proves that every asset, liability, and equity balance at period end is backed by evidence from outside the general ledger. It's one type of account reconciliation, run across the whole balance sheet as a month-end close control. Teams also call it balance sheet account reconciliation or reconciliation of balance sheet accounts.

• Supporting balanceThe balance from an independent source, such as a bank statement, AR aging, fixed asset register, or lender statement
• Reconciling itemA specific, documented reason the GL and the support differ, such as a deposit in transit or an entry that wasn't posted
• Unexplained differenceWhat's left after every reconciling item, which must be zero or under your written threshold before sign-off

Every balance sheet account with a balance or activity in the period needs a reconciliation, but the support and the frequency differ by account. Use this table to set up your account list.

Reconcile accounts with a zero balance too if they had activity in the month. Two offsetting errors can net to zero and still misstate the income statement.

In this example, reconciling 13 accounts at October 31, 2026, produces five journal entries totaling $133,800 and one $640 difference under the threshold.

What explains each difference, with where each supporting balance comes from and the entry it needs:

How each difference was resolved

Each difference gets a cause, a fix, and evidence attached to the reconciliation.

• CashThe bank statement shows $4,382,750. Adding $146,200 of October 31 receipts deposited November 2 and subtracting $318,750 of payments that hadn't cleared gives $4,210,200. The GL matches once the $2,400 October bank fee is booked: $4,212,600 − $2,400 = $4,210,200. For the full method, see bank reconciliation.
• Accounts receivableAn $18,400 credit memo issued October 30 reached the AR aging, but the sync to the GL failed. Repost it through the billing integration, dated October 30, instead of a manual journal to the control account, so the subledger and GL stay tied.
• InventoryOctober cycle counts found $32,400 less product on hand than the perpetual records showed. The controller approves the count results, and the shrink posts to cost of goods sold.
• Prepaid expensesThe schedule rolls forward cleanly: $432,000 opening balance + $96,000 of new prepayments − $42,000 of October amortization = $486,000, which matches the GL. For how to build the schedule, see prepaid expenses.
• Fixed assetsA fully depreciated forklift with a $38,000 cost was scrapped in October with no proceeds. The register removed it, but the GL didn't. Removing it from both cost and accumulated depreciation leaves net book value at $4,682,000, with no gain or loss.
• IntercompanyThe US entity billed the Canadian subsidiary a $13,200 management fee on October 31, and Canada hadn't recorded it. Canada books the payable in October, so both sides match before eliminations. For the full process, see intercompany reconciliation.
• Accrued liabilitiesThe carrier bills October freight in mid-November. The schedule includes a $42,600 accrual based on October shipments and contracted rates, but it was never posted. For how to calculate and support accruals, see accrued expenses.
• Payroll liabilitiesAfter tying withholdings, benefits, and payroll taxes to the register, $640 is still unexplained. It's under the $5,000 threshold, so the preparer logs it as an open item with an owner and a November 30, 2026, due date instead of holding up the sign-off.

Journal entries from the reconciliation

The reconciliation produces five entries in the US entity's books, all dated October 31, 2026, except the credit memo, which posts on October 30.

Four of the entries lower October pre-tax income by $95,800 ($2,400 + $18,400 + $32,400 + $42,600). The disposal entry has no income effect. In Canada's books, the local controller debits management fee expense and credits the intercompany payable for $13,200. That entry has no consolidated effect, because it eliminates against the US entity's fee income.

Sign-off

Each reconciliation carries two signatures and two dates. The staff accountant prepares all 13 by November 4, 2026 (business day 3), and the accounting manager reviews them by November 5 (business day 4). The controller adds a second review on cash, receivables, inventory, accrued liabilities, and intercompany, the five high-risk accounts.

The period locks only after the five entries post and the last reconciliation is signed. Any entry posted to these accounts after sign-off reopens the affected reconciliation.

A balance sheet reconciliation format has four parts: a header, a balance section that compares the GL to support, a reconciling items list, and a sign-off block. Using the same format for every account keeps preparers consistent and makes review faster.

Header: Entity, account number and name, period end date, risk rating, threshold, preparer, reviewer, and due date.

Balance section, filled in with the accrued liabilities account from the example:

Reconciling items list, with a sample row:

Sign-off: Prepared by and date, reviewed by and date, and a second reviewer and date for high-risk accounts.

For accounts supported by a schedule, such as prepaids, accruals, and deferred revenue, add a roll-forward: opening balance + additions − reductions = closing balance. The closing balance becomes line B.

Balance sheet reconciliation template in Excel or Google Sheets

You can build the template in one sheet with five formulas. Put the inputs at the top and the items list from row 12 down.

Make one tab per account, plus a summary tab that pulls B5, B6, B9, and the sign-off dates from each one.

You do a balance sheet reconciliation in eight steps, from pulling the trial balance after cutoff to a reviewer's sign-off before the period locks. Following the same order each month keeps reconciliations comparable across preparers and periods.

1. 1Pull the trial balance after cutoffRun it once subledgers close and recurring entries post, and list every balance sheet account with a balance or activity
2. 2Assign each accountGive it a preparer, a reviewer, a risk rating, a threshold, and a due date by business day
3. 3Gather independent supportBank and lender statements, subledger reports, registers, and schedules, all dated as of the period end
4. 4Calculate the differenceGL balance minus supporting balance
5. 5Identify and classify reconciling itemsTiming items that clear on their own, errors to correct, and missing entries to post
6. 6Post entries and log the restBook corrections in the period, and log timing items with an owner and an expected clear date
7. 7Confirm what's leftThe adjusted GL balance matches support, and the unexplained difference is zero or under the threshold
8. 8Review and sign offA second person checks the support and each item, then signs and dates the reconciliation before the period locks

These steps sit in the reconciliation block of your month-end close checklist, after subledgers close and before flux review and reporting.

To reconcile a GL account, compare its balance to a subledger, a third-party statement, or a schedule that rolls forward from the last reconciled balance. Knowing which kind applies tells you where errors tend to hide.

A GL to SL reconciliation ties a control account in the general ledger to the detail in its subledger, as in the receivables example.

Reconcile high- and medium-risk balance sheet accounts monthly and low-risk accounts at least quarterly, based on a written risk rating. A risk rating puts your team's hours where errors are most likely.

Published guidance follows the same pattern. In a February 2016 Journal of Accountancy article, Marc Ursick recommends ranking balance sheet accounts as high, medium, or low risk. Higher-risk accounts then get closer reconciliation. Vanderbilt University's account reconciliations policy, effective January 2018, schedules reconciliations daily, monthly, or quarterly by risk level. The University of Minnesota's reconciliation policy, last amended January 2020, requires balance sheet accounts to be reconciled quarterly at a minimum.

Re-rate every account each year, and move an account up a tier after a material error. Set due dates by business day so reviewers have time before the period locks. Ursick's article uses business day 6 as an example due date.

Set two written thresholds per account: a dollar amount that triggers investigation before sign-off, and an age at which open items escalate to the controller. Written thresholds stop your team from chasing pennies on low-risk accounts.

Ursick's 2016 article notes that "not every account can be reconciled to the penny" and recommends setting tolerances and materiality thresholds across the organization. Vanderbilt's policy requires a documented resolution plan for reconciling items over $10,000 that are more than 90 days old. It ages items in 0–30, 31–60, 61–90, and over-90-day buckets, starting the first calendar day after month end.

Set the investigation threshold well below the materiality level your auditors use for the financial statements, because small differences across many accounts add up. A difference under the threshold still gets documented, as the $640 payroll item was in the example.

A staff or senior accountant prepares the reconciliation, and a different, more senior person, such as an accounting manager or controller, reviews and signs it. Separating the two roles is what makes the reconciliation a control.

Vanderbilt's policy states that "the preparer and approver cannot be the same person." It adds that some accounts may need an extra certification by an accounting manager. Ursick's 2016 article adds that the person tracking completion doesn't have to be in management.

Weak review also shows up in audit findings. KPMG's 2025 study of material weaknesses reviewed 3,307 annual reports filed in fiscal 2025. Of those, 238 companies (7%) disclosed material weaknesses as of June 30, 2025. The most frequently cited financial close issue was "lack of precision, timeliness, and adequate oversight of management review controls."

Before you sign a reconciliation, confirm the balance, the support, every reconciling item, and the unexplained difference. Working through the same list on every account makes your review precise and repeatable.

1. 1The GL balance matches the final trial balance for the right entity and period end
2. 2The support is independent of the GL, dated as of period end, and attached
3. 3The supporting balance on the reconciliation matches the attached document
4. 4The difference and unexplained difference are calculated correctly
5. 5Each reconciling item has a description, date, amount, and evidence
6. 6Timing items clear in the next period, such as deposits in transit on the next bank statement
7. 7Errors and missing entries have posted journal entries, referenced by number
8. 8No item is older than your escalation age without a resolution plan
9. 9The unexplained difference is zero or under the threshold, and documented
10. 10The balance is reasonable against last month and the account's normal activity
11. 11The preparer signed and dated it, and you aren't the preparer

Common balance sheet reconciliation mistakes include aged reconciling items no one clears, balances with no real support, and plugs that force a reconciliation to zero. Each one makes a reconciliation look complete when the balance is still wrong.

Balance sheet cash and your bank reconciliation differ when the GL changed after the reconciliation or the balance sheet line combines several cash accounts. Checking these causes in order finds the gap quickly.

• Bank reconciliation adjustments not bookedFees, interest, or returned items found on the reconciliation were never posted to the GL
• Entries posted after the reconciliationA backdated payment or journal changed the GL balance after sign-off
• More than one accountThe balance sheet cash line combines operating, payroll, savings, and petty cash accounts
• Different dates or entitiesThe report and the reconciliation use different period ends or subsidiaries
• ReclassificationsOverdrafts moved to liabilities, or restricted cash shown on its own line

Re-run the GL balance for each cash account as of the reconciliation date and compare it to the reconciliation's adjusted book balance. The account that doesn't match is where the difference sits.

The purpose of balance sheet reconciliation is to prove each reported balance exists, is complete, and is accurate before the financial statements go out. It also gives your auditors signed evidence for every balance.

• Accurate statementsIn the example, $95,800 of October expenses and sales returns would have been missing from the income statement
• Error and fraud detectionIndependent support and a second reviewer make unauthorized or duplicate entries visible
• Audit readinessEach signed reconciliation, with support attached, is evidence your auditors can test without extra requests

The best practices for monthly balance sheet account reconciliation are one standard template, support kept with each reconciliation, completion metrics, and fixes for recurring items. They build on the risk ratings, deadlines, and thresholds above.

• StandardizeUse one template and one policy across every entity. Ursick's 2016 article recommends standard policies, processes, and templates company-wide.
• Keep support with the reconciliationAttach statements, schedules, and entries so the next preparer and your auditors find them in one place
• Track metricsReview overdue reconciliations, material reconciling items, and completion by person or department, as Ursick suggests, then adjust assignments or due dates
• Fix root causesWhen the same reconciling item comes back each month, change the upstream process, such as the billing integration in the receivables example

Yes, software can pull GL and supporting balances, match transactions, roll schedules forward, and route reconciliations for review. That leaves your team the exceptions. In Ledge's 2025 survey of 100 finance professionals, teams reported spending an average of 20–50 hours a month on cash reconciliation alone.

High-volume, rules-based accounts such as cash, receivables, and intercompany gain the most from automation. Judgment accounts, such as accruals and reserves, still need a preparer who understands the estimate. For a comparison of tools, see best account reconciliation software.

Our Close Agent prepares each reconciliation on your close checklist, ties it to source, drafts any entries, and sends the workpaper to a named reviewer. The period can't lock until every reconciliation is signed off. If you want reconciliations prepared before your team starts the close, explore our Close Agent.