General Ledger Reconciliation Template

This General Ledger Reconciliation Template is built for controllers, accounting managers, and staff accountants who need a standardized, audit-ready way to reconcile GL accounts each period. Use it to tie any general ledger account to its supporting source, itemize the reconciling items that explain any difference, and document preparer and reviewer sign-off in one workpaper.

Read our full guide on general ledger reconciliation here.

What Is a General Ledger Reconciliation?

A general ledger reconciliation is the process of verifying that the balance in a GL account matches an independent supporting source (a bank statement, subledger, or schedule) and documenting any variance between the two. It's a core account reconciliation control: if the balances don't agree, every reconciling item must be identified, explained, and resolved before the books can close.

How to Use This Template

Template Purpose: Reconcile a general ledger account balance to its supporting source each period, itemize the reconciling items that explain any difference, and document preparer and reviewer sign-off.

Template Sources: GL trial balance, plus the independent supporting source for the account (ex. bank statement, AR/AP subledger, amortization schedule, fixed asset register, loan statement).

Process Overview

GL reconciliation each period involves six steps:

1. Identify the accounts to reconcile: material accounts like cash, AR, and AP monthly; others at least quarterly
2. Gather the supporting detail for each account
3. Compare the GL balance to the supporting balance
4. Investigate differences and itemize each reconciling item
5. Post adjusting journal entries for true errors
6. Retain the reconciliation as audit documentation

Make a copy of this template (one per GL account) and follow these procedures:

1. On the GL Recon tab, enter your company name, GL account number and name, and the period-end dates
2. Enter the Balance per GL from your trial balance and the Balance per Supporting Source for each period
3. Itemize reconciling items in the Add / Less rows, and log the detail behind each item on the Reconciling Items tab
4. The Adjusted Supporting Balance and Unexplained Difference calculate automatically; an unexplained difference of $0 means the account reconciles
5. Investigate any unexplained difference and post adjusting entries for errors
6. Complete the Prepared By and Reviewed By sign-off rows. These should be different people, a core internal control and SOX requirement
7. Mark the status each period

If using Numeric: Add this sheet as a reconciliation source and Numeric will automatically pull in the trial balance from your GL and the balances in the tab labeled "Numeric" for you to tie out each month.

If not using Numeric: Each period-end, cross-reference the worksheet and your downloaded trial balance to reconcile the account. Delete the tab labeled "Numeric".

See a full list of account reconciliation templates here.

What's Included in This Template

This general ledger reconciliation template is built for accounting teams that need a repeatable, per-account reconciliation workpaper with the reconciling-item detail and sign-offs auditors expect.

Tabs

• Cover & Instructions: The template's purpose, data sources, the six-step reconciliation process, and step-by-step procedures. New users should start here.
• Numeric: One row per GL account with month-end balance columns. Numeric reads this tab to tie out against the GL trial balance each month. Teams not using Numeric should delete this tab.
• GL Recon: The main workpaper, where the GL balance and supporting balance are compared and all reconciling items are summarized.
• Reconciling Items: The support tracker, logging each reconciling item with enough detail to trace it back to source documentation and confirm when it clears.

Key Fields

The GL Recon tab includes the following fields:

• Company name and GL account number and name
• Period-end date columns
• Balance per GL (from the trial balance)
• Balance per Supporting Source
• Add / Less reconciling item rows
• Adjusted Supporting Balance
• Unexplained Difference
• Prepared By, Date Prepared, Reviewed By, Date Reviewed, and Status

The Reconciling Items tab includes:

• GL Reference
• GL Posting Date
• Amount
• Memo
• Corrective Action / Expected Clearing
• Cleared (Yes/No)
• Reconciling Month

Underlying Formulas

The GL Recon tab calculates the reconciliation using the following logic:

• Adjusted Supporting Balance = Balance per Supporting Source + Add items − Less items
• Unexplained Difference = Balance per GL − Adjusted Supporting Balance
• An unexplained difference of $0 means the account reconciles; anything else requires investigation.

Status Logic and Outputs

Each period carries one of three statuses: Complete, Complete but needs review, or Open. Every reconciling item must be reviewed and resolved before financial statements can be generated.

One pattern to watch: reconciling items that persist across periods, or a growing number of unexplained differences, can signal a material weakness in internal controls that should be escalated.

Example of a Completed General Ledger Reconciliation

The template ships with a completed example for account 1200. The GL shows a balance of $84,300, while the supporting source shows $82,150, a $2,150 gap explained by two reconciling items:

With the two items applied, the Adjusted Supporting Balance equals the GL balance and the Unexplained Difference is $0, meaning the account reconciles. Each item is also logged on the Reconciling Items tab with its GL reference, memo, and corrective action, so a reviewer or auditor can trace every number back to source documentation.

Types of General Ledger Reconciliations

Different GL accounts require different supporting sources. Common types include:

• Bank reconciliation: GL cash balance vs. the bank statement (see our dedicated bank reconciliation template)
• Credit card reconciliation: GL liability balance vs. the card statement
• Intercompany reconciliation: Balances between related entities, which must net to zero, a common source of complexity for multi-entity companies
• Fixed asset reconciliation: GL balances vs. the fixed asset register and depreciation schedules (see our fixed asset reconciliation guide)
• Prepaid and accrual reconciliation: GL balances vs. amortization schedules (see our prepaid expense workpaper)

For reconciling the full balance sheet in one schedule, see our guide to balance sheet reconciliation.

Common Reconciling Items in GL Accounts

• Timing differences: Transactions recorded in one system but not yet the other. These resolve naturally in a following period but should still be documented.
• Unrecorded transactions: Items on the external statement but not in the GL, like bank fees or interest. These require journal entries.
• Errors and duplicates: Transpositions, double-postings, and similar mistakes. These require correcting entries.
• Foreign currency adjustments: Rate differences on multi-currency accounts that create variances between the GL and the supporting source.

Why General Ledger Reconciliation Matters

1. Consistency across the team: A standard format means every account is reconciled and documented the same way, making review faster and handoffs cleaner.
2. Fraud and error detection: Comparing the GL to independent sources surfaces unauthorized activity and entry errors early, before they compound across periods.
3. SOX and audit readiness: Documented reconciling items with preparer/reviewer segregation of duties are a key internal control. When audit season arrives, auditors pull the file instead of reconstructing the process with your team.

When to Move Beyond Templates

Spreadsheet templates are a practical starting point for GL reconciliation. They're free, flexible, and the whole team already knows how to use them. But they have limits, and the data makes the case: more than 90% of spreadsheets used for business decisions contain errors. Here's a simple framework, by company size, for knowing when you've hit the wall.

Small Businesses and Early-Stage Companies

A spreadsheet works well when the account count is low and one person can own the reconciliation process from start to finish. Even then, keep in mind that one workpaper per account per period adds up fast.

Mid-Sized and Growth-Stage Companies

At this stage, templates become the bottleneck: manual balance pulls from the ERP, version control confusion across dozens of account workpapers, no automatic audit log, and static snapshots instead of live data. These teams benefit most from automated matching and exception flagging that scales with transaction volume.

Enterprises and Multi-Entity Organizations

Enterprise teams generally require reconciliation software with deep ERP integration, multi-entity and intercompany support, and audit-ready documentation built directly into the workflow. Spreadsheet templates aren't designed for this level of complexity.

Knowing When to Re-evaluate

If your team spends more time maintaining workpapers than investigating reconciling items, it's time to evaluate what's next. Many growing teams shift toward continuous reconciliation that happens throughout the month rather than in one concentrated push at close.

How Numeric Helps With GL Reconciliations

• Real-time ERP sync: Numeric connects directly to NetSuite, Xero, QuickBooks, and Sage Intacct, so trial balances flow in automatically each period instead of being pulled by hand. Numeric also monitors prior-period balances: if a journal entry posts after an account is signed off, Numeric alerts the preparer and highlights the exact transactions that changed the balance.
• Automated transaction matching: Instead of reviewing line by line, Numeric's account reconciliation product matches transactions and surfaces only the exceptions that need a human decision.
• Built-in audit trail and controls: Preparer and reviewer assignments, comments, and approvals are all logged in a clear month-end close checklist, so audit documentation builds itself as you work.

Schedule a demo to see how Numeric handles GL reconciliations from trial balance to sign-off.

FAQs About the General Ledger Reconciliation Template