Create New Year Workbook

1. Select completed-year tracker

Tracker workbook .xlsx

New budget year Output file name

Waiting for workbook.

2. Choose what to keep or clear

Recommended default: keep Categories, Rules, Settings and reports; clear Transactions, Forecast, Imported Files, Import Log and Ignored Transactions.

Clear Transactions
Keep the sheet/header structure but remove prior-year transaction rows. Clear Forecast
Keep the forecast sheet ready for new-year planning. Clear Imported Files
Start the new year with a clean import-file audit trail. Clear Import Log
Start the new year with a clean activity log. Clear Ignored Transactions
Prevents old ignored transaction IDs blocking future imports. Keep Rules
Preserve categorisation learning from the prior year. Keep Categories and Budgets
Carry forward categories; update budgets later if needed. Keep Dashboard and Reports
Preserve reports; Monthly Spend Matrix will be rebuilt from Categories.

3. Planned changes

Recommended process

Save the completed year as an archive, for example Finance_Tracker_2026_Final.xlsx.
Open this utility and select the archived/completed workbook.
Enter the new budget year.
Create and download the new workbook. The Monthly Spend Matrix is rebuilt from the Categories tab.
Open the new workbook and review budgets/forecasts before importing new transactions.