Comment by akerro

Or instead using spreadsheets just use a self-hosted free software that is dedicate to personal finance analytics https://github.com/firefly-iii/firefly-iii