Sales Pipeline Forecast

Aggregate deal values into weighted monthly or quarterly forecasts and an entered probability-adjustment scenario.

On-device No sign-up Free to use

Forecast weighted deals controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Processed in your browser. Your inputs stay on this device.

    Result

    Showing an example.

    Group weighted deals by expected close period and currency.

    USD deals of 1000 at 50 percent and 2000 at 25 percent in February produce a 1000.00 base forecast. Adding 10 percentage points yields 1300.00; unweighted value is 3000.00.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/sales-pipeline-forecast · 20 November 2026

    Was this helpful?

    How to use Sales Pipeline Forecast

    1. Paste a CSV table or choose a CSV file with id, value, probability, expected_date and currency headers. Deal IDs must be unique.
    2. Choose monthly or quarterly grouping and enter a scenario adjustment in percentage points.
    3. Run the forecast. Compare unweighted totals, base weighted values and scenario weighted values within each currency.
    4. Download the forecast and keep its probability and expected-close assumptions with the source deals. The result is not a payment schedule or a predicted outcome.

    Example: Sales Pipeline Forecast

    Group weighted deals by expected close period and currency.

    You add
    Open deals: id,value,probability,expected_date,currency D1,1000.00,50,2026-02-10,USD D2,2000.00,25,2026-02-20,USD Forecast periods: month Scenario probability adjustment (percentage points): 10
    You get
    USD deals of 1000 at 50 percent and 2000 at 25 percent in February produce a 1000.00 base forecast. Adding 10 percentage points yields 1300.00; unweighted value is 3000.00.

    Supported inputs and limits

    • At most 2,000 deals, 80 CSV columns and 2 MiB.
    • Deal amounts have two decimal places and are nonnegative.
    • Probabilities range from 0 to 100; a scenario adjustment ranges from -100 to 100 percentage points and the resulting probability is clipped to 0–100.
    • Dates are valid calendar dates from 1900 through 2200.
    • Three-letter currency labels form separate totals.
    More details

    No exchange rates, win-probability estimation, receipt timing or accounting revenue recognition are supplied.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved on your device.

    Questions about Sales Pipeline Forecast

    Does the forecast predict whether a deal will close?

    The calculation uses the probability you enter. It multiplies that assumption by the deal value; it does not estimate a new probability from sales history.

    How is the scenario adjustment applied?

    An adjustment of 10 changes 25 percent to 35 percent. It adds percentage points rather than multiplying the original probability by 1.10.

    Why are currencies reported on separate rows?

    Adding different currencies would produce a misleading total. Each period and entered currency label gets its own weighted and unweighted results.

    Page updated · Project managed by Tony Hines · Report a problem with Sales Pipeline Forecast