SurvivalWare Cash Flow Software
  • Home
  • Products
  • FAQ
  • Blog
  • About
  • Contact

Rollover for the New Year

1/2/2023

0 Comments

 
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”
Picture
Picture
BEFORE Rollover:
Picture

Picture
AFTER Rollover:
Picture
Picture
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.



0 Comments



Leave a Reply.

    Picture

    Rusty Luhring

    Founder / CEO of Luhring SurvivalWare, Inc.

    Financial modeling expert

    Categories

    All
    Announcements
    Fort Knox Model
    ROI
    SurvivalWare Tips

    Archives

    January 2023
    December 2022

    RSS Feed

(c) 2023 Luhring SurvivalWare, Inc.             
Home        Products         Blog         About        Contact 
Proudly powered by Weebly