View a forecast

Forecasts help you to see the health of your pipeline or to see how your sales team is doing against their quota or target.

Note

The forecasting feature is not supported on mobile devices.

License and role requirements

Requirement type You must have
License Dynamics 365 Sales Premium or Dynamics 365 Sales Enterprise
More information: Dynamics 365 Sales pricing
Security roles Any primary sales role, such as salesperson or sales manager
More information: Primary sales roles

Open and view a forecast

Bottoms-up forecasting is the projection of what a salesperson, team, or organization will sell in a given predefined period (month or quarter). Sellers can also use forecasts to track their performance by using assigned sales targets or quotas.

To view a forecast

  1. Review the prerequisites.

  2. Sign in to the Sales Hub app.

  3. At the bottom of the site map, select Change area Change area icon., and then select Sales.

    Icon to change area in the site map.

  4. Under Performance, select Forecasts.

  5. On the grid page, do the following:

    • Select a forecast from the drop-down list. Any forecasts for which you have permissions will appear here.

    • Choose the forecast period you want to see. Options in the drop-down list reflect the number of forecast periods defined in the forecast configuration. The default is the current period.

    Forecasts view page.

  6. The forecast grid displays all relevant columns as defined in the forecast configuration. The totals are aggregated by user or by territory, at each level of the hierarchy and for each period according to the forecast column attributes.

    For example, if you're using the out-of-the-box Forecast category on an org chart forecast, the grid will display the following information:

    • Users: Shows the hierarchy of users as defined by the Manager field. To learn more, see Forecasts and sales hierarchy.

    • Quota: A target amount set for a specific owner over a given time frame. The progress bar is calculated against this value.

    • Committed: Shows the aggregated (rolled-up) value of estimated revenue for all open opportunities that have the forecast category set as Committed (high confidence). This value can be adjusted during forecast.

    • Best case: Shows the aggregated (rolled-up) value of estimated revenue of all open opportunities that have the forecast category set as Best Case (medium confidence). This value can be adjusted during forecast.

    • Pipeline: Shows the aggregated (rolled-up) value of estimated revenue for all open opportunities that have the forecast category set as Pipeline (low confidence). This value can be adjusted during forecast.

    • Omitted: Shows the aggregated (rolled-up) value of excluded revenue for all open opportunities that have the forecast category set as Omitted.

    • Won: Shows the aggregated (rolled-up) value of revenue that's generated for all won opportunities that have the forecast category set as Won.

    • Lost: Shows the aggregated (rolled-up) value of revenue that's lost for all lost opportunities that have the forecast category set as Lost.

    Note

    The permissions granted during the forecast configuration affects who can view the forecast values. To learn more, see Provide viewing permissions.

Forecasts and sales hierarchy

Every forecast is attached to an organization-defined hierarchy that rolls up the values level by level. If the Org chart forecast template is used, the forecast is created based on the sales team hierarchy as defined by the manager role on the User record. Similarly, if the Territory forecast template is used, the hierarchy is based on the Territory manager lookup field.

For example, you created a forecast by using the Org chart forecast template. The hierarchy is defined based on the User record. If Alyce Durham is a sales manager with one direct report, and she's designated as manager in her direct report's User record, she'll see a forecast for herself and her direct report. Because Alyce Durham reports to Samuel Strom, Samuel will see his own forecasts along with the rolled-up forecasts of his direct reports, including Alyce's.

Forecasts for a manager and direct reports.

To see the rolled-up forecast for everyone in the hierarchy, expand a specific forecast.

Select a currency

When your sales teams are distributed across different geographies and viewing the forecast with organization's base currency might cause confusion for users in other geographies to analyze and understand forecast. The multi-currency selection option helps the sales teams to choose and convert the forecast data in real time based on the latest exchange rate to their convenient currencies defined in your organization, which help in better planning, organizing, and understanding the current forecast state.

Note

The real time conversion of forecast data always takes place based on the latest exchange rate defined in your organization.

For example, you have sales teams in the US and Europe. The base currency for your organization is defined as US Dollar and also, Euro is defined as one of the currencies. When you create forecast with multi currency enabled, sales teams open the forecast the data is displayed in Dollar. Sales teams in Europe can select currency as Euro and the forecast data is displayed in Euro. The conversion of currency happens in real time based on the current exchange rate. Also, manual adjustments can be made on the chosen currency.

Select currency drop-down.

Note

Administrator or forecast manager must enable the option to select currency. More information: Turn on multi-currency selection.

Tasks you can do on the forecast grid

Using the forecast grid, you can do the following tasks:

Can't find the options in your app?

There are three possibilities:

  • You don't have the necessary license or role.

  • Your administrator hasn't turned on the feature.

  • Your organization might be using a custom app. The steps described in this article are specific to the out-of-the-box Sales Hub and Sales Professional apps. Check with your administrator for exact steps.

See also

Project accurate revenue with sales forecasting
Configure a forecast
Analyze revenue outcome by using predictive forecasting
Forecasting FAQs
Troubleshoot issues with forecasting