cancel
Showing results for 
Search instead for 
Did you mean: 
dawgteem
Level 1

After I updated Quickbooks Online with my bank account there are duplicate transactions showing up all the way back from January. How do I fix that?

 
3 Comments 3
AlcaeusF
Moderator

After I updated Quickbooks Online with my bank account there are duplicate transactions showing up all the way back from January. How do I fix that?

Hi @dawgteem,

 

Welcome to the Community. I can help you fix the bank feeds issue in QuickBooks Online.

 

Duplicate transactions usually happen when you disconnect and reconnect an account. If you updated your bank details using this method, QuickBooks will redownload your previous data.


The income and expenses that will upload to the system will depend on the information that your bank shares. There are times a financial institution linked to QuickBooks downloads duplicate transactions.

 

There are simple steps you can follow to resolve the problem. I recommend using the Exclude feature to remove duplicates from your banking.

 

Here's how:

 

  1. Go to the Banking menu or Transactions menu, then select the Banking tab.
  2. Select the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Select Exclude

 

If there are changes to your account details on your bank's website, like your username or password, you can edit the sign-in info direct in bank feeds. You should be able to select your bank from the tile and select the Edit option.

 

Please follow these steps:

 

  1. Go to the Banking menu or Transactions menu.
  2. Select the Banking tab.
  3. Select the Edit ✎ icon in the tile for the bank account you want to update.
  4. Select Edit sign-in info.
  5. Update your account info.
  6. Select Save and connect.

 

For more information, as well as how to exclude a transaction in the QuickBooks Mobile app, I recommend the following article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Leave a comment below if you have other concerns related to banking. The Community and I will be around to help you.

dawgteem
Level 1

After I updated Quickbooks Online with my bank account there are duplicate transactions showing up all the way back from January. How do I fix that?

Am I able to delete the duplicate transactions without causing more issues?

LieraMarie_A
QuickBooks Team

After I updated Quickbooks Online with my bank account there are duplicate transactions showing up all the way back from January. How do I fix that?

No the worry, @dawgteem. Deleting duplicate transactions won't cause any more issues.

 

QuickBooks sends downloaded transactions to the For Review tab. From there, we have the option to match, add, or exclude them from the list. After excluding them in the For review tab, you can find them in the Excluded tab. You may bring these transactions back by clicking Undo. You can also permanently remove them from QuickBooks by selecting Delete.
Capture.PNG

 

If the duplicate transactions are already categorized or matched:

  1. Select Banking or Transactions on the left menu.
  2. Navigate to the Categorized tab and tick all the duplicate transactions.
  3. A black box will appear at the top of all transactions, showing how many are selected. Select Undo. This will move them over to the For review tab.
    Capture.PNG
  4. Navigate to the For review tab and tick the duplicate transactions.
  5. In the black box at the top of all transactions, select Exclude.
    Capture.PNG
  6. To permanently remove these transactions from QuickBooks, select the Excluded tab. Then, select the tick box to the left of the Date column to tick all transactions. Select Delete.
    Capture.PNG

 

Here's more information about working with bank feeds in QuickBooks Online: Categorize your bank transactions.

 

Should you have additional questions about managing bank feeds, let me know in the comments. I'm always here to help.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us