You might be wondering whether there is anything special you need to do to your Tiller-powered spreadsheet budget for the new year. This guide is meant to help you navigate what to do when the new year rolls around.
Some templates offer multi-year budgeting, meaning you can retain the budget amounts for categories from the prior year and continue adding new budget amounts for categories for the new year. Some templates do not offer this functionality.
Templates that support multi-year budgeting
Tiller Foundation Template
As of August 26, 2019 this is the only officially supported template that Tiller offers. Other templates, previously available via the Tiller Console, were transitioned to Tiller Labs and are supported in the Tiller Money Community (including the Tiller Budget with Rollovers above).
The Tiller Foundation Template supports multi-year budgeting, but does require a few easy steps to set it up for multiple years.
- Open your spreadsheet
- Navigate to the Categories sheet
- Select column E and hold the shift key and then select column P
- Right click and choose “Insert 12 right” to insert 12 blank columns to the right of the current budgeting year’s month columns.
- Use the quick fill square to pull and fill the contents of column P into the 12 blank column headers. This should create 12 new budget months.
- Use the quick fill square to pull and fill the contents of your category budgets for the first category in your list from left to right. Alternatively, if you want to start over with brand new budget amounts vs using the prior year’s budget amounts, you can type =Q2 into cell R2 and then fill that to the right using the quick fill square.
- Hold shift and select all the cells for the 12 new months for the first category (that you just filled across to the right). Hint: you can select the first one, hold shift, and select the last one to the far right and it will select all 12.
- Use the quick fill square to fill the formulas down to all your category budget rows for the new year. This just allows for rapid budget filling when you fill in the budget amount for the first month it will cascade to the right.
- Optionally: hide columns E - P when the new year starts so those don’t get in the way. Click column E, hold shift, then click column P. Right click and choose “Hide columns E - P”
- Plan out your budget for the new year by entering budget amounts into the cells for each category. Start with column Q and they should cascade automatically to all months from R - AB.
Tiller Budget with Rollovers (screenshot below)
The Tiller Budget will continue to create budget periods and years automatically via the Tiller add-on and the use of scripts running in the background. If you’re using this budget template you don’t need to do anything.
Budget templates that do not support multi-year budgeting
Some of the early versions of budgeting templates from Tiller do not support multi-year budgeting.
The Tiller Monthly Budget template
This template looks very similar to the Tiller Foundation Template (the Foundation Template was built off this template), but it does not support multi-year budgeting where you can set budget amounts for categories. You can tell you’re using this template if you have a tab called “Monthly View” in your sheet.
For the new year you can do one of the following:
Reset your budget numbers
This template’s budgets are set on the Categories sheet and are static for the current calendar year. These same budget values will get re-used in the new year unless you change them. If you change them you’ll lose the historical budget values.
You will need to change the year value on the Yearly Budget sheet (tab along the bottom) to reflect the new year and have it show the actuals for that year. The budget columns on this sheet are showing whatever is in the Categories sheet, regardless of which year’s actuals are showing.
If you want to retain the historical budget values you can create a copy of your Categories sheet (right click and choose duplicate) and rename it “2019 Categories” or something like that. This would be a reference only sheet. The reporting sheets will not allow you to pull the data from this historical Categories sheet for analysis or comparison.
Make a copy of your sheet
If you’d like to keep your prior year budget intact, you can make a copy of your Google Sheet (from the File menu) at the beginning of the new year. Then you’ll have a working copy of that budget archived (but not updating by Tiller) and then just adjust the budget amounts for the new year in the original spreadsheet’s Categories sheet and update the year on the Yearly Budget sheet.
You can always start fresh in a new Tiller-powered Google Sheet no matter what template you’re using. By default the Tiller Console will opt you into using the Tiller Foundation Template fed by the Tiller Money Feeds add-on. If you want to try the Tiller Budget with Rollovers it’s documented and supported on the Tiller Money Community here.
If you decide to start fresh, and don’t want to lose your work, you can try the Tiller Labs experimental Migration Helper tool to get your categorized Transactions, Categories, and manual account balances into the new Google Sheet. From there you can copy/paste your budget values and other customizations. You can also manually migrate your data in a few simple steps.
Tiller Money Tracker for Excel
This template also doesn’t support multi-year budgeting, but you can follow similar steps to those for the Tiller Monthly Budget. You can make a copy of your Categories sheet or the entire Excel workbook to have as an archive for the prior year and then update the budget numbers in the original with your new year’s budget amounts.
Otherwise, you can overwrite your budget values on the Categories sheet and continue budgeting without an archive.
What about planning out the coming year?
If you aren’t ready to overwrite your budget numbers in templates that don’t support multi-year budgeting you can make a copy of your spreadsheet and adjust the numbers in the copy to help you plan for the upcoming year.
If you’re using the Tiller Budget with Rollovers you can add future periods using these steps.