Jim Merritt - August 19, 2026

If you use Bank Transactions in QuickBooks Online, Rules can be one of the biggest time-savers available to you. When they are set up correctly, Rules can help categorize repetitive transactions quickly and consistently.

But there is another side to Rules that I see far too often: a poorly created Rule can create a lot of cleanup work.

QuickBooks Online allows you to create Rules that look at information such as the transaction description, bank text, or amount and then automatically assign details such as the transaction type, category, tags, and payee. You can also specify whether a Rule applies to money coming in or going out and whether it applies to one particular bank or credit card account or all accounts.

The key is remembering that QuickBooks is only doing what you told it to do. If you give it a bad Rule, it can consistently make the same bad decision over and over again.

Here are some of my Do’s and Don’ts for creating Rules in QuickBooks Online.

What Is a Rule in QuickBooks Online?

A Rule tells QuickBooks:

“When you see a bank transaction that meets these conditions, categorize it this way.”

For example, suppose your business pays your internet provider $149.00 every month.

Instead of manually choosing:

Internet Expense

every month, you might create a Rule telling QuickBooks that transactions containing the internet provider's name should be categorized to your Internet or Utilities expense account.

That can be a great Rule because the transaction is predictable and normally goes to the same account every time.

QuickBooks currently allows up to five conditions per Rule, and Rules can use Description, Bank text, or Amount as criteria. Rules can also be prioritized, with higher-priority Rules applied first.

And that brings us to the most important part.

The DO’s of Creating QuickBooks Online Rules

DO: Create Rules for Transactions That Are Truly Consistent

The best Rules are for transactions that almost always belong in the same place.

Good examples might include:

• Monthly internet service

• Telephone bills

• Software subscriptions

• Bank service charges

• Insurance payments

• Rent

• Certain recurring merchant fees

If the vendor and the expense category are predictable, a Rule can save you a considerable amount of time.

QuickTrainer Tip:

Before creating a Rule, ask yourself:

“Will transactions matching this Rule almost always be categorized the same way?”

If the answer is yes, it may be a good candidate.

If the answer is, “Well...most of the time,” you may want to think twice.

DO: Make Your Rule as Specific as Possible

One of the most common mistakes I see is creating Rules that are too broad.

Suppose you create a Rule that says:

Description contains “AMAZON” → Office Supplies

Sounds reasonable, right?

Not necessarily.

Your Amazon purchases might include office supplies, computer equipment, gifts, cleaning supplies, inventory, or something personal that needs to be handled differently.

A better Rule uses enough information to identify a specific type of transaction without accidentally capturing unrelated purchases.

QuickBooks lets you combine multiple conditions when building a Rule, so take advantage of them when necessary.

Specific Rules are usually safer Rules.

DO: Pay Attention to “Description” Versus “Bank Text”

This is an important one.

QuickBooks distinguishes between the Description and the Bank text received with a transaction.

The Bank text is essentially the information QuickBooks receives from your financial institution. The Description may be a simplified version of that information.

If a Rule isn't working the way you expect, check whether you created it using Description when you really needed Bank text—or vice versa. Intuit specifically identifies this as a common reason Rules don't apply as expected.

Whenever I'm troubleshooting a Rule, this is one of the first things I look at.

DO: Give Your Rules Meaningful Names

Don't create Rules called:

Rule 1
Amazon
Expense
Credit Card Rule

Six months later, those names won't tell you much.

Instead, use descriptive names such as:

Spectrum – Internet Expense
Adobe – Software Subscription
Bank Fee – Checking Account
Office Rent – Monthly Payment

A clear naming system makes your Rules much easier to review, troubleshoot, and maintain.

DO: Review Your Rules Periodically

Your business changes.

Vendors change.

Subscriptions change.

Bank descriptions change.

And your accounting needs change.

Go through your Rules periodically and ask:

• Do I still need this Rule?

• Is it categorizing transactions correctly?

• Is the expense account still appropriate?

• Is the vendor still being used?

• Is another Rule conflicting with it?

• Should the Rule apply to every bank account or only one?

QuickBooks lets you copy, disable, enable, or delete Rules, so you don't necessarily have to permanently delete a Rule if you simply want to stop using it for a while.

The DON’Ts of Creating QuickBooks Online Rules

DON’T: Create a Rule Just Because QuickBooks Suggests One

Automation is useful.

Blind automation isn't.

Just because QuickBooks recognizes a pattern doesn't necessarily mean every future transaction matching that pattern should receive the same accounting treatment.

Remember:

Your goal isn't to get through Bank Transactions as quickly as possible. Your goal is to get the accounting right.

QuickBooks can suggest categories based on previous transactions, but those transactions should still be reviewed to make sure the suggested treatment makes sense.

DON’T: Automatically Categorize Every Transaction From the Same Vendor

This is probably my biggest warning when it comes to Rules.

Think about businesses such as:

• Amazon

• Walmart

• Costco

• Home Depot

• Lowe's

• Office Depot

You may purchase many different types of things from these vendors.

If you automatically send every Home Depot transaction to Repairs & Maintenance, what happens when you purchase a $4,000 piece of equipment?

That transaction may require completely different accounting treatment.

The vendor name alone doesn't always tell you what you purchased.

DON’T: Use Rules for Transfers Without Thinking Through the Other Side

Moving money between your own bank accounts is not income and it isn't an expense.

If $5,000 moves from checking to savings, you haven't earned $5,000 and you haven't spent $5,000.

You simply moved your money.

Be very careful when creating Rules involving transfers, credit card payments, loan payments, owner's contributions, or owner's draws. These transactions often require more thought than a simple expense Rule.

Categorizing these incorrectly can seriously distort your financial statements.

DON’T: Automatically Post Transactions Until You Trust the Rule

QuickBooks Online currently includes an Auto-post option that can automatically accept qualifying transactions into the books when they meet the Rule's conditions. Intuit recommends starting with simple, consistent transactions such as rent or gas expenses before expanding your use of Auto-post Rules.

I agree with the cautious approach.

When creating a new Rule, I prefer to see how it behaves first.

Does it capture the transactions you expected?

More importantly:

Does it capture transactions you DIDN'T expect?

Once you are confident that the Rule is accurate and specific enough, then you can decide whether automatic posting makes sense.

Saving a few mouse clicks isn't worth creating hours of cleanup later.

DON’T: Ignore Rule Priority

If you have several Rules that could potentially apply to the same transaction, Rule order becomes important.

QuickBooks allows you to change Rule priority, and the Rule with the highest priority is applied first.

For example, you might have:

Rule 1: Description contains “Amazon”
and
Rule 2: Description contains a more specific recurring Amazon charge.

If your broad Rule takes priority, QuickBooks may never get to the more specific Rule you intended to use.

Another reason I recommend keeping Rules specific rather than broad.

DON’T: Assume a Rule Means You Never Have to Look at the Transaction Again

This may be the most important Don't of all.

A Rule is a tool.

It isn't an accountant.

Rules can speed up data entry and make your accounting more consistent, but they don't know the business reason behind every transaction.

A vendor changes.

A purchase is unusual.

A recurring charge increases.

A transaction that normally belongs in one account needs to go somewhere else this month.

Those exceptions are exactly why reviewing your Bank Transactions remains important.

A Good Rule Saves Time. A Bad Rule Multiplies Mistakes.

When used correctly, QuickBooks Online Rules can be extremely helpful.

They can reduce repetitive data entry, create more consistency, and make working with Bank Transactions much faster.

But remember this:

The power of a Rule is also its danger.

If you manually categorize one transaction incorrectly, you have one mistake.

If you create a Rule incorrectly, QuickBooks can repeat that mistake again and again.

My advice is simple:

Start small.

Create Rules for your most predictable transactions. Make the conditions specific. Review the results. Be cautious with automatic posting. And periodically review your Rules to make sure they're still doing what you intended them to do.

Automation should make your accounting more accurate and efficient—not simply faster.

Need Help Cleaning Up or Setting Up QuickBooks Online?

If your QuickBooks Online Bank Transactions are filled with questionable Rules, incorrect categories, duplicate transactions, or items you're just not sure how to handle, QuickTrainer, Inc. can help.

Since 2006, QuickTrainer has helped small businesses learn how to use QuickBooks correctly through practical, one-on-one QuickBooks training and support.

We can help you:

• Set up QuickBooks Online correctly

• Review and clean up existing Bank Rules

• Learn how to properly use Bank Transactions

• Review your QuickBooks data for problems

• Clean up incorrectly categorized transactions

• Create a workflow that makes QuickBooks easier to manage

• Provide personalized one-on-one QuickBooks training remotely

Don't let automation create more accounting problems than it solves.

QuickTrainer, Inc. — Your QuickBooks and Accounting Experts

Let QuickTrainer give you back your time.

📞 Call QuickTrainer at 910-338-0488 📧 Email: [email protected] 🌐 www.qti-wilmington.com