WorkluneHow to Use a Sales Pipeline Spreadsheet for a Small Service Business
A sales pipeline spreadsheet helps a small service business see where potential revenue is coming from and what action is needed to move opportunities forward.
Define a small set of stages
Use stages that reflect actual buying progress, such as New Lead, Contacted, Discovery, Proposal Sent, Negotiation, Won and Lost. Every stage should represent a meaningful change in the sales process.
Avoid adding stages just to make the pipeline look sophisticated. Too many stages create subjective data and make comparisons harder.
Track expected value
Expected value is the amount the opportunity could be worth if it closes. For retainers, decide whether you are tracking monthly value, contract value or another consistent measure.
Consistency is more important than the exact convention because it lets you compare opportunities and total pipeline over time.
Use probability as an estimate
Probability is not certainty. It is a planning estimate that can help calculate weighted pipeline: expected value × probability.
If a €2,000 opportunity has a 50% probability, its weighted value is €1,000. The total weighted pipeline gives a more conservative view than simply adding every possible deal at full value.
Require a next action
An opportunity without a next action often stalls. Record the next step and target close date for every active opportunity.
This turns the pipeline from a reporting board into a work queue: send the proposal, book the meeting, follow up on approval or confirm the decision.
Review movement, not only totals
During a weekly pipeline review, check which opportunities moved forward, which stayed stuck and which need to be closed as lost. A growing total is less useful if nothing progresses between stages.
Over time, stage movement and win/loss patterns can help you improve follow-up, qualification and forecasting.