How to Use Salesforce Forecasting: Set Up, Review and Fix the Number (No Code)

How Salesforce forecasting works, the four things to set up, how to read the Forecasts tab, and how to review and fix the deals behind the number.
How to use Salesforce forecasting: a forecast review in a Valorx Wave Matrix with every rep, deal and month

Salesforce forecasting rolls every open deal into a few numbers by month, rep and manager. To use it well you set up four things, learn to read the Forecasts tab, and then review the deals behind the number. This guide follows the video: a team showing $5.37M in commit against an $8.4M quota, and the three deals that changed it.

Jump to a chapter

What you'll learn

  • How categories, quotas and the rollup work
  • The four things to set up
  • How to read the Forecasts tab
  • How to build a forecast review screen
  • How to fix the deals and see the number move
  • Video length: 6 minutes

How Salesforce forecasting works

Every open deal carries a forecast category: Pipeline, Best Case, Commit or Closed. The category comes from the deal's stage, and a rep can change it on the deal.

Salesforce forecast categories: deals sorted into Pipeline, Best Case, Commit and Closed
Six deals, four forecast categories. Demo data.

The forecast adds those categories up by month or by quarter, then rolls them up from each rep to their manager through the role hierarchy. A forecast type decides what gets counted: deal amount, product revenue or quantity.

Salesforce forecast rollup: four reps roll up to their forecast manager by month
Added up by month, then rolled up from four reps to their manager.

How to set up Salesforce forecasting

Setup takes four things, all in Setup under Forecasts.

  1. Turn forecasting on. Open Forecasts Settings and switch on Turn on Forecasting.
  2. Pick a forecast type. The one in the video counts opportunity amount by close date.
  3. Set the forecast hierarchy. Enable each rep, and name a forecast manager for the role above them. Here, four reps roll up to Mary Adams.
  4. Add quotas. Each rep gets a number for each month, so the forecast has something to measure against.
Forecasts Settings in Salesforce Setup with forecasting turned on and the forecast types listed
Steps 1 and 2. Forecasts Settings, with the Opportunity Amount forecast type active.
Forecasts Quotas in Salesforce Setup showing a monthly quota for each of four reps
Step 4. A quota for each rep for the month.

How to read the Forecasts tab

Each row is a month. Across the top: quota, closed, commit, best case and open pipeline. Commit forecast means closed deals plus commit deals. The bar under each number shows how far it is from quota. Open a month and the reps appear under their manager. Click any number and the deals behind it list below.

The Salesforce Forecasts tab showing a commit forecast of 5,369,620 against a quota of 8,400,000
The team's quarter: $5.37M in commit against an $8.4M quota. Demo data.

Where the Forecasts tab stops

The number is only as good as the deals under it. Three deals in this quarter didn't hold up.

Worked example from the video

Three deals were in the wrong place. Fixing them moved the commit forecast for the quarter.

Quota$8.40M
Commit before$5.37M
Deals changed3
Commit after$4.15M
  • A commit deal past its close date. Pelican Wearables, $536,400, in Commit with a close date of November 13.
  • A Best Case deal still in Discovery. Quill Robotics, $791,320.
  • A commit deal with pricing still open. Hyperscale AI, $1,218,160.
The opportunity list under the Salesforce Forecasts tab with the deals behind the open pipeline number
The deals behind the number, listed under the Forecasts tab.

You can edit a deal in that list, one at a time. A forecast review needs every rep, every deal and every month on one screen, where you can change them together.

The Forecasts tabWith a Wave Matrix
Click a number to list the deals behind itEvery rep, deal and month on one screen
Spot a past close date by reading each rowA rule turns the row pink when the close date has passed
Edit deals one at a timeChange several deals, then save once
Deal amount by monthThe same deals by account, by product or against a target in a custom object

How a matrix connects more than one object

A forecast rarely lives in one object. Deals are opportunities, customers are accounts, products sit on the deal lines, and the target is often in a custom object your team built. A matrix in Valorx Wave takes its rows from one object, its columns from another and the numbers in the cells from a third.

How a Valorx Wave Matrix takes rows, columns and cells from different Salesforce objects
The row is the primary record. The cells are its secondary records. Standard and custom objects both work.

Build the forecast review

You need Valorx Wave from the AppExchange. Everything happens in the Matrix Wizard, without code.

  1. Name it. Ours is Forecast Review.
  2. Set the rows. They come from opportunities: the rep, the deal, the forecast category, the stage and the close date.
  3. Set the columns. Use the close date. That becomes the timeline.
  4. Set the value. The amount goes in each cell.
  5. Filter. Open deals only, owned by the West Sales team.
  6. Make it readable. A color bar on forecast category, a rule that turns a row pink when its close date is before today, a rule on amount so the largest deals stand out, and a tint for each rep.
  7. Sort and save. Sort by rep, then by deal, and open it.
Rules in the Valorx Wave Matrix Wizard: a forecast category color bar, a past close date rule, a large deal rule and a tint for each rep
Step 6. The color bar and the rules that make the review readable.
A forecast review in a Valorx Wave Matrix inside Salesforce with every rep, deal and month on one screen
The finished review. The pink row is the commit deal whose close date has passed. Demo data.

The same matrix reads monthly for the review, weekly for the deals closing now, quarterly for the number you report and yearly for the plan.

Fix the deals and watch the number change

Three changes, made in the matrix:

  • Pelican's close date moves to December 4, and the pink highlight clears.
  • Quill goes from Best Case to Pipeline.
  • Hyperscale goes from Commit to Best Case, until pricing is agreed.
The forecast review matrix after three deals were changed and saved to Salesforce
After the save. The three changed rows are marked.

One save writes all three to the opportunities in Salesforce, under the same permissions as any other edit. Back on the Forecasts tab, commit was $5.37M and is now $4.15M. It's a smaller number, and it's one you can defend in the forecast call.

The Salesforce Forecasts tab after the changes showing a commit forecast of 4,151,460
The Forecasts tab after the three changes: commit is $4,151,460.

Forecast by account and by product

The same idea works across objects. In this matrix the rows are accounts and the cells come from a custom object, Account Forecast, with a target and a forecast for each month. A formula shows the gap. Green is above target and red is below. Pelican Wearables is $310,000 above target for the quarter. Hyperscale is $820,000 behind. Change a forecast here and it saves to the custom object.

Target, forecast and gap by account and month in a Valorx Wave Matrix built on a custom object
Target, forecast and gap for each account, from a custom object. Demo data.

One more view: the same deals by product and month, so you can see which products carry the quarter.

Revenue by product and month in a Valorx Wave Matrix built on opportunity products
Revenue by product and month, from the deal lines.

Questions this video answers

How does forecasting work in Salesforce?

Each deal has a forecast category that comes from its stage. Salesforce adds the categories up by month or quarter and rolls them up from each rep to their manager through the role hierarchy. A forecast type decides whether it counts deal amount, product revenue or quantity.

How do I set up forecasting in Salesforce?

In Setup, turn on forecasting in Forecasts Settings, pick a forecast type, enable users and name forecast managers in the Forecasts Hierarchy, then add quotas for each rep and period.

What does commit forecast mean in Salesforce?

Commit forecast is the total of closed deals plus deals in the Commit category for the period.

Can I edit deals from the Forecasts tab?

Yes, one at a time in the list under the forecast. The review in the video uses a matrix so several deals across reps and months can be changed and saved together.

Can a forecast use a custom object?

In the video, a matrix reads a target and a forecast for each account and month from a custom object, shows the gap with a formula, and saves edits back to that object.

Keep going

Recorded in a Salesforce demo org with demo data, restored after recording. Company names in the video are fictional demo accounts.

Want to see it on your own forecast? Book a demo and we'll build the first matrix with you on the call.