Revenue forecasting for small teams, without fancy software
For a team under about ten people, a five-column spreadsheet will out-forecast most CRM reporting, because the thing that makes forecasts accurate is not the tool but the record, and a spreadsheet keeps a record perfectly well. Below: the exact sheet, the twenty-minute monthly routine, and the point at which software genuinely starts to help.
The sheet
One row per open deal. Five columns, in this order, because this is the order you will fill them in while talking:
- Owner — so you can eventually tell whose calls hold up
- Deal — enough to recognise it in a meeting
- Value — what lands in the period, not total contract value
- Odds — the owner's own number, not a stage default
- Close month — month, not a specific day
Add one computed column: value × odds. Sum it and you have your weighted pipeline. Add a second: odds × (1 − odds) × value², sorted descending. That one tells you which deals carry the uncertainty, which is the column that changes how your meetings run.
That second column is the whole reason to bother. It will usually show that three deals out of thirty account for most of the doubt in your quarter, and those three are the only ones worth arguing about.
The monthly routine
At the start of the month, duplicate the sheet to a dated tab and freeze it. This takes ten seconds and is the single most valuable habit in the whole exercise — it is what turns a pipeline into a record.
During the month, update odds when something actually changes. Not weekly for the sake of it. A deal whose odds have not moved in three weeks either has not moved, or nobody has checked.
At the end of the month, mark each deal won, lost or slipped, and write two numbers in a running tab: what you forecast at the start, and what closed. Two numbers a month. After six months you can answer whether you run hot, by how much, and whether it is improving.
What a spreadsheet will not do
It cannot give you a range. Weighted pipeline is a point estimate; working out the distribution of outcomes needs simulation, which a spreadsheet does badly. With few, uneven deals this matters more than anything else on this page.
It will not survive two people editing it. The moment a second person updates the sheet during the meeting, you need a shared tool or a discipline about who types.
It degrades past about fifty rows. Not because the maths breaks, but because nobody scrolls, and deals you do not look at drift.
When a tool earns its place
Three thresholds, in the order they usually arrive. When the sheet passes about fifty open deals and the long tail stops being reviewed. When more than two people need to edit it at once. And when you have a year of frozen monthly tabs and want to actually analyse them, which is tedious by hand and is where most teams quietly give up on the record.
Before those, a tool mostly replaces a sheet that was working with a subscription that does the same thing. The accuracy came from the habit, and the habit is free.