How to change the budget Date without moving the data.

How to change the budget Date without moving the data.

Currently, when changing the start dates in Forecast 5, the dates will change but figures will remain in the same order (they will not move to match the previously set months)

E.g.
           

But occasionally there is a need to change the forecast start date with out moving the data values.

E.g. The Forecasts start date was set as December, however now the need is that forecasts start date to be April but December is the first month with values.

These steps will allow you to achieve this.

Start with the original forecast

  1. Export data to excel by going to the Utilities menu > Record list.
  2. In excel, insert blank columns for April to Nov so the first value date is now December.
  3. Export the Opening balance sheet to excel from the Enter Opening Balances screen.
  4. Click New/Open (top left corner) to get to the Open Forecast screen. 
  5. Then select the forecast and select “Copy Forecast No Values”
  6. Once that has copied, open the forecast, go to Settings > Details and change the start date to April and the first data month to Dec.
  7. Select all and import record list.
  8. Then import opening balance sheet.
Note: Certain records e.g. Fixed Assets, may need to be deleted and re-entered to get the deferred start date to apply.

If you have any issues or confusions, our consulting team can assist at our prevailing consulting rate. Please email support@forecast5.com for assistance.


    • Related Articles

    • Record List Import - Wages importing negative

      Issue: When using the Record List import to bring in your data from Excel, the wages records are importing as negative values. Solution: Until a permanent solution is found, follow the steps below: 1. Enter 0 in the set all box of each wages record. ...

    • Forecast Data Export Guide

      The Data Export allows you to export multiple existing forecasts from Forecast 5 into a formatted spreadsheet to be imported into an external product, e.g., Spotlight, Fathom. Please see the attachment tab for the guide

    • Removing Prior Year Data When In Actuals

      Run the balance sheet for the year BEFORE you want your actuals to begin and export to excel.  Why? This will be used to update your opening balances. Export all the reports for the year you want the forecast to start for comparison. Reset to No ...

    • Moving Forecast 5 from one PC to another.

      If you have a Single Computer License and you change computers, there are two ways to do keep your forecasts: First follow the process to deactivate your license in this article How To Deactivate Your License (forecast5.com) Method 1: For those using ...

    • Forecast 5 Demo Data

      Downloaded and installed Forecast 5 and you aren't sure where to start? We have provided a demo data forecast that will help you see most of the features and benefits that Forecast 5 has to offer. Download the attached demo data (found at the bottom ...