After Actuals are enabled in a forecast, it is normal practice to periodically move the Actuals month forward to allow the forecast to be updated. This is done by going to Data > Actuals Data > Set Actuals Month and then selecting the new Actuals data month.
There a 2 reasons why Castaway will not allow the Actuals month to be moved forward:
- The Projected Balance Sheet is Out of Balance
- There is only 1 month left in the forecast
1. The Projected Balance Sheet is Out of Balance
Castaway will not allow you to proceed with the subsequent months until your Projected balance sheet has been balanced for every month, including the Opening Month. To check if your Actuals are OOB, go to Data > Actuals Data > Enter Balance Sheet. To check if you Opening Month is OOB, go to Data > Opening Data > Enter Balance Sheet. Once you’ve balanced your Balance Sheet, you should be able to move the Actuals month forward.
To learn more about resolving your Out of Balance file, please click here for an article that you may find helpful.
2. There is only 1 month left in the forecast
For example: your forecast period is from July 16 to June 17 and you’ve imported your Actuals up to May 17. However when you try to import Actuals June 17, Castaway greys out the month of June and you’re unable to move the Actuals month forward.
This is because your forecast must always have at least 1 month of forecast available i.e. you cannot set the last month of a forecast to actuals.
To bring in Actuals June 17, you first need to extend your forecast period by at least 1 year.
Go to Data > Alter Forecast Dates and increase your Number of Years.
If none of these solutions resolved your issue, please contact our Support Team.