SheetCompareBalance Sheet Reconciliation Template
Compare each balance-sheet account prior period vs current period, with an automatic movement column and supporting-doc sign-off.
What's in it
- Prior Period — The account balance at the end of the prior period.
- Current Period — The account balance at the end of the current period.
- Movement — Auto-calculated (Current minus Prior). The change to explain.
- Supporting Doc — The schedule or reconciliation that backs the current balance.
A balance-sheet review is about movement: what changed since last period and why. This template puts each account's prior and current balances side by side, computes the movement automatically, and ties each line to its supporting document and a sign-off, so reviewers can focus on the accounts that moved instead of re-checking everything.
Use it as the bridge between two closes. Enter prior and current balances and the movement and net total calculate as you type.
How to use it
- 1
Enter prior-period balances
List each account and its closing balance from the prior period.
- 2
Add current-period balances
Enter this period's balance for each account. The Movement column shows the change automatically.
- 3
Explain each movement
Attach the supporting doc for each account and sign off. Unusual or unexplained movements are your review list.
Frequently asked questions
How is movement different from a GL reconciliation?▾
GL reconciliation checks a balance against its subledger at a point in time. This checks the change in each balance between two periods, which is the analytical review side of close.
Can I add more accounts?▾
Yes. Insert rows; the Movement formula copies down and the Net total adjusts.
How do I compare two periods automatically?▾
Keep a workbook per period and diff them in SheetCompare to confirm exactly which balances and sign-offs changed.
Related templates
General Ledger Reconciliation Template
Reconcile each GL account against its subledger, with an automatic difference column, a reconciled flag, and a reviewer column for sign-off.
Bank Reconciliation Template
Match your ledger against the bank statement, with a live difference column and totals that flag anything out of balance.
Credit Card Reconciliation Template
Match each statement charge against what you recorded, with a variance column that flags mismatches and category tracking.