QuickBooks HelpQuickBooksHelpIntuit

Fix bank transactions downloaded in QuickBooks Online

by Intuit•34• Updated 6 months ago

Find out what to do if QuickBooks can't find the right match or matches the wrong transactions in QuickBooks Online.

When you connect your bank and credit card accounts to QuickBooks, it downloads your recent bank and credit card transactions. Then it automatically matches them with any records you’ve created in QuickBooks. If it can't find a match, it creates a new record for you. All you have to do is review and approve the work.

If QuickBooks can’t find a match, or shows the wrong match, while you’re in the For Review tab, it’s no problem. Here’s how to find the right match, or create a new record if there isn’t a match.

Note: If you match the wrong transactions or categorize them into the wrong account, you can still un-match them to fix it.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

If you already entered a transaction that should match, but QuickBooks can’t find it, don’t create a new transaction. Find the one you already created so you don’t get a duplicate record. Here’s how:

Review the match

  1. Go to the Banking menu, and then select the For Review tab.
  2. Select the bank transaction to see more info about it.
  3. Review the info under “Record found.” This section shows records you already entered into QuickBooks that it thinks are a match for the downloaded transaction.QuickBooks Online Banking Tab Find Other Records
  4. If it’s not the right match, select Find other records. This opens the Match transactions window.
  5. Select the box to uncheck the recommended match.

Find the right match

You can now search for the right transaction in the Match transactions window.

  1. In the From and To fields, enter dates that are a few days before and after the date of the transaction you’re looking for.
  2. In the Search box, enter the amount, the customer you did business with, or reference number for the transaction in QuickBooks.

Any transactions that meet your search will appear on the list.

QuickBooks Online Match Transactions

When you find the match

  1. Select the box for the matching transaction or transactions.
  2. Make sure the total matches the transaction downloaded from your bank.
  3. Select Save.

If the match amount is slightly off

If the difference between a sales receipt you already entered and a downloaded transaction is more than 5%, QuickBooks won’t show a match. This usually happens when banks add processing fees that weren’t on the sales receipt you created.

If you know you've found the matching transaction:

  1. Go to the Sales menu.
  2. Find the original sales receipt, and add a “processing fee” line item for the difference. This itemizes the record and shows the included fee.

If QuickBooks makes the wrong match

If QuickBooks tries to make a match, but you know you haven’t entered a matching transaction, don’t select Match. Instead, start a new record by choosing Add.

  1. Select the transaction to expand the view.
  2. Change the selection from Match to Add. You can also do this if QuickBooks incorrectly selects “Record transfer.”
  3. Select the Payee and Category.
  4. Select Add.
  5. Go to the Reviewed tab.
  6. Find and open the transaction.
  7. Add any other details you need.
QuickBooks LedgerQuickBooks Online AccountantQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

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