Are you simply betting that your future will be bright? Or are you using your data to plan for tomorrow? As my data-loving, gal-pal, Stacey Ho, CPSM, puts it: “Forecasting is a little bit of science, and a little bit of crystal ball.” In this blog, I’ll share what forecasting can tell you, and how to get started today using anything from Excel to a major ERP finance software system. Your firm, no matter what size, can take small steps to plan for a bright future.
Forecasting is a way to use your pipeline to demonstrate potential future sales. It helps your firm make smarter decisions or know when to course correct. Forecasting can tell you if you need to identify more work, improve your hit hate, recognize “must-win” opportunities, or even when to hire more staff.
To get started with forecasting, you will need to set yourself up for success. This is done through aligning the right people, process, data, and technology:
People | You will first want to have a good understanding of who is responsible for data collection, maintenance, input, etc. and who will be gathering and reporting on the data. Consider who has both the knowledge and the time to put the forecast together. Lastly, make sure you have buy-in from your firm leadership.
Process | Once you have the people identified, it is time to start working on the process. This includes setting sales goals for your firm, so you have them to compare the forecast to and which can be developed using a top-down or bottom-up approach. You will also want to determine the frequency in which you report the forecast and how often you will update it. The frequency can be weekly, monthly or quarterly. I recommend beginning with quarterly and eventually increasing to monthly for firms just starting to forecast, Additionally, you will need to decide how far out into the future your forecast goes. The two most common forecasts are the current calendar or fiscal year and a rolling 12-month report.
Data | To build your forecast you need data. This includes dates, dollars, and status. I will go into more detail regarding the minimum data you need to build a forecast in just a bit.
Technology | Once you have identified people, process, and data, you will have a pretty good idea of what type of technology is needed. CRM systems, like Deltek Vision and Vantagepoint, are developed specifically to make reporting forecasts seamless and automated. Once the information is entered into the system, you can build reports or dashboards easily, segment the data by office or market, and schedule the reports to be delivered automatically.
Since a forecast is predicting your sales into the future, there are some minimum pieces of information you need to record to develop a forecast report. Those pieces of information are:
There are some other data fields that will make your forecast reports even better:
Now that you have set up your initial forecast report, make sure you maintain it on whatever frequency you decided above. Maintenance encompasses:
While forecasting can tell your firm if it will meet its goals, there are some other uses of sales forecasting. In my experience, forecasts have been used to:
Stop guessing what the future will look like for your firm by developing a sales forecast. With some minimum information that is tracked in a CRM like Deltek Vision or Vantagepoint, you can easily build a forecast report that will give your firm a clear picture of the future. Ready to get started?