How to Use Bank Rules in QuickBooks Online (Without Messing Up Your Books)
Bank rules are one of the biggest time-savers QuickBooks Online offers and I've written about them at a higher level in this post about underused QBO features. Set up right, they can handle the boring categorization work for you, turning thirty minutes of clicking into five minutes of review. Set up carelessly, they miscategorize your transactions for months before you notice, and by then untangling the mess is its own project.
So it's worth doing right! Here's how I think about when to set up a rule, how to build one that won't backfire, and how to keep your rules accurate over time.
What a bank rule actually does
A bank rule is an instruction you give QBO that says "when a transaction matches these conditions, do this to it automatically." The conditions can be based on the description, the bank, the amount, whether it's money in or money out, or some combination. The action can be as simple as assigning a category and payee, or as involved as splitting the transaction across multiple accounts.
Once a rule exists, QBO will apply it to any matching transaction that comes through your bank feed, either auto-confirming the match or flagging it for your review first. Both modes are useful; which one to use depends on how confident you are in the rule, which I'll get to.
Before you make rules, make your Chart of Accounts clean
Rules are only as good as the categories you're assigning things to. If your COA is disorganized, rules will just propagate the mess faster. Clean up the COA first, then build rules against it.
Step 1: Decide if this transaction deserves a rule
Not every transaction needs one. Rules are best for transactions that hit three criteria:
They happen regularly. A one-time purchase doesn't need a rule. A monthly software subscription does.
They're always categorized the same way. A Square deposit that sometimes goes to retail sales and sometimes goes to service income doesn't want a rule (it'd guess wrong at least half the time). A Canva subscription that always goes to Software & Subscriptions does.
The transaction is specific enough to identify without ambiguity. A charge from "Mindbody" is specific. A charge that just shows up as "ACH Withdrawal" could be a dozen different things, and a rule would probably match the wrong ones.
If a transaction meets all three, it's a good rule candidate. If it only meets one or two, you're probably better off categorizing it manually each time.
Step 2: Build the rule
In QBO, go to Transactions > Bank transactions (or Banking in older versions) and click Rules in the upper right. Click New rule. Give it a name that describes what it does (I like format like "Canva Software & Subscriptions" so future-me can scan the rules list and see what each one does at a glance).
Set the conditions. The most common one I use is "Bank text contains [vendor name]." Use the most specific text you can that'll still catch every version of the transaction. For example, "CANVA" will catch both "CANVAMONTHLY" and "CANVAANNUAL," while "CANVA*MONTHLY" would miss the annual charge.
If the same vendor should be categorized differently depending on the amount (rare, but it happens), add a second condition on amount. You can combine conditions with "and" (must match all) or "or" (must match any).
Set the action. Assign the payee, the category, and any other fields you want the rule to fill in.
Decide whether to auto-confirm. For rules you're confident in, auto-confirm could save you a click per transaction. For rules where you want one more sanity check, leave auto-confirm off. I personally never use the auto-confirm option; it takes two seconds to verify that the rule is working correctly, and I’ve seen too many bookkeeping disasters caused by automatic rules.
Common mistakes to avoid
Too broad. Rules that match on a single common word ("deposit," "payment," "transfer") will sweep up far more than you intended. Use vendor names, specific payees, or amounts when possible.
Too many, too fast. If you're starting fresh, resist the urge to build twenty rules on day one. Build them as you encounter the same transaction type a second or third time. Rules you build speculatively are more likely to be wrong than rules you build from patterns you've actually seen.
Never reviewing. Rules can go stale. A vendor renames themselves, a subscription changes price, you reorganize your Chart of Accounts and the category a rule points to no longer exists in quite the same way. Plan to review your rules list every few months to make sure everything still makes sense.
Forgetting that rules propagate errors. If you miscategorize a transaction manually, you've miscategorized one transaction. If you build a rule that miscategorizes a transaction, you've miscategorized every future instance of that transaction until you notice. This is why reviewing your matches matters, and why rules aren't a substitute for understanding what's happening in your books.
How I use rules in client files
I use them a lot, but selectively. For recurring software subscriptions, regular vendor purchases, predictable deposits, rules do the heavy lifting. For anything ambiguous, anything new, or anything that I want my own eyes on each month, I categorize manually. The goal isn't to automate every transaction. The goal is to automate the obvious ones so I can focus attention on the ones that actually need thinking.
If you'd rather not build and maintain rules yourself
Setting up and maintaining bank rules is part of what I do for clients! Book a free call and we can talk about what ongoing bookkeeping support looks like.