iBill.ca
Start free
Bank reconciliation

Bank reconciliation for Canadian businesses

Line up your bank statement with your books. Deposits match the payments you recorded, expenses match their bank charges, and everything else gets an account in a few clicks. A statement balance is optional.

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. Import the statement

    Upload your bank's CSV file. iBill skips lines it already has and suggests matches to payments and expenses you've recorded.

  2. Start a session

    Pick the bank account. Leave the dates blank to use the imported range, and add the statement's opening and ending balance only if you want a $0.00 tie-out.

  3. Match, categorize, finish

    Click Match on a suggested payment or expense, or give a line an account, one at a time or in bulk. Then finish categorizing, or complete the reconciliation against the balance.

Worked example: two lines, two different outcomes

An Ontario consultant invoiced a client $1,000.00 plus HST and recorded the payment when the e-Transfer arrived. The bank statement then shows that deposit and a $14.95 monthly fee.

Already in your books: the payment you recorded

AccountDebitCredit
Bank Account (1200)$1,130.00
Service Revenue (4000)$1,000.00
GST/HST Collected (2100)$130.00
Total$1,130.00$1,130.00

The $1,130.00 deposit on the statement matches this entry. Clicking Match marks the bank line reconciled and links it here. No second entry is posted, so the income is counted once.

Posted when you categorize the fee

AccountDebitCredit
Bank Fees & Interest (7000)$14.95
Bank Account (1200)$14.95
Total$14.95$14.95

A built-in rule already suggested Bank Fees & Interest. Most bank service charges are GST/HST-exempt financial services, so a two-line entry with no tax is right. Saving the line as a rule means next month's fee is suggested the same way.

Both lines end up reconciled, but only one of them changed your books. That is the point of matching first: income and expenses you already recorded stay counted once, and the bank statement only fills the gaps.

If you add the statement's ending balance, iBill shows the difference as you go. When it reaches $0.00 you complete the reconciliation. If a difference remains, you can complete anyway and iBill posts it to Suspense (9999) for you or your accountant to sort out.

What’s included, and what isn’t

  • Suggested matches compare amounts within two cents and dates within five days; you confirm every match.
  • Matching only looks at payments and expenses already recorded in iBill. Record an invoice payment first; reconciliation does not record payments.
  • Bulk categorize up to 100 lines at a time, and save a line as a rule (contains, exact or starts with). 22 rules for bank fees and interest come built in, and iBill suggests new rules from what you categorize often.
  • Before you categorize a line that looks already recorded, iBill warns you so the same purchase isn't counted twice.
  • A line you categorize posts its full amount to one account, with no GST/HST split. Record purchases with tax as expenses to claim input tax credits.
  • Not included: live bank feeds, a session history screen or a printable reconciliation report.

Questions

Do I need my statement's ending balance?

No. You can categorize imported lines without it. Add the opening and ending balance when you want iBill to confirm your books agree with the statement to the cent.

Will matching a deposit count my income twice?

No. Matching links the bank line to the payment entry you already recorded. Only lines you categorize post a new entry.

Can iBill categorize recurring charges automatically?

Rules suggest an account for lines whose description contains, equals or starts with text you choose. You review the suggestions and apply them, up to 100 at a time.

Can I reconcile more than one account?

Yes. Each bank account has its own lines and sessions. It needs a linked account in your chart of accounts before you can reconcile it.

Make your books match your bank

Import a statement and reconcile it in one sitting. See the rest of the accounting tools.

Start free

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