iBill.ca
Start free
Bank statement import

Bank statement import for Canadian businesses

Download a CSV statement from your bank's website, upload it to iBill, and every line is ready to match or categorize. It works with any Canadian bank or credit union. iBill does not connect to your bank: you choose what to import.

Free · No credit card · All features included

Sample iBill report: recent journal entries with debits and credits
Journal entries in iBill (sample data)

How it works

  1. Download a CSV file

    In your online banking, export the account's transactions as CSV (comma-separated values). Three months at a time keeps files small. PDF and Excel statements can't be read.

  2. Upload and check the preview

    Pick the bank account and the file. iBill recognises TD, RBC, Scotiabank, BMO, CIBC and Xero layouts. For any other bank you match the date, description and amount columns once.

  3. Import, then categorize

    iBill imports the lines, skips any it already has, and suggests matches to payments and expenses you've recorded. Then you categorize the rest in bank reconciliation.

Worked example: one month from a credit union CSV

A design studio exports October from its credit union. The file uses a layout iBill has no preset for, so the owner matches four columns: Date, Description, Withdrawals and Deposits. Here is what happens to five of the lines.

Line in the CSVAmountWhat iBill does
Interac e-Transfer from North West Dental+$918.40Suggests the $918.40 payment you recorded on invoice INV-0042 three days earlier.
Visa purchase, office supplies−$62.15Suggests the expense you entered for the same amount, with its receipt.
Monthly account fee−$14.95Pre-tags it Bank Fees & Interest (7000) with one of the built-in rules.
Interest paid+$1.12Pre-tags it Interest Income (4200).
Same five lines, imported again next week—Skipped as duplicates. Re-importing a file never adds lines twice.

Nothing is posted to your books at import. Suggestions wait until you confirm them in bank reconciliation, where a matched line links to the entry that already exists and a categorized line posts a two-line journal entry.

If your file has a balance column, iBill compares each line with the change in balance and warns you when deposits and withdrawals look swapped. It never flips signs on its own.

What’s included, and what isn’t

  • CSV files only, up to 5 MB each, read as UTF-8. Comma, semicolon or tab separated.
  • Six ready-made layouts (TD, RBC, Scotiabank, BMO, CIBC, Xero) and column matching for any other bank or credit union, including French column names.
  • Dates in six common formats. When a date like 03/04/2026 could be day-first or month-first, iBill asks you rather than guess.
  • Several bank accounts, each with its own lines and duplicate check.
  • Not included: live bank feeds or a connection to your bank, OFX/QFX/QBO, PDF or Excel statement import, and credit card accounts as their own account type.
  • Your column choices are remembered in the browser you used, not across devices.

Questions

Does iBill connect to my bank automatically?

No. iBill has no live bank feed. You download a CSV statement from your bank and upload it, so nothing is shared with iBill until you choose to import it.

Which banks work?

Any Canadian bank or credit union that lets you download transactions as CSV. TD, RBC, Scotiabank, BMO, CIBC and Xero files are recognised automatically; for any other layout you match the columns once.

What happens if I import the same statement twice?

Lines iBill already has for that bank account are skipped and counted as duplicates. Two identical charges on the same day in one file are both kept.

Does importing record GST/HST on my purchases?

No. Input tax credits come from expenses you record with their GST/HST. When a bank line matches one of those expenses, the tax is already in your books; a line you categorize directly posts the full amount to one account.

Bring your bank statement into iBill

Import a CSV, match it to what you've already recorded, and see where your money went. See the rest of the accounting tools.

Start free

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