I can't move the Actuals month forward

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 Forecast > Opening & Actuals and then selecting the new Actuals months.

There a 2 reasons why Castaway will not allow the Actuals month to be moved forward:

1. The Projected Balance Sheet is Out of Balance (OOB)
2. 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, click on the Balance Sheet Data tab in Opening & Actuals panel. To check if your Opening Month is OOB, click on the Profit & Loss Data tab instead. 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 the Setup work space and increase your Number of Years.

If none of these solutions resolved your issue, please contact our Customer Success team by submitting an online ticket HERE