Set the start date to the date of your first payment for the year, set the Frequency to Monthly, and set the Multiplier to 3.
Copy that, thank you. I was putting the 3 in the occurrence not the multiplier. Thatāll do it!
Cheers
Brian
My start month in the budget plan and categories sheet is November, however, it seems to be skipping December in the categories sheet and putting in Januaryās values from the budget plan where Decemberās should be in the categories sheet. Ideas?
Everything in categories is one month ahead of budget plan. Seems like a simple fix but I am having a hard time.
Depending on what columns you have in your Categories sheet, you might have the adjust the formula. The first month of my budget period, Jan 2022, is in column F, so my formula I have in cell F2 is:
=IF(ISBLANK($A2),"",IFERROR(SUMIF('Budget Plan'!$E$4:$E$200,$A2,OFFSET('Budget Plan'!$L$4:$L$200,0,MATCH(DATEVALUE(F$1),'Budget Plan'!$M$3:$X$3,0))),0))
If your first month is in a different column, then youād change the āDATEVALUE(F$1)ā to match the column yours starts in. Once youāve done that, you can then drag that formula across all the columns, and then down all the rows.
I also use @randy Savings Budget. My question - If you cannot adjust the ābudgetā amount, how would one make the change on the budget planner if you were to receive a raise mid-year, or have a rent increase? Wouldnāt changing it on the budget planner change all the months for the budgeting period?
For something like that, Iād create two budget items. One would start at the beginning of the year and have an end date after your last paycheck at the lower rate. Then the next budget item would have a start date before the first increased paycheck, and an optional end date at the end of the year.
@jpfieber, Iām trying to setup a budget starting June 2022, this is when I started using Tiller. When I enter Monthly and enter a start date of 6/1/2022, the budget ends at the end of December and nothing is entered starting in January and on. I realize if I want to start in June then I donāt need to enter a start date, however I figured this was an error that needs to be fixed since I think it should just continue through the full 12 months since I did not enter an end date. Can you look into what is causing this behavior?
@jpfieber Ignore my last question! I was still in version 1.60 of your budget plan. I upgraded to the latest version and I am no longer having this issue.
When I have a budgeted item Frequency set to āAnnuallyā and I change the Status to āDisable,ā the amounts donāt get cleared out from the totals. Disabling does work for all other frequency types.
Thanks @brettanicus, just found the bug and fixed it in the shared template. Once @randy pushes the update youāll be able to update your template using the Community Solutions add-on.
The new version will be 1.72
The update is: Fixed missing status check for frequency āAnnualā.
Sorry @randy push another update so quickly, but I found a way to convert the main formulas in the Budget Plan sheet to array formulas instead of individual formulas in each cell. I think this will improve performance (seems peppier to me). There are no other changes to functionality, so if youāre fine with the current performance, thereās no rush to update. Will be available once @randy pushes the update.
The new version will be 1.80
The update is: Updated main formulas to array formulas
Hi, I just loaded the Budget Plan template and the Group column is not populating with anything. I see a #REF! error within the formula, but not sure how to correct it. Iām using a fresh Foundation Template with no changes to the Category sheet other than populating with my Groups and Categories. Here is what I see in cell D3 for Group in the Budget Plan sheet: ={āGroupā; ARRAYFORMULA( IFERROR( VLOOKUP( E4:E, {INDIRECT($AK$2),INDIRECT(#REF!)},2, FALSE ), IFERROR(1/0) ) ) }
I do like to sort by Group so any thoughts you have on this would be appreciated.
Woops, I broke that with the 1.80 update. Just fixed it,
The version is now 1.81
The update is: Fixed broken Groups column from last update
Thank you!! That did it! And thanks for the prompt response.
I noticed that the start date of a category is only taking into account the month. I changed L3 to 1/1/2023, but the category that started in 8/1/2022 only started populating in August. Not a big deal, I can just remove the start date since itās for the whole year butjust thought you might wan to know.
@jpfieber I need help with this scenario. If Iām budgeting Jan - Dec and have a budget category that I need to adjust upwards at some point mid year because I realize I need to be spending more in that category than I originally thought, how do I make the adjustments to only affect the months going forward from that point on. I do not want to affect previous month categories as those budget months were already balanced and I donāt want to throw those balanced budgets off by introducing new budget numbers to the prior months. Can the budget plan handle this? If so, how?
One more budget plan question. I want to budget my income and expenses so that they equal each other. Is there somewhere on the Budget Plan that I can put a summation of my expenses minus the sum of my income so I can budget this number to zero?
@jpfieber Iām having issues with Bi-Monthly, for some reason when I set a row to bi-monthly the occurrences are showing as 0. What do you think might be the issue?