I hear you on this. In order to keep your transactions updated I recommend manually uploading the transactions. After manually uploading you can match your transactions using the steps provided in this article. You also have the option of setting up bank to automatically categorize the transactions from the manual upload. Here's an article with more details on that. In case you come across duplicate transactions, you can delete them by following the steps below:

1. Navigate to the Banking menu.
2. Click on the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Hit Exclude.

Feel free to ask other questions. I'm here to steer you in the right direction.