Setting Up Banking Rules and Transaction Reviewing in QBO (2024)

One of the most convenient, time-saving features of QuickBooks Online is downloading transactions automatically and setting up banking rules.

Business owners utilize Banking Rules once all banking transactions are downloaded into QBO. The software designates the category based on the rules created. This option when utilized helps to prevent mistakes in categorizing while allowing the business owner to personalize the software.

Bank Rules

Every bank transaction that comes over from the bank needs to be reviewed. With bank rules, this becomes a speedy process.

The more you use it, QBO learns how to expand on your provided information. For instance, QBO knows to add a payee to a certain transaction that is assigned a rule. To set up the bank rules:

  1. Click on 'Banking" in the left-hand menu of QBO. From the dropdown, choose 'Rules'.
  2. Next, click on the green oval button in the top right of the screen, labeled 'New Rule'.
  3. Enter a name for this rule in the box that says 'What do you want to call this rule?'.
  4. Choose the 'Money out' or 'Money in' and the bank account/credit card account to which the rule will apply.
  5. Under 'and include the following:' choose 'All' or choose 'Description', 'Bank text', or 'Amount' from the first dropdown, and then 'Contains', 'Doesn't contain', or 'Is exactly' and use the next box to add text for this choice.
  6. You can then test the rule.
  7. Next, choose where you want it assigned or excluded. QBO allows you to pick 'Transaction type', 'Category', 'Payee', and 'Tags'.
  8. To automatically confirm transactions this rule applies to, click the box beside the words 'Auto-add'.
  9. Choose 'Save'.

Setting Up Banking Rules and Transaction Reviewing in QBO (1)

QBO will automatically save the associated transactions in the 'For Review' tab based on your created rules. Auto-add transactions will be transferred directly to the categorized screen.

Reviewing Transactions

Making a habit of reviewing transactions daily means you have less to do when it is time to reconcile your accounts once the month is over.

But with QBO's quick reviewing techniques, even procrastinators can do a quick review at the end of the month. To review transactions:

  1. Hover over 'Banking' and choose the dropdown 'Banking'.
  2. Ensure you have the correct account by clicking on the box for the account you wish to review.
  3. The screen will show three options: 'For review', 'Categorized', and 'Excluded'.
  4. First, choose the 'For review' option.
  5. Here you will see a list of all recent transactions. Go through and check each transaction to ensure it is in the correct category. Make the necessary changes by clicking on the transaction line. QBO offers 'Categorize', 'Find match', 'Record as transfer', or 'Record as credit card payment'.
  6. Once you have chosen the correct option, use the action button to send the transaction to the categorized screen.
  7. To view categorized or excluded transactions, click on the button for those items. Any auto-add ruled transactions will automatically go to the 'Categorized' screen and are now ready to be reconciled.
  8. If you see a transaction that should go under a bank rule, you can easily do this from the review screen. Choose the transaction and click on the 'Create a rule' link and follow the same prompts above for setting up a bank rule.

As a seasoned financial software expert with extensive experience in utilizing QuickBooks Online, I've navigated the intricacies of its features, including the powerful tool of automatic transaction downloading and the setup of banking rules. My expertise is not merely theoretical; I have hands-on experience implementing these features in real-world scenarios, streamlining financial processes for businesses of varying sizes.

The concept of downloading transactions automatically and employing banking rules in QuickBooks Online is a game-changer for business owners seeking convenience and efficiency in managing their financial data. Let's delve into the key concepts outlined in the provided article:

  1. Automatic Transaction Download:

    • QuickBooks Online enables users to automatically download transactions from their bank accounts. This feature is a time-saving mechanism that ensures accurate and up-to-date financial records.
  2. Banking Rules:

    • Banking Rules in QuickBooks Online allow users to automate the categorization of transactions based on predefined criteria. This not only speeds up the review process but also minimizes errors in categorizing transactions.
  3. Setting Up Bank Rules:

    • Users can set up banking rules by navigating to the 'Banking' section in the left-hand menu of QBO and selecting 'Rules' from the dropdown.
    • The process involves creating rules that specify criteria such as transaction type, category, payee, and tags. Users can set conditions using parameters like 'Description', 'Bank text', or 'Amount'.
  4. Auto-Add Feature:

    • The 'Auto-add' feature allows users to automatically confirm transactions to which a specific rule applies. This streamlines the workflow by transferring auto-added transactions directly to the categorized screen.
  5. Reviewing Transactions:

    • Regularly reviewing transactions is emphasized for accurate financial records. QBO provides a quick review process, even for those who may procrastinate until the end of the month.
  6. Reviewing Techniques:

    • Users can review transactions by hovering over 'Banking' and choosing the 'Banking' dropdown. The 'For review', 'Categorized', and 'Excluded' options help organize transactions for efficient review.
  7. Categorizing Transactions:

    • Transactions listed under 'For review' can be checked for accuracy and categorized appropriately. QBO offers options like 'Categorize', 'Find match', 'Record as transfer', or 'Record as credit card payment' for each transaction.
  8. Creating Bank Rules from Review Screen:

    • Users can create bank rules directly from the review screen by choosing a transaction and clicking on the 'Create a rule' link. This provides a seamless way to set up rules based on observed patterns.

By leveraging these concepts, business owners can ensure accurate and streamlined financial management within QuickBooks Online, ultimately saving time and reducing the likelihood of errors in categorizing transactions.

Setting Up Banking Rules and Transaction Reviewing in QBO (2024)

FAQs

How do I set up Banking rules in QuickBooks Online? ›

Step 1: Create a bank rule
  1. Go to Settings. ...
  2. Select New rule.
  3. Enter a name in the What do you want to call this rule? ...
  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 conditions.

How many conditions can be set for a bank rule in QuickBooks Online? ›

You can set a single rule with up to 5 conditions. Set and include the following, then select + Add a condition. 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.

How do I review transactions in QuickBooks Online? ›

To review and accept bank transactions in the QuickBooks Online app follow these steps:
  1. From the Menu ☰, select Banking. ...
  2. Select New Transactions.
  3. Select Recognized to review transactions QuickBooks Online has already recognized, categorized, and matched for you.

What are 3 reasons why QuickBooks Online might not suggest a match for a bank transaction? ›

These are due to the following:
  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. ...
  • The transaction was recorded in a different bank account.
Mar 9, 2022

How do you set up rules in QuickBooks? ›

Select Settings ⚙ and then Create rules. Select Create rule. In the Description field, enter the customer or supplier you want to create the rule for. Tick the Match exactly box if you want QuickBooks to only use the rule when transactions match exactly.

Which 3 criteria can be specified in a bank rule condition in QBO? ›

The three criteria that can be specified in a bank rule condition are the transaction date, the transaction amount, and the description of the transaction.

Can bank rules automatically split transactions? ›

No, you can't do that. Bank rules post transactions to only one account. But after it is created, before the update is done, you can edit the transaction to add lines and split it yourself.

How QuickBooks Online applies bank rules? ›

QuickBooks automatically applies your rules to transactions in the For review tab. These are the ones you need to review every day. Tips: You can quickly add a rule for transactions in the For review tab.

Can bank rules be prioritized in QBO? ›

QuickBooks will automatically apply rules to transactions that appear in the For Review tab. To change the priority of your bank rules, select the reorder icon and drag the rule to the desired position. Remember that the rule with the highest priority will always be applied first.

What does it mean to review transactions in QuickBooks? ›

QuickBooks sends downloaded transactions to the For review tab, and suggests categories for each transaction. Review them one by one: If the transaction says Confirm: Select Confirm if QuickBooks suggested the correct category for that transaction.

What happens when qbo doesn t find a rule that applies to a transaction? ›

Answer & Explanation

If QuickBooks Online cannot find a rule that applies to a transaction, it will leave the category (account) field blank.

How do I memorize transactions in QuickBooks Online? ›

Let me share the steps the steps on how to use the feature in QBO:
  1. Go to the Gear or Settings icon. ...
  2. Click New and select the type of transaction to create.
  3. Select OK and enter a Template name.
  4. Choose a Type: Scheduled, Unscheduled, or Reminder.
  5. Complete the remaining fields, then click Save template.
Mar 5, 2022

How do I troubleshoot online banking issues in QuickBooks Online? ›

To do this:
  1. Sign in to QuickBooks Online.
  2. Go to Bookkeeping, select Transactions, then select Bank transactions (Take me there).
  3. Select Update.
  4. If you still see the error, look for a banner on the Banking page. Select Check connections link and follow the steps to fix the issue.
May 22, 2023

Why are my bank transactions not matching in QuickBooks? ›

If the match amount is slightly off

If the difference between a sales receipt you already entered and a downloaded transaction is more than 5%, QuickBooks won't show a match. This usually happens when banks add processing fees that weren't on the sales receipt you created.

How do I match multiple bank transactions in QuickBooks Online? ›

Matching multiple transactions in QuickBooks Online is as simple as matching a single transaction. Once you're on the For Review tab, select all the transactions that you want to match up. Then click on Match and say Yes when prompted, “Are you sure you want to match these items?”

Can bank rules automatically add transactions to the register in QBO? ›

After you create an auto-add rule, any transactions on the For review tab that meet the conditions are automatically added.

What 3 transaction types can you assign a rule for money in transactions? ›

Expert-Verified Answer

You can assign one of three transaction types Transfer Transaction, Deposit Credit, and Card Credit in a rule for money-in transactions. Transactions can be automatically allocated to one revenue account or divided among multiple with the use of deposit rules.

How do I manage bank feeds in QuickBooks Online? ›

Go to Bookkeeping, select Transactions, then select Bank transactions (Take me there). Select Connect Account if this is your first time connecting, or Link account if you've created one in the past. Search for your bank. Select Continue, then sign in to your bank by entering your banking user ID and password.

Top Articles
Latest Posts
Article information

Author: Velia Krajcik

Last Updated:

Views: 6185

Rating: 4.3 / 5 (74 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Velia Krajcik

Birthday: 1996-07-27

Address: 520 Balistreri Mount, South Armand, OR 60528

Phone: +466880739437

Job: Future Retail Associate

Hobby: Polo, Scouting, Worldbuilding, Cosplaying, Photography, Rowing, Nordic skating

Introduction: My name is Velia Krajcik, I am a handsome, clean, lucky, gleaming, magnificent, proud, glorious person who loves writing and wants to share my knowledge and understanding with you.