This is amazing, and what I was really using the Savings Budget for, but I didnāt want to change my budget, just to see if I can balance the items somehow.
A couple of quickies:
1- In the post, you need to put the sheet name in CodeView, otherwise it uses smart quotes.
2- Is there a way to filter or start with a specific date? I have from 2020 onwards, but I only want to start from 2022 for example.
Thanks! I updated the docs to make the sheet name preformatted.
Good idea to allow the start date to be switchable. For now, you can change CT29 to your desired start date, (it currently comes from the first date found in your Categories sheet). Iāll add a changeable field somewhere that overrides that if set when I get a chance.
Joseph, this is great. Be careful, you have almost built an envelope system great job
Rich
Thanks! Thatās kind of what Iām working towards, but I havenāt really used an envelope system before. What do you think could be added to make it more useful for someone wanting to do envelope budgeting?
Thats a good question. A good start would be to look at the Envelope Systems I built here (slight plug)
I think the biggest difference between yours, the savings budget, and mine is I base my envelope values on the actual income and money in my accounts, and not the potential money that I have in my planned budget. Meaning, while I expect to get paid twice in a month, I cant add the money to the envelope until it hits my bank account. Yes I can plan for it in my budget, but it isnāt marked as available until payday. slight difference but a mighty difference. Which is great. I think the value proposition of Tiller is its ability to work with so many sheets and ways of doing personal finance.
Overall, I think what you are doing in all of your sheets is awesome. Keep it up.
We are so grateful you continue to tackle and iterate on some of the hardest personal-finance budgeting challenges, @jpfieber. Budget Status is a cool & powerful mashup of an envelope budget with workflows linking savings balances to real-world accounts for improved workflow accountability.
Your āpoolsā concept looks like a nimble reimagining of what was attempted with the Savings & Debt template.
The Tiller Builder Rewards Program is excited to award you $750 for this powerful, new community template.
This is super cool and useful @jpfieber! Thank you for all you contribute to the Tiller Community and the Tiller experience. Itās getting to the point that I visit the Community just to see what youāve recently built or shared.
Really cool but Iām having weird issues trying to set this up.
-
Like you I have created a Pool called āProjectsā which is tied to our Online Savings Account. For whatever reason, the balance for my OSA is wrong in Budget Status once I link it. It seems to be showing the balance from before my last deposit (I think from what I recall of the number) to that account which Iām not sure how is possible. I deposited cash into that account about a month ago. My account balance for this savings account is correct on the Balances tab, so I have no idea how your sheet could pull an old/wrong number from a month ago?
-
Iām unable to build a Dropdown list in Categories. I can build the Data Validation rule and it links to Budget Status and can see my Pool names in the rule, but once I click the Done button to complete and set the ruleā¦nothing happens. Google wonāt let me complete the rule. So it basically puts a blank drop down list in my Categories sheet with the generic Option 1 or Option 2 to pick from.
-
āif you have multiple accounts assigned, it will add them together for the Pool Balance.ā I have two pools assigned to this savings account and this Pool Balance feature isnāt working either. Itās not adding it together.
What in the world?
I pull the balance for the account from the Accounts sheets āLast Balanceā column. Is the number showing there correct?
For the Data Validation, Iām just seeing the new interface for it, and I have to say so far I donāt like it. Make sure the changes you are making are applying to the range you want. In my attempt to redo it, I accidentally pointed a different column at Budget Sheet. Also, it seemed that instead of just pasting the ='Budget Status'!$D$5:$D
, I then had to click on the grid button you usually use to go find the range before it properly recognized it and then showed entries for all of my pools.
Interesting. Never noticed that hidden part on Accounts. Found the issue there in that sometimes Accounts get changed on the backend by the financial institution. Your sheet was pulling an old balance from a month ago that was listed before the current, correct balance. I blanked out the old Last Balance line and it now pulls correct number. Pulled new balances just to make sure I didnāt break that and it seems to be fine.
For Drop Downs, it wonāt let me type in =āBudget Statusā!$D$5:$D and hit the grid button. I had to hit grid button and drag over my Pool options before it would work. Thus, it wonāt let me input your āinfinityā option.
Pool Balance is still not working if I understand that correctly? I have two Pools pulling from one account so the Pool Balance should be 2x of that Account balance? Right?
After studying this for a while this is really cool. Iām assuming this will automatically roll into January 2023 when we hit January and switch over?
Also, I do have one recommendation unless Iām just missing how this might workā¦
Would like to see an additional column in Section 3 and/or 4 that calculates the difference between Prior Budget and Prior Activity. Could call it Prior Balance or Prior Gap or whatever. Having this column would quickly help you operate the Category Transfer Tool without having to do math. Iāve added this myself in a Copy of my Tiller workbook to test it by adding a new column to the left of Column X between Sections 3 and 4. It didnāt seem to break anything but maybe Iām not seeing something?
For example, Iām going to start using this in 2023 in conjunction with your Budget Plan. So at the end of January 2023 I would like to be able to move money around different categories to balance/reconcile the month, if you will. I can obviously do that as it is configured but will have to do the math myself whereas if we had a column to reference we could quickly plug into the Category Transfer Tool.
Just a few questions about the budget plan for 2023. I am looking to make a few changes in categories and also the budget designation for 2023.
-
I want to separate my wifeās paycheck and my paycheck. She is an hourly employee and paid every 2 weeks, so there is a bit of variability in her check total. Iām salaried so it is more predictable. If i add a new category so I have two categories for income instead of one in 2023, how can I adjust that in the budget plan? Should I go back to 2022 and change that so it transfers into 2023 or can i make that change simply for 23?
-
I am looking to make some home improvement costs, can i manually enter those totals and tailor them toward the months spent? I believe you used that example with a bath remodel but was not sure how to enter a custom amount that will be spent.
I have an āIncomeā Group with a number of categories in it:
- My Salary
- Her hourly
- My side income
- Her side income
I have two budget items in Budget Plan:
- One weekly with a multiplier of 2 (I get paid every other week)
- One weekly (she gets paid once a week)
My salary is very regular, so budgeting is easy. Herās is not as regular, so I do the best I can to balance it out. If you have transactions for her income from last year, you might just set the frequency to āPast - Categoryā or āPast - Descriptionā and then you could always use the multiplier to increase it if her pay rate increased. Keep in mind you can also create multiple entries for one category and use the start and end dates. So if she had 20 hours a week until June, and then 30 hours a week after that, create one budget item with an end date of 6/30 and then a new one with a start date of 7/1. Each can then have a different budget amount.
For the home improvement, the example used āSpreadOverPeriodā frequency where you could input the total amount to budget, and then use the start and end dates to determine what period the spending is budgeted over. If you want to get more specific than that, you could create a separate budget item for each month, or you could create separate items for each part of the project. Itās very flexible that way, allowing you to have as many items in as many categories as you need.
Thank you for this. Follow up, if i start a new category or income group on Budget Plan, does it automatically copy over to the categories page? I do like how you have different income descriptions under your income category. I might switch to that. I will play around with it now.
If you want to start a new category, you need to create it first on the Category sheet, thatās where Budget Plan (and all other sheets) pulls itās category list from.
Ok, I was finally able to install budget status, following with our last conversation on budget plan.
I currently have in the part 3 āBudget Infos based on categoriesā a beautiful N/A in currently available. I guess it is because my budget (in budget plan and categories) officially starts in January ?
It shows an error : Did not find Value 44896 in MATCH evaluation.
Here too it would be essential to have a date to be able to go forward and backward.
To compare, saving budgets does have more of a tiller look and I enjoy the progress bar much more than the % wheel of budget status visually. (I do come from YNAB, not a surprise there).
I donāt really use the poolsā¦ I just set my accounts in there (which I linked to the same nameās account to pull the current balance) and set these in the category sheet as to what account I would use to pay for X, Y or Z.
I am curious to see if the total rollovers at the end of a period as well.
Hi @jpfieber ā Iām trying to switch over from the Savings Budget / Savings Goal & Debt Tracking worksheets to your Budget Plan and Budget Status worksheets.
Iām having a hard time getting my projected accumulation of unspent funds in each category (ie saving for a big expense 8 months from now).
My thought is that the āBudget Planā worksheet is not the place to find (or add that in myself) that info because it doesnāt track the pools and transfer of funds to different categoriesāwhich your Budget Status worksheet does.
That said, āBudget Statusā does not have any future projection functionality in it. Itās only a current state picture of categories, pools, and your bank accounts (which is great for that purpose).
Thanks for the help! -Kyle
I added a couple tweaks:
- Added ability to set the start of the budget year (A25)
- Fixed settings to ignore budget info from before budget period
The version is now 1.10
Dumb questionā¦I think with this one we have to redownload it because Iām not seeing it in the Community Solution sidebar list of apps?
Correct, this hasnāt been submitted to the gallery yet, so you can download from the link in the first post.