If you use QuickBooks Online and you’re still categorizing every single bank transaction by hand, I have good news: you’re doing work the software is happy to do for you.
Bank rules are one of the most underused features in QBO. They’re a simple “if this, then that” system. If a transaction looks like this, then automatically name it, categorize it, and tag it. Set up a handful of good ones and your weekly bank feed review goes from a slog to a skim. Let’s walk through three rules worth setting up today.
Wait.. what are bank rules?
First, a 20-second primer on where bank rules live: in QBO, go to the Rules page (under the Accounting apps menu, or, even easier, open any transaction in your For Review tab and click “Create rule from this transaction,” which pre-fills the details for you). That second method is the fastest way to build a rule, because QBO grabs the information straight from a real transaction. That means you don’t have to remember the exact wording – it’s right there to work from.
A couple of things to know before we start.
- Each rule can have up to five conditions
- You can match on the Description, Bank text, or Amount
- QBO applies rules in priority order, so the order they’re listed in matters if two could apply to the same transaction.
Good to keep in the back of your mind as you build..
Rule #1: The “same vendor, every time” rule
This is the bread-and-butter rule, and the one that’ll save you the most time. It’s for any vendor you pay regularly and categorize the same way every single time. Think your software subscriptions, your phone bill, your recurring suppliers, your merchant processing fees.
The setup: create a rule that says when the description or bank text contains [vendor name], set the payee to [vendor] and the category to [the account you always use]. For example: any transaction containing “ADOBE” gets named Adobe and categorized to Software & Subscriptions.
Why it’s worth it: these are the transactions you’d otherwise click, name, and categorize over and over, week after week. A rule does it once and then forever. If you have ten regular vendors, that’s ten little decisions removed from every review.
A small tip: use the Bank text condition rather than Description when a vendor’s name shows up in a messy, abbreviated form on your statement (think “SQ *COFFEE 0392”). Bank text matches the raw data from your bank, which is often more reliable for catching those scrambled descriptions.
Rule #2: The “fix the ugly name” rule
You know the transactions I mean — the ones that import as “AMZN MKTP CA*2X4 9 0,” “SQ *,” or a string of numbers that tells you nothing three weeks later. Left alone, these create messy books and a lot of “wait, what was that?” detective work at month-end.
The setup: create a rule that catches the recognizable fragment (e.g. description contains “AMZN”) and renames the payee to something clean and human (“Amazon”), plus assigns a category if it’s consistent.
Why it’s worth it: beyond saving time, this is about clean, readable books. When you or your accountant looks back at the year, “Amazon — Office Supplies” is instantly clear; “AMZN MKTP CA*2X4” is a small mystery every time. Rules quietly and efficiently turn cryptic bank gibberish into records that actually make sense.
One honest caution: be specific enough that the rule only catches what you intend. A rule matching just “CA” would fire on far too much. Match on the distinctive part of the text, and lean on the Amount condition too if a vendor needs to be split by how much you spent.
Rule #3: The “money in” rule
Most people build rules only for expenses and forget that rules work just as well on the Money in side. If you receive regular deposits that should be handled the same way each time such as payouts from a payment processor, recurring client payments, transfers, or owner contributions, a rule keeps your income side just as tidy as your expenses.
The setup: when you create the rule, set “Apply this to transactions that are” to Money in, then match on the deposit’s description and assign the right category (or mark it as a transfer if it’s money moving between your own connected accounts).
Why it’s worth it: income that’s miscategorized, or worse, a transfer between your own accounts accidentally booked as revenue, quietly distorts your numbers and can inflate what looks like income. A simple money-in rule prevents that, and it’s the kind of thing most DIY setups miss entirely.
A few habits to make rules work for you
- Name your rules clearly. QBO suggests a name, but a tidy, descriptive name (“Adobe → Software”) saves you headaches when your rule list grows.
- Review, don’t blindly trust. Rules apply automatically in your For Review tab, but they’re a head start, not a hands-off autopilot. Glance before you confirm ESPECIALLY in the early weeks while you’re tuning them.
- Mind the order. Because QBO runs rules by priority, if a rule isn’t firing the way you expect, check whether another rule above it is catching the transaction first. You can drag to reorder.
- Let them build over time. You don’t need fifty rules on day one. Every time you find yourself manually categorizing the same thing twice, that’s your cue to make it a rule.
One note on QBO’s newer AI categorization
If you’re on a recent version of QBO, you’ll notice it now suggests categories on its own using AI, learning from how you’ve categorized in the past. In theory that’s genuinely helpful, but it can be prone to errors and it doesn’t replace rules.
Think of it this way: AI suggests based on patterns; a rule guarantees the outcome you’ve told it to. For your predictable, recurring transactions, a rule is still the more reliable tool.
The bottom line
Bank rules are a small upfront time investment that pays back every single week. Start with your most frequent vendors, clean up your ugliest transaction names, and don’t forget the money-in side. Within a couple of weeks you’ll wonder how you ever reviewed your bank feed without them!
Want your QBO set up so it’s working for you instead of the other way around? Getting your rules, categories, and bank feed dialed in is exactly the kind of thing I help businesses with. Reach out today and book a free consultation so that we can make your books run themselves a little more.