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
How it works
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.
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.
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
| Account | Debit | Credit |
|---|---|---|
| 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
| Account | Debit | Credit |
|---|---|---|
| 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?
Will matching a deposit count my income twice?
Can iBill categorize recurring charges automatically?
Can I reconcile more than one account?
Related
Make your books match your bank
Import a statement and reconcile it in one sitting. See the rest of the accounting tools.
Start freeFree · No credit card · All features included · Join 1,200+ Canadian Businesses