Rowpost

Guides · Bank rules

QuickBooks Online bank rules: how to set them up, when they fire, and why they miss

Last updated · Applies to QuickBooks Online (US)

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

  1. Go to Accounting › Rules and select New rule.
  2. 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".
  3. 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.
  4. in: one bank or card account, or All bank accounts. Pick a specific account when the same vendor means different things on different cards.
  5. 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.
  6. Add conditions. Each one tests Description, Bank text or Amount with Contains, Doesn't contain or Is exactly.
  7. Choose what the rule sets: Transaction type, Category, Payee, and depending on company settings Product/service, Tax, Customer, class or location.
  8. 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:

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

SymptomUsual causeFix
Rule never applies to a vendor it clearly namesCondition is on Description with Is exactly; store numbers, city names or "#" suffixes varySwitch to Bank text, operator Contains, shortest stable fragment
Rule worked for months, then stoppedBank changed its descriptor (merger, new processor) or QuickBooks changed its cleaned DescriptionOpen a recent unmatched row, compare its Bank text to the rule, add a second condition under Any
Wrong category appliedA higher rule with a broader condition caught it firstReorder; move the specific rule up
Rule applies to money out but not the refundRules are one-directionalDuplicate the rule (Actions › Copy) and set it to Money in
Rule applies in one company, not anotherRules are per company fileUse Export rules and Import rules from the dropdown next to New rule
Row shows Match instead of the rule's categoryQuickBooks found an existing transaction with the same amount and a close dateMatching wins over rules; accept the match or choose Categorize on that row

Habits that keep a rule list healthy

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.