Week 5: Bank Rules , Teach QuickBooks to Think Like You
Welcome to Week 5 of QuickBooks Without the Guesswork!
So far, we’ve connected bank feeds, learned how to match transactions, and explored how to categorize income and expenses. Now it’s time to make your bookkeeping workflow a little more efficient.
Enter: Bank Rules.
Bank rules let QuickBooks Online (QBO) recognize familiar transactions and suggest the same bookkeeping treatment each time. Think of them as helpful instructions you give QuickBooks: “When you see this vendor, it usually belongs in this category.”
That can save you time. It can also create a spectacular mess if you automate too much too quickly.
The goal is not to let QuickBooks run wild. The goal is automation with oversight, clear, creative, calm bookkeeping while you continue Keeping Two Eyes on Your Books.
What Are Bank Rules in QuickBooks Online?
A bank rule tells QBO what to do when a downloaded bank transaction meets certain conditions.
For example, you might create a rule that says:
When a transaction from your internet provider appears, categorize it as Internet or Utilities.
When a matching transaction arrives through your bank feed, QuickBooks can apply the category, payee, transaction type, and other details you selected.
Depending on your settings, QBO may:
Pre-fill the transaction for you to review
Automatically add the transaction to your books
Apply a category and leave the final approval to you
For most small businesses, starting with pre-filled transactions that still require review is the safest choice. You get the time-saving benefits of automation without handing over the entire steering wheel.
You can learn more about the current bank rule options in Intuit’s QuickBooks Online guide to bank rules.
How Bank Rules Save Time
Bookkeeping often includes the same decisions over and over:
The monthly internet bill belongs in Internet or Utilities
The website hosting charge belongs in Website or Software Expense
The office rent payment belongs in Rent
The recurring software subscription belongs in Software Expense
If the vendor and bookkeeping treatment are consistent, a bank rule can reduce repetitive clicking.
Instead of opening the same type of transaction every month and choosing the same category, QBO can make the suggestion for you. You review it, approve it, and move on with your day.
That may only save a few seconds per transaction, but those seconds add up. More importantly, bank rules can help create consistency in your records, which is one of the foundations of reliable bookkeeping.
Types of Bank Rules in QBO
QuickBooks gives you several ways to tell a rule when it should apply. The exact wording may vary slightly depending on your version or account settings, but common options include:
Bank Text or Description
You can create a rule based on words found in the bank transaction description.
For example:
“Spectrum”
“GoDaddy”
“Adobe”
“Verizon”
“Google Workspace”
This is often called a name-contains rule because QBO looks for a word or phrase within the transaction details.
Be specific. A rule for “Google” might catch several unrelated Google charges. A rule for “Google Workspace” is more focused.
Amount
You can create a rule based on the dollar amount. QuickBooks Online generally allows numeric comparisons such as:
Equals
Is greater than
Is less than
Does not equal
An exact amount can work well for a stable monthly expense. For example, if your hosting bill is always exactly $29.99, a rule using that amount may be helpful.
However, be cautious with amount-based rules. A payment of $500 does not tell you what the payment was for. Several unrelated transactions may share the same amount.
Money In or Money Out
You can tell QBO whether the rule applies to money coming into the account or money leaving it.
For recurring expenses, choose Money Out. For certain predictable deposits, you may choose Money In, but customer payments usually require more care, as we’ll discuss below.
Bank Account
You can apply a rule to one bank account or multiple accounts. A rule for business checking may not be appropriate for a credit card or savings account, so choose carefully.
All or Any Conditions
You may be able to choose whether all conditions or any conditions need to be met.
All conditions: Every detail must match. This creates a narrower, safer rule.
Any conditions: Just one of the listed details needs to match. This creates a broader rule.
When you’re learning, narrower rules are usually better. You want a rule that catches the right transactions, not every transaction that vaguely resembles the right one.
How to Create a Simple, Safe Bank Rule
Let’s use a recurring internet expense as an example.
Step 1: Open Bank Transactions
In QuickBooks Online, go to Accounting > Bank transactions. In some versions, you may see a Banking or Bank Feeds label instead.
Look for the option to manage your bank rules. This may appear under an Update dropdown or a similar menu.
Step 2: Create a New Rule
Choose New rule and give it a clear name, such as:
Monthly Internet , Spectrum
A descriptive name makes your rules easier to manage later. “Rule 1” may seem fine today, but it will not be very helpful when you have twelve rules to review.
Step 3: Choose the Transaction Direction
Select Money Out because this is an expense leaving your bank account.
Then choose the bank account where the internet payment appears.
Step 4: Add a Specific Condition
For the bank text or description, choose Contains and enter the vendor name as it appears in your bank feed.
For example:
Spectrum
If the amount is stable, you may also add an amount condition, such as:
Amount equals $89.99
Using both the vendor and the amount makes the rule more specific. Just remember that the rule may stop applying if the vendor changes the bill.
Step 5: Choose the Category
Select the appropriate expense category, such as:
Internet
Utilities
Telephone and Internet
Software Expense, depending on the charge
You can also add the payee if that is useful for your records.
Step 6: Leave Auto-Add Off at First
QuickBooks may offer an option to automatically add or confirm transactions that meet the rule.
For a new rule, we recommend leaving that option off until you have tested the rule through several transaction cycles. This allows the transaction to appear for review with the category already filled in.
Review the transaction, confirm that the rule applied correctly, and then select Add or Post.
Once you’re confident the rule is consistently accurate, you can decide whether auto-add makes sense.
Good Candidates for Bank Rules
The best bank rules are predictable and boring. In bookkeeping, “boring” is a compliment.
Good candidates often include:
Monthly internet bills
Website hosting
Stable software subscriptions
Office rent
Regular phone service
Recurring insurance payments
Predictable storage or membership fees
A good rule usually has a consistent vendor, a clear purpose, and a category that does not require much interpretation.
Before creating a rule, ask:
Does this vendor appear regularly?
Is the transaction purpose clear?
Is the category usually the same?
Would I make the same decision every time?
If the answer is yes, a bank rule may be a good fit.
Transactions You Should Not Automate
Not every repeated transaction should have a rule.
Avoid automating transactions that are:
Variable and difficult to identify
Connected to customer payments
Split between multiple categories
Personal and business mixed together
Related to loan payments
Related to payroll or taxes
Requiring receipts or additional documentation
Unusual or one-time purchases
Dependent on business judgment
Customer payments are a common example. A deposit from a customer may need to be matched to an invoice, sales receipt, payment processor, or accounts receivable record. Categorizing it as generic income could create inaccurate sales records or make it appear that revenue was received twice.
Loan payments also deserve caution. One payment may include both principal and interest, which often need different bookkeeping treatment.
The golden principle is simple:
Automate repetition, not judgment.
If you have to stop and ask, “What was this really for?” the transaction probably should not be fully automated.
Automation With Oversight
Bank rules are assistants, not decision-makers.
Even when a rule applies correctly, you should still review your bank transactions regularly. Look for:
The correct vendor
The correct category
The correct amount
Duplicate transactions
Unexpected changes
Transactions that should be matched instead of added
A rule can apply a category, but it cannot always understand the full story behind a transaction. That is where your review matters.
This is also why bank rules should be introduced gradually. Start with one or two reliable expenses. Watch how they behave. Then expand from there.
What to Do When a Rule Causes Problems
Rules are not permanent. You can edit, turn off, or delete a rule when it no longer works.
Go back to the bank rules management area and review the rule list. From there, you can typically:
Edit the vendor or description condition
Adjust the amount
Change the category
Change the bank account
Turn off auto-add
Deactivate the rule
Delete the rule entirely
If a rule categorized several transactions incorrectly, correct those transactions individually first. Then fix or turn off the rule so the problem does not continue.
It is also helpful to review your rules occasionally, especially after changing vendors, pricing plans, bank accounts, or your chart of accounts.
Common Bank Rule Pitfalls
Rules That Are Too Broad
A rule based on “Amazon” could capture office supplies, personal purchases, equipment, and gifts. A broad rule may save time while quietly creating inaccurate books.
Use more specific conditions whenever possible.
Rules That Over-Categorize
A vendor may sell more than one type of product or service. If the same vendor appears for different business purposes, do not force every transaction into one category.
Rules That Conflict With Matches
If QBO identifies an existing transaction, invoice payment, or expense that should be matched, choose Match rather than adding a new transaction.
Adding instead of matching can create duplicates. When in doubt, pause and inspect the details.
Forgetting to Review Auto-Added Transactions
Auto-add can be useful for highly predictable expenses, but it should not become “set it and forget it.” Review your categorized transactions regularly to catch changes early.
The Tip Jar
Start small.
Choose one recurring expense, perhaps your internet or hosting bill, and create a rule that is specific, easy to understand, and set for review rather than automatic posting.
After a few months, ask:
Did the rule catch only the right transactions?
Did the category remain accurate?
Did the vendor or amount change?
Would I trust this rule next month?
If yes, you may be ready to add another. If not, edit the rule or turn it off. There is no prize for having the most automation. The prize is having books you can trust.
That is the difference between helpful Automation and bookkeeping chaos with a shortcut button.
Need help setting up QBO rules, reviewing your workflow, or keeping your records current? Ledgers By Liisa LLC offers QuickBooks Online coaching, monthly bookkeeping, and consultations and advisory services tailored to your business.
Book a consultation at www.ledgersbyliisa.com. We’ll help you keep things Clear. Creative. Calm.( while Keeping Two Eyes on Your Books.)
Comments