Trial Balance Template
Before you close the books or build your financial statements, you need one gut check: do your total debits actually equal your total credits? This template lists every account from your chart of accounts and instantly flags whether debits and credits match, so a data entry error gets caught before it flows into your financial statements.
Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Bookkeepers closing the books each month
- Business owners double-checking their books before sending them to an accountant
- Anyone preparing financial statements who wants to catch entry errors first
- Students learning double-entry bookkeeping fundamentals
What's included
- Every account listed with its debit or credit balance
- Automatic total-debits and total-credits check
- Built-in flag if the trial balance doesn't balance
- Built-in AI prompt to help track down what's causing an imbalance
Why use a template instead of starting from scratch?
A trial balance only works if it's complete — miss an account, or put a balance on the wrong side, and the whole check is meaningless. This template lists every account from your chart of accounts, has you enter its balance and side, and instantly flags whether debits and credits actually match, so you catch a wrong entry before it becomes a wrong financial statement.
How to Use This Template
Download and open in Excel or Google Sheets
Requires a Tools Club membership — log in first to access the file.
List every account from your chart of accounts
Assets, liabilities, equity, revenue, and expense accounts — every one that had activity in the period.
Enter each account's ending balance on the correct side
Debit balances for assets and expenses, credit balances for liabilities, equity, and revenue — following normal balance rules.
Check the automatic debit and credit totals
They should match exactly. If they don't, the difference tells you where to start looking.
Run the built-in AI prompt if something's off
Attach the saved file to ChatGPT or Claude and ask what commonly causes this size of imbalance.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on what commonly causes an imbalance of this size and where to start checking, no accounting background required.
Common Mistakes to Avoid
Putting a balance on the wrong side
Assets and expenses normally carry debit balances; liabilities, equity, and revenue normally carry credit balances. A balance recorded on the wrong side by habit is the most common way a trial balance fails to balance.
Leaving out an account with a zero-looking balance
An account that nets to zero for the period still needs to be included if it had any activity — skipping it can hide an entry that should have been caught.
Assuming a matching total means everything is correct
Debits equaling credits only proves the entries balance each other — it doesn't catch an entry posted to the wrong account entirely. It's a first check, not a full review.
Running it only once, at year-end
Running a trial balance monthly catches an error while it's still one transaction to track down, instead of twelve.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
100+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club