Four checks: a hand-uploaded quota column, a goal gap, a manager quota line, and one user with a fiscal year.
Key Takeaways
Keep the target number and the deal total on separate lines before the weekly call. The four checks below come from the specific documentation for Microsoft, HubSpot, Freshsales, and Nutshell.
- Verify that the quota column does not list the deals underneath it. In Microsoft, underlying opportunities are not displayed for Quota and simple column types because no opportunities contribute to calculating their values, and you manually upload these values through an Excel workbook Microsoft.
- Calculate the gap as the difference between the Goal amount and the Closed Won amount. In HubSpot, the gap is defined specifically as the difference between the Goal amount and the Closed Won amount HubSpot.
- Confirm that the manager’s quota appears as its own distinct line item. In Freshsales, the quota of the team members rolls up to the managers, and the manager’s quota is also displayed as a separate line item Freshsales.
- Check that each quota is assigned to a single user and a fiscal year. In Nutshell, each quota is assigned to a single user and a fiscal year Nutshell.
Setting a sales quota helps you quantify your team’s sales performance and help motivate your team towards meeting the revenue targets, according to Freshsales. This definition frames the quota as a target for motivation and measurement.
The quota line is a target, and the open deals are a different figure on the same screen
The quota line is a target, and the open deals are a different figure on the same screen. The four checks in the title come from Microsoft, HubSpot, Freshsales, and Nutshell.
A quota is not the pipeline. Adding them together creates a false total. The goal is to keep the two figures distinct so the weekly call reflects reality.
Keep them separate.
The table provides a clear reference.
A filled table of the quota line and the deals, by publisher
The following table gives one quoted rule for each of the four publishers from their documentation.
| Publisher | Quota/Goal Definition | Separation from Deals |
|---|---|---|
| Microsoft | Values are manually uploaded through an Excel workbook according to Microsoft. | Underlying opportunities won't be displayed for Quota and simple column types, because no opportunities contribute to calculating their values according to Microsoft. |
| HubSpot | The Goal amount is a distinct figure in the forecast tool according to HubSpot. | Gap is the difference between the Goal amount and the Closed Won amount according to HubSpot. |
| Freshsales | The manager’s quota is displayed as a separate line item according to Freshsales. | The quota of the team members would roll up to the managers, keeping the manager’s quota distinct according to Freshsales. |
| Nutshell | Each quota is assigned to a single user and a fiscal year according to Nutshell. | The quota is tied to one user and year, according to Nutshell. |
Each row above names the publisher and one quoted rule. Microsoft’s quota column does not list the deals underneath it, as the values are uploaded manually without opportunity contribution. HubSpot defines the gap by subtracting closed won from the goal, ensuring the target is not confused with the won amount. Freshsales displays the manager’s quota as its own line item, separate from the rolled-up team quotas. Nutshell assigns a quota to a single user and a fiscal year. Before the weekly call, verify that your screen displays these figures on separate lines to prevent accidental addition.
Microsoft's quota column has no deals under it, and the schedule example is a fiscal year
In the "View and manage underlying opportunities" documentation, the system does not display underlying opportunities for Quota and simple column types because no opportunities contribute to calculating their values; you manually upload these values through an Excel workbook, according to Microsoft. This structural separation means the quota line on the screen is a standalone figure, not a sum of open deals. When you look at the column, you are looking at a manually entered target, not a live calculation of pipeline activity. The absence of linked opportunities is the key check. Simple column types match it, so an empty column is not a quota alone.
The scheduling documentation provides a specific example of how forecast periods are defined. It states, "Let's say your organization's fiscal year runs from January 1 to December 31," according to Microsoft. This date range is an example for the organization in the documentation, not a universal requirement for every company. The guide then explains, "To schedule a monthly forecast for the fiscal year 2023, select the values as follows," according to Microsoft. The fiscal year 2023 is the specific timeframe used in this scheduling example. See Forecast period rules: read 4 before the weekly number.
When you add the schedule described in the example, the system generates the periods. The documentation notes, "When you add the above schedule, 12 forecast periods are added to the Periods for this forecast table on the right side," according to Microsoft. The number 12 refers specifically to the periods added in this monthly scheduling scenario for the example fiscal year. It is a result of the specific schedule selected in the example, not a fixed limit for all forecast models.
These details clarify the nature of the quota line in this context. The quota value is uploaded manually through Excel, independent of the opportunities in the system. The fiscal year dates, the specific year 2023, and the resulting 12 periods are part of the scheduling example provided in the "Define and schedule a forecast model" guide. They illustrate how periods are created for a forecast model, but they do not define the quota itself. The quota remains a manually uploaded figure that sits apart from the deal data.
HubSpot's gap is the goal amount minus closed won
In the "Use the forecast tool" documentation, the gap is defined as the difference between the Goal amount and the Closed Won amount, according to HubSpot. This calculation treats the goal and the closed-won revenue as two separate inputs that produce a third figure: the gap. The gap is the arithmetic result of subtracting the second from the first.
See Open, won, and lost stage rules in 4 sales tools.
The setup process for this tool involves setting forecastable revenue goals for team members, according to HubSpot. This step establishes the target figure that will later be compared against actual closed-won revenue to calculate the gap. The goal is assigned to individual team members. The gap therefore reflects the remaining distance to the target, not the total value of open deals.
When preparing for the weekly call, ensure the goal amount and the closed-won amount are identified as distinct figures before calculating the gap. The gap is not a measure of pipeline coverage; it is a measure of progress toward the target. If the closed-won amount is zero, the gap equals the goal amount. If the closed-won amount exceeds the goal amount, the gap is negative. The open-deal total is not part of this specific calculation. The gap is derived solely from the goal and the closed-won revenue.
Freshsales shows the manager's quota as its own line, and Nutshell ties a quota to one user and a year
In the Sales Forecasting dashboard, all sales quotas and forecasted revenues can be accessed from the Sales Forecast dashboard, according to Freshsales. The quota of the team members rolls up to the managers, and the manager’s quota is also displayed as a separate line item(s), according to Freshsales. This distinct line item keeps the manager's target visually separate from the individual team member quotas on the same dashboard. When you review the weekly numbers, look for this specific separate line item to ensure the manager's goal is separate from the team members’ quotas. The separation is structural in the display, not just a matter of calculation.
Nutshell assigns each quota to a single user and a fiscal year, according to Nutshell. This one-to-one assignment between a user and a fiscal year prevents a single quota figure from being shared across multiple representatives. Quotas roll up into monthly totals for reporting and visibility, according to Nutshell. Sales quotas in Nutshell allow administrators to define sales targets for individual users and track performance across months, quarters, and years, according to Nutshell. When preparing for the weekly call, verify that the quota figure for each user is tied to that specific user's fiscal year assignment.
To apply these checks, identify the separate line item for manager quotas in Freshsales and the single-user fiscal year assignment in Nutshell. This verification step helps maintain the distinction between the target and the pipeline before the numbers are added together in the weekly review.
Illustrative example of a target and closed work
Target 95 minus closed work 20 leaves gap 75. Open items 10, 10, 10, and 25 sum to 55. Closed work of 0 leaves gap 95. Do not add the target to the open sum.
A next step for the quota and the open-deal total on your screen
Today, match one check on this page to your screen. This note is an editorial recommendation for your own screen; it is not a product setting. Keep the two numbers apart so the quota line is never read as the open deals.
Sales quotas are available on Nutshell Growth and above, according to Nutshell.
Quota line FAQ
Does Microsoft show deals under a quota column?
No, underlying opportunities are not displayed for quota column types because values are manually uploaded through Excel. According to Microsoft, no opportunities contribute to calculating these values. This separation keeps the target distinct from the pipeline figures.
What is HubSpot's gap?
The gap is the difference between the Goal amount and the Closed Won amount, according to HubSpot. It does not include open deals in its calculation.
Where does Freshsales show quotas?
Quotas are accessed from the Sales Forecast dashboard and displayed as separate line items for managers. According to Freshsales, team member quotas roll up to managers. The manager’s quota appears as its own distinct line item.
How does Nutshell assign a quota?
Each quota is assigned to a single user and a fiscal year. According to Nutshell, this structure ties the target to one person and one period. The system rolls these assignments up into monthly totals.
What do fiscal year 2023 and 12 periods refer to?
These are Microsoft's scheduling example values for a monthly forecast, not requirements for every company. According to Microsoft, the example assumes a fiscal year runs from January 1 to December 31. This specific date range illustrates the scheduling setup without implying universal applicability.
To check a quota against what your reps can carry each quarter, the Quota Forecast Quarter Shape Workbook has a team capacity sheet that counts each rep's start date, ramp time and share of quota hit, and splits the yearly number by quarter and month.