Rollover for the New Year

Rolling over an MTX file is something you do once a year to keep a fixed number of time periods in the model. 

Here is what happens:

• A copy of the current file is saved in the Archive folder with the rollover year in its name
• The oldest 12 months of the file are chopped off
• All other time periods are moved to the left in the MTX file by 12 months
• The columns are relabelled with the appropriate time period names
• The “last actual month” is reset to 1

The time to do this is just before loading the first month of the new fiscal year.  If you are on a calendar year, you would perform a rollover some time in February just before loading up January actuals.

Rolling over is easy to do.   You can do one file at a time, or all at once if you have several company files.

To rollover the currently open MTX file:

1. Select Toolbox / Rollover
2. Click “Run”

BEFORE Rollover:

---

AFTER Rollover:

To rollover all MTX files:

1. Select Toolbox / Rollover
   
2. Check the  box “Roll Over all Files in Folder”
   
3. Click “Run”

NOTE: Immediately after rollover, the 'last actual month" is set to January of the new year.  The numbers for that month will be the projections for January from just prior to the rollover.  The January actuals should be loaded right away to replace the projected values.