iBill.ca
Start free
Trial balance

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

Sample iBill report: key account balances by account number
Key account balances in iBill (sample data)

How it works

  1. Pick the date

    Reports, Trial Balance. Choose As of, usually the last day of a month or your fiscal year, and click Generate.

  2. 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.

  3. 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:

AccountDebitCredit
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?

In iBill it always should: entries that don't balance can't be posted. If the badge ever says Unbalanced, contact support@ibill.ca.

Is the trial balance cash or accrual?

It includes every entry posted up to the date. Payments, expenses and mileage are posted when they happen; vendor bills are posted when you enter them, so Accounts Payable shows bills you owe.

Can I send it to my accountant?

Give your accountant read-only access so they can run it themselves. There's no file export of the trial balance yet.

What should I check first on a trial balance?

The bank account against your bank statement, then the sales tax accounts against your last filing, then any expense account that looks too high or too low for the period. Those three catch most of the mistakes that matter at year end.

Books that always balance

Run a trial balance for any date, any time. See the rest of the accounting tools.

Start free

Free · No credit card · All features included · Join 1,200+ Canadian Businesses