Bank Rules in QuickBooks Online: Setup and Fixes

A bank rule is a standing instruction that tells QuickBooks Online how to categorize a transaction before you ever look at it. Set up a handful properly and a bank feed that used to take an hour to clear takes about five minutes. Set them up carelessly and you will spend a weekend in January working out why eight months of fuel purchases went to Office Supplies.

This walks through creating a rule, the two settings most people get wrong, how the priority order actually behaves, and how to unpick rules that have already miscategorized real transactions. It also covers the part that catches out anyone doing catch-up work: rules apply to transactions you upload from a file, not just to a connected bank feed.

How to set up a bank rule in QuickBooks Online

The Rules screen has moved more than once, so check both paths. In most accounts it is Transactions, then the Rules tab. In the newer navigation it sits under All apps, then Accounting, then Rules. There is also a shortcut worth knowing: open any transaction in the For review tab and click Create rule from this transaction, which pre-fills the bank text for you and removes the most common source of typos.

1. Click New rule and give it a name. The name is only for sorting your own list, so use something you will recognize at a glance, such as "Shell fuel" rather than "Rule 4".
2. Set the direction. The For field asks whether this applies to Money in or Money out. Getting this backwards is why a rule silently never fires.
3. Choose the accounts. The In field lets you apply the rule to all bank and credit card accounts, several, or exactly one. Scope it tightly when a vendor means different things on different cards.
4. Build the conditions. Pick all or any, then add lines. You can match on the bank description text or the amount, with operators including Contains, Doesn't contain and Is exactly. Use Add line for a second or third condition.
5. Set what happens. Choose a transaction type, a payee and a category. You can also write a memo, and you can Split the amount across several categories by percentage or fixed value.
6. Decide how it applies. This is the big one, and it is covered on its own below.
7. Save.

Auto-add or manual review: the setting that decides everything

QuickBooks gives you two ways for a rule to behave, and the difference is much larger than the wording suggests.

Auto-add is genuinely useful for a fixed rent payment or a software subscription that hits the same amount on the same day. It is dangerous everywhere else, because the transactions you most need to look at are the unusual ones, and auto-add is precisely the setting that stops you looking. A good working pattern is to create every rule on manual review, watch it for a full month, and only promote the ones that were right every single time.

How rules are prioritized in QuickBooks Online

QuickBooks runs bank rules sequentially from the top of the list down, and the first rule that matches wins. This is the single most common reason a rule "stops working": a broader rule above it is catching the transaction first. On the Rules screen the rules are numbered on the left, and you can drag them into a new order using the reorder control.

The ordering principle is simple. Specific rules go above general ones. If you have a rule matching "AMAZON" that sends everything to Office Supplies, and a second rule matching "AMAZON WEB SERVICES" that sends hosting to Computer and Internet, the AWS rule has to sit above the Amazon rule or it will never fire. Nothing in the interface warns you about this, so when a rule appears to be ignored, check the order before you check anything else.

If the reorder control does not appear at all in a US account, that is a known interface issue rather than something you have configured wrong, and it needs Intuit support to resolve.

Do bank rules apply to transactions I upload from a file?

Yes, and this is the part worth planning around. Bank rules run against anything that lands in the For review tab, and that includes transactions you import yourself from a .qbo Web Connect file, a .qfx or a CSV. QuickBooks does not distinguish between a connected feed and a manual upload once the transactions are in the queue.

That matters enormously for catch-up and cleanup work, because the bank feed only reaches back so far. QuickBooks pulls roughly 90 days of history when you first connect an account, and older transactions have to come from somewhere else. If you convert your PDF bank statements to QBO first and upload those files, every rule you have written applies to that historic batch on the way in. Two years of statements can arrive already categorized instead of arriving as 1,400 blank lines.

The practical order is: write the rules first, then import. Doing it the other way round means clearing the queue by hand and then writing rules that have nothing left to act on. If you are rebuilding a year of books from paper or downloaded statements, spending twenty minutes on rules before the first upload is the highest-value twenty minutes in the job.

Why is my bank rule not working?

A rule that does not fire almost always fails for one of six reasons. Work down the list in order.

• Wrong direction. The rule is set to Money in and the transaction is Money out, or the reverse. Check this first, because it is the most frequent cause.
• Another rule is catching it first. Rules run top to bottom and stop at the first match. Move the specific rule above the general one.
• The condition text does not match the bank text. What you see on the paper statement is often not what the bank transmits. Open the transaction in the feed and copy the bank description exactly rather than typing what you expect it to say.
• The rule is scoped to the wrong account. A rule set to one checking account will not touch the credit card.
• You used "all" when you meant "any". With all selected, every condition has to be true at once, so two conditions that can never both hold produce a rule that never fires.
• The transaction was already categorized. Rules act on transactions coming into the review queue. Anything already added to the register is untouched, and has to be fixed directly.

How do I fix transactions a bad rule already categorized?

Fixing the rule does not retroactively fix what it has already done, so this is a two-step job. Correct the rule first, then repair the history.

Go to Transactions, then Bank transactions, and open the Categorized tab. Filter to the account and the date range, and sort or search on the payee or description the bad rule was matching. QuickBooks lets you tick several transactions and use Undo, which pushes them back into For review as uncategorized. Once your corrected rule is saved and ordered properly, they come back through the queue and get categorized correctly on the second pass.

If the transactions are already reconciled, be more careful. Undoing a reconciled transaction breaks the reconciliation for that period, and you will need to undo the reconciliation in QuickBooks Online or reclassify the transactions in place rather than sending them back to the feed. For a large batch that only needs the category changed, reclassifying is usually the safer route, and the same approach applies when you are cleaning up a pile of uncategorized transactions in QuickBooks.

How many bank rules should I actually create?

Fewer than most people expect. The value is concentrated in the transactions that repeat, and in almost every set of books a small number of vendors account for most of the line count: the fuel card, the payroll provider, the merchant processor fees, the phone bill, the recurring software charges, the landlord. Twelve to twenty well-aimed rules will usually categorize seventy to eighty percent of a typical month.

Writing a rule for a vendor you paid once is a net loss. It adds a row to a list you now have to maintain and reason about when the ordering goes wrong later. If a transaction is not going to happen again, categorize it by hand and move on.

One structural warning: rules encode your chart of accounts at the moment you wrote them. If you later merge accounts, rename categories or restructure the chart, go back and check the rules, because a rule pointing at an account that no longer means what it used to will keep quietly filing things in the wrong place. The same caution applies to card spending that a rule cannot really judge on description alone. Where the category genuinely depends on what was bought rather than who was paid, the receipt has to decide, and a system that reads receipts and categorizes the spend against a policy is doing a job a bank rule structurally cannot.

Can I use bank rules in QuickBooks Desktop?

QuickBooks Desktop has a comparable feature, but it works differently and it is not as flexible. In Desktop the equivalent lives in the Bank Feeds Center under renaming rules, which map a downloaded bank description to a payee name and an account. Conditions are simpler, there is no split by percentage, and the ordering behavior is not exposed the way it is online. If you are moving from Desktop to QuickBooks Online, expect to rebuild the rules rather than migrate them, and treat it as an opportunity to write fewer and better ones.

A working setup, start to finish

If you are starting from nothing, this sequence gets you to a clean feed fastest:

1. Clear one month of the feed by hand and pay attention to what repeats. Do not write a single rule yet.
2. Write rules for the ten or fifteen vendors that appeared more than twice, all on manual review, copying the bank text out of the feed rather than typing it.
3. Order them with the specific rules at the top. Anything matching a parent brand goes near the bottom.
4. If you have history to load, import it now. Convert the statements to a QBO file and upload, and the rules will categorize the batch as it arrives.
5. Run a month. Note which rules were right every time.
6. Promote only those to auto-add. Leave everything else on manual review permanently.

The last step is where the time savings actually come from, and it is the one most people skip in either direction. Turning on auto-add for everything creates a register nobody has reviewed. Turning it on for nothing means you keep clicking Add several hundred times a month for a rent payment that has been identical for three years. The rules that earn auto-add prove it first.

Once rules are in place, the remaining work in the feed is the genuinely ambiguous transactions, which is exactly where a human should be spending the time. If your statements are only available as PDFs, our PDF to QBO converter turns them into a QuickBooks-ready file so your rules can do the categorizing, and there is more detail on the review step itself in the guide to reviewing imported bank transactions in QuickBooks. For loading several accounts at once, see importing multiple bank accounts into QuickBooks.