šŸ† Budget Status - Google Sheets

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.

1 Like

Joseph, this is great. Be careful, you have almost built an envelope system :grinning: great job

Rich

1 Like

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?

1 Like

Thats a good question. A good start would be to look at the Envelope Systems I built here :slight_smile: (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.

1 Like

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.

:trophy:

6 Likes

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.

1 Like

Really cool but Iā€™m having weird issues trying to set this up. :face_with_diagonal_mouth:

  1. 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?

  2. 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.

  3. ā€œ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.

2 Likes

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.

  1. 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?

  2. 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.

1 Like

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.

1 Like

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.

1 Like