cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Dickens
Level 2

Can I edit duplicated downloaded bank transactions via a CSV file?

I have just noticed that at least two transactions are the same. Also found that some of the dates are not in numerical order!
1 REPLY 1
Rasa-LilaM
QuickBooks Team

Can I edit duplicated downloaded bank transactions via a CSV file?

Welcome to the Intuit Community, Dickens.


Allow me to share some information on how to handle duplicate bank transactions.


To rectify the issue, you’ll have to exclude the data to remove the duplicate entries. I'll guide you through the process on how to accomplish this task.

 

  1. Choose Banking on the left panel, then click on the Banking link.
  2. In the Bank and Cards section, go to the For Review tab.
  3. Mark the boxes for the duplicate transactions.
  4. From the Batch actions drop-down, choose Exclude Selected.


After completing the process, the transactions will fall under the Excluded tab on the Banking page. Once done, you can now go back to your bank and download the data with dates in the correct order.


Check out the How to exclude expenses from downloaded bank transactions article for more details.

 

These steps should get you pointed in the right direction. Please update me on how things go after trying out the resolution. I want to make sure everything is taken care of and you're all set with this concern.

Need to get in touch?

Contact us