General Ledger Template
A detailed general ledger template for recording all financial transactions by account. Includes columns for date, account number, description, reference, debit, credit, and running balance calculated automatically via formula.
How to use this template
Set up your chart of accounts
Enter your account numbers and names in the Account No. and Account Name columns to match your chart of accounts.
Record transactions chronologically
Enter each transaction with the date, description, reference number, and debit or credit amount in the appropriate column.
Verify running balances
The Running Balance column calculates automatically as each row is entered. Verify balances match your ERP or source system.
Reconcile to subsidiary ledgers
For accounts with subledgers (AR, AP, inventory), confirm the GL balance matches the total of the subledger detail.
Archive at period end
Save a copy of the completed ledger as part of your period-end workpaper package for audit trail purposes.
Why use this template
- Running balance formula eliminates manual adding and reduces errors
- Consistent format makes reconciliation to ERP exports straightforward
- Reference column links entries back to source documents for audit support
- Works for any account type — assets, liabilities, revenue, or expenses
Related templates
Trial Balance Template
A clean trial balance template for listing all general ledger accounts with their debit and credit balances. Includes automatic totals, a balance check formula that confirms debits equal credits, and conditional formatting to flag any difference.
WorkpapersGeneral Journal Template
A general journal template for recording all types of journal entries in chronological order. Includes columns for date, journal entry number, account, description, debit, and credit with running debit/credit totals to verify entries balance.
WorkpapersPrepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.