QuickBooks HelpQuickBooksHelpIntuit

Categorise online bank transactions in QuickBooks Online

by Intuit•5• Updated 4 days ago

QuickBooks Online helps you review categories for automatically downloaded transactions and suggests categories based on how you’ve categorised similar transactions in the past.

Note: QuickBooks Online won’t download pending transactions.

Step 1: Download the latest bank and credit card transactions

QuickBooks tries to update your bank transactions automatically every 24 hours, but you can manually update them.

  1. Follow this link to complete the steps in product Open this link in a new window
  2. Select Update. This updates the transactions on all of your accounts.
    Tip: If you see a message about additional authentication, follow the prompts to continue the update.
  3. QuickBooks recognises common suppliers from your bank transactions, and will automatically add new suppliers into your account.
  4. Turn this option off if you don’t want new suppliers added. In Bank transactions, go to Settings ⚙ and turn off Add new suppliers.

If you have trouble downloading your transactions, you can try other options.

Step 2: Review and categorise downloaded transactions

Follow the steps below based on the device you're using.

Follow this link to complete the steps in product Open this link in a new window

  1. Select the account you want to review.
  2. Select the For review tab.
  3. QuickBooks sends downloaded transactions to the For review tab, and suggests categories for each transaction. Review each transaction and do one of the following:
    • If the transaction says Add:
      • Select Add if the suggested category is correct.
      • Or change the category using the dropdown or adding a new one.
    • Select Add to categorise the transactions
    • The transaction already exists in QuickBooks, you may have the option to match or view multiple matches.

Note: You can create a bank rule that automatically categorises transactions for you.  You can also turn suggestions off if you want to manually categorise your transactions.

Step 3: Choose the right category

Categorise income

Money paid to you. For example, this could be from:

  • Sales
  • Customer payments
  • Refunds
  • Fixed assets sold
  • Bank loans received 
  • Money invested

Categorise expenses

Money paid to others. For example, money spent on:

  • Office Supplies 
  • Meals
  • Taxes
  • Fixed assets

Step 4: Other categorisation actions

There are a few other options to take to help you properly categorise your transactions.

In QuickBooks Online Plus and Advanced, you can track your expenses by item. You can use it if you keep track of your stock or need item tracking for your job costing reports. Here’s how to turn it on:

  1. Go to Settings Settings gear icon. and select Account and settings.
  2. Select Expenses.
  3. Select Edit next to Bills and expenses, then turn on Show Items table on expense and purchase forms.
  4. Select Save then select Done.

Note: To use the Estimates vs. Actuals report in QuickBooks Online Advanced, you need to track your expenses by item. If you're not sure whether you need to use item tracking, talk to your accountant.

You can record an expense in your bank feed using an account from your chart of accounts, using a product or service, or both. 

Note: If you want to record it with both, you need to split the transaction.

Follow this link to complete the steps in product Open this link in a new window

  1. In the For review tab, search and select the required expense transaction.
  2. In the Product/service ▼ dropdown, select the product or item from the items list.
    Note: You need to split the transaction if you want to use both the Product/service and Account dropdown on the same transaction.
  3. Select Add.

You can split transactions between multiple categories for better tracking.

Follow this link to complete the steps in product Open this link in a new window

  1. In the For review tab, select the transaction you want to split.
    Note: If the option is Match, change it to Categorise.
  2. Select Split which opens the Split transaction window.
  3. From the Category ▼ dropdown, select the categories you want to split the transaction into.
  4. Enter an Amount for each split so the Difference shows EUR €0.
  5. Fill out all the necessary information.
    Note: The field name may vary depending on the transaction.
  6. Select Split and add.
  • The cheque image disconnects when cheques are matched to a bill and converted into a bill payment.
  • If your connected bank transactions don’t have cheque images automatically attached, your bank is not supported. However, it may be supported at a later date as we work to partner with more financial institutions.

Result

After completing these steps, your bank transactions will be categorised correctly in QuickBooks Online. This helps maintain accurate financial records and ensures your reports reflect real activity.

Sign in now for personalized help

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