Skip across the chapter
Quota Playbook

Forecast settings: 8 checks before a coaching 1:1

Quota Playbook Editorial Team · Published · 13 min read

Verify eight quota and forecast settings in your CRM before a coaching 1:1 so the numbers you discuss are visible and accurate.

Key takeaways

  • Assign each quota to a single user and a specific fiscal year, as stated in Nutshell.
  • Define data sources, hierarchy structure, and time periods when setting up a forecast model, according to Microsoft.
  • Limit your setup to a maximum of 5 forecast categories, according to Freshsales.
  • Regulate access for creating or editing quotas and viewing sales forecasts between team and hierarchy views, according to Freshsales.
  • Specify the entities required to generate the forecast, as defined by Microsoft.

Verify these five core settings before your next coaching conversation to ensure the numbers you discuss are accurate.

How to verify quota and forecast data before a 1:1

Start by confirming the fiscal year assignment for each team member. According to Nutshell, each quota is assigned to a single user and a fiscal year. This specific pairing is the first setting to check before reviewing performance metrics.

The title of this guide counts eight distinct settings you must verify. These include fiscal year assignment, hierarchy structure, forecast category limits, access permissions, data source definition, quota value copying, report visibility, and pipeline linkage. Each of these elements plays a role in how data appears during a coaching session.

Bring the Sales One-on-One Agenda for Coaching Software Sellers to that conversation once these settings are checked.

Your primary next action is to open your CRM's quota or forecast configuration page. Check the fiscal year against your company's financial calendar, and check the hierarchy structure against your current sales team structure. This step ensures the foundational data is correct before you dive into specific rep performance.

The scope of these settings varies by platform. Focus on the specific configuration options available in your system.

Review the hierarchy structure next. Ensure the reporting lines align with how you manage the team. The data must reflect the actual organizational structure you are coaching against.

Verify the fiscal year. Verify the hierarchy.

Defining the fiscal period and hierarchy

Before you open a coaching conversation, confirm that the time frame and reporting structure in your CRM match your current team. The first two items on your checklist are the fiscal year assignment and the hierarchy structure.

1. Fiscal year assignment

Verify that every quota is tied to the correct time period. This means you must check that the specific user has a quota linked to the current fiscal year. If a rep's quota is missing or attached to the previous year, the performance data you review in the 1:1 will be inaccurate.

To understand the scope of the period, consider how your organization defines its calendar. According to Microsoft, an organization's fiscal year might run from January 1 to December 31. Use this example to confirm whether your CRM's fiscal year boundaries align with your company's actual financial calendar. If your fiscal year starts in July, for instance, the CRM setting must reflect that start date to ensure the quota period is correct.

Read Forecast period setup: Settings from 4 vendors when you compare that start date with the period in your CRM.

2. Hierarchy structure

The second check is the hierarchy structure, which determines how individual data rolls up to team or company levels. According to Microsoft, you define the hierarchy structure to show how data rolls up. If the hierarchy is misconfigured, a manager might see aggregated data that obscures individual rep performance, making it difficult to coach specific behaviors.

Setting up forecast categories and data sources

Before you coach a rep on their numbers, confirm that the forecast categories in your CRM match how your team actually stages deals. The structure of these categories determines what data feeds into your pipeline view. If the categories are misconfigured, your 1:1 conversations may be based on incomplete or mislabeled stages.

In Freshsales, the system provides a fixed number of standard categories. According to Freshsales, two categories are available in the application. You can also create additional custom categories to fit your specific sales process. The platform allows for 3 additional custom categories to be created to meet your business needs. This means the total number of forecast categories you can have is up to 5. Verify that your team is using these categories consistently. If a rep moves an opportunity into a custom category, ensure that category is defined and visible to managers.

For Microsoft Dynamics 365 Sales, the setup involves defining the data sources that generate the forecast. According to Microsoft, you must define the entities that must be used to generate the forecast. This step ensures that the forecast model pulls from the correct records. If you do not specify the right entities, the forecast may exclude key pipeline items.

When setting up these categories, avoid assuming that all CRMs use the same default number. Each platform has its own limits. For example, Freshsales caps custom categories at 3, while other systems may differ. Instead, verify the limits for your specific CRM. If you are using Freshsales, confirm that you have not exceeded the 5-category limit. If you are using Microsoft Dynamics 365, confirm that the forecast model is linked to the correct entities.

To summarize this section: 1. Check the number of forecast categories available in your CRM. 2. Verify that custom categories are created and visible in reports. 3. Confirm that the data sources for your forecast model are correctly defined. 4. Test any changes in a safe environment before applying them to live data.

Documented quota and forecast rules

The table below lists the specific configuration rules documented by each publisher. Use this reference to verify that your CRM settings align with the documented behavior before your next coaching session.

Publisher Setting Rule
Nutshell Reporting visibility Quotas roll up into monthly totals for reporting and visibility, according to Nutshell.
Nutshell Report display The Forecast Report will show you your sales and projected sales compared to your quota, according to Nutshell.
Microsoft Fiscal year example Let's say your organization's fiscal year runs from January 1 to December 31, according to Microsoft.
Microsoft Hierarchy structure In this step, you define the data sources for your forecast (which records to include), the hierarchy structure (how data rolls up), and the time periods (monthly, quarterly, annually), according to Microsoft.
Freshsales Category limits You can have up to 5 forecast categories, according to Freshsales.
Freshsales Category limits Two categories are available in the application and 3 additional custom categories can be created, according to Freshsales.
Freshsales Custom categories Custom: 3 additional custom categories can be created to meet your business needs, according to Freshsales.
Freshsales Pipeline linkage Gauging the potential of deals in your pipeline and being able to use that to project revenue for a given week/month/quarter can be handy when it comes to assigning and fulfilling sales quotas, according to Freshsales.
Freshsales Access permissions You can regulate access to create/edit quota, commit deals and view sales forecasts between team and hierarchy views, according to Freshsales.
Freshsales Dashboard access All sales quotas and forecasted revenues can be accessed from the Sales Forecast dashboard, according to Freshsales.
Microsoft Opportunity visibility Getting visibility into the underlying opportunities that are contributing to the forecast values helps the sales team to focus on specific opportunities and take action, according to Microsoft.
Microsoft Manual upload rules Underlying opportunities won't be displayed 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.
Microsoft Role based visibility The opportunities you see in the table depend on the role assigned to you in the hierarchy that was used to configure the forecast, according to Microsoft.

Verify your current settings against these documented rules to ensure your data is accurate.

Assigning targets and managing access rights

Before you assign numbers to your team, confirm that your CRM plan actually supports quota tracking. According to Nutshell, sales quotas are available on Nutshell Growth and above. If your organization is on a lower tier, the feature will not be present in the interface, so verify your subscription level before attempting to configure targets. This plan requirement applies specifically to the Nutshell platform as described in their help documentation.

Once you have confirmed plan availability, you can streamline the assignment process. According to Nutshell, quota values can be copied between users to simplify setup. This functionality is useful when multiple reps share similar target structures or when you are onboarding new team members with identical baseline goals. You can use this copying feature to reduce manual entry errors and ensure consistency across the team. Note that this capability is specific to Nutshell's quota management system.

Managing who can see and edit these numbers is just as important as setting them. According to Freshsales, you can regulate access to create/edit quota, commit deals and view sales forecasts between team and hierarchy views. This means you can control which users have permission to modify quota figures and which users can only view them. You can also distinguish between team-level access and hierarchy-level access, allowing you to tailor visibility based on reporting lines. This granular control helps maintain data integrity by ensuring only authorized personnel can alter forecast commitments.

When configuring these permissions, consider your team's structure. If your sales organization operates with distinct teams, you may want to limit quota editing to team leads. If you rely on a hierarchical reporting structure, you might grant broader view access up the chain of command. The ability to regulate access between these two views provides flexibility in how you enforce data governance.

Verifying visibility and pipeline linkage

Report visibility and pipeline linkage determine whether the numbers you discuss in a 1:1 actually reflect the deals on the ground. Before you sit down with a rep, confirm that the reporting layer and the underlying opportunity data are aligned and accessible to you.

Report visibility In Nutshell, quotas roll up into monthly totals for reporting and visibility, according to Nutshell. The same source notes that the Forecast Report will show you your sales and projected sales compared to your quota, according to Nutshell. Verify that your team's monthly totals appear in the report. If the report shows a gap between projected sales and quota, you have a specific number to address in the coaching conversation.

Pipeline linkage Freshsales notes that gauging the potential of deals in your pipeline and being able to use that to project revenue for a given week, month, or quarter can be handy when it comes to assigning and fulfilling sales quotas, according to Freshsales. When the conversation turns to open deals, walk through Deal stage progress: 7 checks for weekly coaching.

Opportunity visibility Microsoft states that getting visibility into the underlying opportunities that are contributing to the forecast values helps the sales team to focus on specific opportunities and take action, according to Microsoft. However, Microsoft also notes that underlying opportunities won't be displayed 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. If your quota column is a manually uploaded value, you cannot drill down to individual deals from that column. Confirm whether your quota field is linked to opportunities or manually uploaded before you ask a rep to explain a specific number.

Illustrative example of a team forecast check

In this illustration, a manager prepares one coaching conversation for a team of 10 and checks 8 forecast settings. The fiscal year in view covers 365 days. The forecast uses 2 categories already in the application and 3 custom categories, 5 in all. The manager copies one quota figure to all 10 people, then opens the report of sales and projected sales compared with the quota. The check takes 30 minutes.

Action step

Open your CRM's forecast configuration page and verify that the fiscal year matches your company's financial calendar and that the hierarchy structure correctly rolls up data for the teams you manage.

FAQ: How to verify sales quota and forecast settings before a coaching 1:1

How many custom forecast categories can I create in Freshsales?

You can create 3 additional custom categories, and the 2 categories available in the application make a total of 5, according to Freshsales. This limit applies specifically to the Freshsales platform as documented in their support materials. You should verify this count against your current configuration to ensure it aligns with your team's forecasting needs.

Can I copy quota values between users to simplify setup?

Yes, Nutshell permits copying quota values between users to simplify setup according to Nutshell. This feature helps streamline the initial assignment process for new team members. Use this capability to maintain consistency across similar roles without manually entering each value.

Which opportunities show in the forecast table?

You see the opportunities that match the role assigned to you in the hierarchy used to configure the forecast.

Which plan level is required to use sales quotas in Nutshell?

Sales quotas are available on Nutshell Growth and above according to Nutshell. If your organization is on a lower plan tier, this feature will not be accessible. Confirm your current subscription level before attempting to configure quota tracking for your sales team.

How does the forecast report display sales compared to quota?

This view provides a direct comparison between actual performance and assigned targets. Review this report before your 1:1 meetings to ground the conversation in accurate, system-generated data.

Sources

  1. Call handling: 9 rules to check before coaching
  2. Overtime errors for non-exempt sales reps: 5 fixes
  3. Check 8 sharing limits before sending coaching files
  4. Coaching note dates
  5. Role play practice numbers

More plays