Questions? We have answers.

Forecasting: overview

  • Updated

Summary

Forecasting helps you establish an independent, data-driven baseline expectation using historical general ledger data.

The feature provides 12-month baseline forecasts for operating revenue and operating expenses. You can use these results to review projected financial trends, compare results against management's forecast, identify areas that may require further inquiry, and support your forecasting procedures.

Forecasting supports your assessment but does not determine whether an entity is a going concern or replace management's forecast. Apply professional judgment when interpreting forecast results and determining whether additional audit evidence is required.

Note: Forecasting is available to eligible customers and must be enabled before use. Contact your Customer Success Manager to learn more or request access.

How forecasting works

Forecasting uses historical general ledger data to generate separate baseline forecasts for:

  • Operating revenue
  • Operating expenses

The forecast displays historical results alongside projected results to help you establish an independent expectation of future financial performance.

For operating revenue and operating expenses, the forecast uses historical cumulative balance patterns to estimate expected future activity.

A 95% confidence interval is included to illustrate a range of reasonably possible outcomes. Forecast results are estimates based on historical evidence and should not be interpreted as predictions of future results.

Using forecasting

You can use forecasting to:

  • Establish an independent baseline forecast using historical general ledger data.
  • Review projected trends in operating revenue and operating expenses.
  • Compare forecast results against management's forecast and assumptions.
  • Identify significant differences or financial trends that may require further investigation.
  • Support discussions about forecast assumptions and forecast reasonableness.
  • Export forecast graphs and supporting data for use in working paper documentation.

Review forecast results

Forecasting provides interactive visualizations of historical and projected financial information.

Depending on the forecast, you can:

  • Review historical and projected results in a visual graph.
  • Switch between balance and flow views, where available.
  • Review forecast data by monthly, quarterly, or yearly periods.
  • Hover over the visualization to review additional details.
  • Zoom in to review specific periods and trends.

When reviewing forecast results, consider whether projected changes indicate areas that require further inquiry or additional audit evidence.

Export forecast results

You can export forecast graphs and supporting data tables for use in working paper documentation.

Exported results can help document the independent expectation used when reviewing management's forecast and provide supporting evidence for your forecasting procedures.


Considerations

Forecasting uses historical general ledger data and observed business patterns to establish a baseline. Historical activity may not always reflect an entity's current or future operating conditions.

Consider whether additional evidence or professional judgment is required when:

  • The entity has experienced significant structural changes.
  • The entity has undergone acquisitions or disposals, introduced new business lines, or changed accounting policies.
  • Historical data may not reflect current or future operating conditions.
  • There are known liquidity issues, covenant concerns, or funding constraints.
  • External market conditions have changed significantly.
  • Management's forward-looking assumptions are not reflected in historical general ledger activity.
  • Forecast results differ significantly from management's forecast.
  • The lower end of the forecast range indicates potential concerns.

Forecast outputs should be interpreted as estimates based on historical evidence, not guaranteed predictions of future results.

Note: Forecasting does not currently support currency conversion across multi-currency datasets. To avoid distorted forecast results, use the forecast only with datasets presented in a single reporting currency.

Was this article helpful?