The Forecast Report provides an easy way for you to see how you, your team, or your entire enterprise are performing with your Forecast (Booked Dollars + Pending Dollars) against your Budget.
To create the Forecast Report, please follow the below instructions:
- Please navigate to Reports on the menu bar.
- Click the Forecast & Deals tab.
- Click Forecast Report link.
On the Options screen, you will be presented with the below options to build your report.
- Hierarchy Selection - in this drop-down you may select the attribute(s) that are to be on the report
- Calendar Selection - in this drop-down you may select what calendar type the report will utilize
- For Time Frame Selection - in this drop-down you may select the time frame of the report
- Roll Up Results By Selection - in this drop-down you may select how you may want to roll up the results by a lump sum or by a time period, such as a month
- Show Pending and Forecast As Selection - Show pending and forecast as Unweighted, Weighted (a confidence percentage is applied to the pending values according to individual deals), or display both amounts at the same time on a report.
- Forecast or Pipeline Selection - allows to change the report to show the Open Pending dollars only (Forecast) or Open Pending Dollars + Open Proposed dollars (Pipeline). You can also choose Both.
- Budget Type Selection - allows you to choose a Bottom-Up or Top-Down view of the budget. This functionality is only available for managers. The Top-Down option will only be useful if you are budgeting Top-Down.
- Include Pitched Projects as part of my forecast - allows dollars from any projects that have been pitched to be included as a separate column on the report.
- Only Show Rows with Pending Dollars - will remove any rows on the report where Pending is equal to $0. Please note that when viewing a monthly roll-up, that you will still show $0 pending months when at least one other month has pending greater $0.
- Run Button - once all options have been selected, clicking the Run button will run the report
Clicking the Filters tab will allow you to select or not select various data points or groups within the report.
Once the report is run, the screen will display the report based on the Options and Filters selected. A view like the below will appear.
- Show Option - clicking this button will show the Options and Filters dialog to edit the report and allow you to re-run the report
- Hide Chart - clicking this button will remove the chart from the view
- Chart Field - the report will display a line chart showing the trending over the time frame that was selected
- Favorite Icon - clicking the Star icon will allow you to save the report has a favorite. Once saved as a favorite, the report can be shared to other users
- Download - in the drop-down a user can select to export the data in either a .csv format or Microsoft Excel format. Clicking the icon next to the drop down will download the report in the selected format
- Report Data - the table at the bottom of the screen is the data from the report. The Forecast Report is formatted so that the hierarchy is on the far left, followed by the following columns:
Notes:
-To view Deal notes, you must choose Deals in the Hierarchy. Then after running the report, click the Note icon next to the Deal name.
-Estimated Close Date and Sales Stage will be hierarchies. They do not have grouping options.
-Sales Stage filter does not have grouping options.
-Estimated Close and Creation Date will be an option whenever Deal is a hierarchy.
- Billed TY - The amount of dollars booked for the time frame selected
- Pending - The amount of dollars on Open-Pending Deals for the time frame selected. These are typically later stage dollars that you are more confident in adding to the Forecast calculation"
- Weighted Pending - The amount of dollars on Open-Pending Deals for the time frame selected individually multiplied by the Deal’s percentage weight
- Forecast - Calculation of ((Billed TY) + (Pending))
- Weighted Forecast - Calculation of ((Billed TY) + (Weighted Pending))
- Budget - The amount of dollars budgeted for the selected Budget Type (Bottom-Up or Top-Down) in the time frame selected
- Proposed - The amount of dollars on Open-Proposed Deals for the time frame selected. These are typically early stage dollars and not tracked in Forecast
- Pipeline - Calculation of ((Booked TY) + (Proposed) + (Pending))
- $ Diff Forecast/Budget - Calculation of ((Forecast) – (Budget))
- % Diff Forecast/Budget - Calculation of ((Forecast) / (Budget))
- $ Diff Weighted Forecast/Budget - Calculation of ((Weighted Forecast) – (Budget))
- % Diff Weighted Forecast/Budget - Calculation of ((Weighted Forecast) / (Budget))
- Billed LY - The amount of dollars booked 1 year prior to the time frame selected
- $Diff FC-LY - This Years Forecast Total Minus Last Year Billing
- %Diff FC/LY - This Years Forecast Total divided by Last Year Billing
- $Diff Weighted FC-LY - This Years Weighted Forecast Total Minus Last Year Billing
- %Diff Weighted FC/LY - This Years Weighted Forecast Total divided by Last Year Billing