The Revenue Forecast visualises expected revenue over the next six or twelve months. It is based on roles that are definitely booked, preliminarily booked, or not booked within projects marked as Won or Open.
To view the Revenue Forecast, you must have the user role Manager and the Talent Business module activated.
Access the report by navigating to: Reports > Projects > Revenue Forecast.
Understanding the Report
The Revenue Forecast displays expected monthly revenue using colour-coded bars. Hover over each segment for more detail. You can tailor the view using various filters.
Available Filters
Currency: Daily-updated exchange rates
Period: 6 or 12 months
Owner Team: Set in the project detail view
Resource: Employee or Subcontractor
Delivery: Booked employees
Group: Subcontractor groups
Allocation: Assigned, Preliminary, or Not Booked roles
Customers
Pipeline: Project stage
Colour Coding in the Report
Green: Revenue from employees with definitely booked roles
Dark Green: Revenue from subcontractors with definitely booked roles (Talent Partner module required)
Blue: Revenue from employees with preliminary bookings, adjusted for role probability
Dark Blue: Revenue from subcontractors with preliminary bookings, adjusted for role extent (Talent Partnermodule required)
Grey: Created roles with no bookings
Below the chart, you can view detailed revenue per month and per project/customer.
Included Parameters Projects with status Open or Won are included if roles meet the following criteria:
Defined Start and End dates
Defined Price (hourly or fixed)
Defined Extent (hourly or fixed)
For preliminary or non-booked roles, the probability is factored into revenue calculations.
Planned absences and bank holidays reduce the calculated revenue accordingly.
Revenue Calculation Method
Revenue is calculated based on the role's parameters, using your organisation's calendar settings to determine working days and hours.
Examples:
Hourly Rate + Percentage Extent
Start: 01.02.2020 / End: 29.02.2020
Working Days: 20 / Hours per Day: 8
Price: €100/hour / Extent: 50%
Calculation: (20 × 8 × 100) × 0.5 = €8,000
Fixed Hours
Same period
Price: €100/hour / Extent: 100 hours
Calculation: 100 × 100 = €10,000
Fixed Price Over 2 Months
Start: 01.02.2020 / End: 31.03.2020
Total Working Days: 42
Price: €20,000 / Extent: 200 hours
Daily Revenue: 20,000 / 42 = €476.19
February: 476.19 × 20 = €9,523.80
March: 476.19 × 22 = €10,476.20
Preliminary Role with Probability
Same as Example 1, with 70% probability
Calculation: 8,000 × 0.7 = €5,600
Revenue is adjusted for any bank holidays or planned absences by subtracting the corresponding daily value per affected day.