QuickBooks Online Bank Feed Rules Part 1

Cloud Accounting has changed the way businesses track their finances forever. While Xero helped to revolutionize the modern-day bank feed, Intuit raised the bar with their QuickBooks Online Bank Feed and Banking Rules. When utilized correctly, Bank Feed Rules can handle a large portion of the transaction review process by auto assigning what a transaction was for including who paid or was paid. But as the saying goes, with great power comes great responsibility, that’s why we created a guide to explain how to use QuickBooks Online Bank Feed Rules.

QuickBooks Online Bank Feed Rule Creation
Part 1

The Sum of the Parts That Make a Rule

Rule name – Give each rule a name.
For – Select whether the rule applies to Money in (deposits) or Money out (withdrawals).
In – From the drop down, you can select which bank accounts this rule applies to. The default is All bank accounts.
Conditions – You have the option to set the conditions that the transaction must meet for this rule to apply:
- From the drop down, select all or any
- From the drop down, you can select bank text, description or amount.
- From the drop down, you can select contains, is exactly, or doesn’t contain.
- In this field, you can enter the bank text, description or amount.
Transaction type – Select whether the transaction is an expense, transfer, check, or deposit / credit card credit
Payee – Select the payee (if applicable).
Category – Select the account the transaction should be categorized to.

Naming your QuickBooks Online Bank Feed Rules for Fast Searching

FOR what & IN which

This is one of the easiest areas to overlook and often one of the biggest reasons a rule fails.

For:Select if your rule will be for money in or money out transactions, if this is set incorrectly, your rule will not work correctly.

Selecting what accounts to effect:

In:Select the accounts you want to be affected by the rule. This will allow you to create rules that will only affect one account or all accounts.

There are some other unique details with rules that make sense but often are overlooked, for example, if you set the transaction type to be a Check, then it will remove all credit cards accounts and only select checking and savings accounts.

Download

Parkway Bank Rules Tip

Download a set of our Universal Bank Rules

Download

Establishing the QuickBooks Online Bank Feed Rule Conditions

This is the most common reason a rule will not work, especially if you try to add multiple conditions. If you have a rule that just does not seem to capture the way you would like it to, check this first.

All: The All setting is best used when trying to dingle out specific transaction types with unique values. A great example of this would be creating rules for ATM withdrawals. In the example below you can see how using the all function enables you to set the defined range for the dollar amount. Later in the tutorial you will see how we use the Split function to auto assign the bank fee value too.

To Payee or not to Payee

Payee:The payee section of QuickBooks Online is a very interesting field for both Vendor Names and Customer Names. Depending on how well you setup your Vendors in QuickBooks Online, it is possible to create bank rules without a Payee name and still have the Payee details populated.

Add a single rule for a single vendor ( 1:1 relationship)
Add a generic name for multiple rules (1:5 relationship)
Leave the vendor name blank but add a rule trigger such as “_Fuel to the memo fields of the transactions. If your bank import file has Payee Names assigned per transaction, then they Payee will be auto generated. This is a great way to use Ledgersync’s check images with QuickBooks Online. (1:many relationship)

Behind the scenes of QuickBooks Online, there are many different variations of names that play important roles on how transactions match but the most important one is the Display Name. The Display Name is . It is the one type of name that can never be duplicated (even across vendors and customer) and is also what everything matches against.

QuickBooks Online Bank Feed Options to Set a Payee

Class and Location Optional But Great!

The Power to Split

Continue to Part 2

QuickBooks Online Bank Feed Rules
Part 2

Want to learn more about QuickBooks Online Bank Feed Rules? Check out our 2nd installment in the Bank Feed Series

Continue to Part 2

Checkout our Process Street Checklist for Bank Feed Rules

Print a copy of the checklist

[fusion_widget_area name=”avada-custom-sidebar-bankrules” title_size=”” title_color=”” background_color=”” padding_top=”0px” padding_right=”30px” padding_bottom=”60px” padding_left=”30px” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” /]

Are you a QuickBooks Desktop User?

Bring the Power of Cloud Accounting to QuickBooks Desktop

VENDORSYNC

QUICKBOOKS DESKTOP AUTOMATION

QuickBooks Desktop Tutorials & Guides

Importing .QBO Files Tutorial

QuickBooks Desktop Renaming Rules

QuickBooks Desktop Renaming Rules Tutorial