@Mark.S yodlee does clean up the data on their side, we just don’t respond to those changes at this time. It’s a big lift for us to be able to respond to those changes appropriately because it’s a type of change management. They send a “delete” notification for one of the duplicates. Our system doesn’t do anything with this information. We’d need to both 1) respond to the delete notification by deleting the corresponding transaction in our database and 2) remove the data from your spreadsheet. The 2nd point there is the bigger lift that has a lot of implications because we don’t touch or modify the data once it’s in the spreadsheet, any modifications to the data in the spreadsheet once we fill it there are a result of actions you are taking (e.g. running AutoCat).
@atkinson21 I would recommend reviewing the Date Added column out right in the Transaction sheet to see if it helps. If it was a big batch that came in at one point that could help you clean up a lot of them. Otherwise I recommend checking out this community-supported tool: Docs: Manage Duplicates workflow