How to Fix Duplicate Transactions in Money in Excel
Question details
The user needs to remove duplicate debit transactions that have appeared in their Money in Excel workbook, despite the financial institution's real account history showing no such duplicates.

- Product
- Money in Excel
- Device & OS
- not provided
- Scenario
- Updating the Money in Excel template and syncing financial data, which results in duplicate entries being downloaded into the spreadsheet.
- Observed behavior
- Duplicate debit transactions are displayed in the workbook after a recent update, and each duplicate entry is assigned a unique transaction ID by the syncing service.
Log into your financial institution's online banking website directly to verify that the duplicate transactions do not actually exist in your real account history.
Refresh Data and Reconnect Your Bank Account
Manually refreshing the data pane or resetting the connection can clear temporary synchronization glitches between the template and your bank.
Data synchronization issues can sometimes cause the add-in to pull the same transaction multiple times. Re-establishing the connection forces the system to re-authenticate and fetch a fresh snapshot of your account history.
Open the Money in Excel pane on the right side of your screen and click the 'Update' button to sync the latest data to see if the duplicates clear.
If duplicates persist, click on the 'Institutions' tab in the Money pane, select your financial institution (e.g., Wells Fargo), and choose the option to disconnect.
Click 'Add an account' in the institutions list, follow the prompts to log back into your bank's secure portal, and authorize the connection again.

Download a Fresh Money in Excel Template
If the current workbook is corrupted or using an outdated version, starting with a completely fresh template can resolve structural data issues.
Manage Your Finances Smoothly with WPS Office
While automated third-party sync tools can sometimes experience data duplication defects, you can rely on WPS Spreadsheet for stable, manual financial tracking. WPS Office is a highly compatible, lightweight suite that handles complex Excel files and custom budget templates perfectly.
- 1. Download and Install: Get WPS Office from the official website and install it on your device in minutes.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open any existing .xlsx budget or finance tracker files.
- 3. Track Finances Manually: Use built-in formulas, pivot tables, and chart tools to track your expenses without relying on buggy automated sync services.

Frequently Asked Questions
Why is Money in Excel showing duplicate transactions?
Duplicates usually occur due to synchronization glitches with the financial institution integration (like Plaid), outdated template version conflicts, or software defects following a recent backend update.
How can I tell if a transaction is a true duplicate in Excel?
You can add a concatenation formula column to combine the date, amount, and merchant name, then apply Conditional Formatting for 'Duplicate Values'. However, if the sync provider assigns unique underlying transaction IDs to identical charges, Excel will technically treat them as separate records.
Does deleting the duplicate row manually fix the issue?
Deleting the row manually is only a temporary fix. Because the underlying data connection still believes the transaction is valid, the next time you click 'Update' in the Money pane, the duplicate might be imported back into your spreadsheet.




