Planning for 2025 budget

As I start looking at planning for 2025, I’m trying to figure out how to step into this without changing my 2024 data. I was going to start building my Jan budget but then thought, well I need to go into the category sheet and change Jan 2024 to Jan 2025. Is that the right way to do this or am I missing a better way?

2 Likes

You will want to add more columns for 2025 to your Category Sheet.

Here is an older but still very useful link from Tiller about getting ready for a new budget year.

3 Likes

Definitely don’t just change it from 2024 to 2025 - you will essentially overwrite all the set budgets for 2024. Martha.rudkin’s solution is the correct one!

@martha.rudkin has pointed you in the right direction. Just one additional thought: there are people who like to archive each year’s sheet and start with a fresh sheet for the new year. If you want to do that, the right way to do it is to make a copy of your foundation sheet and save the copy as the archive copy. Then, reset the dates on the original foundation sheet. All your bank connections are maintained through the original sheet, not the copy, so you do not want to use the original as the archive.

2 Likes

@sshaffer663 Steve,

There are also a couple of great budget planning solutions to look at:

Docs: Budget Builder

Budget Plan - Google Sheets

Thanks @Clint.C these are helpful. Do you use one of these? I actually really like the budget builder. Great view on prior year actuals.

Excellent. Thanks for pointing to this @martha.rudkin

1 Like

Steve, this is my first year using Tiller. I am planning on using them for my creating my 2025 budget. These type of solutions address many of the issues I have encountered after creating my 2024 budget in a spreadsheet outside of Tiller. The video in the Budget Plan - Google Sheets solution is very good to watch even if you decide not to use the solution. It covers so many items that I encountered creating and maintaining my 2024 budget manually.

1 Like

Probably covered in the videos but I only keep one prior year in my production Tiller sheet for YOY comps. I’ll archive a copy of my 2024 Tiller sheet at the end of 2024 and then remove 2023 transactions for my 2025 Tiller sheet. I do this simply for performance sake.

Yes. there are multiple ways to go about it depending on need for historical data or reference. I definitely recommend checking out @martha.rudkin 's suggestion

I have been using Randy’s Budget Builder for many years. Just today, I posted how I use it and an improvement to it here.

I add the columns to the Categories worksheet like @martha.rudkin indicates and then use the following formula in the first category under Jan 2025 column…

=arrayformula(iferror(vlookup($A2:$A156,{‘2025 Budget Builder’!$D$7:$D250,‘2025 Budget Builder’!$AY$7:$BJ250},match(BB$1:BM$1,‘2025 Budget Builder’!$AY$2:$BJ$2,0)+1, FALSE)))

This pulls the monthly budget I set up in my 2025 Budget Builder worksheet.

2 Likes