actualbudget / actual

A local-first personal finance app
https://actualbudget.org
MIT License
13.52k stars 1.08k forks source link

[Bug]: SimpleFin-synced account shows wrong total amount. (possibly related to `startDate` #3048

Open jeffjose opened 1 month ago

jeffjose commented 1 month ago

Verified issue does not already exist?

What happened?

Looks like the total amount displayed on the top of the page for an account is different is the account is old vs an account created in a fresh budget file.

I believe this is due to starting balances and startDate. In the new budget file, the startDate doesnt go as back as the original account's starting balance, and that somehow causes the total amount to be different.

In other words BUDGET 1 created few months back - ACCOUNT A (simpleFin synced)

BUDGET 2 freshly created - ACCOUNT A (simpleFin synced)

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Linux

duplaja commented 1 month ago

Did you set a starting balance for the account, for a particular date?

The total amount shown at the top is calculated using the sum of all transactions. If you set a starting balance, then the bank sync uses that as the initial date, and goes from there (or 90 days, whichever is most recent).

jeffjose commented 1 month ago

No. I didnt set Starting Balance. Both accounts were 100% populated by SimpleFin.

image Image showing starting balance of the "old" account. Note how it starts on 11/13/2023

Same account (credit card) but on a new budget file and synced via SimpleFin today. The starting balance is on 4/15/2025

image

FWIW, the "old" account shows the same transactions on 4/15/2025 image

jeffjose commented 1 month ago

Exported transactions into a sheet. I plan to dig into this a bit more later today as well.

https://docs.google.com/spreadsheets/d/1t1Ub28aeJGT909Q8Z1kQrwv80CZF-h9V0oQTwLfTLHE/edit?usp=sharing