Thanks for diving in, @aronos.
The partial savings are definitely not intuitive.
There are basically 3 categories of transactions that need to be handled differently to keep a budget true:
- Budgeted transactions with rollovers turned on
- Budgeted transactions with rollovers turned off
- Unbudgeted transactions (e.g. transfers, uncategorized or no-longer-used categories)
I THINK the equation I shared above handles all three cases but I’m happy to make improvements if anyone has suggestions.
You ask why I made the Savings setting optional, @aronos? I guess just because I can imagine users who are comfortable using the Monthly Budget but want to have one or two of their categories accrue as long term goals. For the most part, having the Savings be optional doesn’t introduce complications… except for the riddle of truing up budget issues.
You ask “is it too late to change the name of this?”… do you mean the template or the
We picked the term
Savings Budget for the template because we wanted something a little more general and less jargony that “envelope” or “rollover”.
I’m open to “Error Adjustment”. When I use “Rollover Adjustment” it is simply as a placeholder for something better.
As for the test sheet, once we settle on the analysis and inputs, I’ll add the equations to the
Savings Budget master and we can see how they work in practice. We can continue to adjust and refine until we are happy with them.