Revenue Forecasting In Salesforce – Reconciliation

Revenue Forecasting In Salesforce – Reconciliation

When we think of the accounting process of reconciliation, we typically are thinking of the reconciliation of the balance sheet accounts. After all, the working capital side of a business is closed out annually and the earnings or losses are swept into retained earnings. The FASB requirements and standard practices of reporting for organizations.

But back on the working capital side of business where operations take place (Sales and Expenses), there is a far more important reconciliation process that is imperative to the life blood (cash) of a business. This reconciliation centers around the most important account in the chart of accounts, revenue.

Yes, sales reconciliation is full of bends and twists. We read about it every day, organizations missing the mark on sales forecast. Do you ever wonder why this occurs?

At White Rock, we work in every day and we serve our customers who use it for tracking customer activity, recording opportunities for leadership, and addressing the anticipated sales transactions in the organization. The revenue may be derived from services, products, or donations.

What we know about the system processes that we build is that there is a defined and predictable relationship between the data recorded in an opportunity’s stage of the sale and the forecast category. For example, an organization may have a five-stage sales process like this:

  • Initiate
  • Discovery
  • Prove
  • Propose
  • Negotiate

These stages would be related to a forecast category setup maybe like this:

  • Pipeline
  • Best Case
  • Commit
  • Likely to Close

There is a percentage that is assigned to the stage to represent how likely that opportunity will be to get booked as a sale. These percentages are determined based on history and sales management’s sales process activity criteria. Here is an example of how this all comes together in

Stage                     Probability of Close                         Forecast Category

Initiate                  10%                                                        Pipeline

Discover               20%                                                        Pipeline

Prove                    50%                                                       Best Case

Propose               70%                                                        Best Case

Negotiate            90%                                                        Commit

In this example, if we have a deal that is in the Prove stage, then management has determined that 50% of the time, half the deals, will close when they reach this stage and they are categorized for Forecasting purposes as a best case. If the total value of those deals is $2,000,000 then experience says that $1,000,000 will result in booked sales.

Now the tricky part. What “moves” a deal along in these stages that provides the forecast outcomes? Well, sales activity on behalf of the sales team, of course. It is assumed that the activities are accurate and well-defined to result in a predictable probability of booked sales.

But what happens if a salesperson is “pushing” the input of data to better reflect a deal’s progress to help the in-process performance look better? Of course, then, we have a padded prediction. If management is not testing the sales activity inputs and puts an inherent trust in the values provided in the sales activity, then a risk is now set in a deal’s outcome. There is a mismatch now recorded in the deal tracking system between the buyer’s view and the seller’s view. Here is where the reconciliation of forecasted revenue breaks down.

This is where organizations should focus their reliance on the type of sales activity that is required in a specific stage of a deal/opportunity. We see so many times where there is poorly defined or subjectively defined activity requirements that are not really supporting a buyer’s behavior. As a result, quarterly forecasts become overstated and unreliable or, even worse, dangerously reflecting the value of future cash flows.

We believe that proper processes and tools that can be associated with long cycle sales are the most important, tactical weapons against this risk. We work with several organizations that focus on this and, in fact, we have developed applications native in to help leaders have reliable sales forecasting.

We recommend that these types of tools be leveraged to provide a more objective set of activities that are related to the buyer’s journey and behavior. Using them will thwart the subjective input of data that can skew the success of a deal. We invite you to learn more about how White Rock can help you ramp up and conquer the risk and dangers of over-stated progress of deals in your organization.

The proper reconciliation of revenue in an organization is so vital to a healthy predictable cash flow. The setup of the Opportunity object in utilizing the standard fields Stage and Forecast Category are vital. If this is an area where you think your organization can improve, please give us a call.

Revenue Forecasting In Salesforce – Reconciliation

Revenue Forecasting In Salesforce – Key Components

Reporting the revenue forecast in is vital information for predicting Sales, budgeting operational support and planning cash flow. The sales team is hard at work moving deals to close and staying on track while management is reviewing these deals to determine how viable and credible the forecast will be for the specific reporting period. Let’s take a deep dive into a simple illustration of how this gets done and what the components are of the forecast.

The deals, or Opportunities, as the standard name goes in Salesforce, are the records stored in the database that show how well a deal is progressing towards the expected close date and amount of the sale. Each deal has some standard fields that are used to reflect and calculate this important milestone. Here is a summary of these standard fields that help with the forecast report:

  • Opportunity Name – the identifying name of the specific deal
  • Opportunity Owner – the rep that is working the deal and owns its success
  • Stage – the progress point of the deal (refer to last week’s article for more details)
  • Opportunity Amount – how much the deal is worth in dollars
  • Close Date – the date that the deal is expected to close and become a sale
  • Probability – the percentage used of deals in a particular stage that close historically (refer to last week’s article)
  • Forecast Category – the value assigned to a stage when reporting sales pipeline results

NOTE: If you didn’t read last week’s article, this would be a good time to refer back so that the calculations are clear as we present the reporting of opportunities below.

The critical computation for the forecast is related to the Opportunity Amount, the Stage, and the Probability. Because management continuously reviews the percentage of deals that close based on information gathered that is related to a “good” deal and a “not-so-good” deal, the probability represents what the likelihood is that a deal will close with the details of each input about the deal. Here is an example of a typical forecast report:

As you can see from the example, the Amount column represents the total expected revenue to be generated from the deals in the list while the Expected Revenue is related to which stage the deal is in and the probability associated with that stage based on historical outcomes. For example, the first deal in the report for XYZ Corp, shows a deal that is valued at $1,500 but because it is so early in its stage, the deal probability is only 10% based on experience. The basis of the 10% can be further adjusted if the parameters of this specific deal are not in line with what historical deals may have had too if they are vastly different from past deal parameters.

Let’s dive into parameters now. These parameters are custom defined attributes of a deal based on sales leadership’s knowledge of their product and services. Each stage has a set of specific parameters that must be articulated to a prospective customer to learn whether they are a true buyer.

Suppose we look at all the stages in another deal example. Looking at each stage below, we have a specific set of actions and information that must be captured by the rep from the prospect by stage to give credibility to the overall health a deal. Here is a table of what this might look like:

Stage – Prospecting
Parameters to learn in this stage:

  • Reception to Elevator Pitch – pitch the deal
  • Size of organization – how big is the org – are they the right “fit” for our product/service
  • Has a compelling driver for product/service – what is the pain point that they are experiencing
  • There is a project sponsor and budget – can they fund this project or get funding – what is the cost of doing nothing?

Stage – Discovery
Parameters to learn in this stage:

  • Define current problem – size up the problem and the effect on the organization’s operation – what is the metric
  • Where is the pain felt from the problem – which area of the organization is experiencing the problem
  • What other options are being considered for the solution – competitors

Stage – Solution/Presentation
Parameters to learn in this stage:

  • Share solution options and successes from them – present the solution and pricing
  • Implementation timeline presented and solution demonstrated – how will the solution get implemented and how long will it take
  • Feedback on demonstration – what is the reaction and next step from the prospect and the sponsors

Stage – Negotiate and Close
Parameters to complete in this stage:

  • Submit final adjustments and contract for signing – any discounts, other terms and conditions to consider pushing the deal through
  • Plan implementation – bring the players in for the implementation game plan
  • Get documents signed and hand-off to production – ink the deal!

Each of these parameters for the stages in this example are key turning points (tipping points that take the deal to the next step/deal velocity) for the deal to progress and move forward. As each of these parameters are learned, completed, and evaluated for quality related to the history of similar opportunities, the probability is established based on the answers to each of the parameters. For example, if in stage Prospecting, it is learned that there is no funding for the deal, then the chances will be very low to zero that this deal will progress, so it would fall “outside” of the “normal” historical deal flow for this stage.

We invite your feedback and ideas to share related to the revenue forecast. Please contact us with your comments and questions.