Hi there fellow mustachians,
I am trying to make my very basic spreadsheets a bit more sophisticated and find myself struggling…any advice is much apreciated!
So what I most would like to see is the monthly savings rate in % but the problem is that when I write down the actuals for e.g. dec 2017, it does not show the entire picture. Like in December I transfered a certain amount from my tax savings buffer to my transaction account to pay the tax invoice in January, so december is way too much on the + side and january on minus… Not sure if any of this makes sense Does it even out after a couple of months? but then the savings rate wouldn’t be accurate or?
My main tracking sheets rigth now are the following:
Monthly budget with some (pretty accurate) forecasts of the monthly expenses. 1. income, 2. savings & investments and 3. expenses. I try to do a 0 CHF budget where everything is allocated for each month in advance. At the moment I do not follow up and add the actuals here after each month.
Asset overview. This is where I track the number of posts etc. for each asset category and specific “line item” e.g. VWRL, normally once every quarter when I buy ETFs. I also have the “liquid” value of our house that is in my name etc. a small cash buffer for emergencies etc. Every year or so I calculate the value of the portfolio.
I’m thinking that keeping better track of the exact savings rate would motivate me a little more each month to save more
What would you recommend that is fairly straightforward to prepare?