[Bug]: Sync pulls one day prior to earliest transaction, causing a cycle that continues

[Ruharc]

Verified issue does not already exist?

• I have searched and found no existing issue
• I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

Edit: I am using SimpleFin for the bank sync

I ran through this issue with youngcw on Discord, so I will be posting my screenshots and things I used to reproduce this that I discussed with them.
I wanted to start fresh in June so I cleared out all of my Accounts transactions. I put in a Starting Balance transaction with my balance amount that was June 1st. I cleared everything out of my account except for that one then I ran the sync. It pulled everything going back to and including May 31st. Then I ran the sync a second time and it included May 30th. It feels like each time it syncs it is seeing more transactions from earlier and adding in extra ones that it didn't get before.

It is basically always resetting the pull filter to include 1 day previous to whatever the earliest transaction in my ledger, including the extra ones that it pulled. I have verified this in the logs as well both on my regular budget file and in a brand new budget file.

Step 1. Started with this in Actual

Step 2. Clicked Sync, Actual Docker logs show this

Step 3. Actual now shows this

Step 4. Clicked Sync again without changing anything in Actual. Logs now show this.

Step 5. Actual now shows this.

This continues as long as there is no gap of days for the transactions it is pulling. It keeps grabbing all the transactions 1 day prior to the earliest transaction in the ledger. If there is a gap with no transactions then it has nothing to pull so it doesn't reset the date range to the day prior on the next sync.

I have verified this on multiple accounts with different banks and on multiple budget files.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome, Desktop App (Electron)

Operating System

Windows 11

[jclapadula]

If it was not always like this, I think GoCardless might have changed the behavior of the API.

I'm not sure how it used to work, but now when you get transactions from dateStart, it brings transactions with bookingDate >dateStart (correct) but also with valueDate > startDate. So if a transaction has valueDate one day after the bookingDate, it will bring transactions that happened before the specified startDate...

[Ruharc]

I should have mentioned that I am using SimpleFin for the sync not GoCardless. I'm not sure if this changes what the problem could be. I will update the initial post with this information as well.

[kennylarsen]

Can confirm it is an issue with GoCardless though...at least with Amex in the UK.

[youngcw]

I think likely what needs to happen is that the incoming transactions get filtered internally instead of just trusting that the returned data is in the right date range

[pavekovt]

Can confirm on GoCardless using a Latvian bank account. Running in Docker, if that changes anything.

[pavekovt]

Is there any workaround for this?

[giorgiooriani]

Same issue with Gocardless connected to Amex UK. It just keeps pulling old transactions even through I set a starting balance.

[pavekovt]

I still haven't found any reliable workaround.
However, it works as expected with Swedbank LV, only Revolut LV doesn't this -1 day transaction pull.

[Ruharc]

I can confirm this is still a problem. I suppose a workaround would be to have a rule that could delete all transaction prior to the Starting Date after sync. This way it doesn't keep the chain going continuously adding transactions going back. I do't think rules can delete transactions though can they?

[Ruharc]

Ok new update. This appears to have been fixed in the edge version, and should be fixed in 24.12 that is supposed to be released tomorrow!

[pavekovt]

Once released will test on my end

[matt-fidd]

This is confirmed as fixed in v24.12.0

[pavekovt]

Well, it still pulls -1 day transactions on Revolut LV on v24.12.0. Can someone verify too @Ruharc, @giorgiooriani?
Please reopen.

[Ruharc]

I can confirm that for all of my accounts that are syncing it is only pulling from the Starting Balance transaction forward. This is using SimpleFin on the latest 24.12.0 on Unraid.