QuickBooks HelpQuickBooksHelpIntuit

Set up bank rules to categorize online banking transactions in QuickBooks Online

by Intuit1740 Updated 2 days ago

Learn how to use bank rules to automatically categorize transactions from your bank.

When you download transactions from your bank, you need to categorize them so that they enter the right accounts. Bank rules can do this automatically.

The more ‌QuickBooks Online uses the bank rules you create, the better it gets at categorizing. After a while, the app learns how to read transactions, then automatically adds details.

Here's how to set up bank rules.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

The QuickBooks design has been updated! If this video doesn't match what you see in QuickBooks, use the in-app Search bar to navigate to the page you need.

Automatically categorize transactions with QuickBooks Payments.

Step 1: Create a bank rule

Note: You can create up to 2,000 bank rules.

  1. Follow this link to complete the steps in product Open this link in a new window
  2. Select New rule.
  3. Enter a name in the What do you want to call this rule? field.
  4. From the Apply this to transactions that are ▼ dropdown, select Money in or Money out.
  5. From the in ▼ dropdown, select a bank or credit card account, or select All bank accounts.
  6. Set the rule's conditions. You can set a single rule with up to 5 conditions. Set and include the following, then select + Add a condition.
  7. In the Conditions fields, specify whether the rule applies to Description, Bank text, or Amount. Then select Contains, Doesn't contain, or Is exactly to decide how QuickBooks applies the rules.
  8. Select the settings for the rule. Select the Transaction type, Category, Tags, and the Payee to apply.
  9. Select Save.
  10. (Optional) To reorder your bank rules priority, select reorder Reorder icon and drag the rule to your desired order. The rule with the highest priority will always be applied first.

QuickBooks automatically applies your rules to transactions in the For review tab. These are the ones you need to review every day.

Tips

  • Quickly add a rule for transactions in the For review tab. Just select a transaction, then select the Create a rule link to open the Rule Window and start setting conditions for the rule.
  • Copy, Disable/Enable, or Delete bank rules from the Actions ▼ dropdown on the Rules page.

If you set up banking rules on another QuickBooks Online company file, you can export them to another company file:

  1. Sign in to the company file you want to export the bank rules from.
  2. Go to Settings Settings gear icon. then select Rules (Take me there).
  3. Select the New rule ▼ dropdown and then Export rules.
  4. Sign out of the company file and sign in to the one you want to import the rules into.
  5. Save the export file in Excel.
  6. Go to Settings Settings gear icon. then select Rules (Take me there).
  7. Select the New rule ▼ dropdown and then Import rules.
  8. Select Browse and find the Excel file you exported.
  9. Select the rules and details you want to import.
  10. Follow the prompts to finish the import.

Step 2: Review recognized transactions

After a rule is applied, a RULE badge appears in the Category field of the transaction. For auto-post rules, an AUTO badge appears.

To filter rules, follow these steps. 

1. Select Accounting, then select Bank transactions
2. Select the All transactions dropdown menu. 
3. Select Rules, No rules, or Auto-post rules.  

Next steps: Set up auto-post

Create targeted rules so that specific transactions are automatically accepted into your books from the Bank transactions (Take me there) page.

Tip: We recommend starting with simple, consistent transactions like rent or gas expenses. Then, use it to cover more transactions.

  1. Follow the steps to create a new bank rule.
  2. Turn on Auto-post under Automatically confirm transactions this rule applies to in the Rules window.
  3. Select Save.

After you create an auto-post rule, any transactions on the Pending tab that meet the conditions are automatically added. Auto-post rules run when you sign in, upload a file, or create or modify a new auto-post rule.

If your bank rules aren't getting applied to transactions

If your bank rules aren't getting applied, it might be because you’re using a rule based on bank text when you meant to make a rule based on description, or vice versa. To explain the difference:

  • The bank text is exactly the same information the app receives from the bank. The bank text is the transaction you'd see listed in your bank account or on your bank statement.
  • The description is a simplified version of the bank text to make it easier to understand. For example, the app might simplify bank text by just giving the vendor name.

By default, the app shows the description in your list of transactions. To show the bank text instead:

  1. Go to Transactions, then select Bank transactions (Take me there).
  2. Select the Settings ⚙ within the Bank transactions section.
  3. Select Show full bank description.

Bank rules work similarly in QuickBooks Online as they do in QuickBooks Desktop. If your rules have been automatically migrated from QuickBooks Desktop, notice the following differences:

  • QuickBooks Online supports up to 5 conditions per rule. The first 5 conditions for each rule from QuickBooks Desktop are migrated.
  • QuickBooks Desktop bank rules containing Begins with and Ends with clauses are matched with the Contains clause once migrated to QuickBooks Online.
  • If a migrated QuickBooks Desktop bank rule contains both Money in and Money out conditions, two bank rules are created in QuickBooks Online.

Find out more about how features and data move to QuickBooks Online.

QuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.