A list of every account with its opening balance, the movement during a period and the closing balance. It also checks that total debits equal total credits.
When to use it
At month or year end, or at any time, to see each account's balance. Use it to confirm the books are in balance before you prepare the Profit & Loss or Balance Sheet.
Before you start
- Vouchers for the period are entered and posted. A draft voucher does not show here.
- You need report access for Finance.
Where to find it
Reports > Finance > Trial Balance.
The fields on this screen
| Field (on screen) | What to enter | Required |
|---|---|---|
| From Date | Start of the period (defaults to the financial-year start) | No |
| To Date | The "as of" date (defaults to today) | No |
Running the report
- Open Reports > Finance > Trial Balance.
- Set From Date and To Date, or keep the defaults.
- Read the result: accounts are grouped under your chart of accounts, with Opening, Transaction and Closing debit/credit columns and a grand total at the bottom.
Reading the result
- Closing equals Opening plus Transaction. A short date range still shows the full opening balance carried forward.
- At the bottom, the grand total of Closing Debit must equal Closing Credit. If a balance warning appears, a voucher is unbalanced. Check the Day Book for that period.
- An Unmapped Ledger line means some entries were posted to an account that is not placed under any account group. Fix that account's group in the Ledger master so it lands in the right section.
Worked example
Run it with From set to the fiscal-year start and To set to the month end. You see each account (Cash, Bank, Sales, Purchases, VAT and the rest) under its group, with the closing balance as of month end and a balanced grand total.
Tips and common mistakes
- If a number looks wrong, open that account in the Ledger report for the same dates.
- The Trial Balance only includes posted vouchers, so post your drafts first.
Related guides
- Ledger, Day Book, Financial Statement (Profit & Loss / Balance Sheet).