0
DAYS
0
HOURS
0
MINS
0
SECS
Over 3.2 million customers use QuickBooks.
Sign up for a free trial!
2015-08-11 00:00:00Product UpdatesEnglishQuickBooks Online has an added a brand new feature called bank rules. Use them to save by setting up automatic categorisation of regular...https://quickbooks.intuit.com/au/resources/au_qrc/uploads/2017/01/Screen-Shot-2015-08-11-at-12.34.53-pm.pngbank rulesHow To Set Up Bank Rules In QuickBooks Online | QuickBooks Australia

How to set up bank rules in QuickBooks Online

3 min read

QuickBooks Online has an added feature called Rules (or Bank Rules). It saves you time by setting up automatic categorisation of regular recurring transactions even if they are slightly different each month. It also allows you to customise many variables of the bank feed data to highly automate the bank transactions you accept into QuickBooks Online.

How to set up bank rules

Bank rules

In QuickBooks Online go to: Left hand side navigation bar > Transactions > Banking > top right click on down arrow on File upload > Manage Rules

Click > New Rule

Rules

This is the Rules Page…

Rule Page

You will find the following fields:

Rule Name: This is the name that will show up when a transaction is automatically filled out for you based on the rule. It’s good to be descriptive with the rule name so that you know exactly what rule was applied. Something easy for you to remember.

For: You can choose from Money Out (expenses) or Money In (income).

In: This is where you choose the bank or credit card account to apply the rule to. Alternatively, you can have the rule apply to any bank account, or all bank accounts.

When a transaction meets – “all” or “any” of these conditions:

Conditions: When you choose a condition, ALL or ANY conditions must be met.

Description: This is the description associated with the transaction. You can choose from:

  • Contains – Is Exactly – Doesn’t Contain

Bank Text: In my experience using the bank feed text works best. Simply cut and paste the bank text from the bank feeds area and use “Contains” as the condition for the transaction that the Rule is being set up

  • Contains – Doesn’t Contain

Amount: This is the dollar amount of the transaction you can choose from:

  • Equals – Is greater than – Is less than – Doesn’t equal

Add Line: You have the option of fine tuning this Rule and adding a Line if you so wish. Set one or more of the following…

Set one or more of the following:

Transaction Type:

If you choose Money out you can choose from: Expense – Cheque – Transfer
If you choose Money in you can choose from: Deposit / Credit card credit – Transfer

Payee: This is the Customer or Supplier (again depending on money in or out).

Category: This is the account you’ll apply the transaction to expense or income

Tax Code: Which GST code is applicable to this transaction each time?

Class: This is the Class tracking category if applicable.

Location: This is the Location tracking category if applicable.

Memo: You can use this as a detailed memo of the transaction.

Split: Something that you won’t see right away is the option to add multiple line items by amount or percentage. This is useful if you need to allocate certain transactions across tracking departments or several accounts (i.e. Telephone expense over various tracking departments or splitting phone and internet use to different accounts). If you click on the Split Button you’ll see the option to split the transaction based on allocating percentages to various categories or fixed amounts you can edit this selection at the down arrow box at Percentage.

A simple example of applying a rule would be bank fees:

Westpac bank fees QBO

Or something a little more difficult: paying back a Bank Loan of Principal and Interest. Interest is variable each month, principal remains the same $515.00, payments have never been over $600.00.

ANZ fees

As you can see bank rules can take your bank feed allocations to another automation level entirely. Happy bank rule creating!

Rate This Article
Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

Setting up Bank Rules Effectively

You have been using bank rules for a while, but are you…

Read more

Banking Rules Update: New Auto-add Bank Rules

A new Auto-add Bank Rules feature has just made our lives easier!…

Read more

Multi-currency tips and tricks

QuickBooks Online can help international business owners tackle common challenges, from handling…

Read more