A quick question: If I log a change to the Savings of two categories and hit “Update Budget” in the Savings Budget tool bar, where are those changes “written?” I understand how changes to the Categories sheet are made, if I were making changes to the Budget among categories, but I am not following where the changes to the Savings are made. Only in the Savings Budget presentation, drawn, then, from entries in the Budget Journal?
This can be a little confusing…
Monthly budgets are written and stored in the
Categories sheet— for full compatibility with our other budgeting tools (like
Monthly Budget and
Yearly Budget). The dashboard’s budget values are pulled from the
Savings changes are written and stored in the new
Budget Journal (that is installed with the Savings Budget). The dashboard’s savings values are pulled from the
Budget Journal sheet.
Note the budget changes are added to the
Budget Journal also, but these entries are just for reference (for a complete record of how you have changed your budget over time). In other words, budget-change entries in the
Budget Journal have no bearing on the data in the Savings Budget dashboard.
Hope this helps.
So, if one were to make changes directly to the Budget Journal sheet (overwriting an entry there) would that then be reflected in the Savings Budget dashboard?
That’s right, @heather. Those changes would be reflected in the dashboard.
Yes. This all makes sense. Thanks for the quick replies, and, BTW, this new tool is ingenious.
The debt balance
It’s working fine for me. I would double-check and make sure that your tracked debt category name exactly matches the account name. Don’t include xxxx1234 in the category name unless that is part of the account name in
Thanks, @cculber2. It works after I remove the xxxxx. I thought the name is obtained from the Debt progress tracker that is linked to accounts. Is there a way to hide goal and debt from appearing in the other report such as monthly analysis.
Yes, if you mark the category as
Hide in the
Hide From Reports column
E it will not be included in most foundation template sheets, but will still be included on the
Savings & Debt sheet.
As @cculber2 notes, we use the
Hide From Reports setting in the
Categories sheet to enable hiding of categories in automatically-rendered dashboards. In the case of the
Savings & Debt template, since the categories/accounts are manually added to the sheet, the
Hide From Reports setting is not used in the tool.
Hope this helps, @adekunledauda.