My Balance History only goes back to last June, 2025 and I would like it to go back to the beginning of my transactions. (Jan 2020). I’m generally short on time and new to Sheets so would rather not reinvent an old wheel …
I’ll welcome even pieces of formulas to move this forward.
Consider using this formula to get the balances based on transactions. If the balances don’t match your latest balances, you may need to enter a transfer transaction equal to the difference to represent your oldest balance. Then you could do some data filtering and copy-paste-values-only into Balance History.