Reconciliation

Balance Sheet Reconciliation Template

Create a systematic balance sheet reconciliation workpaper to reconcile your GL balances to supporting schedules and ensure accuracy.

How to use this template

1

Pull your trial balance

Extract the unadjusted trial balance from your GL. Include all balance sheet accounts with their debit and credit balances.

2

Create account reconciliation schedule

For each balance sheet account, set up a template that ties GL balance to supporting schedules (subsidiary ledgers, subledgers, or detail reports).

3

Reconcile to supporting details

For each account, verify the GL total matches the sum of supporting detail. Document the reconciliation reference and note any exceptions.

4

Identify and document adjustments

For any reconciling items, determine if an adjustment is needed or if supporting documentation needs correction.

5

Obtain evidence and sign-off

Gather supporting documentation for each reconciliation and have the responsible person initial and date the completed workpaper.

Why use this template

  • Catches errors in GL entries or supporting schedules before finalizing financials
  • Creates audit trail and evidence for external review
  • Identifies stale or obsolete accounts that can be cleaned up
  • Standardizes the reconciliation process across your accounting team

Ready to streamline your close?

Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.