Duplicate transactions can throw out your balances and make your records harder to manage. This guide explains why duplicates happen and how to avoid them in both manual and live-feed accounts.
Why Duplicate Transactions Happen
Duplicates usually come down to one of two things:
Importing the same data more than once
Incorrect setup when adding or moving bank accounts
The cause and fix will depend on whether you’re using a manual account or a live bank feed.
Manual Bank Accounts
Common cause
Duplicates typically happen when the same file is imported more than once.
How to prevent it
Only import each transaction file once
Double-check before uploading a file
Review your transactions regularly to catch any duplicates early
Live-Feed Bank Accounts
With the introduction of additional profiles, you no longer need to disconnect and reconnect accounts to separate your data. Instead, you can simply add a new profile.
Common cause
Duplicates can occur when a bank account is added to a new profile without setting the correct import-from date. This can cause older transactions to be pulled in again.
How to prevent it when adding an account to a new profile
Add your additional profile
Connect your bank account to that profile
Set the import-from date to the day after the last transaction already recorded in TaxTank
This ensures only new transactions are imported.
If the import-from date isn’t set correctly, the system may re-import historical data, which creates duplicates.
General Best Practices
Reconcile your accounts regularly to keep everything accurate
Avoid manual imports if a live feed is already connected
Always check your import settings before confirming
Fixing Duplicate Transactions
If duplicates already exist, you’ll need to review and remove the extra transactions to bring your balances back in line.