The forecast page of your deals in Teamleader Focus helps you follow up on your sales opportunities even more quickly and efficiently than before. In one overview you’ll get an idea of your expected revenue in the upcoming three months. At a glance you can also find deals without a close date and easily drag them to the month in which you expect the deals to close. Discover all about the deal forecast here!
What is it?
First of all, you can find the deal forecast by navigating to Deals and Quotations > Forecast. Based on the current open deals, you can find an overview of your expected revenue 3 months ahead.
Each month shows you a calculation of the total expected revenue. How this is calculated exactly will be explained later in this article. Below 'Total expected revenue', next to ‘Open’, you can find the amount of deals with a close date currently in that month. Moreover, you’ll find the total amount you could win if all deals are closed.
The deal forecast calculations (‘Total expected revenue’) rely of course on the amount of the deal, but also on both the close date and the probability of your deal. To fill out or change these last two fields, follow these steps and finetune your deals immediately:
Navigate to your deal forecast
Click on a deal
Click on Edit
You can also change the amount of a deal by clicking on View detail.
This leads you back to the deal overview page, where you can click the pencil next to the deal to change the amount.
On the left hand side of your deal forecast, you can find deals with the 'Date passed/missing'. These are deals that are still open, but:
either have an expected close date earlier than this month;
or have no expected close date filled out.
These deals can help you make a more accurate forecast if they have a (future) close date. The close date of these deals can easily be adjusted by:
Dragging and dropping the deal from the left column to one of the 3 other columns next to it. The deal automatically gets assigned a close date that corresponds to the final day of the month you dropped the deal in;
Filling out the close date by clicking on the deal in the deal forecast and editing it.
We point these deals out to you based on:
Expected close dates in the past, meaning that these deals require action now that the close date has passed
Weighted amount (amount excl. VAT * probability) of the deals. The most important deals are at the top of the column
When you’ve optimized your forecast, it’s time to focus on how the revenue is actually calculated.
Forecast in detail
The deal forecast focuses on how many deals you can close this current month, or in one of the upcoming 2 months.
For each month, you’ll see the following details on the deals expected to close:
Note: When you have multiple quotations per deal: When displaying the deal amount, the average of the amounts in the open quotations will be taken into account.
Deals per month are sorted on the weighted amount (amount excl. VAT * probability of the deal). This means that the most important deals are on top, in a descending view.
You can drag & drop deals inside a specific month to update the expected closing date. The deal automatically gets assigned a close date that corresponds to the final day of the month you dropped the deal in
You can click on deals and edit the expected closing date / deal probability
Total expected revenue
Each month you’ll see at a glance the revenue you can expect to win in that period:
The ‘Total expected revenue’ is calculated like this:
For the current month: Sum of the total amount of the deals already won this month and the total weighted amount (amount excl. VAT * probability) of all open deals
In this month, you'll find more information on the calculation when hovering over the question mark:
The calculation will only be shown this month, and not in the next two months. This is because you can’t have any won deals ‘in the future’.
For example: say it’s February and you’d now close a deal that had an expected close date in March, then the won deal amount will be included in February’s statistics and not in those of March.
For the next two months: Sum of all open deals based on the weighted amount
You’re also able to seamlessly filter based on deal assignee. You can find this filter in the top right-hand corner of your deal forecast.
This makes it possible to see for example:
The full company forecast for this month and the upcoming months (= no filter)
Your personal forecast (= click on your own name to filter on your deals)
The forecast of one of your colleagues (= click on one of their names to filter on their deals)
In the deal forecast, there is no difference between one-time and recurring items on your quotation
The numbers in your deal forecast are updated instantly:
every time you drag & drop a deal from one column to another
every time you edit something in the side panel (close date or probability)