[GH-ISSUE #7173] [Bug]: Relinking and syncing SimpleFIN account duplicates some transactions #52121

Closed
opened 2026-04-30 20:17:51 -05:00 by GiteaMirror · 1 comment
Owner

Originally created by @pmdevita on GitHub (Mar 11, 2026).
Original GitHub issue: https://github.com/actualbudget/actual/issues/7173

What happened?

For some reason, SimpleFIN required me to relink my bank account and once I did, this showed up as a new separate account, separate from my previous one. In order to keep syncing to Actual, I unlinked the Actual account from the old account under SimpleFIN and linked it to the new one. I expected this to either only pick up the new transactions or require me to manually get it up to speed.

However, after doing this and doing a bank sync, a few transactions appeared to duplicate. Given this is technically a new account under SimpleFIN, I suspect the lack of transaction history or differences with the account could potentially explain it. The duped transactions are also all transfers (though not transfers involving other Actual accounts), so there may be something funny going on there. I'll give a few examples to try and show what happened.

This first is this transaction (I'm using American style dates). The description and amount of this transaction matches one I did on 01/05/2026, however, it is now dated 07/01/2025.

Image

Looking at 01/05/2026, there is now a duplicate transaction for this.

Image

It seems to me, given the locks from reconciling, that this transaction now on 07/01 was actually moved from 01/05, and the one on 01/05 is a new duplicate of that transaction.

Second example, this transaction should be dated 01/14/2026 but is now dated 11/15/2025. The fact that it's split seems to confirm to me this is the original entry, moved to this date. There's also a new dupe on 01/14/2026.

Image

Another few examples, same thing.

Image Image

Interestingly, one of my other accounts that I had to do this with did not duplicate transactions, but one of the newly imported transactions was dated 02/28/26 instead of 03/07/26. That one was not a transfer.

How can we reproduce the issue?

Some of this might be situational based on SimpleFin but the best I can think of is:

  1. Begin with an Actual account that has matching/reconciled history with another account on SimpleFIN.
  2. On SimpleFIN, link your bank account again as a new account (nicknames can help distinguish)
  3. On Actual, unlink your account from the currently linked account under SimpleFIN and link it to the new one.
  4. Run bank sync on the account.
  5. Check to see if the account total no longer matches and if there are any new/duplicate transactions added to the account history.

Where are you hosting Actual?

Docker

Actual 26.2.0

What browsers are you seeing the problem on?

Firefox

Operating System

Mac OSX

Originally created by @pmdevita on GitHub (Mar 11, 2026). Original GitHub issue: https://github.com/actualbudget/actual/issues/7173 ### What happened? For some reason, SimpleFIN required me to relink my bank account and once I did, this showed up as a new separate account, separate from my previous one. In order to keep syncing to Actual, I unlinked the Actual account from the old account under SimpleFIN and linked it to the new one. I expected this to either only pick up the new transactions or require me to manually get it up to speed. However, after doing this and doing a bank sync, a few transactions appeared to duplicate. Given this is technically a new account under SimpleFIN, I suspect the lack of transaction history or differences with the account could potentially explain it. The duped transactions are also all transfers (though not transfers involving other Actual accounts), so there may be something funny going on there. I'll give a few examples to try and show what happened. This first is this transaction (I'm using American style dates). The description and amount of this transaction matches one I did on 01/05/2026, however, it is now dated 07/01/2025. <img width="876" height="50" alt="Image" src="https://github.com/user-attachments/assets/28d119d9-2620-4e24-acbc-b80a602b1fde" /> Looking at 01/05/2026, there is now a duplicate transaction for this. <img width="869" height="44" alt="Image" src="https://github.com/user-attachments/assets/eb8dbf35-b86b-47e9-95c9-d5add37867a4" /> It seems to me, given the locks from reconciling, that this transaction now on 07/01 was actually moved from 01/05, and the one on 01/05 is a new duplicate of that transaction. Second example, this transaction should be dated 01/14/2026 but is now dated 11/15/2025. The fact that it's split seems to confirm to me this is the original entry, moved to this date. There's also a new dupe on 01/14/2026. <img width="886" height="133" alt="Image" src="https://github.com/user-attachments/assets/8459b90b-9df3-4997-a033-96fd80bdf9a1" /> Another few examples, same thing. <img width="896" height="78" alt="Image" src="https://github.com/user-attachments/assets/114e901d-7ff7-4546-a310-79baea75c37b" /> <img width="885" height="76" alt="Image" src="https://github.com/user-attachments/assets/29278833-e8c6-4399-a2e7-003254cab475" /> Interestingly, one of my other accounts that I had to do this with did not duplicate transactions, but one of the newly imported transactions was dated 02/28/26 instead of 03/07/26. That one was not a transfer. ### How can we reproduce the issue? Some of this might be situational based on SimpleFin but the best I can think of is: 1. Begin with an Actual account that has matching/reconciled history with another account on SimpleFIN. 2. On SimpleFIN, link your bank account again as a new account (nicknames can help distinguish) 3. On Actual, unlink your account from the currently linked account under SimpleFIN and link it to the new one. 4. Run bank sync on the account. 5. Check to see if the account total no longer matches and if there are any new/duplicate transactions added to the account history. ### Where are you hosting Actual? Docker Actual 26.2.0 ### What browsers are you seeing the problem on? Firefox ### Operating System Mac OSX
GiteaMirror added the bug label 2026-04-30 20:17:51 -05:00
Author
Owner

@youngcw commented on GitHub (Mar 11, 2026):

If most of the transactions didn't duplicate, then it sounds like just those transactions had different transactions IDs then with the old account. For the changed dates, you would have to check the data returned from simplefin, but it must have sent that data over with those bad dates.

I don't think there is really anything we can do if the data from simplefin changed

<!-- gh-comment-id:4042635581 --> @youngcw commented on GitHub (Mar 11, 2026): If most of the transactions didn't duplicate, then it sounds like just those transactions had different transactions IDs then with the old account. For the changed dates, you would have to check the data returned from simplefin, but it must have sent that data over with those bad dates. I don't think there is really anything we can do if the data from simplefin changed
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#52121