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
How it works
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.
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.
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 CSV | Amount | What iBill does |
|---|---|---|
| Interac e-Transfer from North West Dental | +$918.40 | Suggests the $918.40 payment you recorded on invoice INV-0042 three days earlier. |
| Visa purchase, office supplies | −$62.15 | Suggests the expense you entered for the same amount, with its receipt. |
| Monthly account fee | −$14.95 | Pre-tags it Bank Fees & Interest (7000) with one of the built-in rules. |
| Interest paid | +$1.12 | Pre-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?
Which banks work?
What happens if I import the same statement twice?
Does importing record GST/HST on my purchases?
Related
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 freeFree · No credit card · All features included · Join 1,200+ Canadian Businesses