Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Trial Balance Format (Excel & PDF)
List every account's closing balance as a debit or credit; the totals and difference update as you type.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this trial balance template
A trial balance lists the closing balance of every ledger account at a date, with debit balances in one column and credit balances in the other. If the bookkeeping is complete and correct, the two totals are equal. It is the step between your ledgers and the final accounts, the profit and loss statement and the balance sheet. This sheet has codes, sample accounts and 35 rows, totals both columns and shows "Agreed ✓" or the exact difference.
How to prepare a trial balance
- 1
Click "Edit online", or download the Excel file.
- 2
Balance off each ledger account at the period end.
- 3
Enter each account with its code, putting debit balances in Debit and credit balances in Credit. Delete the sample rows you don't need.
- 4
Check that the totals agree. If they don't, the difference shows how much to look for.
- 5
Use the figures to prepare your profit and loss statement and balance sheet.
Tips when the trial balance does not agree
Debit or credit?
Assets, expenses and drawings are normally debits; liabilities, capital and income are normally credits.
Divide by 9
If the difference divides exactly by 9, look for two digits swapped (for example 54 entered as 45).
Halve the difference
A difference of twice an amount often means that amount was put on the wrong side.
It can agree and still be wrong
An entry missed on both sides, or posted to the wrong account, won't show up as a difference.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
Currency Converter
Convert between 150+ world currencies with live rates















