Skip down to the research record

Forecast category rules in 4 tools before the call

Quota Forecast Editorial Team · Published · 11 min read

The forecast category picks the column where a deal adds its value, according to Microsoft.

Key takeaways for which forecast category rules decide what is in or out of the number

  • The number on your weekly call depends on which column each deal sits in. Before the call, identify which of these labels your system uses to keep a deal out of the number.
  • Freshsales allows up to 5 forecast categories, and that five-category maximum is a Freshsales rule, so the same limit should not be assumed elsewhere Freshsales. The cap of 5 belongs specifically to Freshsales, not a universal standard.
  • HubSpot organizes deal stages into one of four forecast categories, a distinct grouping structure HubSpot. In HubSpot, "Not forecasted" describes deals that are in the pipeline for the current time period but are not included in the forecast HubSpot. The four groups belong to HubSpot's setup.
  • Microsoft uses the label "Omitted" to exclude an opportunity from all forecast totals Microsoft. The "Omitted" label belongs to Microsoft's opportunity capture.
  • When a deal is excluded from the total, the label varies by system. Close handles exclusion through status; marking an Opportunity with a "Lost" status removes the value from any expected revenue Close. The "Lost" status removal belongs to Close's opportunity statuses. Do not assume the same category names or limits apply across all four tools.

A category decides which column a deal adds to

The category rule determines which forecast column each opportunity contributes to, according to Microsoft. That placement decides whether the deal’s amount appears in the number you report on the weekly call. You must identify the specific column your system assigns to each open deal before you state the total. The column name defines the status of the deal within that specific vendor’s reporting structure. A deal placed in one column does not automatically appear in another column on the same grid. You need to check the category setting for every opportunity to know where its value lands. The system uses this assignment to build the forecast total for the period. If a deal is missing from the expected column, its category assignment is likely different from what you assumed. Verify the category for each deal before you calculate the sum. Do not assume that a deal in a high-confidence stage is in the same column as a deal in a lower-confidence stage. Check the settings page in your tool to see the exact list of columns available. Each column represents a distinct bucket for the forecast number. The total you report is the sum of the values in the specific columns you choose to include. Some columns may be excluded from the primary forecast number by design. You must know which columns count toward the number you will state on the call. The category assignment is the final step in determining a deal’s contribution to the forecast. It is not a label for the deal’s health, but a label for its reporting bucket. The column placement is the rule that separates deals in the number from deals left out.

A filled table of category rules by publisher

The table below lists the category rule for each publisher, the specific number or status on the page, and whether that status places a deal in or out of the forecast.

publishercategory rulenumber on the pagein or out of the forecast
FreshsalesYou can have up to 5 forecast categories5Five-category maximum
HubSpotUse the category dropdown menus to organize your deal stages into one of four forecast categories4Depends on the category; Not forecasted is out
MicrosoftOmitted: Exclude this opportunity from all forecast totalsOmittedOut of the forecast
CloseMarking Opportunities with a ‘Lost’ status removes the value from any expected revenueLostOut of the forecast

According to Freshsales, the system supports a maximum of five categories. According to HubSpot, deal stages are organized into one of four forecast categories. According to Microsoft, the Omitted category excludes an opportunity from all forecast totals. According to Close, marking an Opportunity with a ‘Lost’ status removes the value from any expected revenue.

Freshsales' cap of 5 and the committed and best-case words

The total number of forecast categories you can manage in Freshsales is limited to five. According to Freshsales, you can have up to 5 forecast categories. That cap defines the maximum structural depth of your forecast columns. Within this limit, the system provides a specific split between pre-loaded options and those you create yourself. Two categories are available in the application and 3 additional custom categories can be created, according to Freshsales. The three custom slots exist to meet your business needs, as stated by Freshsales.

Committed refers to deals that sales reps are confident of closing in the month or quarter, or by the expected close date, according to Freshsales. Best-case refers to deals that sales reps are optimistic about, but are not willing to commit to it just yet, according to Freshsales. This label captures potential revenue that is not yet firm.

You can adjust which category serves as the baseline for new deals. One of the categories can be set as default and this category cannot be deleted, according to Freshsales. This lock prevents accidental removal of the primary bucket. When you set the expected close date, the default category will be considered as the category for the deals, according to Freshsales. See why the date moved. This rule automatically assigns the default label to deals with a close date, streamlining data entry.

To prepare for the weekly call, verify your current configuration. Check if your three custom categories are defined and active. Confirm that the default category is set to the label you want for standard close dates. Ensure that Committed and Best-case are used consistently by your team. If you have not yet defined your custom categories, create them now to reach the full capacity of five.

HubSpot's four groups and the deals marked not forecasted

The "Set up the forecast tool" page defines how to organize deal stages using category dropdown menus. According to HubSpot, you use these menus to organize your deal stages into one of four forecast categories. See forecast categories explained. The page explicitly limits the organizational structure to these four distinct groups for the dropdown selection.

Two of these categories define the core of the forecast number. The first is Commit, which the source defines as deals that have a high likelihood of closing and have been committed to the forecast according to HubSpot. The second relevant category is Not forecasted, which covers deals that are in the pipeline for the current time period, but are not included in the forecast according to HubSpot. This specific rule clarifies that a deal can exist in the pipeline and still be excluded from the forecast number if it is assigned to this category.

On the weekly call, the distinction between these two labels determines whether a deal’s value is added to the total or left out. A deal marked as Commit is included in the forecast total because it has been committed to the forecast. A deal marked as Not forecasted is excluded from the forecast total, even though it remains in the pipeline for the current time period. The revenue leader must verify which category each deal stage is assigned to in the dropdown menu to ensure the number reported matches the system’s definition.

The source also notes a legacy option that appears in accounts created before March 20th, 2024 according to HubSpot. The date March 20th, 2024, is a cutoff for the visibility of this legacy amount option, not a category name or a forecast period.

To prepare for the call, check the category dropdown for each deal stage in your system. Confirm whether the stage is mapped to Commit or Not forecasted. If a stage is mapped to Not forecasted, its value is not included in the forecast number, regardless of its presence in the pipeline. Running this check confirms that the number you present matches the system’s categorization.

Microsoft's omitted column and the won or lost warning

The Omitted category excludes an opportunity from all forecast totals, according to Microsoft. When you review the grid before the weekly call, any deal marked Omitted is left out of the expected revenue calculation.

Do not type Won or Lost by hand on the opportunity record. Manually setting these statuses can cause the opportunity to disappear from the forecast or produce inaccurate rollup values, according to Microsoft. Instead, close the opportunity using the Close Opportunity dialog; the forecast category updates automatically, according to Microsoft. Completing this step allows the system to handle the status change and the category adjustment in one action.

Forecast values are only updated every 24 hours or can be refreshed manually anytime, according to Microsoft. This refresh rule applies to the grid display, not to the category names themselves. If you change a category or close a deal, the number on the page may not reflect that change until the next refresh cycle or a manual update.

Close on won value and lost value

The Opportunity Pipelines & Statuses page in the Close Help Center defines a Won status and a Lost status. Marking Opportunities with a ‘Won’ status will add the value as revenue in Reporting, according to Close. See open, won, and lost stage rules.

Marking Opportunities with a ‘Lost’ status removes the value from any expected revenue, according to Close. This rule is the specific mechanism that takes a deal out of the forecast number. When you change a deal to Lost, the system stops counting its value toward the expected revenue total. For Close, this is the "left out" action.

The distinction between these two statuses is the core of the in-or-out decision. On the call, you can say a deal is "in the number" if it is still open and counted in expected revenue. You say it is "left out" if it has been marked Won (adds the value as revenue in Reporting) or Lost (removed from expected).

Illustrative example of a weekly total

Picture 10 open deals before a weekly call. 4 sit in a category the call includes. 6 sit in a category the call leaves out. Read a total built from the 4 only. The 6 stay off that total. If 1 of the 4 is moved to the left-out category, the call uses the other 3. A later pass moves 2 more deals into the left-out group, and the included count remains 3. These figures are illustrative and belong to no named team.

Confirm the category for every deal in the pipeline before the meeting. This ensures the number you read matches the system’s calculation.

FAQ: Which forecast category rules decide what is in or out of the number

How many forecast categories can Freshsales hold?

You can have up to 5 forecast categories according to Freshsales.

What does HubSpot mean by not forecasted?

Not forecasted refers to deals that are in the pipeline for the current time period, but are not included in the forecast according to HubSpot. These deals remain visible in your pipeline view but do not contribute to the final forecast number.

What does Microsoft's omitted category do?

When you assign this status, the deal is removed from every aggregated forecast figure. This allows you to keep a deal in your system without it affecting your reported revenue expectations.

What happens in Close when a deal is marked lost?

This action ensures the deal no longer contributes to your projected sales figures. The value is stripped from the expected revenue calculation once the status is applied.

Does a 24 hour refresh rename a category?

No, the 24-hour rule refers to when forecast values are updated, not to renaming categories. Forecast values are only updated every 24 hours or can be refreshed manually anytime according to Microsoft. This timing applies to the data refresh process within the grid. It does not change the names or definitions of the forecast categories themselves.

Sources