Yes I do. I made the Budget Builder template for my own budgeting process.
To add a new budget year:
- Add 12 new columns to the
Categories
sheet for the new budget year. - If you had previously used the Budget Builder template, stretch the Budget Builder formulas into the new columns (if not, add this formula in the top left corner of the new budgets and expand down:
=iferror(offset('Budget Builder'!$AX$7,match($A2,'Budget Builder'!$C$7:$C,0)-1,match(G$1,'Budget Builder'!$AX$2:$BI$2,0)-1))
) - Copy the existing/previous year budget cells in the
Categories
sheet. - Paste over the formulas as values (the previous year should no longer be formula driven).
- Update the Budget builder to the new calendar year in cell
C1
. - Delete previous budget mods in the Budget-year Modifiers and baseline overrides sections.
Good luck.