How do you budget for 2020 and beyond? I see where you can change the yearly period in the monthly and annual budget tab but all the budget information comes from the Categories tab. I do not see in the categories tab where I can adjust the monthly columns to reflect 2020 number.
Any ideas? Thank you.
, @patmrogers!
You can set the 12 month budget start in that first budget month column on the Categories sheet to something other than Jan 2019. If you were to set it to 9/1/2019 your 12 month budget would start Sept 2019 and end Aug 2020.
You can also extend the budget by adding additional columns to the right of the last month in the Categories sheet. For a 24 months, add an additional 12 columns to the right and then use the quick fill square to drag the formula from last last month header to the right for those other columns.
Then your yearly and monthly budget view tabs will be able to pull data in from those future months.
Video demo of how to change start month here:
Let me know if you get stuck.
Heather
Thanks for sharing this Heather!
Does this mean that the categories tab is the only place that captures the actual budget information? So if I wanted to look at my budget historically, I would need to keep those old columns and continue to add new columns for new years? What’s the best practice here? Just replace the months for the new year when planning for the next year or just keep adding months so that budgeting in an ongoing process and not necessarily a once a year activity?
In the Foundation template, yes, the Categories sheet is the only place where historical budgets are kept. So if you want your budget target history per category then you’ll want to add the additional columns per year.