Planning Using a Rolling Forecast

If your administrator enabled rolling forecast, you can plan using a rolling forecast in addition to, or instead of, standard forecasting. With rolling forecasts, you can perform continuous planning so you can plan beyond a one year horizon. Depending on how your administrator set up rolling forecast, you can plan continuously at a weekly level for either 13, 26, or 52 weeks, at a monthly level for either 12, 18, 24, 30, 36, 48, or 60 months, or at a quarterly level for either 4, 6, or 8 quarters. In an application with a 13-period calendar, you can plan continuously at a period level for 13 or 26 periods.

When your administrator updates the current time period, rolling forecast forms and dashboards are automatically updated to add or drop time periods to the reflect the updated rolling forecast range. Trends and drivers are populated to newly added time periods.

You can plan with a rolling forecast using:

  • Driver and trend-based planning.
  • Manually entering rolling forecast values.

Forms and dashboards using a rolling forecast range are available in each component: Revenue, Expense, Balance Sheet, and Cash Flow.

KPIs are available for reporting purposes:

  • TTM (Trailing Twelve Months). This scenario reports the activity in Flow based accounts over the prior twelve months.
  • Projected 12. For Flow type accounts, this scenario reports on the sum of (current period + 11 future periods). For Balance type accounts – this scenario reports on a member value 12 periods in the future.

Note:

Select the Rolling Forecast scenario member only for forms on the Rolling Forecast Rolling forecast icon tab.

Watch this overview video to learn more about planning using a rolling forecast.

video iconOverview Video.

Watch this tutorial video to learn more about planning using a rolling forecast.

video iconTutorial Video.

Table 3-2 Planning Using a Rolling Forecast

Task Goal More Information
Oerview icon Overview Get an overview of revenue, expenses, balance sheet, or cash flow over the rolling forecast range in a dashboard format. Analyzing Financials with Dashboards
Rolling forecast icon Rolling Forecast
  • For Revenue and Expense: Perform driver-based or trend-based planning over a rolling forecast range.
  • For Balance Sheet: Specify balance sheet drivers over a rolling forecast range.
  • For cash flow: Perform driver-based cash flow planning over a rolling forecast range.
Direct entry icon Direct Entry

Directly enter data, for example if your planning and forecasting does not have historic trends or specific business drivers.