Forecasting

Forecasting
Settings > Budgeting

If your organization uses Forecast for budget revisions, you will need to manually set up the Forecast for the new year. The usual procedure is to copy the final budget for the new year into a Forecast column so that the original budget can be locked down and revisions can only be made in the Forecast during the coming year.


Forecast Setup - Years
Settings > Budgeting > Years

  • Click New.  Enter the year and select Type Forecast.
  • Check the box. Disallow entry on specific dates if you wish to set date restrictions for when forecast changes can be made each month. The system defaults to the last day of each month, but these dates may be overridden. If this box is unchecked, forecast changes will be allowed in any month as long as the Allow Entry box is checked.
  • Allow Entry: opens the forecast for all users.  If at any time you want to stop all users from doing forecast entries, simply uncheck this box. No other permission settings need to be changed.

o The Account Restrictions button allows for restricting selected G/L accounts for entry in this forecast year. This setting may be changed at any time during the year. Allow entry box must be checked for this option to be available.

The User Restrictions button allows you to select specific users for which forecast entry for this year is open at this time. This setting may be changed at any time during the year. Allow entry box must be checked for this option to be available.

  • Allow change to an annual amount. Uncheck this box if you want to allow users to spread/respond to monthly amounts but not change the total annual amount on the G/L account’s forecast. 
  • See Budget Years for more information on these entry settings.
  • If you are not ready to generate the forecast at this time, you may stop here and generate the forecast amounts later using Budgets > Global Budget Changes. To generate the forecast now, proceed as follows.
  • Check the box to copy budgets from: (new year) Budget to (new year) Forecast. This will copy monthly, annual, and component details from the budget to the forecast. 
  • Check the box to copy allocations from: the (new year) Budget to the (new year) Forecast.
  • Click Save

Forecast Setup - Formats
Settings > Budgeting > Formats 

  • If no format changes are needed for the forecast for this year, the existing format remains in effect.
  • If the format name is defined for Budget Type All, this format will be used for both budget and forecast. You can have a different format for forecast with Budget Type Forecast and use the same Format ID/name as the budget format.
  • If you wish to make any changes to a format (columns, etc.), do not edit the existing format. Instead, create a new format name by clicking to highlight the format and click Copy. Remove the words - Copy from the name (format ID) and set the effective year for the new year and Budget Type Forecast. It is important that the name (Format ID) be exactly the same as the budget format so that components from the prior year can be viewed.
  • Make any format changes needed for the new year. If using columns for allocations, be sure the data slot number coincides with the appropriate allocation setup.

Forecast Setup -Allocations
Settings > Budgeting > Allocations 

  • The forecast year has its own allocation setups that might differ from the budget. If any rates have changed, simply make changes to the Forecast Allocation setups and recompute for the forecast if necessary.

ImportantYou will probably want to lock down the Budget for this year to ensure this is locked down for most users (or all users).  Using Settings > Budgeting > Years, double-click to edit the appropriate budget year and uncheck Allow Entry. Click Save.