Most UK small business owners manage their sales pipeline from memory — which means deals go quiet, quotes go cold, and revenue that was almost theirs disappears. A sales pipeline does not need to be complicated or expensive. It needs to be visible and consistent.
What a sales pipeline actually is — and why most small businesses do not have one
A sales pipeline is a list of every live opportunity your business is currently working on, with its current status, its value, and the next action required. That is all it is. Most small businesses have something like this in their heads — but the moment it lives only in memory, it stops being managed and starts being forgotten.
Without a visible pipeline, you cannot forecast revenue, you cannot spot which deals are going cold, and you cannot prioritise who to contact today. You react to whoever shouts loudest rather than whoever is most valuable and most winnable.
The pipeline stages every UK small business should track
You do not need many stages — complexity kills consistency. Five stages work for most owner-led businesses: Enquiry Received, Quote Sent, Negotiating or Follow-Up, Verbal Agreement, and Closed. Move every deal through these stages as they progress and you have a live view of your pipeline at any moment.
For each deal, record the client name, the estimated value, the date you last contacted them, and the next action with a date attached. That is enough information to run a meaningful weekly pipeline review in fifteen minutes.
How to track your pipeline without CRM software
A spreadsheet can be enough when the team is small and the number of open opportunities remains manageable; there is no universal deal-count cutoff. The key is consistency of format — the same stage names, clear ownership and a regular update routine.
Useful columns include customer, lead source, service or product, expected value, stage, date received, last contact, next action and due date, expected decision date, outcome and lost reason. Limit personal data to what you need, give access only to people who need it, and agree which version is the source of truth. If follow-ups are missed or several people overwrite records, that is a sign to improve the process or consider a CRM.
The numbers that tell you if your pipeline is healthy
Track the count and value of opportunities by stage, time spent in each stage, the proportion that move forward, and the share that become paying work. Define the denominator: for example, won jobs divided by qualified opportunities closed during the same period. Do not mix open leads with completed outcomes.
There is no single conversion-rate target that fits every sector, price point or lead source. Compare your own results over consistent periods and segments. A sudden change in quote-to-win rate may point to a shift in lead quality, pricing, capacity or follow-up; investigate the cause before changing targets.
What to do when deals go quiet
A deal may be delayed, blocked by an unanswered question, lost to a competitor or no longer a priority. Use the next-action date agreed with the prospect rather than applying one arbitrary follow-up interval to every sale. A concise message can ask whether the project is still active and whether any information would help with the decision.
If there is no response after a reasonable sequence, mark the opportunity as dormant or closed-lost, record the last contact and set a future reminder only if the customer has indicated that timing may change. This keeps the forecast honest and avoids endless follow-up. Review open deals weekly: every active opportunity should have an owner, a next action and a reason it remains open.
How to forecast pipeline value without treating every lead as a sale
Keep quoted value separate from forecast cash. A useful forecast groups opportunities by evidence and expected decision date; it should not treat an enquiry, verbal agreement and signed order as equally certain. If you use probabilities, base them on your own past results for comparable stages and lead sources, then review them against actual outcomes. Do not borrow a generic percentage and present it as a reliable prediction.
A simple example: four open quotes worth £2,000 each create £8,000 of quoted pipeline, not £8,000 of guaranteed revenue. Your expected cash date also depends on delivery, invoice timing and the customer's payment terms. Update the forecast when the stage or evidence changes.
Conclusion
A useful sales pipeline shows what is genuinely open, what evidence supports the forecast and the next action for each opportunity. Review the stages and outcomes consistently before deciding whether a spreadsheet or CRM is the better fit. The Business Dashboard Toolkit at jamesedison.co.uk/founder-os includes a Sales Tracker alongside 11 other business tools. One downloadable file. Single Business License £10.