Categorize and match online bank transactions in QuickBooks Online

Learn how to review downloaded bank and credit card transactions and put them in the correct accounts.

After you connect your bank and credit card accounts QuickBooks automatically downloads the latest transactions. It looks for and tries to match them with transactions you’ve already entered into QuickBooks. If it can’t find a match, it creates a new transaction record for you.

All you have to do is approve the match or newly created transaction. Here’s how to get started

Step 1: Download the latest bank and credit card transactions #

For most banks, QuickBooks downloads the latest available transactions every night around 10 PM PT. Some may take a little longer. You can also manually update your accounts any time to get the latest available transactions:

  1. Go to the Banking menu or Transactions menu
  2. Go to the Banking tab.
  3. Select Update

This updates all of your bank and credit card accounts.

Tip: If you see a message about additional authentication, follow the onscreen steps to continue the update. Not all banks require this, but some do for added peace of mind.

Here’s what to do if you have trouble downloading your transactions.

Step 2: Review and categorize downloaded transactions #

  1. Go to the Banking menu or Transactions menu.
  2. Select the tile for the account you want to review.
  3. Select the For Review tab to start your review.

QuickBooks sends downloaded transactions to the For Review tab. Review them one-by-one.

For each, you have the option to match, add, or view multiple matches. Follow the steps in the section for each option:

Match with an existing transaction #

Add a new transaction #

View and review multiple matches #

Step 3: Review matched or added transactions #

After you match or add downloaded transactions, they’re recorded into QuickBooks. You can review your work and make sure everything is correct in the Categorized or Reviewed tab

It’s a good idea to quickly check this after your review:

  1. Go to the Banking menu or Transactions menu
  2. Select the tile for the account you want to review.
  3. Go to the Categorized or Reviewed tab.
  4. Select the link in the Added or Matched column to review the transaction.

If you need to change or move a transaction to a different account, follow these steps to undo or unmatch it. Tip: Make all of your changes before your monthly reconciliations.

Split transactions between multiple accounts #

Exclude personal or duplicate transactions #

Exclude personal or duplicate transactions to keep your accounts accurate:

  1. Go to the For Review.
  2. Check the checkbox for each transaction you want to exclude.
  3. Select Exclude.

Excluded transactions move to the Excluded tab. They won’t be added to QuickBooks or downloaded again.

Powered by BetterDocs

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to content