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
tab.
Videos
Your Goal | Watch This Video |
---|---|
Learn about planning using a rolling forecast. |
|
Table 4-6 Planning Using a Rolling Forecast
Task | Goal | More Information |
---|---|---|
![]() |
Get an overview of revenue, expenses, balance sheet, or cash flow over the rolling forecast range in a dashboard format. | Analyzing Financials with Dashboards |
![]() |
|
|
![]() |
Directly enter data, for example if your planning and forecasting does not have historic trends or specific business drivers. |
|