QuickBooks HelpQuickBooksHelpIntuit

Fix bank transactions downloaded

by Intuit76 Updated 2 weeks ago

Find and match the correct bank transactions you’ve downloaded in QuickBooks Online

icon of an agentIf you need help using QuickBooks, you can partner with a QuickBooks Live Bookkeeper to feel more confident. Find out more about QuickBooks Live Bookkeeping.

If you need help using QuickBooks, you can partner with a QuickBooks Live Bookkeeper to feel more confident. Find out more about QuickBooks Live Bookkeeping.

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. It creates a new record for you if it can't find a match. All you have to do is review and approve the work.

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

Find and match the correct transaction

If you’ve 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:

  1. Go to Transactions, and select Bank transactions.
  2. Find the bank transaction you want to match, then select the Suggested ‌AI Icon from the Categorize or Match column. The AI will provide match suggestions for ‌transactions similar to ‌the one you picked.
  3. Find the match for your selected transaction.
    Note: Selecting a transaction from the match suggestions will direct you to the Invoice page.
  4. Select the correct match and add the category from the Category ▼ dropdown menu.
  5. Select Post.

Fix mismatched amounts

If QuickBooks shows suggestions that match, then the difference is likely in the AI suggestions. Adjust transactions when amounts don't match.

If you know you've found the matching transaction:

  1. Go to Sales, and select All sales.
  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 finds a match but you don’t see it in your transactions, don’t select Match. Select Post to start a new transaction.

  1. Go to 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 Pending 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