Correct duplicate transactions
This article describes how to correct transactions that have been duplicated when explaining transfers between bank accounts.
When explaining bank transactions that relate to transfers to and from another bank account in FreeAgent, you should wait until both bank transactions have been imported into your FreeAgent account.
If you explain one of the transactions before the other has been imported into FreeAgent, you may end up with transactions being duplicated and cause a mismatch between your bank balance in FreeAgent and your bank account.
For example, if you’ve explained the ‘Money out’ bank transaction in the outgoing bank account but the corresponding ‘Money in’ bank transaction in the receiving bank account has not yet been imported into FreeAgent, a manual transaction will be created in the receiving bank account. When the corresponding ‘Money in’ bank transaction is then imported into FreeAgent, it will create a duplicate transaction for the transfer in the receiving bank account.
In this scenario, you’ll need to follow the steps below to match the duplicate imported transaction with the manual transaction. You'll be able to match transactions together as long as the duplicate transactions are recorded in FreeAgent within 14 days of each other. If there is a gap of more than 14 days, you will need to delete the uploaded transaction.
Navigate to the ‘Banking’ tab at the top of the screen and select ‘Bank Accounts’ from the drop-down menu.
Choose the bank account that contains the duplicate transaction(s).
Click on the red imported transaction, select ‘Adjustments’ and choose ‘More options’ from the drop-down menu.
You should see the manually added transaction in the ‘Use an existing Manual Entry’ section. Select ‘Use selected entry’.
This will merge the purple manual transaction and the red duplicate transaction together into one green transaction, which will be linked to the other green transfer transaction in the original bank account.
If you have Guess enabled in one or both of the bank accounts, you may wish to edit the Guess rules so that only one of the bank accounts guesses transfers, which might also help avoid duplicates going forward.