SheetCompareGeneral 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.
What's in it
- GL Balance — The balance per the general ledger.
- Subledger Balance — The balance per the supporting subledger or schedule.
- Difference — Auto-calculated (GL minus Subledger). Should be zero for a reconciled account.
- Reconciled — Y/N flag once the difference is explained or cleared.
Month-end close depends on every balance-sheet account agreeing with its supporting detail. This template lists each GL account beside its subledger balance, computes the difference automatically, and gives you a reconciled flag and reviewer column so the close checklist is visible at a glance and unexplained gaps can't hide.
It's the control sheet, not the detail: one row per account, a live difference, and a sign-off. Drop in your trial balance and subledger totals and the differences populate instantly.
How to use it
- 1
List your balance-sheet accounts
One row per account: number, name, and period. Start with cash, receivables, payables, inventory, and accruals.
- 2
Enter both balances
Add the GL balance and the subledger or schedule balance. The Difference column calculates automatically.
- 3
Explain and sign off
For any non-zero difference, attach the supporting doc and the explanation, then set Reconciled to Y and record the reviewer.
Frequently asked questions
Which accounts should I reconcile?▾
At minimum every balance-sheet account: cash, AR, AP, inventory, prepaids, accruals, and equity. Income-statement accounts are usually reviewed via analytics rather than reconciled line by line.
What does a non-zero difference mean?▾
The ledger and the supporting detail disagree, an unposted entry, a timing difference, or an error. It must be explained before the account is signed off.
How do I track this month against last?▾
Keep one workbook per close and diff consecutive months in SheetCompare to see which accounts changed status or balance.
Related templates
Balance Sheet Reconciliation Template
Compare each balance-sheet account prior period vs current period, with an automatic movement column and supporting-doc 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.
Vendor Invoice Reconciliation Template
Three-way match of PO against invoice, with an automatic variance and a Match/Review status formula so price and quantity gaps surface.