Bookkeeping Basics · Edmonton
QuickBooks bank rules: automation without the mess.
Bank rules can save you hours every month or quietly miscategorize a year of transactions. Here's how to build rules that are specific, GST-aware and safe.
By the Plum team- Updated Oct 2026
- 9 min read
- Bank rules auto-categorize bank feed transactions based on conditions you set.
- Make conditions specific: a full supplier name, the right account, and an amount range if needed.
- Always set the GST tax code in the rule, or you'll lose input tax credits.
- Auto-add only transactions that are identical every time. Review the rest.
QuickBooks bank rules are one of the best time savers in QuickBooks Online. Set them up well and your monthly bank feed shrinks from 200 decisions to a handful. Set them up badly and they'll quietly push personal purchases into business expenses, drop GST credits on the floor and categorize your sales tax payments as office supplies, all without anyone noticing.
This guide covers how rules work, how to build one with a worked example, how they interact with GST in Canada, and the mistakes we see most often when we review files.
1How QuickBooks bank rules work
When your bank or credit card connects to QuickBooks Online, transactions arrive in a queue for review. A rule looks at each new transaction and, if it meets your conditions, fills in the details for you.
- Conditions: which account the transaction came from, money in or money out, and tests on the bank text (description contains, is exactly, doesn't contain) or the amount (equals, greater than, less than).
- Actions: the transaction type, payee, category, tax code, class or location, a memo, and optionally a split across several categories.
- Auto-add: an option to add matching transactions straight to your books without review.
- Order: rules run in priority order, and the first one that matches wins. Put specific rules above general ones.
You'll find rules in the Banking area of QuickBooks Online: open your bank transactions and look for the Rules tab (in some menus it sits under Transactions, then Rules). You can also create a rule from a transaction in the feed when you categorize it.
2A worked example: the monthly phone bill
Say you're a GST-registered consultant in Leduc. Every month your mobile provider takes $105.00 from your business chequing account: $100 for service and $5 GST. The phone is used only for business.
A good rule for it:
| Setting | Value |
|---|---|
| Apply to | Money out, Business chequing only |
| Condition | Bank text contains the provider's full name as it appears on your statement |
| Payee | The phone company |
| Category | Telephone and internet |
| Tax code | GST 5% |
| Auto-add | Off for the first two or three months, then on if the amount never changes |
With the GST tax code set, QuickBooks treats the $105 as tax-inclusive and records this entry every month:
| Account | Debit | Credit |
|---|---|---|
| Telephone and internet expense | $100.00 | |
| GST/HST payable (input tax credit) | $5.00 | |
| Bank (chequing) | $105.00 | |
| Total | $105.00 | $105.00 |
Without the tax code, the whole $105 goes to expense. Your expense is still deductible, but the $5 credit is gone. That's $60 a year from one bill, and most businesses have dozens of recurring GST-bearing charges. Our guide to input tax credits explains why that 5% matters.
Splitting a mixed-use bill
Now say the same phone is 70% business and 30% personal. Set the rule to split by percentage: 70% to Telephone with the GST code, 30% to Owner draws (sole proprietor) or Shareholder loan (corporation), with no tax code. Percentage splits work even when the bill amount changes. Only claim the business share, and keep a note of how you worked out the percentage.
3What makes a rule good or bad
| Good candidates | Bad candidates |
|---|---|
| Fixed software subscriptions | Amazon and other everything-stores |
| Bank and card fees | Gas stations (fuel, snacks and personal fill-ups) |
| Phone and internet | Costco, Walmart and grocery stores |
| Insurance premiums | E-transfers in or out |
| Merchant processing fees | Transfers between your own accounts |
| Rent on your commercial space | Loan payments (they need a principal and interest split) |
The pattern: rules are great for transactions where the supplier tells you everything about the purchase. They're risky where the same supplier could mean five different things. A rule that sends every "AMZN" charge to Office supplies will be wrong as often as it's right.
Loan payments are a good example of something to handle by hand. Each payment is part principal and part interest, and the split changes every month. Our post on how to record a loan payment explains why.
4Rules, matching and transfers
Before you categorize anything, QuickBooks looks for a match: an invoice payment, bill payment, deposit or expense you've already entered that fits the bank line. When a good match is offered, take it over a rule. A customer payment should clear its invoice, not become new income.
Transfers between your own accounts need special care. Say you pay your business Visa $2,500 from chequing. That single payment appears twice: money out of chequing, and a payment on the card. Neither is an expense.
| Account | Debit | Credit |
|---|---|---|
| Business Visa (liability) | $2,500.00 | |
| Bank (chequing) | $2,500.00 | |
| Total | $2,500.00 | $2,500.00 |
In the bank feed, record it once as a Transfer from chequing to the card, then match the card-side line to that same transfer. A rule that categorizes the chequing side to an expense counts every card purchase twice: once when you bought it on the card and once when you paid the bill. If you do write a rule for card payments, make sure its action is a transfer, not an expense, and that it's limited to the chequing account.
5Common bank rule mistakes
1. Conditions that are too broad
"Description contains SHELL" also catches any other merchant whose name contains those letters. Use the fullest text that's consistent on your statement, and add an amount condition where it helps.
2. Auto-add on variable transactions
Auto-add means nobody looks. Use it only for charges that are the same supplier, the same purpose and ideally the same amount every time.
3. No tax code
The most expensive mistake on this list, because it's invisible. Expenses look right, but every GST return is short on credits.
4. Rules on income
Customer payments should usually be matched to invoices or sales receipts, not categorized by a rule to Sales. A rule on incoming e-transfers is a fast route to double-counted income.
5. Forgetting rule order
If a general rule sits above a specific one, the general rule wins. Review your rule list once or twice a year and delete rules for suppliers you no longer use.
6. Categorizing meals at 50%
In Canada, meals and entertainment are generally only 50% deductible, but that limit is usually applied as a tax adjustment at year end, not in your bookkeeping. Book the full amount to Meals and entertainment (with GST) and let the 50% happen on your return. Splitting it in a rule makes the books harder to follow.
Fixing a rule that went wrong
If you discover a rule has been miscategorizing transactions for months, editing the rule only changes future transactions. The ones already added stay where they were put. Run a transaction report filtered by the payee or category, select the affected transactions, and recategorize them (QuickBooks Online lets you do some of this in bulk from the bank feed's categorized tab or a report). Be careful with any period you've already filed a GST return for; changes there may need a correction on your next return rather than a rewrite of the old one.
A rule setup checklist6The Canadian record-keeping angle
Rules make categorizing faster, but CRA still expects the paperwork behind every expense. A bank line saying "$105 phone" isn't enough on its own to support an input tax credit; you need the bill showing the supplier and GST. Attach bills to transactions in QuickBooks, or keep them organized elsewhere, and hold on to them for six years from the end of the tax year they relate to.
Plum builds and maintains bank rules for clients in Edmonton, Leduc, Beaumont and Sherwood Park as part of every monthly plan. If your bank feed takes hours every month, book a call and we'll show you what a clean setup looks like.
7Questions people ask
What are bank rules in QuickBooks Online?
Bank rules tell QuickBooks how to categorize transactions from your bank feed automatically. You set conditions, such as the bank description containing a supplier name, and the rule fills in the payee, category and tax code for you.
Should I let QuickBooks rules auto-add transactions?
Only for transactions that are identical every time, like a fixed monthly software subscription or bank fee. For anything that varies, let the rule suggest the category and review it before adding.
Can a QuickBooks bank rule split a transaction?
Yes. A rule can split a transaction by percentage or amount across several categories, for example a phone bill that's partly business and partly personal. Splits by percentage are the most practical for amounts that change.
Why is my QuickBooks rule not working?
Common reasons are that the bank description doesn't match your condition exactly, another rule higher in the list caught the transaction first, the rule is set for a different bank account, or QuickBooks found a match to an existing transaction instead.
Do bank rules apply GST automatically?
Only if you set a tax code in the rule. Without one, the full amount goes to the expense category and you lose the input tax credit. Choose the GST tax code when you build the rule.
Want this off your plate?
Flat-fee bookkeeping for Edmonton small businesses. Month to month, no surprises.
Book a free 15-min callThis article is general information for Alberta businesses and isn't tax or legal advice. Rules and thresholds change, so confirm your situation with your accountant or CRA.