Contractor Sales Forecast Worksheet & Draft Builder

Enter your details

Industry*

Forecast period, as-of date and outcome basis*

Anonymized, non-overlapping pipeline cohorts*

Actuals already achieved and exclusions*

Optional goal and separate capacity inputs

Fictional monthly signed-revenue model

Build the estimate without moving the goal

Already signed: $100,000
Recorded actuals, outside the open-proposal cohort.
Modeled addition: +$60,000
10 open proposals × $20,000 × 30% assumed conversion within this month.
Combined estimate: $160,000
Actuals plus the modeled addition.

Separate goal: $200,000

Modeled gap: $40,000

A signed-job forecast and a cash forecast need different evidence

A forecast needs a clear finish line: signed work, completed jobs and collected revenue are different outcomes. Enter the period, as-of date and outcome basis before listing opportunities. Then separate actual results already achieved from the open pipeline that may contribute during the remaining period. If one job appears in both groups, the forecast can count it twice.

Use non-overlapping cohorts with their counts, values, timing and evidence. A stage name such as proposal sent does not supply a conversion probability. When an assumption is used, state its basis and keep it visible beside the estimate. The generator should organize the reasoning, not manufacture historical performance the business has not measured.

Timing is part of the forecast, not a footnote

A proposal expected to sign next month does not belong in this month’s signed-work forecast. A signed job does not automatically belong in this month’s collections. State the outcome and time period first, then identify which records can contribute to it. That prevents one appealing pipeline total from being used to answer several incompatible questions.

Actuals already achieved should be separate from open opportunities. When an opportunity changes stages, move it within the open population rather than leaving a copy in both stages. Keep revised values and exclusions traceable so a larger total can be explained as new work, a changed amount or a corrected duplicate.

Show one cohort calculation in full

In a fictional signed-work forecast, two already-signed jobs total $40,000. Four separate open proposals are each worth $20,000 and might sign within the period. A stated 50% scenario assumption contributes $40,000 from that open group, producing an $80,000 total including actuals. The 50% is illustrative, not a measured conversion rate or a claim about your pipeline.

If one of the four proposals moves outside the period, the same assumption produces $30,000 of open contribution and a $70,000 total. Nothing about the sales quota target changes that arithmetic. Review the uncertain customer decision through the estimate follow-up process; update the timing from actual information instead of increasing probability to recover the target.

Use assumptions as questions the team can revisit

A probability without a basis is not made reliable by a precise percentage. If the source does not establish a comparable rate, show the assumption or unresolved information explicitly. At the next review, explain which opportunities advanced, which dates moved and which assumptions changed. The goal remains a separate comparison. Missing the target may prompt action, but it should not cause the forecast to be rewritten as the number leadership hoped to see.

Timing can change the answer without changing the deal count

If five proposals move to next month, only five remain in this period’s open cohort. At the same value and conversion assumption, the modeled addition becomes $30,000 and the combined estimate becomes $130,000.

Why the conversion rate is an assumption here

This fictional exercise supplies 30% to demonstrate the model. It is not a contractor benchmark or a prediction about your pipeline. Use a defensible rate for the defined cohort and keep its source visible.

Define the forecast period and avoid double counting

Fix the snapshot and basis
Record an as-of date, period end and what counts as the outcome. A signed sale is not automatically installed revenue or collected cash.
Build non-overlapping cohorts
Record remaining eligible value, stage, age and source. Exclude actuals, duplicates and work outside the horizon.
Use period-specific evidence
Supply observed conversion and timing from comparable cohorts. Leave the forecast incomplete if that evidence is missing.
Save and backtest
Keep each dated version. Compare its estimate with later actuals on the same basis; record value error, timing misses and changed assumptions.

Keep the forecast reproducible next week

Use the blank forecast assumptions register (CSV) to keep the observation date, period, revenue basis and evidence beside each amount. The download is a record sheet; it contains no automatic formulas or imported CRM data.

Freeze the cohort: list which proposals were open on the observation date.
Separate already signed work before applying a conversion assumption to the remaining proposals.
Record which dates or assumptions changed at the next review. Explain the movement instead of silently replacing last week’s estimate.

For a workbook with built-in calculations, Smartsheet publishes downloadable forecast spreadsheets. Use this tool for the contractor-specific assumptions and written explanation. When the question is what the team must produce to reach a target, use quota capacity planning.

Questions about sales forecast template

Is working backward from a revenue goal a forecast?

No. It is a capacity scenario. A period forecast needs a dated pipeline and evidence about the outcome and timing.

Can I use an eventual close rate for this month?

Not without timing evidence connecting that rate to the forecast horizon. Label it as an assumption or leave the period estimate unresolved.

How many $12,000 jobs meet a $400,000 goal?

34 whole jobs. The unrounded ratio is 33.333 expected job equivalents; 33 jobs only produce $396,000.

How do I check forecast accuracy?

Save the original as-of snapshot and compare it with actual outcomes for the same period and basis. Separate timing error from value error.

Does GhostRep automatically import every deal?

This public generator uses the inputs entered here. It does not connect to your CRM or verify pipeline records.