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.
How to use this template
Enter the reporting date
Fill in the 'As of' date in the header to identify the period for this trial balance.
List all general ledger accounts
Enter each GL account number and name in the Account No. and Account Name columns.
Enter debit and credit balances
Input the balance for each account in either the Debit or Credit column based on its normal balance type.
Verify the balance check
The Totals row sums both columns and the Balance Check row calculates the difference. It should equal zero if all entries are correct.
Investigate any difference
If the balance check is non-zero, trace back through recent journal entries to find the posting error or missing entry.
Why use this template
- Automatic totals and balance check formula eliminate manual verification steps
- Clean layout makes it easy to identify accounts with unusual balances
- Serves as the starting point for financial statement preparation
- Provides clear audit evidence that the books are in balance at period end
Related templates
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.
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.