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

Posted on 26th November 2020 by Streets What's trending?


Image to represent Set up bank rules to categorise online banking transactions in QuickBooks Online

When you download transactions from your bank, you need to categorise them so that they go into the right accounts. Bank rules speed up this review process.

You can create rules that automatically categorise transactions for you. The more QuickBooks uses your bank rules, the better it gets at categorising. After a while, it can even scan transactions and add details like payees.

Step 1: Create a bank rule

  1. Go to the Banking menu or Transactions menu, then select the Rules tab.
  2. Select New rule.
  3. Enter a name in the Rule field.
  4. From the For ▼ dropdown, select Money in or Money out.
  5. From the In ▼ dropdown, select the bank or credit card account.
  6. Set the rule conditions. Decide if the transaction must meet All or Any of the conditions. You can add up to 5 conditions.
  7. In the Conditions fields, specify whether the rule applies to Bank text, Description, 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, Payee, and the Category to apply.
  9. Select Save.

Each time QuickBooks uses a rule, it puts those transactions in the Recognised section of the For Review tab. It also adds a "Rule" label to the transaction.

If everything looks good, select Add to move the transactions directly into an account in QuickBooks. You can also select and review it before you move it.


No Advice

The content produced and presented by Streets is for general guidance and informational purposes only. It should not be construed as legal, tax, investment, financial or other advice. Furthermore, it should not be considered a recommendation or an offer to sell, or a solicitation of any offer to buy any securities or other form of financial asset. The information provided by Streets is of a general nature and is not specific for any individual or entity. Appropriate and tailored advice or independent research should be obtained before making any such decisions. Streets does not accept any liability for any loss or damage which is incurred from you acting or not acting as a result of obtaining Streets' visual or audible content.

Information

The content used by Streets has been obtained from or is based on sources that we believe to be accurate and reliable. Although reasonable care has been taken in gathering the necessary information, we cannot guarantee the accuracy or completeness of any information we publish and we accept no liability for any errors or omissions in material. You should always seek specific advice prior to making any investment, legal or tax decisions.


Expert insight and news straight
to your inbox

Related Articles


Merger gives us a greater footprint in the West Midlands, with Wales in our sights!

We are delighted to announce the establishment of Streets Dyke Ruscoe Limited. The announcement follows the merger of the well-established and widely respected Shropshire and Worcestershire practice of Dyke Ruscoe Chartered Certified Accountants with ourselves. This latest merger has enabled us to establish a greater footprint in the West Midlands, ...


We are excited to introduce our new Virtual Finance Office service - ViFi

At ViFi, we specialise in providing virtual finance solutions that transform the way businesses manage their finances.ViFi is your virtual finance department, offering comprehensive remote financial services. From day-to-day bookkeeping to proactive financial planning, our team in the UK ensures that you have everything a traditional accountant offers, ...


You might think that your payroll is high now, but it is going to get even higher next April

The first Labour Budget in 14 years was supposedly billed as being one to drive growth, though it is hard to see how this will come about as from next April, businesses face increased costs of employing people with the rise in the national minimum wage to £12.21 ...

You might also be interested in...