Trial balance software for Canadian businesses
One page with every account's balance and proof that debits equal credits. It's the report your accountant starts from, and in iBill it's always up to date because the entries are posted as you work.
Free · No credit card · All features included
How it works
Pick the date
Reports, Trial Balance. Choose As of, usually the last day of a month or your fiscal year, and click Generate.
Check the totals
Each account shows its code, name and balance in the Debit or Credit column. A Balanced badge confirms the two totals match.
Look closer
Click any account to open its ledger for the period, or filter the report by class, location or project.
Worked example: a consultant's trial balance on June 30
Six months into the year, a sole proprietor in Ontario who invoices clients and records expenses runs her trial balance. A shortened version:
| Account | Debit | Credit |
|---|---|---|
| 1200 Bank Account | $16,240.00 | |
| 2110 GST/HST Paid (ITC) | $1,183.00 | |
| 2100 GST/HST Collected | $5,330.00 | |
| 4000 Service Revenue | $41,000.00 | |
| 6100 Office Supplies | $9,100.00 | |
| 6600 Vehicle Expenses | $2,400.00 | |
| 6800 Travel | $17,407.00 | |
| Total | $46,330.00 | $46,330.00 |
The totals match, so the books are in balance. Revenue of $41,000.00 is what she collected, on a cash basis. GST/HST Collected less GST/HST Paid is roughly the HST she'll owe for the period, before any adjustments her accountant makes.
Vehicle Expenses of $2,400.00 is the business share of what she paid for fuel, repairs and insurance; her mileage log in iBill supports that share and posts nothing itself.
What a trial balance tells you, and what it doesn't
A balanced trial balance means every entry has equal debits and credits. iBill guarantees that, because an entry that doesn't balance can't be posted. It doesn't mean every transaction is recorded or categorized correctly: a bank fee you never entered, or a purchase filed under the wrong account, still leaves a balanced report.
That's why the trial balance is a starting point. Reconcile your bank first, so the bank balance is right, then read down the accounts for anything that looks out of place, and click into it.
A quick monthly routine: reconcile the bank, run the trial balance for the last day of the month, and compare GST/HST Collected with GST/HST Paid (ITC) to see roughly what you'll owe at filing time. Anything you don't recognize, open it: the account's ledger shows each entry, its date and where it came from.
What’s included, and what isn’t
- As of any date, with balances from every entry up to that day.
- Voided entries and their reversals are left out of the balances.
- Tag filters for classes, locations and projects.
- Every row opens that account's ledger.
- Your accountant can use it with read-only access.
- Not included in the app: exporting the trial balance to a file, a post-closing trial balance, and comparing two dates side by side.
Questions
Why would a trial balance not balance?
Is the trial balance cash or accrual?
Can I send it to my accountant?
What should I check first on a trial balance?
Related
Books that always balance
Run a trial balance for any date, any time. See the rest of the accounting tools.
Start freeFree · No credit card · All features included · Join 1,200+ Canadian Businesses