Moving Records to a New Year

At the beginning of every new year, you will need to start using the Reseller Toolkit copy for that year. So at the start of 2026 you will need to use the 2026 template and copy data from your 2025 version, and then in 2027 you will need to do the same with data from the 2026 template. The data migration should only take a few minutes (assuming you haven’t made modifications to the template itself).

Set up the Spreadsheets #

Here are the steps you should take as you set up your Toolkit copy for a new year:

1. Open the Toolkit you used for the previous year in a new window.
2. Open the Toolkit for the upcoming year in a new window.
3. From the previous year’s Toolkit, navigate to the My Business tab and copy all populated records in column E to the equivalent fields in the My Business tab of the current year’s Toolkit. It’s safest to do this one section at a time, so start with Business Name, then Country, then Currency, etc. Make sure you scroll all the way down to row 158 so you don’t miss anything.
4. In the Inventory tab of the previous year’s spreadsheet, go to the Status column (column K) and click the lined triangle icon to show filtering options.
5. In the list of status values near the bottom, uncheck Sold. This will filter your list of inventory items so you only have records still in your inventory. This step will ensure we only carry forward items still in your inventory.
6. Select filtered rows starting from row 3 through the last populated row in the previous year’s Inventory tab. Make sure all columns from A to L are selected.
7. In the current year Inventory tab, click column A3. Then paste in your data (Edit > Paste) and confirm that all of your copied inventory records are populated.
8. Switch to the Assets & Liabilities tab in both spreadsheets.
9. In the previous year’s Toolkit, select and copy your asset records into the Asset records (columns A to E) of the current year spreadsheet.
10. Copy your Liabilities records from the previous year spreadsheet to the new one. If you haven’t updated the amounts for a long time, this is a good opportunity to update your account balances for assets and liabilities.

If you have any important notes or other records you need to retain, copy those over as well. Once the steps above are complete, you should only record new inventory and sales in the current year Toolkit and discontinue using the file for the previous year (except for reporting and recording late changes like refunds).

Important Notes #

• Always keep a copy of spreadsheets for previous years for as many years as your country’s tax laws require. Beyond the reporting requirements, you will need this data if you need to record later refunds and for potential tax use.
• Sales, other revenue, expenses, commissions, and mileage are all unique to the calendar year when they were recorded. This data should not be carried over to the current year spreadsheet.