QuickBooks Bank Rules: How to Set Up and Fix Them
Jun 26, 2026 • Updated Jul 25, 2026
PDF, JPG, PNG, BMP, HEIC, TIFF
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF · Max 50MB
Uploading...
Same tool as our bank statement to QBO converter. Free to try, no card needed.
To set up a bank rule in QuickBooks Online, go to Transactions, then Bank transactions, and open the Rules tab, then select New rule. Give the rule a name, choose whether it applies to money in or money out, set up to five conditions on the Description, Bank text, or Amount, and then tell QuickBooks the category, payee, and tax to assign. Turn on Auto-add if you want matching transactions posted for you instead of just suggested. From then on, any downloaded line that meets the conditions is categorized automatically.
Bank rules are the single biggest time-saver in the QuickBooks bank feed once you have more than a handful of repeating transactions. This guide covers how rules work in Online and Desktop, how to build and prioritize them, and the common reasons a rule stops firing. The converter at the top of this page matters here too: rules act on whatever lands in the For review tab, so transactions you upload from a converted statement get categorized by your rules exactly like live feed transactions.
| Part of a bank rule | What it controls | Notes |
|---|---|---|
| Money in / money out | Whether the rule applies to deposits or payments | A rule is one direction only; build two if you need both |
| Conditions (up to 5) | Match on Description, Bank text, or Amount | Use Contains, Doesn't contain, or Is exactly; pick All or Any |
| Assign | Category, payee, class, location, tax | What QuickBooks fills in when the rule fires |
| Auto-add | Posts matches automatically vs only suggesting | Off by default; suggested matches still wait in For review |
| Priority | Which rule wins when two could match | Drag to reorder; only one rule applies per transaction |
What is a bank rule in QuickBooks?
A bank rule is an instruction that tells QuickBooks how to categorize a downloaded bank transaction automatically based on what it looks like. When a feed line matches the conditions you set, such as a description that contains a vendor name, QuickBooks assigns the category, payee, and other fields you chose. Rules turn repetitive manual categorizing into a one-time setup, so the same coffee shop charge or monthly software fee is coded the same way every time.
How do I create bank rules in QuickBooks Online?
Go to Transactions, then Bank transactions, and select the Rules tab, then choose New rule. Name the rule, pick money in or money out, and add conditions on the Description, Bank text, or Amount field. Choose whether all or any of the conditions must be true, then set the category, payee, and tax to apply. Save the rule, and it works on the next download. A fast shortcut is to open a transaction in For review and select Create a rule from that line.
How do bank rule conditions work in QuickBooks Online?
Each rule allows up to five conditions, and each condition checks the Description, the Bank text, or the Amount against an operator: Contains, Doesn't contain, or Is exactly. You then choose whether the transaction must meet All of the conditions or Any of them. Use Contains with a short, distinctive piece of the vendor name for the widest reliable match, and reserve Is exactly for amounts or exact text you never want to vary.
How do I make a bank rule add transactions automatically?
Turn on the Auto-add toggle when you build or edit the rule. With Auto-add on, transactions that meet the conditions are posted to your books automatically instead of sitting in For review for you to confirm. Auto-add rules run when you sign in, when you upload a file, and when you create or change an auto-add rule. Leave Auto-add off for any rule where you still want to eyeball the match before it posts.
Can bank rules be prioritized in QuickBooks Online?
Yes. QuickBooks applies only one rule per transaction, and you control which rule wins by priority. On the Rules tab, select the option to reorder and drag each rule into the order you want, highest priority at the top. The first rule whose conditions match is the one that gets applied, so put your most specific rules above broader catch-all rules to keep them from being overridden.
Why are my bank rules not working in QuickBooks Online?
The usual reasons a rule does not fire are conditions that are too strict, the wrong money direction, or a higher-priority rule matching first. Check that the description text you typed actually appears in the bank line, that the rule is set to the correct money in or money out, and that no broader rule above it is catching the transaction. Rules also apply only to new downloaded transactions, not to lines you already categorized or excluded.
Do bank rules apply to transactions I already categorized?
No. Bank rules run on transactions while they sit in the For review tab, not on transactions you have already added to your books. If you build a rule after some matching transactions were already categorized, the rule will not retroactively recode them. To apply new logic to old transactions, you would undo them back to For review first, or edit those entries by hand, then let the rule handle everything going forward. For the manual side of that cleanup, see how to categorize transactions in QuickBooks.
How do I edit or delete a bank rule in QuickBooks Online?
Open Transactions, then Bank transactions, and go to the Rules tab. Find the rule in the list, then use the Edit option in the Action column to change its conditions or the category it assigns, or use the dropdown arrow next to Edit and choose Delete to remove it. You can also copy a rule from the same menu to build a similar one quickly. Deleting a rule does not change transactions it already categorized.
How do I use bank rules in QuickBooks Desktop?
QuickBooks Desktop uses renaming rules inside the Bank Feeds Center rather than the Online rules engine. When you assign a payee and account to a downloaded transaction, Desktop offers to remember that choice and apply it to similar future transactions. You manage these under the Bank Feeds settings, where you can add, edit, or delete rules. The idea is the same as Online, but the screens and the level of control differ.
Can I export or import bank rules in QuickBooks?
QuickBooks Online does not offer a built-in export or import of bank rules between unrelated companies, though rules carry over when an accountant copies a client file and migrated Desktop rules are converted on import. If a Desktop rule contains both money in and money out conditions, the migration splits it into two separate Online rules. For moving rules between companies, accountants typically rebuild them or use a third-party tool.
Who can set up bank rules in QuickBooks Online?
Any user with access to the banking and transactions area can create and manage bank rules, which includes the primary admin, company admins, and standard users granted banking permissions, as well as the accountant user. If a team member cannot see the Rules tab, their role does not include banking access, and an admin needs to update their user permissions before they can build rules.
Do bank rules work on imported or converted statements?
Yes. Bank rules apply to any transaction that enters the For review tab, whether it came from a live bank feed or from a file you uploaded. So if you convert an old statement PDF to a QuickBooks .qbo file with the converter at the top of this page and upload it, your existing rules categorize those transactions automatically as they land. That makes rules a fast way to clean up backfilled months without coding every line by hand.
Can a bank rule assign a class, location, or tag?
Yes. If class tracking, location tracking, or tags are switched on in your company file, a bank rule can set them at the same time it sets the category and payee. That is the part most people miss, and it is where rules stop being a small convenience and start doing real work. A rule that recognizes your fuel vendor and stamps every charge with the right category and the right class means your profit and loss by segment is built as the transactions land, instead of being reconstructed at month end.
Set the class inside the rule the same way you set the category, on the second half of the rule screen where you assign what QuickBooks should do with a match. If the class field is not there, class tracking is off in that company. Read how class tracking works in QuickBooks Online for the plan requirements and the combined limit on classes and locations before you build rules that depend on it.
One caution: a rule with auto-add turned on that assigns a class will post transactions straight into your books already classified, which is excellent when the mapping is right and annoying to unwind when it is not. Let a new class rule run without auto-add for a cycle, confirm it is stamping what you expected, then switch auto-add on.
How do I copy a bank rule instead of building it again?
Open the Rules tab, find the rule, and use the Actions dropdown at the end of its row. Copy creates a duplicate you can rename and adjust, which is far faster than rebuilding a five condition rule from scratch when you need a near identical one for a second vendor or the opposite money direction. The same dropdown is where you disable a rule temporarily instead of deleting it, which is what you want when you are testing why the wrong rule keeps firing.
Remember that a rule is one direction only. If a vendor both charges you and issues refunds, copying the money out rule and flipping it to money in is usually the quickest way to cover both.
Last updated July 2026.
Frequently asked questions
How many bank rules can I have in QuickBooks Online?
QuickBooks Online allows up to 2,000 bank rules per company, which is far more than most businesses ever need. The practical limit is your own ability to keep them straight. Once you pass roughly fifty rules, a naming convention that starts with the vendor name pays for itself, because you will be searching that list to find why something categorized oddly.
Will a bank rule change a transaction I already reconciled?
No. Rules only act on transactions sitting in the For review tab. Anything you have already added to the register, reconciled, or matched is untouched by a rule you create or edit afterward. To fix already posted transactions in bulk you need to reclassify transactions in QuickBooks instead, which is a separate tool and a separate workflow. For the one-by-one approach on a handful of lines, see how to categorize transactions in QuickBooks.
Why did the wrong rule fire on my transaction?
QuickBooks applies only one rule per transaction, and when several rules match, the one highest in the priority order wins. A broad rule sitting above a specific one will swallow transactions the specific rule was built for. Drag the more specific rule above the general one on the Rules tab, then recheck the For review list.
Should I turn on auto-add for every rule?
No, and this is the mistake that creates the most cleanup. Reserve auto-add for transactions that are genuinely identical every time, like a fixed monthly software subscription or a recurring bank fee. Anything with a variable amount, a shared vendor, or a category that depends on context should stay in For review where a person confirms it.
Do bank rules work if I import statements instead of using a live bank feed?
Yes. Rules run on anything that reaches the For review tab, and it makes no difference whether the transactions arrived through a live feed or through an uploaded file. If your bank feed is broken or you are catching up on older periods, you can convert the statement PDF to a .qbo file and your existing rules will categorize the imported transactions exactly as they would feed data.
Once your rules are categorizing cleanly, the next step is to confirm the books tie out, so see how to reconcile bank statements in QuickBooks and what to check when your bank balance doesn't match QuickBooks. To control which lines post at all, read how to exclude bank transactions in QuickBooks, and to link downloaded lines to entries you already made, see how to match transactions in QuickBooks. If you also keep a spreadsheet copy of the statement for review, a bank statement to Excel converter lets you scan and sort lines before importing, an account that only exports CSV can run through a CSV to QBO converter, and teams that want vendor bills coded and paid the same way every month can automate it with accounts payable automation.
Convert your first statement free.
Upload a PDF bank statement, see every transaction extracted in seconds. No card to try it.
Still comparing tools? See our bank statement to QuickBooks converter comparison.