Skip to content

Pipeline & forecast report

The Pipeline & forecast report answers three questions about your open deals: what will we close, when, and how much of it is recurring. It lists the open pipeline by the month each deal is expected to close, by its stage and by its forecast category, with MRR and One-time value side by side and a Weighted total that scales each deal by its win probability.

It is the detail behind the Open pipeline and Weighted pipeline rows of the MSP revenue report.

Go to Reports and click Pipeline & forecast under Revenue.

The report covers the opportunities your role can view. It opens on This quarter.

Use the row of filters above the numbers:

  • The period: a preset such as This quarter or Last month, All time, or Custom range with a from and a to date. A deal counts in the period its Expected close date falls in.
  • The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities. People who have left are listed last, marked (inactive).
  • The pipeline: All pipelines or one pipeline. This filter appears when you have more than one.
  • The source: All sources or one source, matched to the deal’s Source.

The dates the period covers are shown at the right of the filters. Your filters are kept in the page address, so a bookmark opens the same view.

Click any figure to open the deals it counts, with Company, Owner, Stage, MRR, One-time fees, Total value and Close date. The list’s total matches the deal count behind the figure. A figure with no deals behind it is plain text. Click a deal to open it, or Pipeline & forecast in the trail at the top to go back to the report.

Every section shows the same five figures for its set of deals:

Figure What it is
Deals How many open deals
Value Their Value (total contract value) added up, before weighting
MRR Their monthly recurring revenue added up, per month
One-time Their one-time fees added up: setup, project or hardware revenue billed once
Weighted Each deal’s Value multiplied by its own Probability, added up

Value is the full picture; MRR and One-time are the parts you plan against. They are never blended into one headline.

The five figures across every deal the report counts. Each opens the whole list.

One row per month, with the months that have no deals kept, so a gap in the forecast is visible.

  • Under a period, the rows are the period’s calendar months. A period longer than 13 months shows its earliest 13, then one row After the last of them holding the rest of the period, so the column still adds up to the totals. Choose a shorter period to see those months apart.
  • Under All time, the rows are this month and the next eleven, with a row Before them for deals whose expected close date has already passed, and a row After them for deals expected later. Click Before to find deals whose date needs updating.

One row per stage that has open deals, grouped by pipeline. When more than one pipeline has deals, each row is named Pipeline › Stage. The Probability column is the stage’s win probability from Settings > Pipeline & Sales Stages: the default each deal starts from when it enters the stage. The row’s Weighted figure uses each deal’s own probability, so a deal a rep has raised or lowered weighs by that number, not the stage’s. A deal in no stage appears as No stage.

Always four rows: Commit, Best case, Pipeline and No category, in that order. A deal’s category is set on the deal or taken from its stage’s default; No category is a deal with neither.

A deal with no expected close date falls in no period and no month. Under every period a line below the tables says how many open deals have none and what they are worth; click the count to open them and set their dates. Under All time they are in the totals and in the stage and category tables, but still in no month row.

  • A deal is open when its stage’s Outcome is Open, or it has no stage yet. Won and lost deals are not shown. The stage name doesn’t matter.
  • Weighted uses each deal’s own Probability, the same number the MSP revenue report and the opportunities board weight by, so the three agree. A deal takes its stage’s probability when it enters the stage; a rep can change it on the deal. Changing a stage’s probability in settings affects deals that enter the stage from then on, not deals already in it.
  • When every open deal has a probability of 0%, Weighted is 0 everywhere and the page says so. Set probabilities on your stages so new deals start with one, and set them on the deals already open.
  • A period is whole days in your own time zone, or your company’s if you haven’t set one. This month, This quarter and This year run to the end of the period, so deals expected later in it are included.
  • Amounts are shown rounded, such as $12.5K.
  • Put an expected close date on every open deal. A deal without one is in no month and in no period but All time, so the quarter reads lower than it is. Check the line below the tables each week and clear it.
  • Set stage probabilities from real close rates. Weighted is only as good as the probabilities on your deals, and those start from the stage’s. Review the stage defaults each quarter against what actually closed, and ask reps to change a deal’s probability only when they know something the stage doesn’t.
  • Watch the Before row under All time. A deal whose expected close date has passed is either slipping or dead. Move its date or move it to a lost stage.
  • Read MRR and One-time apart. A quarter that looks strong on Value may be one large hardware order. MRR tells you whether the recurring base is growing.
  • Use forecast categories for the call. Commit is what you would stake the quarter on, Best case what could land. Keep Pipeline for the rest, and the category table becomes your forecast call in one glance.

The report says no open deals are expected to close in this period. Nothing matches the period and filters. Set the period to All time and clear the other filters. If it then says there are no open deals yet, no deal you can see is in an open stage.

An open deal is missing. Its expected close date is blank or outside the period, or its stage’s Outcome is not Open. Set the date, choose a longer period or All time, or check the stage under Settings > Pipeline & Sales Stages.

Weighted is 0 everywhere. Every open deal has a probability of 0%, usually because the stages had none when the deals entered them. Set probabilities on the stages in pipeline settings so new deals start with one, and set them on the open deals.

A row’s Weighted isn’t its Value times its Probability. The Probability column is the stage’s default; Weighted uses each deal’s own probability. A deal in that stage has been set to a different number. Open the row’s deals to see which.