Our Tiller Money Labs team is working to keep you efficient, inspired, and enabled with financial templates, tools and workflows. In our Tiller Money Labs Roundups, we keep you updated on our latest features and sheets.
Savings Budget
With your feedback, we are making great strides at improving and hardening the new Savings Budget.
While it is still in a dev-feedback stage, we plan to demonstrate it broadly next week. If you have questions or would like to learn more, don’t miss the Tiller Money Live webinar next Thursday at 10AM PST!
Though the Savings Budget (Prototype) doesn’t include the rollover-to concept, the migration tool can now replicate historic rollover-to shifts in your new budget by modeling them in the Budget Journal sheet
Fixed a bug that rendered Categories-sheet budgets in reverse-chronological order
Hey Randy, I noticed that the Merge Categories Workflow did not update the Category column in my AutoCat sheet (if the deleted category was present there).
For people who have been using the foundations template budget for some time (7 months for me), and starting the savings budget now, is there a way to start new with the savings budget as of the current month? Otherwise, I have to go back to prior months and adjust each category month by month and move forward. Any suggestions here?
Also, I have a few categories that show up twice in the savings budget, but not on my monthly budget. In all cases one category is capitalized and the other is not, but the dollar amounts appear to be duplicated. (example: Golf and golf). This is not the case in my monthly budget.
|Golf|$58.97|$280.00|$664.99|
|—|---|—|---|
|golf|$58.97|$280.00|$664.99|
If you haven’t already found it, there is an easy way to start from the current month using the Savings Budget. If you go into the hidden area by unhiding the columns to the right of column H, you will see a Starting Period setting in cell M2. Just go ahead and set that to the month you’d like to start tracking savings accruals from.
Regarding the duplicate categories, can you tell me more about what is going on in the spreadsheet. Are there duplicated category names in the Categories sheet? Do you have data validation turned on in the Categories column in the Transactions sheet (i.e. to force matching capitalization)? Do any rows in the Transactions sheet use different category capitalization than the Categories sheet?
Based on how the sheet is built, I can see how it would display duplicates where the Monthly Budget would not… but I don’t understand what would be the source of the alternate capitalization.
Best,
Randy
P.S. I’m really sorry I lost track of this thread. I’m doing my best to catch up on posts like yours now. Thanks for your patience. I hope I’m not too late on this.
Hi @randy . Thanks for responding. Now, I am just seeing this for some reason. Anyway, the novice here sees that in M2 the formula is =BC4. Is this a special formula that =1/1/2020? I can’t enter the date that I want which now is 1/1/2021 now. It doesn’t accept that. Is there a code that= 1/1/2021?
The cell M2 is intended as a hidden space to override your budget start month. It autopopulates from the earliest budget in your Categories sheet which a formula in cell BC4 determines. You can type over it with a different date, just be sure not to put an equals sign before it. Just enter 1/1/2021.
