Blog · forecast categories Salesforce

Make Forecasts Auditable: Salesforce Forecast Categories for Admins

Admin-first steps to fix stage-to-category mapping, pick the right rollup, and enforce overrides so Salesforce forecast categories become auditable and...

Decorative auditable forecast title card

Forecast categories are Salesforce’s confidence buckets: Pipeline, Best Case, Commit, Closed, and Omitted, each mapped from an opportunity’s stage. Wrong mappings and the wrong rollup type are why a forecast called at $1.2 million lands at $1.7 million, or worse, well under. Fix the stage-to-category mapping and pick a rollup type that matches how your team actually manages risk, and the forecast becomes something you can defend in front of a board.


TL;DR:

  • Correct stage-to-category mapping is critical; errors at setup propagate through all forecasts and can misrepresent deal values.
  • Both single-category and cumulative rollups serve different review purposes; choose based on whether operational detail or leadership speed is your priority.
  • Manual forecast category overrides by reps create untrustworthy numbers; implementing audit processes and requiring justifications can mitigate this risk.
  • Forecast type and date basis, such as close date or schedule date, significantly influence forecast results and should align with your revenue recognition process.
  • Commitcontrol provides a transparent scoring system on top of existing categories, enhancing forecast defensibility without requiring major workflow changes.

Commitcontrol
Make Revenue Forecasts Defensible
CommitControl adds transparent, deterministic scoring to Salesforce pipeline data, giving revenue leaders detailed reasoning behind every score.
Explore CommitControl

Table of Contents

Understanding Salesforce forecast categories and what they mean

Every opportunity in Salesforce carries a forecast category, and that category decides whether the deal counts toward your number. Get the categories wrong and the number you present on Monday will not survive Wednesday’s pipeline review.

The standard set is:

Only some of these count toward the number leadership sees. A typical rollup includes Commit and Closed as the core number, with Best Case layered on top as upside. Omitted opportunities never appear, regardless of value.

Picture an opportunity that starts in Pipeline at the discovery stage, moves to Best Case once a proposal goes out, then flips to Commit when the rep confirms a signature date. Each move changes what your forecast total shows, automatically, the moment the stage changes.

How stage-to-category mapping works and how to edit it

Forecast category mapping sits on the Opportunity Stage picklist. When a rep changes a deal’s stage, Salesforce updates both the forecast category and the probability percentage automatically, based on the mapping an admin configured. Get this mapping wrong once, at setup, and every forecast built on it afterwards inherits the error.

Here is the path to inspect or change it:

  1. Go to Setup, then Object Manager, and select Opportunity.
  2. Open Fields & Relationships and click into the Stage field.
  3. Review each stage value and its assigned forecast category and probability.
  4. Edit the mapping for any stage that is pointing to the wrong category.
  5. Save, then check a handful of existing opportunities in that stage to confirm the rollup updated correctly.

Salesforce documents this process directly, including the rule that any stage change updates the forecast category and probability together, not independently, as detailed in its guidance on managing stage-to-category mappings.

Lightning Experience and Classic behave differently here. Lightning exposes the full set of forecast categories for every stage, giving admins more flexibility. Classic restricts which categories a given stage can map to, which is one reason organisations still running Classic often see stranger forecast numbers than they expect.

Pro Tip: Watch for reps who manually override the forecast category on an individual opportunity rather than moving the stage. It is legal in Salesforce, but it disconnects the number from the stage, which is exactly the kind of quiet distortion that makes a forecast indefensible later. Pull a report filtered on category overrides monthly and review it with the rep.

Single category versus cumulative rollups: choosing the right total

A single category rollup counts only the opportunities sitting in that exact category. A cumulative rollup counts that category plus everything logically ahead of it, so a cumulative Best Case total includes Best Case, Commit, and Closed, if your organisation has configured it that way. Salesforce supports both models, and the choice changes what number your team sees on the forecast page without changing a single underlying opportunity.

The practical difference shows up fastest at quarter close. A VP checking a cumulative Commit total gets one number that already folds in everything more certain than Commit, useful for a fast leadership check-in where nobody wants five numbers to add up in their head. A RevOps analyst doing pipeline hygiene wants the opposite: single-category clarity, so they can see exactly how many deals sit in Best Case without Commit and Closed inflating the count.

Match your rollup choice to the audience:

Forecast types and date measures: close date, product date, and schedule date

Forecast Type is the configuration layer that decides what your forecast actually measures, amount or quantity, and which date field drives period attribution. It is easy to overlook, and it is often the reason two forecasts built from the same pipeline show different numbers. Salesforce’s Metadata API documents ForecastingType as the field-level control behind amount, quantity, and dateType settings.

Three date bases are available, and each tells a different story:

An annual contract signed in March but delivered in monthly instalments will forecast very differently depending on which date basis drives it. Close Date puts the full value in March. Schedule Date spreads it across twelve periods. Salesforce Help confirms that schedule and product date forecasts change the Forecasted Amount column outright, and each needs its own custom report type to display correctly.

Choose the dateType that matches how your finance team recognises revenue, not the one that happens to be the Salesforce default.

Customisation limits and the changes that break rollups

You can rename standard forecast categories. You can add a Most Likely category in Lightning Experience. What you must never do is change the standard API names underneath those categories, as Salesforce’s own documentation on customising pipeline forecast categories warns explicitly. The label a rep sees can change. The internal key cannot, because rollup logic references that key directly.

Forecast types themselves have limits too. Organisations are typically limited to a few active forecast types by default. Salesforce Support can raise that limit for organisations running more complex measures, such as separate views by product line and by schedule date, but it is a support request, not a self-service toggle.

A safe-change checklist, before you touch anything in production:

  1. Make the change in a sandbox first, always.
  2. Validate that rollup totals still calculate correctly for every affected category.
  3. Check every report and dashboard that references the forecast category field by label.
  4. Communicate the change to reps and sales leadership before it goes live, not after someone notices the number moved.

Pro Tip: If a rename breaks a report filter that hard-coded the old label, you will not find out until someone’s Monday dashboard shows zero. Test report filters in sandbox alongside the rollup, not as an afterthought.

Governance: keeping category overrides from hiding pipeline risk

Manual overrides are the single biggest threat to a defensible forecast. A rep can override the forecast category on an opportunity without moving its stage, which means the number on the forecast page can drift from what the stage actually says about deal health. Multiply that across twenty reps and a forecast built on overrides tells you almost nothing reliable about risk.

Three controls keep this in check:

Treating forecast categories as deterministic signals of process discipline, rather than a field reps adjust on feel, is what makes them auditable. A category should mean the same thing every time it appears, traceable back to a specific stage change on a specific Opportunity record, with a human owner accountable for that judgement. That is the opposite of a black-box score nobody can explain in a board meeting.

Best practices for data quality behind an accurate forecast

Forecast accuracy is a data quality problem wearing a forecasting label. Categories are only as trustworthy as the fields feeding them, and three habits do more to fix that than any dashboard redesign.

Close dates need discipline. A close date that slides every review cycle without a documented reason is a warning sign, not a scheduling quirk. If a rep has moved a close date three times in a quarter, that opportunity’s category confidence should be questioned before it is trusted.

Stage duration should be visible. Deals that sit in Commit for eleven weeks past a typical sales cycle length are telling you something the category label is not. Build a report showing days-in-stage next to forecast category, and review outliers weekly.

Amount fields must reflect reality. Categories mean little if the amount underneath them is a placeholder from six months ago. Require reps to update amount whenever a proposal changes, not just when the deal closes.

Duplicate and stale records distort the rollup. An opportunity nobody has touched in ninety days, still sitting in Best Case, inflates a number that leadership will eventually have to walk back. Omit it, close it, or reassign it, but do not leave it inflating the total by default.

None of this requires new tooling. It requires someone owning the audit, on a schedule, with the authority to push back on reps who treat the CRM as optional paperwork.

Forecast categories, quota management, and performance tracking

Forecast categories and quota attainment are two different measurements that get confused constantly. Quota tracks what a rep has closed against target. Forecast category tracks what a rep believes will close and how confident that belief is. Conflating the two is how a sales leader ends up surprised in the last week of quarter.

But if that Commit total is built on deals with slipping close dates and no signed paperwork, the quota gap is about to get worse, not better. Pulling forecast category health alongside quota attainment, rep by rep, surfaces this gap before it becomes a missed number.

RevOps teams that track category distribution over time, not just the point-in-time snapshot, catch a specific failure pattern: reps who consistently over-populate Commit early in the quarter and then quietly move deals back to Best Case or Pipeline as the close date approaches. That pattern, tracked across a full quarter, is a far better predictor of who will miss quota than any single week’s forecast number.

Build the comparison into your regular cadence rather than a one-off audit. A rep’s Commit-to-Closed conversion rate over several quarters tells you more about their forecasting reliability than their attainment percentage alone.

Setting up user permissions and profiles for forecast categories

Forecast visibility follows the standard Salesforce role hierarchy, which means the permissions conversation is really about who can see, adjust, and override forecast data at each level.

Reps generally need edit access on their own opportunities, including the ability to change stage, which drives their forecast category automatically. Managers need visibility into their team’s rolled-up forecast, plus the ability to adjust forecast amounts at a manager level without touching individual rep records. That manager-level adjustment sits separately from the underlying opportunity data, which is intentional. It lets a manager apply judgement to a total without corrupting the deal-level source data underneath it.

Forecast Manager and Forecast Viewer permissions control this split. Assign Forecast Manager sparingly. Someone with that permission can adjust rolled-up numbers that leadership sees, and every adjustment should be traceable to a named person, not a shared profile.

Field-level security matters just as much as object permissions here. If a profile has edit access to the Amount field but not the Stage field, reps can change deal value without triggering the category updates that stage changes cause automatically. That mismatch is a common, quiet cause of forecasts that do not reconcile with the opportunities behind them. Audit field-level security on Stage, Amount, and Forecast Category together, not as separate exercises.

Setting up user permissions and profiles for forecast categories — overview diagram

How forecast categories connect to reports, dashboards, and other Salesforce features

Forecast categories are a field like any other once they leave the forecast page, which means they show up in custom reports, dashboards, and even list views, and every one of those needs to agree with what the forecast page shows.

A common failure: a dashboard built months ago still filters on a forecast category label that an admin has since renamed. The report runs, returns numbers, and nobody notices the filter is silently excluding the renamed category until a quarterly total looks short. Rebuilding filters after any category rename is not optional maintenance, it is the difference between a dashboard that reports reality and one that reports history.

Custom report types matter more here than in most other areas of Salesforce. Standard opportunity reports do not always expose Product Date or Schedule Date forecast values cleanly, which is why Salesforce Help specifies dedicated report types for schedule and product date forecasts. Build those report types once, correctly, and reuse them, rather than reconstructing filters every quarter.

Dashboards aggregating across business units should pull from the same rollup type consistently. Mixing a single-category filter on one dashboard component with a cumulative filter on another, on the same page, produces numbers that look contradictory even when both are technically correct. Standardise which rollup type feeds executive dashboards and keep operational dashboards clearly labelled as the exception.

How forecast categories connect to reports, dashboards, and other Salesforce features — overview diagram

Troubleshooting the most common forecast category problems

Most forecast category problems trace back to one of four causes, and diagnosing which one you have saves hours of guesswork.

The rollup number does not match what you expect. Check whether the report or dashboard is using single-category or cumulative rollup logic. This is the single most common support ticket, and it is rarely a bug.

A renamed category broke a report. If a dashboard component returns zero after a category rename, the filter almost certainly still references the old label. Rebuild the filter against the new label rather than hunting for a data problem that does not exist.

Forecast amounts look wrong for a specific opportunity. Check the Forecast Type’s dateType setting first. An opportunity with line items on different Product Dates will forecast very differently under Close Date versus Product Date measures, and the discrepancy is expected behaviour, not corruption.

Reps report the forecast category does not match the stage. Pull that opportunity’s history and check for a manual override. This is where the governance controls from earlier in this guide, override notes and weekly audit reports, pay for themselves.

When none of these explain the discrepancy, check whether a stage-to-category mapping was recently edited. A single unreviewed mapping change can quietly distort every forecast built after it, for every opportunity that touches the affected stage.

CommitControl’s perspective: making category-backed forecasts defensible

Forecast categories give you the structure. They do not give you the confidence that every commit deal in that bucket will actually close. That gap, between a well-mapped category and a defensible number, is where most forecasting tools reach for a black-box model and ask you to trust a score nobody can fully explain.

Commitcontrol takes a different route. It maps to the same Opportunity records your categories already reference, and every score it produces traces back to a specific, visible input on that record. No rep workflow changes. Nothing new to log into daily.

The practical outcomes matter more than the mechanism. A clearer commit number you can walk into a board meeting with. A rollback workflow for leadership transitions, when a new sales leader inherits a pipeline nobody trusts. And a forecast miss ROI calculator that puts a number on what a bad forecast actually costs, before it costs you a quarter.

Categories tell you where a deal sits. Commitcontrol tells you whether that placement holds up.

— Brian

Where Commitcontrol fits once your categories are configured

Commitcontrol is built for the moment after your forecast categories are correctly mapped, when the real question becomes whether you can trust the number they produce. Commitcontrol takes the opposite approach: the same inputs always produce the same score, every signal traces back to a Salesforce record, and a person owns each decision rather than a model nobody can question.

Commitcontrol

It suits sales leaders and RevOps teams who have already done the admin work, correct stage mappings, sensible rollups, clean data, and now need a layer that makes the resulting commit number defensible under scrutiny. If you inherited a pipeline during a leadership change, the sales leadership transition tooling is built specifically for resetting a forecast nobody trusts yet. Pricing runs on a flat organisational tier rather than per seat, so the whole team is covered from day one; details sit on the pricing page for mid-market teams. Start by running your current pipeline through the forecast miss ROI calculator to see what a repeat of last quarter’s miss would actually cost.

Sources

FAQ

What are the different types of forecasting in Salesforce?

Salesforce forecasts by opportunity forecast categories (Pipeline, Best Case, Commit, Closed, Omitted, and optionally Most Likely), and separately by Forecast Type, which determines whether you measure amount or quantity and which date field drives the timing.

What are the four types of forecasting?

Outside Salesforce-specific terminology, forecasting methods are commonly grouped into qualitative, time series, causal, and judgmental approaches; within Salesforce, the closest equivalent is choosing between Close Date, Product Date, and Schedule Date forecast types alongside category-based rollups.

What are the 7 steps of forecasting?

Definitions vary by methodology, but a practical Salesforce-relevant version covers: mapping stages to categories, choosing rollup type, selecting forecast type and date basis, cleaning pipeline data, reviewing commit-to-closed conversion, auditing overrides, and reconciling the final number against actuals.

What are the standard values for forecast categories?

The standard Salesforce forecast category values are Pipeline, Best Case, Commit, Closed, and Omitted, with Most Likely available as an optional addition in Lightning Experience.

Can Commitcontrol replace Salesforce forecast categories?

No. Commitcontrol works alongside your existing Salesforce forecast categories, adding a deterministic, traceable scoring layer on top of the categories and stage data you have already configured.

Editorial content. All metrics are Salesforce-derived and reviewed for accuracy. Not a substitute for professional judgment.

From the article to your own numbers

See the same discipline applied to your pipeline.

CommitControl derives every figure from your own Salesforce data. Nothing is invented, and every number traces back to the record it came from. Connect Salesforce and the same view runs live on your data within 24 hours.

Evaluate CommitControl