Banking Rules in QuickBooks Online – How They Work & Why You Should Use Them

2/25/20252 min read

Managing your transactions in QuickBooks Online (QBO) can become time-consuming if you manually categorize every single expense and deposit. That’s where banking rules come in!

By setting up banking rules, you can automate transaction categorization, reduce errors, and speed up reconciliation. In this post, we’ll cover:

  • What banking rules are and how they work

  • How to set them up in QBO

  • Best practices to make them work for you

What Are Banking Rules in QuickBooks Online?

Banking rules are customized conditions that automatically categorize transactions imported from your bank feed. Instead of manually assigning categories, QBO applies rules based on criteria you set, such as:

  • Payee Name (e.g., transactions from "Shell Gas" go to Fuel Expenses)

  • Bank Text/Description (e.g., if a transaction contains "Uber," categorize it as Travel)

  • Amount Range (e.g., all transactions between $50–$100 from a specific vendor go to a certain category)

💡 Why Use Banking Rules?

✔ Save time by reducing manual data entry
✔ Maintain consistency in transaction categorization
✔ Reduce errors and improve financial accuracy

How to Set Up Banking Rules in QuickBooks Online

📌 To create a banking rule:

  1. Go to Banking → Rules → New Rule

  2. Give your rule a name

  3. Choose whether the rule applies to money in (deposits) or money out (expenses)

  4. Set conditions (such as “Bank Text contains ‘Amazon’”)

  5. Select Transaction Type (Expense, Transfer, or Check)

  6. Choose the Payee and Category (e.g., Office Supplies)

  7. Click Save

Example Rule: If a transaction contains "Stripe," categorize it as Sales Income.
Example Rule: If a transaction from "Verizon" is under $200, assign it to Utilities.

💡 Tip: You can apply rules automatically or review them before they are categorized.

Best Practices for Using Banking Rules

Be Specific – Avoid overly broad rules that may miscategorize transactions.
Use Multiple Conditions – Combine payee, description, and amount for accuracy.
Set Rules for Recurring Transactions – Automate categorization for rent, subscriptions, or utilities.
Regularly Review Rules – Update rules if vendors or expenses change.
Exclude Transfers – Ensure transfers between accounts aren’t mistakenly categorized as income or expenses.

How We Can Help

Banking rules can streamline your bookkeeping and keep your transactions properly categorized, but they need to be set up correctly to avoid errors. We help small business owners optimize their QuickBooks Online setup, automate categorization, and ensure accurate financial reports.

💬 Need help fine-tuning your banking rules? Contact us today!