Guides · Bank rules
QuickBooks Online bank rules: how to set them up, when they fire, and why they miss
Bank rules are the biggest time-saver in the QuickBooks Online bank feed, and the feature people give up on fastest. Most "my rules stopped working" complaints come down to three things: the rule text does not match what the bank sends, a higher rule catches the transaction first, or the rule is set to suggest instead of post.
Where bank rules live
In current QuickBooks Online, rules are under All apps › Accounting › Rules, on the Bank rules tab. Older layouts put the same page under Banking › Rules. You can also open the editor from a single row on the review tab with Create rule; QuickBooks pre-fills the conditions from that transaction, so the rule is guaranteed to match at least one real row.
Rules act only on downloaded transactions still waiting on the For review tab (labelled Pending in some companies). They never rewrite transactions already in your books.
Creating a rule, field by field
- Go to Accounting › Rules and select New rule.
- What do you want to call this rule? Name it after the outcome: "Fuel – Shell/Chevron/Exxon" reads better in a long list than "Shell".
- Apply this to transactions that are: Money in or Money out. A rule cannot cover both, so refunds from a vendor need their own money-in rule.
- in: one bank or card account, or All bank accounts. Pick a specific account when the same vendor means different things on different cards.
- and include the following: All or Any. "All" means every condition must be true; "Any" means one is enough. Up to five conditions per rule.
- Add conditions. Each one tests Description, Bank text or Amount with Contains, Doesn't contain or Is exactly.
- Choose what the rule sets: Transaction type, Category, Payee, and depending on company settings Product/service, Tax, Customer, class or location.
- Decide whether the rule should post on its own, then Save.
Description versus Bank text
This distinction causes more silent misses than anything else. Bank text is the raw string your bank sends, for example POS DEBIT SHELL OIL 57442128 HOUSTON TX. Description is QuickBooks' cleaned-up version, often just Shell Oil, and the cleaning can change over time or differ between cards. Rules on Bank text with a short, stable fragment (SHELL OIL) survive that; rules on Description with Is exactly break the moment a store number appears.
Amount conditions
Is exactly is the useful amount operator for fixed subscriptions and loan payments. Combine it with a text condition under All: "Bank text contains ADOBE" and "Amount is exactly 59.99" catches the Creative Cloud charge and leaves a one-off Adobe Stock purchase for review. Amounts are matched as positive numbers.
Suggest versus post automatically
By default a rule only suggests: the matching row stays on the review tab with the category filled in and a RULE badge until you confirm it. Turn on the auto-post option in the rule editor (Auto-post in the current editor, Auto-add in older ones) and QuickBooks adds the transaction the moment it downloads; it lands on the Categorized (or Posted) tab with an AUTO badge.
Auto-posting suits transactions where the category is never in doubt and the amount is predictable: bank fees, the same subscription every month, loan payments. It is wrong for anything that might need matching to an existing bill, invoice or transfer, because an auto-posted expense that should have been a match is a duplicate you then have to find and undo. Run a new rule in suggest mode for a month, confirm it never mis-fires, then switch it on.
The order rules fire in
QuickBooks evaluates rules from the top of the list down and stops at the first rule whose conditions are met. One rule per transaction, no stacking. You change priority by dragging a rule with the reorder handle on the Rules page. Two consequences follow:
- Specific rules must sit above general ones. If "Bank text contains AMAZON → Office supplies" sits above "contains AMAZON WEB SERVICES → Software", every AWS invoice lands in office supplies.
- A broad catch-all (anything containing "TRANSFER") belongs at the bottom, in suggest mode only.
When a rule you expect to fire does not, read the list from the top and ask which earlier rule the transaction could satisfy. That is usually the answer.
Why rules miss, and the fix for each
| Symptom | Usual cause | Fix |
|---|---|---|
| Rule never applies to a vendor it clearly names | Condition is on Description with Is exactly; store numbers, city names or "#" suffixes vary | Switch to Bank text, operator Contains, shortest stable fragment |
| Rule worked for months, then stopped | Bank changed its descriptor (merger, new processor) or QuickBooks changed its cleaned Description | Open a recent unmatched row, compare its Bank text to the rule, add a second condition under Any |
| Wrong category applied | A higher rule with a broader condition caught it first | Reorder; move the specific rule up |
| Rule applies to money out but not the refund | Rules are one-directional | Duplicate the rule (Actions › Copy) and set it to Money in |
| Rule applies in one company, not another | Rules are per company file | Use Export rules and Import rules from the dropdown next to New rule |
| Row shows Match instead of the rule's category | QuickBooks found an existing transaction with the same amount and a close date | Matching wins over rules; accept the match or choose Categorize on that row |
Habits that keep a rule list healthy
- Keep conditions short.
UBERcatches rides;UBER *EATSas a separate higher rule splits meals out. Long conditions copied from one bank line rarely match the next. - One category, one rule, several conditions. One "Fuel" rule with SHELL, CHEVRON and EXXON under Any beats three rules. The list stays readable and the ordering problem shrinks.
- Audit monthly. On the review tab, set the All transactions filter to Rules to see which rows a rule touched. Anything miscategorised there points to a condition that needs tightening.
- Export before you clean up, disable rather than delete. Export rules gives you an Excel file to keep or reuse in a new client file; the Actions menu on each rule offers Disable/Enable for seasonal vendors.
Where Rowpost helps
QuickBooks rules handle the predictable half of the feed. The other half is the long tail: vendors that appear a few times a year, descriptions that change, and the rows where you know the category on sight but still click into each one. Rowpost is a Chrome extension that works on the For review table itself. You write the same "description contains X → category Y" rules, they run in your browser and show suggestions inline with a confidence indicator, and you confirm them in bulk through one review dialog. J/K/X keyboard review and a Ctrl/⌘+K palette cover the rows your rules missed; rows QuickBooks wants matched are left alone. Free for five rules; Pro ($19/month) removes the limit and adds rule export. See also clearing the For review tab faster and bank feed keyboard shortcuts.
Get Rowpost on the Chrome Web StoreFree for up to 5 rules. Nothing is added to QuickBooks without a confirmation.
Frequently asked questions
Do QuickBooks Online bank rules apply to transactions already in the For review tab?
Yes. When you save a new rule, QuickBooks runs it against the rows currently waiting for review as well as future downloads. Rows that were already added to your books are not changed.
Can one transaction be affected by more than one rule?
No. QuickBooks applies the first rule in the list whose conditions are met and stops. Put specific rules above general ones and drag to reorder.
Why does a rule show a category but the row stays in For review?
The rule is in suggest mode, which is the default. The category is pre-filled and the row carries a RULE badge, but you still confirm it. Turn on the auto-post option in the rule editor if you want QuickBooks to add it on its own.
Can I copy bank rules from one QuickBooks company to another?
Yes. On the Rules page, open the dropdown next to New rule and choose Export rules, then in the other company choose Import rules and pick the rules you want.