Working with Zoho CRM Sales Forecast Module

Working with Zoho CRM Sales Forecast Module

What is a sales forecast?

A sales forecast is similar to a weather forecast, where you predict the weather based on various factors like humidity, precipitation, air speed, wind speed, and so on. This prediction drives decisions like what you wear, what you need to buy, where you can go, and so on.

A sales forecast is an estimate of how sales will fare in the upcoming fiscal period or quarter. Once a forecast is made, businesses and teams can allocate resources based on the expected revenue. As you progress through that month or fiscal period, you can track your actual achievement against the sales target.

Using sales forecasts, decision makers and the sales force can plan their activities for the upcoming fiscal period or quarter. In addition, forecasts help businesses allocate resources efficiently, monitor performance compared to expectations, and guide sales strategies.

For example, if your sales goal is to close 10,000 deals in Q1, then:
  1. You can set appropriate targets for your team members to achieve this goal by the end of the quarter.
  2. With every individual's progress, you will be able to decide how close you are to achieving the goal.
  3. The gap between the target and the achievement will tell you the percentage by which you are likely to fall short.
  4. Identifying deviations and the reasons behind them lets you stay ahead of the curve when it comes to reaching your sales goals.

What are the benefits of sales forecasting?

Let's consider weather forecasting as a non-sales analogy. Weather forecasts provide predictions about upcoming weather. These predictions help different people make better decisions:
  1. Event organizers can plan outdoor activities or events.
  2. Farmers can plan irrigation, planting, and harvesting.
  3. Pilots can decide flight routes and schedules.
  4. Communities can prepare for extreme weather or natural disasters.
  5. Energy companies can use forecasts for demand planning, and so on.
In a similar manner, sales forecasts help drive decision-making in an organization:
  1. Sales teams can set realistic targets, measure performance, and decide sales strategies.
  2. Marketing teams can plan campaigns effectively.
  3. Finance teams can use forecasts for budgeting and financial planning.
  4. Operations teams can manage inventory and production, and so on.
In particular, sales forecasting helps sales teams:
  1. Understand their pipeline better
  2. Set realistic targets to achieve
  3. Monitor sales progress from beginning to end
  4. Take necessary actions during the process to accelerate goal achievement
  5. Define upcoming forecast accurately based on results from the current forecast

Availability

Users with administrative privilege can configure forecasts (manage settings that affect all forecasts). Forecasts managers, users in the highest role, and admins can create forecasts.
The number of forecasts that can be created depends on the subscribed edition:
  1. Standard - 5
  2. Professional - 10
  3. Enterprise - 15
  4. Ultimate - 20

Business Scenarios

You can create multiple forecasts in Zoho CRM by using the following parameters individually or in combination:

Condition-based forecasting: To estimate the marketing budget for premium deals, you should find the revenue that will be generated from these deals. While creating a forecast, you must set the conditions such that only premium deals are considered.
If the premium deals in your business come from a particular industry, you can set the industry as "XYZ" or if premium deals are always above $10,000, you can set the condition accordingly. This way, your forecast will be generated only for certain kinds of deals.

Region-based forecasting: If you want to estimate the budget or decide the quantity of raw material to stock for a region, you must find out the sales trends in those regions.
The sales forecast for an individual territory will tell you the number of targets achieved or missed. The gap will show the percent increase or decrease in the target achievement based on which you can plan the next steps.

Currency or quantity-based forecasting: You can estimate the revenue, expenditure, cost, quantity, or number of entities by creating amount-based forecasts or number-based forecasts.
For example, if the total number of deals is more than the targeted number, then you must gear up inventory as the forecast points to increased selling. Similarly, if the number is way below the target, it would be best to avoid pouring funds into procuring more material.

Time-based forecasting: You can set a target for the current or future quarter to plan your expenses. Monthly targets can help prepare your business for the upcoming months.
If you notice a dip in deal closures, you can forecast lesser revenue generation for the month and thus cut down a few expenses to meet other essential expenditures. Likewise, if there is an increase in deal closure, you may have to take a look at other budgetary measures.

How to plan your forecast in Zoho CRM

Before you start creating a forecast, decide the following:

Purpose of the forecast: Define the rationale of the forecast by deciding what you want to estimate:
  1. Region-wise revenue generation or units sold
  2. Increase or decrease in overall sales
  3. Team sales growth or dip
  4. Performance of high value deals.
What do you want to forecast (amount or quantity): Based on the above decision, choose whether you want to estimate a money-related metric or a quantity. You can forecast deals based on revenue or number. The data you want to forecast must be captured in a currency or number field in the records of the Deals module.

How do you want the targets to be defined: Depending on your organization's requirements, a forecast's target can be set in a top-down or bottom-up manner.
  1. In the top-down model, the target is set for the business as a whole by a small group of managers or a forecasting team. This target is then dis-aggregated across different roles/territories/managers and users. In Zoho CRM, admins and users in the highest role/ position set the overall target. Targets for lower levels of the hierarchy are usually set by forecast managers by splitting up this overall target.
    This is simpler and quicker to create as fewer users are involved. The small team of managers can use their strategic perspective to set accurate targets for your business. For example, you can effectively consider macro-economic forces and set targets after considering how they will affect different parts of your business. The drawback is that accuracy may be an issue, as most users are not involved in setting targets.
  2. In the bottom-up model, you set targets for the lower levels of the hierarchy, and the organization-wide target is summed up from these smaller targets. Usually, this means that users set targets for themselves, which are approved by their managers or someone higher up in the hierarchy. This takes more work and time, as many people are involved, and there may be a few rounds of rejections before submitted targets are approved. The upside is that it could result in more accurate forecasts as it uses the local knowledge present at different levels of the organization.
How are targets assigned: Depending on your business model, you can either have a role, reporting, or territory-based hierarchy. You can set targets for one of the following hierarchies at a given time:
  1. If your company follows a role hierarchy, the target can be set among users in various roles and sub roles.
  2. If your company follows a reporting hierarchy, then the target can be distributed among individuals and their reporting managers.
  3. If your company has different product lines or region-based selling and thus adheres to territorial hierarchy, each territory, sub territory, and users within them will be allotted a certain target.

Forecast configuration

In Zoho CRM, forecast configuration is the foundation for all the forecasts you will be creating. In other words, the forecast model, fiscal year, field used for forecast estimation, and so on will apply to all the forecasts that you create in Zoho CRM. This can only be set by users with admin profiles.
Note
  1. If the forecast configuration is edited, the current and future forecasts that are based on the old configuration will be deleted. Completed forecasts will be archived.
  2. Changing the fiscal year of your organization will delete all the existing forecasts as well as the archived forecasts.

Forecast configuration includes:
  1. Forecast model: By default, the top-down model is selected. You can switch to the bottom-up model if that suits your organization.
  2. Hierarchy based on which the forecast will be created: By default, role and territory hierarchies will be displayed. If reporting hierarchy is enabled, role hierarchy will be replaced with reporting.
  3. Forecast based on deal revenue or deal quantity: You can select both options to create amount and unit-based forecasts or choose one. A system-defined field (count of deals), all standard and custom currency fields, and number fields will be available.
  4. Fiscal year and its display: Manage the fiscal year settings at Setup > General > Company Settings > Fiscal Year.

To configure forecast setting
  1. Log in to your CRM account with administrator privileges.
  2. Go to the Forecasts module.
  3. In the Forecast homepage, click Configure Forecast.
    If you have already created Forecast Configuration, click the More button (...) and select Edit forecast configuration to make changes.

  4. In the Create/Edit Forecast Configuration page, do the following:
    1. Choose the forecast model: Top down or Bottom up.
    2. Choose the Hierarchy: Role/Reporting or Territory.
    3. To choose the forecast type:
      1. Select Deal Revenue and choose a currency field from the drop-down.
      2. Select Deal Quantity and choose a number field from the drop-down.
    4. Fiscal year and its display will reflect the configuration at Setup > General > Company Settings > Fiscal Year. Click Manage to go there.
  5. Click Save.

CRM users and forecasts

Forecast managers

A forecast manager can create forecasts and set targets.  In the reporting and territory hierarchy, the respective managers (reporting manager/ territory manager) are automatically considered as the forecast managers. In role hierarchy, a forecast manager can be manually assigned by CRM users who have the permission to manage roles in their profile.

A forecast hierarchy can have multiple forecast managers. In role hierarchy, there can only be one forecast manager for a particular role. For example, a user from the regional sales manager role, a user from the strategic account executive role, and a user from the sales executive role can be forecast managers.

To assign a forecast manager in role hierarchy

  1. Log in to the CRM account as an administrator.
  2. Navigate to Setup > Security Control > Roles and Sharing > Roles.
  3. Hover over a role and click Add manager.

  4. In the Add Manager popup, select a User and click Save.

To change a forecast manager in role hierarchy

Once a forecast manager is selected for a particular role, you cannot remove them for the respective role. You can assign another user in the same role as the forecast manager.
  1. Edit a role or hover on the Manager icon.
  2. In the Edit role page, under Forecast Manager, select a User.
  3. Click Change.
For assigning reporting managers (reporting hierarchy), see: Reporting hierarchy.
For learn more about territory hierarchy and territory managers, see: Using Territories.

Who can create forecasts and set targets?

CRM admins can set the forecast configuration and create forecasts. Other users can perform various actions depending on their position in the hierarchy and the forecast model chosen.

If top-down model is chosen

User type
Forecast-related actions
CRM admin

  1. Set forecast configuration
  2. Create forecasts
  3. View and set targets for all users and other unit, such as:
    1. Roles and sub-roles in the role hierarchy
    2. Territory and sub-territory in the territory hierarchy
    3. Reporting managers in the reporting hierarchy
User in highest role (Role hierarchy) or position (Reporting hierarchy)

  1. Create forecasts
  2. View and set targets for themselves.
  3. View and set targets for all users and other units, such as:
    1. Roles and sub-roles in the role hierarchy
    2. Territory and sub-territory in the territory hierarchy
    3. Reporting managers in the reporting hierarchy
Forecast manager

  1. Create forecasts
  2. View and set targets for themselves.
  3. View and set targets for:
    1. Their peers (in the same role) and users in sub-roles in the role hierarchy
    2. Their peers (other territory managers), own territory and its sub-territories, and users in sub-territories in the territory hierarchy
    3. Their subordinates in the reporting hierarchy
Other users
  1. View their assigned target

If bottom-up model is chosen

User type
Forecast-related actions (actions in bold are specific to the bottom-up model)
CRM admin

  1. Set forecast configuration
  2. Create forecasts
  3. Lock forecasts
  4. Notify users to submit targets
  5. Approve/reject/revise submitted targets
  6. Bulk approve/reject submitted targets
  7. View and set targets for all users
User in highest role (Role hierarchy) or position (Reporting hierarchy)

  1. Create forecasts
  2. View and set targets for themselves.
  3. Notify users to submit targets
  4. Approve/reject/ override submitted targets
  5. View and set targets for all users.
Forecast manager

  1. Create forecasts.
  2. Notify the following users to submit targets:
    1. Peers (in the same role) and users in sub-roles to submit targets in the role hierarchy
    2. Peers (other territory managers) and users in own territory and its sub-territories in the territory hierarchy
    3. Subordinates in the reporting hierarchy
  3. Approve/reject/ revise submitted targets from the above list of users.
  4. View and set targets for:
    1. Themselves, their peers (in the same role), and users in sub-roles in the role hierarchy
    2. Their peers (other territory managers) and users in their own territory and its sub-territories in the territory hierarchy
    3. Their subordinates in the reporting hierarchy
Other users

  1. View their own target
  2. Submit their own target

Note
  1. If a forecast manager in a superior role edits the target of their subordinate roles, then the target will be locked. This happens only in cases where the forecast manager creates the forecast. Hence, the forecast manager in those subordinate roles will not be able to edit the target. That is, if the sales manager's or sales reps target is edited by the senior sales manager, then their targets will be locked. Any forecast manager from sales manager or sales rep role will not be able to edit it.
  2. In the case of role hierarchy, one user from a role can be selected as the forecast manager. There can be multiple forecast managers within the hierarchy. For example, Amelia can be a forecast manager for the sales manager role while Joseph can be one for the account executive role, and so on.
  3. In the reporting hierarchy, reporting managers, that is users who have subordinates reporting to them, are the forecast managers.
  4. In the territory hierarchy, territory managers are the forecast managers.

Creating forecasts

Overview

CRM admins, users in the highest role or position, and forecast managers can create forecasts. Forecast configuration (managed by CRM admins) will serve as the basis for any forecast that you create.

For every single forecast, you need to set the
  1. Forecast type: A forecast tracks a single metric. This can be either money-based or quantity-based. If you want to make both types of estimations, you must create two different forecasts. Remember that the forecast will be based on the field selected in the forecast configuration.
  2. Forecast period: You can draw forecasts for the previous, current, or future quarter or month. For example, revenue generated every quarter or the number of deals closed every month.
    Currently, we are supporting forecasts for two previous years and one future year.
    In case you've chosen a custom fiscal year pattern, the forecast period can be either a quarter or a period. The monthly option will only be available if you've chosen the standard fiscal year pattern.
  3. Forecast for all or selected deals: You can create exclusive forecasts for certain kind of deals by defining criteria such as revenue generated from premium deals, number of deals closed in the US, deals amount above 15,000 USD, and so on. Likewise, you can create multiple forecasts with different criteria.
  4. Set target: The target will be set for the field (revenue or quantity) you want to forecast.

Setting Targets

The way targets are set will depend on the forecast model selected in forecast configuration.

If it is top-down, you'll set a target for the organization and break it down into smaller targets for other entities (roles, territories, reporting managers) in the hierarchy. Finally, targets are assigned for individual users. This is an approach where the targets are set and driven from the top to the bottom of the hierarchy. Most users will not be involved in setting the target.

If the split-up doesn't match with the total target, then a warning icon will be displayed showing the incorrect amount. You can adjust the values to meet the total target amount or continue to save the forecast despite the mismatch.

If it is bottom-up, targets are set for different users, and these will get summed up as the organization's target. For example, if you've assigned and approved targets for every user in a role hierarchy, the individual targets will get rolled up into targets for roles. In turn, the roles' targets will be summed up as the organization's target.
While you, as the admin or forecast manager, can set the target for other users in the hierarchy, the true power of the bottom-up approach is unlocked when users are asked to submit their own targets.
Admins and forecast managers can approve, reject, or revise these targets. Engaging everyone in the process lets you take in more information and come up with a more accurate forecast, but it may take longer and involve more resources.
Note
  1. When setting a target for a user, a popup will appear that shows the deals in various states in the pipeline to give a better picture. The deals are split into open and closed won deals, with open deals being further split into pipeline, best case, committed deals, and custom forecast categories (if you've configured them). If enough data is available, Zia's predicted target will also be available for your reference.
  2. Role hierarchy
    1. Only one role can be assigned to a user, so a user can only have one target, as per the forecast.
    2. If you want to assign the same target value to the users in that role, you can click on Apply this target to all peers option. This option will appear ONLY while entering the target value for the first user in a role and if the model is top-down.
  3. Territory hierarchy
    1. If a user belongs to multiple territories, they can be assigned different targets in each territory. Therefore, one user can have more than one target from different territories.
    2. Let's say a territory (Europe) has sub territories (North and South).  The territory manager for Europe will be able to set targets for the North and South sub territories as well.
    3. If a territory does not have a manager, a manager from any of the superior territories can set targets for the users in various sub territories.
    4. Target cannot be set for non-territory users.
    5. If you want to assign the same target to all the users, then you can apply this target to all peers by clicking the option that appears ONLY while entering the value in the first row.
  4. Reporting hierarchy
    1. Though it is not mandatory to set a target for the non-reporting users, it is a best practice to assign every individual a target for meaningful forecasting.
  5. If a user or role is deleted from the organization: For the forecast period that is completed, the user will be retained but tagged as deleted.
  6. The users or role names will be deleted for the current and future forecasts.

Creating a new forecast

To create a forecast

  1. Navigate to the Forecasts module and click Create Forecast.
  2. In the Create New Forecast page, do the following.
    1. Forecast Type: Select Revenue based or Quantity based forecast.
      The forecast type will be based on the configuration that is set in the forecast configuration by the admin.
    2. Forecast Period: Select Quarterly or Monthly and choose the current, future, or completed quarter or month. In case custom fiscal year is chosen, your options will be Quarterly and Periodly.
    3. Forecast Name: Enter the forecast name. (e.g. High value deals)
      The forecast name will be followed with quarter and year/month (e.g. High value deals Q4 2024 or High value deals Jan 2024)
    4. Forecast on: Select All Deals or Selected Deals.
      Define criteria for selected deals.
  3. Click Next.
    You will be redirected to the target setting page.

To set targets

Continue from the third step.

If top-down model is chosen
  1. In the Set Target page, enter the value for the Company Target.
    The same target value will be populated for the highest role or parent territory. (eg., CEO/Zylker as parent territory).
  2. Split the target value among:
    Depending on the type of hierarchy set in your org.
    1. Role, users in a role, sub-roles, and users in sub-roles OR
    2. Reporting manager and subordinates OR
    3. Territories, users in a territory, sub-territories, and users in sub-territories.
  3. Click Apply this target to all the peers to assign the same target to subsequent users.
    This applies only while entering the target for the first user under a role or territory

  4. Click Save.
If the bottom-up model is chosen


To notify users and set targets
  1. In the Set Target page, notify users to submit targets by hovering over them and clicking Notify to set target. The user will receive an email notification to submit their target.
  2. In case you (admin/forecast manager/user in highest role or position) want to set the target for a user, you can do so. In this case, the target will be considered approved by default.
  3. Click Save.
To notify users once a forecast has been created
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the page that opens, go to the Target Achievement Report section.
  4. For the users in the hierarchy, you'll be able to:
    1. Notify a user to submit their target
    2. View when a user was last notified
    3. Resend a notification to a user. You can send a maximum of five notification emails to a user.
Note
You'll also be able to notify users and resend notification in the Edit Forecast page.


To submit the target for approval
  1. Navigate to the Forecasts module.
  2. In the Waiting for your Target Submission section, click Submit your target against the forecast.
  3. In the Submit Your Target popup that appears, enter the target and click Submit for Approval.

Note
Users can also submit their target in the following places:
  1. In the Forecasts module, hover on the period of the desired forecast and click Submit your target.
  2. In the Forecasts module, click the desired forecast. In the detailed report page, hover over the desired period, and click Submit your target.
  3. This option is available once you've submitted your target.
    Hover on the period of a desired forecast and click View Full Hierarchy. Go to your card and click the edit icon. In the popup that appears, set your target and click Submit for Approval.
  4. You can edit your target after it's been submitted or approved, but only the approved target will be included in the forecast.

Approve or reject submitted targets
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the page that opens, go to the Target Achievement Report section.
  4. Go to a user's card and click Approve or Reject.


Note
You can also approve or reject targets in the Edit Forecast page.


Bulk approve or reject submitted targets
Admins have the option to approve or reject targets in bulk. To do this, they can:
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the page that opens, go to the Target Achievement Report section.
  4. Click Awaiting Target Approvals.
  5. In the Awaiting Target Approvals popup, select the required targets and click Approve or Reject.
Lock Target Submission
Admins can lock Target Submission to prevent others from submitting, approving, or rejecting targets. Once locked, only the admin can make changes to the targets.
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the page that opens, go to the Target Achievement Report section.
  4. Click Lock Target Submission.
  5. In the Lock Target Submission popup that appears, click Yes, Proceed.
Unlock Target Submission
Admins can unlock target submissions as well.
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the page that opens, go to the Target Achievement Report section.
  4. Click Unlock.
  5. In the Unlock Target Submission popup that appears, click Yes, Proceed.

Creating continuous forecasts

You can continue a new forecast from the existing one to create continuous forecasts. For example, if you create a Deal revenue forecast for the upcoming quarter based on the previous forecast, you can use a continuous forecast. It allows you to set targets based on achievements and gaps observed in the previous forecast.

An important benefit of continuous forecasting is that you can use Zia's target achievement prediction to compute the ideal target a user can accomplish. Zia predicts the target based on the previous forecasts' achievement. Let's say that in Q2, your team members closed more deals than their target, and as a result, the company observed an increase in deal revenue.

Zia will use the above data to calculate the target that each one can achieve and help you set the predicted target for the upcoming quarter.
In case the users are unable to meet the predicted target by the end of the forecast period, Zia will use the result to understand the gap and adjust the target values for the next continuous forecast that is created.



When you create a continuous forecast, you can set targets manually or by using the following options:
  1. Zia suggested target: Target calculated by Zia based on the previous forecast will be auto-populated. The targets will be marked as Predicted Target.
  2. Existing forecast target: Targets that were set in the previous forecast will be auto-populated. The user can select which forecast period they want to use.
  3. Existing forecast achievement: The target achieved in the previous forecast will be auto-populated. For example, if a user's target was 10,000 but they achieved 12,000; then 12,000 will be set as the target in the continuous forecast. Again, the user can select which forecast period they want to use.
Points to remember
  1. A continuous forecast will take over the name of the previous forecast to help admins identify the source. For example, if the previous forecast was Deal revenue, the same name will be used in the continuous forecast followed with quarter/month and year (Deal revenue Q4 2024).
  2. If the previous forecast was created for selected deals, then the continuous forecast will also be created for the same set of deals. You cannot change the condition provided for the new forecast.
  3. You can click on the company target, role's or territory's target to view the open deals and their split among: pipeline, best case, and committed. You can also see the predicted target.
A continuous forecast can be created in two ways:
  1. By creating a forecast from an existing forecast
  2. By creating a forecast for next period
To create a continuous forecast
I. Continue from existing forecast
  1. Go to the Forecasts module and click Create Forecast.
  2. In the Create Forecast popup, select Create from existing forecast.
  3. Select a Forecast from the drop-down list.
  4. Select Forecast period.
    Forecast name and Forecast on cannot be changed. They will retain the values present in the old forecast.
  5. Click Next.
    You will be redirected to the Set Target page.
  6. Either set target manually, notify users to set targets (for bottom-up model), or select an option from the Quickly set target dropdown.
  7. In the Quickly Set Target drop-down, choose one of the options:
    1. Zia suggested target
    2. Existing forecast target
    3. Existing forecast achievement
  8. Click the Forecast period, next to the Existing forecast target and Existing forecast achievement to autopopulate the values.
  9. Click Save.
II. Create for next period 
  1. Navigate to the Forecasts module and select a Forecast.
  2. Click Create for next period.
  3. In the pop-up, choose the Forecast period.

  4. Click Create.
    You will be redirected to the Set Target page.
  5. Either set target manually, notify users to set targets (in case of bottom-up model), or select an option from Quickly set target dropdown.
  6. In the Quickly Set Target drop-down, choose one of the options:
    1. Zia suggested target
    2. Existing forecast target
    3. Existing forecast achievement
  7. Click the Forecast period, next to the Existing forecast target and Existing forecast achievement to autopopulate the values.
  8. Click Save.

Viewing forecasts

Forecast list View

In the Forecast module, you can see the list of forecasts that are created for the organization. By default, a user will view the forecasts created for the current fiscal year when they land on the list view. They can filter and view the other forecasts. There are several actions that can be performed from the list view (like editingrenamingdeleting, or cloning forecasts).

Filter forecasts

You can use filters to view a particular forecast.

1. Forecast type: You can choose whether to view revenue or quantity-based forecasts.
2. Forecast year
: The forecasts are grouped as past, current, and future year. You can choose one of the years to view all forecasts created during the time.
3, 4, 5. Forecast based on role, user, or territory
: Based on the type of hierarchy you used to create a forecast, you can filter and view forecasts created for a particular user, role, or region.

Note
  1. Region and company filters for territory hierarchy can be used by users who are part of multiple territories.
  2. Role and user filter for role and reporting hierarchy will be available only to admins and users in highest role.

Renaming and deleting forecast


Rename: An admin, a forecast manager, or a user in the highest role can rename a forecast by clicking on the more (...) icon next to the forecast name.
Delete: Only an admin or a user in the highest role can delete a forecast. You can use this option to delete all forecasts created under the respective forecast name across all periods.

To rename or delete a forecast
  1. Navigate to the Forecasts module.
  2. Hover on the forecast name and click the more (...) icon.
  3. Click Rename to change the forecast name.
  4. Click Delete to delete the forecast.

Editing, cloning, and deleting forecast period

You can find these options by clicking on the more (...) icon next to the forecast period.

Editing: The current forecast will be highlighted as the current quarter or month. You can edit them, but you cannot edit the targets of completed forecasts.
Deleting
: Upon deleting a forecast period, the existing computation for the users, roles, sub roles, and sub territories will be deleted. The period will be deleted only from the particular forecast. There will be no change to other forecasts that may have been created for the same period.
Cloning: You can clone a forecast period of the current or future quarter or month. When cloned, the target of the original forecast period will be copied on the cloned forecast. The forecast name cannot be changed while cloning.

Holistic view of forecasts across years 

View forecast of individual user, role, or territory

In the Forecast list view, you can view all the forecasts that are created in the org. You can click on the desired forecast and expand the period to view the target, achievement, gap, current open deals, and the respective amount for each deal state (pipeline, best case, and committed).

You can also click on the user, role, or territory names to view the drilled-down report. 


Upon clicking the forecast created for the CEO (deal revenue Q2 2021):
  1. The detailed report showing the target, total achievement, and overall gap will be displayed.
  2. The current deals will be split as: open deals, pipeline, best case, and committed. Upon clicking on one of those numbers (eg. pipeline), you can view the list of contributing deals.
  3. Similarly, you can click on the other categories to find deals contributing towards committed, best case, etc. 
  4. Likewise, if you click on the corresponding user, role, or territory under the forecast period, you can view their target break-up too. In addition, you can navigate to the other roles, territories, or users in the forecast by clicking on the hierarchy displayed right below the forecast.

Detailed view of all deals

In a forecast, you can click on the value under achievement and current open deals to see the contributing deals, the account they belong to, stage, amount, and more.

View complete hierarchy details

From the forecast listing, you can select a forecast period and click View Full Hierarchy to see the detailed breakdown of user, role, sub role, territory, and sub territory. You can see the total target, net achievement, and open deal amount. It will be split up based on category for each entity of the hierarchy.

Tracking achievement and performance

When you click View Full Hierarchy for a forecast period, you will be taken to a page where you have can track forecast achievement and performance over time. It has two major components to help you do this:
  1. The forecast overview
  2. The target achievement report

Forecast Overview

Forecast overview is a collection of charts to analyze your team's performance in the particular forecast. It helps users and admins get a quick overview of their performance and plan changes to satisfy the target requirements.

  1. Performance Trend: Sales managers and sales reps can analyze their performance with the help of the Performance trend chart. This plots the accumulation of achievements across dates. It can be compared with the target (plotted as a straight line). The trend line predicts whether the target can be achieved within the forecast period, based on current performance. Users can speed up progress in current deals to meet the target achievement based on these visually represented predictions.

  2. Achievement Comparison: Users can compare their performances on a regular basis to analyze how they have performed over a period. Deal amounts can also be compared on a daily or monthly basis as well.

  3. Comparison Across Periods: This chart compares the total amount achieved for a particular forecast, across different periods. It shows the total value of deals and the deal value achieved in a particular forecast period, in the form of single vertical columns distinguished by different shades. The chart also shows the target set for each forecast period.

Target Achievement Report

This report complements the charts available in the Forecast overview section. It is a drilled-down report where every individual's target, achievement, and open deals are displayed. If you're using a bottom-up model, this report serves as the location for notifying users and editing, approving, rejecting, or revising targets. Admins will also be able to lock bottom-up forecasts from here.

Under Open Deals, you can view the number of deals that are in the pipeline and the ones that are considered best case or committed to forecast approximate profit or loss. You can hover on the info icon next to the open deals to see this pop-up. 

Some common terms:
Achieved amount 
- Sales achieved by your users against the target.
Achieved percentage 
- The percentage of total sales achieved/total target set.
Gap 
- The difference between the target set and achieved sales in percentage.
Predicted achievement 
- The achievement that Zia predicts based on target achievement and deal closure patterns from previous forecasts.The following details are available on the User Performance Page:

Roles Performance Page

The Roles Performance report can be accessed on the Roles Performance page by clicking on the particular role in the hierarchical view of the target achievement report page. It has the same details and charts available on the User Performance page, depicting the analysis of all users in the particular role. However, the Reasons for Performance Gap and Improvements will be different from those provided in the User Performance page.

Achievement gap reasons for roles:
  1. Recent users transferred between roles: When users are moved to different roles, they will be mentioned in the form of the count of such users and the percentage of the target deal value that they owned. Clicking on the count of users will display the list of such users .
  2. Mismatch found in the split and target: If there is a delay in allocation of values in the target, it will be mentioned as the percentage of the value in the target that is mismatched.
  3. Users low performance: A count of users who closed less than 20% of their targets will be listed, if present. The list of users will be linked with the count.
  4. Target Overrated: If the targets of users are overrated, then it will be mentioned along with the percentage of overrating. 
Improvements suggestions for roles:
  1. Identify the users who have low value follow up rate: If some users have led to a decline in customer happiness, they will be mentioned in a list linked to the count of such users.
  2. Right deals to Right person: If user A has a high win rate of 76% on high value deals and 60% on low value deals, it will suggest assigning high value deals to user A to get better results.
  3. Reassignment gives some better results: If two users have some stagnated and untouched deals, it will be mentioned as improvement to reassign those deals to help closure.
  4. Correction needed in target: When five users (A,B, C, D, & E) have overrated targets and three users (J, K, & M) have low rated target compared to their average performance, then it will be mentioned with this improvement.
Note
  1. Admins or users in the highest role can edit the target value of other users from the target achievement report.
  2. A forecast manager can edit the targets of peers and users in sub roles or sub-territories.
  3. Every two hours, the deal data gets synced automatically. You can manually refresh the report to sync recent deal data.
  4. Deals that do not fall under any territory are grouped as without territory and placed at the bottom of the target achievement report. For these deals, only the achieved and open deals amount will be displayed.
  5. Achievement of deals that are without territory will be added up to the company's achievement.
  6. The deals owned by a user who is not part of a territory will be grouped under non-territory members. The open deals and achievements will be displayed under the non-territory member group.
  7. The charts on User and Roles' performance pages will only be available for Completed and Current forecasts.
  8. This Current Deals by Stages chart will be available only for Current forecast.
  9. Achievement Comparison chart will only be available if there are data from previous forecast periods.
  10. Improvements and Reasons for Performance Gap will be updated once in a week.

To view the achievement report
  1. Navigate to the Forecasts module and select a desired forecast.
  2. Hover on the period and click View Full Hierarchy.
  3. In the report, click the + icon against the role to view the achievements of team members and sub-roles.
  4. Click the info icon next to the open deals to see the deal split-up based on their state: pipeline, best case, and committed.
  5. Users who have achieved their target are marked as Star performers.
  6. Click on the Achieved or Open deals amount to view the complete deal listing.

  7. In Enterprise and Ultimate editions, click on a user or on a role to view the User Performance page and Role performance page respectively.

Auto sync of deal information for the latest forecast

Whenever the deal's status changes, the information is synced with the forecast to show the latest target achievement report. The sync takes place every two hours automatically. However, you can manually sync the data by clicking the refresh icon at the top. The last synced time will be displayed.

Note
  1. You may notice a data mismatch if you open the target achievement report before the auto-sync.
  2. Once the forecast period is completed, the open deals and achieved amount will be locked. Any changes done to the open deals once the forecast period is completed will not be reflected in the target achievement report.

Predicted Achievement

Forecasting is a process that uses past data as input to estimate achievement and pick out future trends. Zia can predict an increase or decrease in target achievement by looking at previous data inputs. For example, if the past trend suggests that a rep usually achieves more than the set target, Zia can predict the ideal target for that rep.

To predict target achievement, Zia requires data from the past six months that includes deals that were won on different days. The deals must be closed on at least 10 different days. In other words, if all the deals are closed on the same day, the prediction cannot be made. The predicted achievement for individual users, roles, and territories will be displayed next to their achievement in the target achievement report. It will be based on the past six months of data and the current deal closure trend.

Archived Forecasts

The purpose of configuring forecasts is to keep track of the company's performance at various levels of the organization. Thus, it is essential to have records of forecasts to get better understand your performance over time. In Zoho CRM, forecasts are automatically archived, and you can go through them as and when required in the future.

The archived forecasts page lists all the forecasts that have been archived. You can filter them based on hierarchy, forecast type, and time. You can also hover over a forecast for the option to see the full hierarchy. This will open the Target Achievement Report page.

Which forecasts are archived?

  1. The forecast list view displays up to 2 completed years' data. The forecasts created beyond these two years will be archived automatically.
    For example, suppose the current forecast is for Q3 2021. The list view has records for completed forecasts since Q1 2019. The forecasts before Q1 2019 would be archived.
  2. If a forecast configuration is edited, the current and future forecasts based on the old configuration will be deleted while the completed forecasts will be archived.
    For the above example of point 1, if you edit the hierarchy or any other configuration, the completed forecasts would be archived, and the current forecast for Q3 2021 will be deleted along with any future forecasts created. 

Note
  • Only the completed forecasts will be archived. If the forecast configuration is edited, the current and future forecasts that are based on the old configuration will be deleted.
  • Changing the fiscal year of your organization will delete all the existing forecasts as well as the archived forecasts.
  • Archived forecasts data will not be available in reports.

 To view archived forecasts

  1. Navigate to the Forecasts module.
  2. Click on the ellipsis in the top-right corner of the forecasts list page.
  3. Select Archived Forecast from the dropdown.
  4. Filter the forecasts based on HierarchyForecast Type, and Time.
  5. Click View full hierarchy.
  6. Click on the info icon i to view the basic details about the forecast like the hierarchy, target field, created by, and archived time.
Note
  • The archived forecasts cannot be edited; they are for viewing purposes only. Archived forecasts can be deleted as and when required.
  • Up to 5 years of forecast records would be available in the Archived Forecasts page. 

Other forecast-related options

Setting forecast category

After the forecast is configured, the forecast category will be automatically populated based on the configuration done in the stage probability mapping. The forecast category will be auto-populated as per the deal stage. If the deal is in an open stage, the category can be edited depending on the progress.

In stage probability mapping, the deal category determines the current state of a deal. There are three deal categories:
  1. Open - The deal is in pipeline.
  2. Closed won - The deal is won and closed.
  3. Closed lost - The deal is lost and closed.
To determine whether deals from a particular state should be considered for forecasts or not, and, if yes, under which category, we define the forecast category. There are five system-defined forecast categories:
  1. Pipeline - The deals are open and still in the sales cycle.
  2. Best case - The deals that have good chances of winning if everything goes well.
  3. Committed - These deals are committed and are highly likely to be won within the forecast period.
  4. Closed - Deals that are won.
  5. Omitted - These deals won't be included in forecasts.
Additionally, you have the option to add two custom forecast categories (for the Open deal stage) based on your business needs.

When the deal category is open, the forecast category can be marked as pipeline, best case, committed, or any of the custom categories created. The forecast category chosen will depend on how your sales reps or managers feel that deal will progress. You can rename these categories as well as change the default colors. Marking a deal with the right forecast category helps the decision makers estimate the revenue that they are likely to generate.

Once the deals move to the closed (won or lost) stages, the forecast category is locked.

Similarly, the deals that are in closed won or lost state are automatically mapped to closed or omitted state respectively. Users cannot edit the forecast category of deals that are closed.

Sales reps can update the forecast category of a deal manually to the best case or committed when the situation calls for it. The total deal amount for a particular category will then be updated in the forecast during its next sync.
Note
  1. When the forecast category of a deal stage is modified, it will be applied to all deals automatically, including both existing and current ones.
  2. System-defined forecast categories (Pipeline, Best case, Committed) can only be renamed and cannot be deleted.
  3. In case of deleting a forecast category and mapping existing records for the category to a new option, only records with a closing date after the current date will be updated with the changed forecast category.

Strategy Influencer in forecasts

Feature availability
  1. Strategy Influencer in Forecasts is available for 20+ user accounts in Enterprise and Ultimate editions.
  2. This feature is ONLY available for English language users. The super admin and other admin users need to be English users.
Zoho CRM's Strategy Influencer includes diverse analytics that depict organizational trends and patterns. It presents anticipated targets, anomalies, the reasons for unmet targets, and solutions to attain targets. By utilizing these insights, you can understand your enterprise's overall performance and develop effective strategies to improve it. Learn more.
 
The Strategy Influencer analysis for a forecast will be tailored to the forecast's objectives and time frame, taking into account the analytics and time filters specific to the monthly or quarterly forecast period.

Once there is enough data for analysis, you will find the View Strategy Influencer option in your forecast overview page. There will be two strategy influencers for forecasts that will be available for use. The first pitch will involve forecasting with deal revenue, encompassing all deals, while the second pitch will focus on forecasting with deal quantity, also including all deals.
Upon clicking this, you will have the option to get insights of the Strategy Influencer in forecasts in the following five components:
  1. Target Contributors
  2. Anomaly Finder
  3. Gap Analyzer
  4. Predictor
  5. Prescriptor

Target Contributors

The Target Contributors component presents specific factors that affect the overall target to be achieved and includes details on each factor, such as the projected target, the attained target, and trend icons that demonstrate the factor's impact.

If it suits your business requirements, you can modify the targets listed in the target contributor section. Upon editing the general target in the strategy influencer, verify the new target figures of the specific contributing factors via the Target Contributors component. Should it be necessary, you may designate this revised general target as your projected target.

Anomaly Finder    

The Anomaly Finder scrutinizes the presence of anomalies in the attained value for a given period, and elaborates on the factors behind them, the anticipated versus actual targets, and the extent of their influence on the target.

Gap Analyzer

The Gap Analyzer detects discrepancies between projected and realized values for a specific day or week, and identifies the causes for these discrepancies.

Predictor

Zia identifies the top-contributing picklist and lookup field values and displays their predicted and achieved targets, along with their impact during different time periods, using the Predictor component. Additionally, you have the option to select specific contributing factors that are relevant to your needs.

Prescriptor

The Prescriptor module provides guidance on reaching an anticipated objective and overcoming any failures to attain it in the future.

Points to remember:
  1. You have the option to retain the strategy influencer every 15 days as per your needs.
  2. Insights from the Strategy Influencer will only be available for forecasts on All Deals.
  3. Insights from the Strategy Influencer for the forecast are only visible to admins.
  4. Strategy Influencer insights are available only for the current ongoing forecasts.