Opening balance sheet: balances and reconciliation

An opening balance sheet shows a business's assets, liabilities and equity at the start of a reporting period. For an ongoing business, start with the prior closing balances, add documented changes and reconcile every opening account before using the statement for reporting.

Establish what the opening date means

A balance sheet is a position at a date. The SEC's financial statement guide distinguishes that snapshot from income and cash flow statements, which cover activity over a period. Opening balances therefore exclude the new period's ordinary transactions.

For a calendar-year company, compare the approved December 31, 2025 close with the January 1, 2026 opening position. Use the same entity, currency and accounting basis. A report run after January transactions have posted is unsuitable unless the export isolates the opening balances.

The general structure belongs in the balance sheet guide. Here the job is narrower: prove continuity between the two dated positions. A newly formed business needs its initial recognized balances and supporting records instead of a prior-year comparison.

Step 1: prepare the exports and the bridge

Obtain the final prior closing trial balance, the opening trial balance, the account mapping and an approved adjustment schedule. Record the export version and cutoff date. Ask the controller whether the closing report was reopened after the opening balances were loaded.

Build a comparison key from entity and account identifier. Include every key appearing in either export, including accounts with zero closing balances. Standardize debit and credit signs before presenting statement amounts; preserve negative balances where appropriate. For multiple entities, complete this reconciliation separately before reviewing the consolidated balance sheet.

Keep approved changes separate from unexplained differences. The IRS gives a specific continuity check for partnerships: beginning total assets on Schedule L generally equal prior-year ending total assets, with differences explained in an attachment (Form 1065 instructions, Schedule L). Your account bridge provides the detail behind that kind of check.

Step 2: compare each account

Suppose a US distributor's prior close and opening file contain the following presentation balances. All amounts are whole USD, so no rounding is needed. Positive amounts represent the displayed asset, liability or equity balance; a negative bridge reduces that line.

Put the table in columns A:E, with headers in row 1. On source tabs named Closing and Opening, column A contains the comparison key and B the normalized balance. Populate comparison columns B and C with:

B2: =SUMIFS(Closing!$B:$B,Closing!$A:$A,$A2)
C2: =SUMIFS(Opening!$B:$B,Opening!$A:$A,$A2)
E2: =C2-B2-D2

Fill down through row 11. Column D contains only amounts supported by the approved bridge. The debt reclassification moves $60,000 from long-term to current debt and leaves total debt unchanged. It explains both debt differences; it does not explain inventory or retained earnings.

Step 3: run two different checks

First, test the accounting equation using the displayed statement balances:

Prior close: =SUM(B2:B5)-SUM(B6:B11)
Opening: =SUM(C2:C5)-SUM(C6:C11)

Prior assets total $1,100,000 and prior liabilities plus equity total $1,100,000. Opening assets total $1,090,000 and opening liabilities plus equity total $1,090,000. Both equations return zero, although the opening file contains unexplained differences.

Second, test account continuity:

=SUMPRODUCT(ABS(E2:E11))

The result is $20,000 of absolute account differences: $10,000 in inventory and $10,000 in retained earnings. This is a review measure, not a $20,000 economic loss. Investigate the linked entries, mapping and import records; the accountant must determine what happened before any correction is posted.

After resolution, rerun the export comparison and retain the final bridge. Later operating movements belong in flux analysis, while future assumptions belong in a projected balance sheet.

Where it goes wrong

• Using a preliminary close. A later approved closing adjustment creates a false opening difference if the comparison still uses an earlier export.
• Missing accounts treated as zero. A lookup can return zero for an absent identifier. Check source row counts and the complete set of account keys.
• Offsetting differences. Matching statement totals do not prove that individual accounts carried forward correctly.
• A bridge without evidence. A balancing amount in retained earnings hides the problem. Every bridge line needs a reason, supporting record and approval.

Reconcile your opening files in Covirage

Upload your prior closing export, opening balances and approved bridge in a file or Google Sheet; Covirage maps the columns, and its tools compute account differences and check totals. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for finance teams for the supporting reporting workflow.