Edition: Professional, Business, Enterprise
User-level: Assistant Project Manager and above
What is the revenue forecast and why use it?
The Revenue Forecasting Board displays the expected invoice schedule across your project stages, month by month. You can drill down to stage level and adjust amounts and timing as needed.
Accurate revenue forecasting is essential for effective cash-flow management. By providing a clear monthly view of projected income, the board helps you quickly assess whether revenue will cover business costs, making it a vital tool for maintaining profitability.
Project List
The left-hand menu displays all projects
Legend:
Red arrowheads, red dots, red numbers: There is something wrong with one of the stages in your project. More than likely, the forecast does not equal the fee.
Teal arrows: There are no issues with this project.
Actions available:
Arrow: The arrow to the right of the project name brings the project into view.
Arrowhead: The arrowhead to the left of the project name expands the project to reveal all phases and stages.
Monetary value: Displayed to the right of the project or stage, this shows the total fee or budgeted value for hourly rates stages.
Percentage value: Shown next to a stage, this indicates the stage’s fee as a percentage of the overall phase or project fee.
NOTE: If a stage does not have a start or end date and you will need to go back to the planning board to amend it.
Revenue rows
The rows in the grid show the monthly expected income for each project in your organisation
Teal bar: Indicates projects with active status currently in delivery.
Lighter teal: Represents projects in proposal status.
Figure in a row: For the current month and beyond, figures show expected revenue; for past months, they show actual invoiced amounts.
Grey overlay: The grey overlay indicates time already passed. Figures within the dark overlay represent amounts already invoiced.
Stage Tool Tip
The stage tool tip displays the following information
Status: Current status of the stage.
Fee: Fee amount for the stage; for hourly rates, this reflects the budgeted value.
Invoiced to Date: Total amount invoiced for this stage so far.
Forecast: Total forecast value for the stage.
Balance: Difference between the fee, invoiced to date, and forecast. (calculated as fee - invoiced - forecast)
Completed: Percentage of stage completion, based on the project work breakdown.
To view the stage tool tip:
Expand the project row from the project list to view all stages.
Hover over the stage in the planning board to display the tool tip
Target Revenue View
The revenue view helps you monitor whether your forecast meets essential targets.
Baseline: The black baseline represents the minimum monthly revenue your business needs to break even, ensuring all costs are covered.
Revenue: The blue line shows the weighted revenue forecast for each month, highlighting if you’re projected to be above or below this target.
The baseline is automatically calculated based on staff costs, using the formula:
Target Revenue = Daily costs × Average working days per month
Daily costs = Actual cost unit × Availability × Utilisation × Daily possible hours
Search the revenue forecast
Type part of the 'project name', ‘project manager’ or 'project number' into the search barat the top of the projects list and press enter to run the search.
Filter the revenue forecast
Click on the filter icon and expand the filters you wish to apply.
Select your desired filter options and click ‘apply filter’.
To view save and load filters read the article here
Custom Distribution
By default, each stage’s fee is forecast evenly over its duration, but you can customise this and edi the monthly invoice values.
Expand the project row from the project list to view all stages.
Click the '...' next to a stage and select Custom Distribution.
You can either:
Keep and adjust the current linear distribution, or
Remove it and start from scratch.
To update the forecast, click under the relevant month and enter the amount you plan to invoice.
Click outside the cell to save.
Note: If the row turns red, the forecast doesn’t match the fee. Hover over the stage to view a tooltip showing the fee, invoiced to date, and total forecast.
Edit Stage Dates from Forecast
You can edit your stage dates directly from the revenue forecasting screen.
Expand the project to stage level from the project list
Click on the stage name that you want to update your stage length for in the left panel.
Edit the start and end date in the panel that appears on the right
Select Save
Note: editing the stage dates will impact the resources, ensure you select the correct stage resources option
Edit the stage fee
You can edit your stage fee directly from the revenue forecasting screen.
Expand the project to stage level from the project list
Click on the stage name that you want to update your fee for in the left panel.
Edit the fee in the panel that appears on the right
Select the back icon to save
Revenue breakdown views
You can customise the revenue forecast view to display gross revenue, internal revenue, external revenue, or expenses revenue.
Each view shows the forecasted monthly values for that category.
To change the view, click the Gross Revenue dropdown at the top right of the revenue forecast and select your preferred option.
Internal
The internal revenue view displays the difference between the fee and the external/expenses budget. If no external costs or expenses are budgeted, this value matches the fee, allowing you to track revenue from internal staff work.
External
The external view shows the external budget for each stage, letting you forecast work that will incur external costs to be paid out.
Expenses
The expenses revenue view highlights the budgeted expenses for each stage. For example, if a stage fee is £28,000 and £1,000 is allocated for travel expenses, the expense revenue will show as £1,000.
Note: internal, external, and expenses views are fixed and display a linear forecast across the stage duration.
Download the revenue forecast
From the menu, you can download a PDF report of the revenue forecast. Click the ellipsis (three dots) on the right, then select Download Revenue Report.
The report will reflect any filters applied on your Revenue Forecast page.
Example: If you filter by Externals, the downloaded report will be the External Forecast Report instead of the Gross Revenue Forecast.