Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
December 27, 2022
Solved

How do I remove a manually entered transaction that's now a duplicate of one that came in through my bank feed?

  • December 27, 2022
  • 3 replies
  • 56 views

How do I get rid of manual entered transactions that a r a duplicate of a bank feed?

Best answer by katelynner

This comes down to whether the bank feed's version of the transaction is still sitting in For review or has already been added as its own separate entry in your books.

 

If the bank feed transaction is still in For review

Go to All apps, then Accounting, then Bank transactions, select the checkbox next to it, and select Exclude. Since your manual entry already exists and is the one you want to keep, there's no need to bring in a second copy from the bank.

 

If the bank feed transaction was already added as a separate entry

You now have two real transactions in your books, and one needs to go. Two ways to handle it:

  1. Find the transaction that was added from the bank feed, undo it so it goes back to the For review tab, then match it to your existing manual entry instead of adding it again. This is the cleanest fix, since matching links the download to the entry you already made rather than creating a second one.
  2. Alternatively, delete whichever of the two entries you don't want to keep. If it's already been reconciled, check with whoever manages your reconciliation before deleting it, since removing a reconciled transaction affects your next reconciliation's beginning balance.

 

One note on terminology: QuickBooks doesn't have a feature that literally merges two already-posted transactions into a single one. Matching (option 1 above) is the practical equivalent, since it ties the bank download to your existing entry instead of creating a duplicate in the first place. This is the best way to prevent this from happening again if it's a recurring pattern, such as regularly recording a transaction manually before the bank feed catches up to it.

 

For the full breakdown of finding and removing duplicates depending on where they sit: Fix duplicate transactions in QuickBooks Online bank feeds

 

3 replies

Level 9
December 27, 2022

I've got the details on how to resolve duplicate transactions on your bank feeds, RoyD1.

 

One way duplicates can arise is by not properly matching downloaded transactions in QuickBooks Online (QBO) to the ones that are already entered into the software. 

 

I've got two options to get this resolved. You can delete or Undo them, then match them to the transactions that are manually entered into the system.

 

To remove the duplicate transactions, you have to open each of them and delete them manually one at a time.

 

Here's how you would undo them:

 

  1. Go to Banking on the left navigation panel.
  2. Ensure to select the account.
  3. Place a checkmark in the box(es) for the transactions you'd like to undo.
  4. Click the Undo button that appears at the top of the list.

 

This article will give you additional details on using the adding and matching feature for the bank feed in QuickBooks Online: Categorize and match online bank transactions in QBO.

 

Get back to me if you have any additional questions about bank feeds. I'll be happy to assist you again.

December 27, 2022

This is a common problem and happens when you transfer money between bank accounts, then import transactions from both accounts. This could be from a bank feed or import from a bank statement. Simple way solution is  you can merge the two transactions together so they become a single transaction, or you can simply delete one of the duplicates instead.

 

 

 

Dunkinbrands.csod.com

katelynner
Community Manager
August 18, 2026

This comes down to whether the bank feed's version of the transaction is still sitting in For review or has already been added as its own separate entry in your books.

 

If the bank feed transaction is still in For review

Go to All apps, then Accounting, then Bank transactions, select the checkbox next to it, and select Exclude. Since your manual entry already exists and is the one you want to keep, there's no need to bring in a second copy from the bank.

 

If the bank feed transaction was already added as a separate entry

You now have two real transactions in your books, and one needs to go. Two ways to handle it:

  1. Find the transaction that was added from the bank feed, undo it so it goes back to the For review tab, then match it to your existing manual entry instead of adding it again. This is the cleanest fix, since matching links the download to the entry you already made rather than creating a second one.
  2. Alternatively, delete whichever of the two entries you don't want to keep. If it's already been reconciled, check with whoever manages your reconciliation before deleting it, since removing a reconciled transaction affects your next reconciliation's beginning balance.

 

One note on terminology: QuickBooks doesn't have a feature that literally merges two already-posted transactions into a single one. Matching (option 1 above) is the practical equivalent, since it ties the bank download to your existing entry instead of creating a duplicate in the first place. This is the best way to prevent this from happening again if it's a recurring pattern, such as regularly recording a transaction manually before the bank feed catches up to it.

 

For the full breakdown of finding and removing duplicates depending on where they sit: Fix duplicate transactions in QuickBooks Online bank feeds