Sales forecasting and revenue reporting

How to build a forecast you can defend, test its accuracy and report on revenue without drowning in spreadsheets.

All answers

In-depth guides on this topic

How do I forecast sales?

Apply historical stage conversion rates to your current open pipeline, adjust for expected close dates, and compare the result against the same period last year plus known seasonality. Forecasting from rep-entered percentages alone is consistently optimistic.

How accurate is my sales forecast?

Measure accuracy by comparing forecast with actual over several closed periods. Within ten percent is strong, ten to twenty percent is workable, and beyond that the underlying stage definitions or close-date discipline need fixing. Track the error direction – persistent over-forecasting points to weak qualification.

What is revenue forecasting?

Revenue forecasting predicts total revenue over a future period from all sources – new business, renewals, expansion – minus expected churn. It is broader than a sales forecast, which typically covers only new deals, and it is what informs hiring and budget decisions.

How do I build a revenue forecast?

Start with committed recurring revenue, add weighted new business from pipeline, add expected expansion, then subtract forecast churn. Build best-case, commit and worst-case scenarios so you can plan spending against the downside rather than the hope.

What sales reports should a small business have?

Five reports cover most needs: pipeline by stage, forecast versus target, win/loss analysis, lead source performance and rep activity versus outcome. Automate their delivery on a weekly and monthly schedule so reporting does not depend on someone remembering.

Related topics