Balance sheet reconciliation template: one row per account, with a worked October
A balance sheet reconciliation template needs one row per balance sheet account and eight columns: the account, its ledger balance, the outside document that supports it, the support balance, the difference, the explanation, the correcting entry, and who prepared and reviewed it. Fill it in at each month-end, starting with cash, and the month is closed only when the difference column is all zeros.
Below is the layout, then one made-up studio's October filled in.
The columns
| Column | What goes in it |
|---|---|
| Account | Every asset, liability and equity account with a balance |
| Ledger balance | From the trial balance at month-end |
| Support | The outside document: statement, report, schedule, contract |
| Support balance | The figure from that document, same date |
| Difference | Ledger minus support |
| Explanation | In words, not just a number |
| Entry | The journal entry that fixes it, if any |
| Prepared / reviewed | Initials and date |
The support has to come from outside the account. A ledger report proving the ledger proves nothing.
A worked October: Juniper Yoga Studio
Juniper Yoga Studio is fictional. It sells class packs that students use over several months, rents its space under a lease with a security deposit, and the owner takes regular draws. Bank and card accounts have already been reconciled for October. Here's the rest on October 31, 2026:
| Account | Ledger | Support | Support balance | Difference |
|---|---|---|---|---|
| Checking | 21,906.44 | Bank reconciliation | 21,906.44 | 0.00 |
| Business card | (1,318.70) | Card statement, new balance | (1,318.70) | 0.00 |
| Security deposit | 3,000.00 | Lease, clause 4 | 3,000.00 | 0.00 |
| Studio equipment, net | 7,480.00 | Asset register | 7,480.00 | 0.00 |
| Deferred revenue, class packs | (6,240.00) | Unused classes report from the booking system | (5,880.00) | (360.00) |
| Owner's equity | (25,550.00) | Roll-forward: opening + profit − draws | (25,550.00) | 0.00 |
The one that didn't tie
When a student buys a 10-class pack, the money is in the bank but the studio hasn't earned it yet. It owes those classes. So the sale goes to deferred revenue, a liability, and moves to class revenue as the classes are used.
The booking system's report says students hold 5,880.00 of unused classes at October 31. The ledger says 6,240.00. The explanation: classes used in October worth 360.00 were never moved out of deferred revenue. Nobody ran the monthly entry.
The entry, dated October 31:
- Debit Deferred revenue 360.00
- Credit Class revenue 360.00
After it, the liability matches the report and October's revenue goes up by 360.00. The profit and loss that went out on November 2 was 360.00 low.
The equity roll-forward
Equity doesn't have a statement. It has arithmetic. Opening equity on January 1 of 18,400.00, plus profit to October 31 of 22,150.00, less owner draws of 15,000.00, gives 25,550.00. The ledger agrees.
That check was done before the 360.00 correction. After it, profit to date is 22,510.00 and equity is 25,910.00, and the roll-forward should be run again with the new profit. It still ties, because both sides moved by the same 360.00.
If the roll-forward ever fails, someone changed a closed period. Find out who and why before anything else.
The order
- Cash and cards first. Most corrections elsewhere touch cash, so settle it. The method for the bank account is its own job.
- Then anything with an outside statement: loans, merchant accounts, payroll liabilities against the provider's report.
- Then schedules you keep yourself: prepaids, deferred revenue, fixed assets.
- Equity last, by roll-forward.
- Post the entries, re-run the trial balance, confirm every difference is zero, and lock the month.
Tips
- Keep a copy of each support document with the month's template. When someone asks in April why deferred revenue moved, the answer is in October's folder.
- A difference with no explanation is not done, even if it's small. Small unexplained differences are where big ones hide.
- Don't post a round-number adjustment to make a row tie. That's a plug, and it buries the mistake it replaced.
The steps, a table of support documents for every common account, and a second worked month with a prepaid and a payroll error are on our balance sheet reconciliation page.
Disclosure: I'm Damin and I run ZeraBooks. In our ledger, bank and card accounts are proven against their statements as they're uploaded, prepaids, depreciation and loan interest are posted at month-end, and a tied month is signed off and locked. Deferred revenue and the other schedules in this template are still a person's job, done with journal entries in the same ledger. More on AI bookkeeping.
Copy the eight columns into a sheet today. Fill in cash. Then do one more row each month until the whole balance sheet is on it.
Comments
Post a Comment