Skip to main content

Revenue Forecasting Overview

Revenue forecast

Updated this week

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:

  1. Expand the project row from the project list to view all stages.

  2. 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

  1. 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

  1. Click on the filter icon and expand the filters you wish to apply.

  2. Select your desired filter options and click ‘apply filter’.

    • Upon applying your filter, you’ll see your search results. The blue dot on the filter icon indicates that filters have been applied.

    • By clicking on the filter icon, you can see which filters have been applied.

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.

  1. Expand the project row from the project list to view all stages.

  2. Click the '...' next to a stage and select Custom Distribution.

  3. You can either:

    1. Keep and adjust the current linear distribution, or

    2. Remove it and start from scratch.

  4. To update the forecast, click under the relevant month and enter the amount you plan to invoice.

  5. 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.

  1. Expand the project to stage level from the project list

  2. Click on the stage name that you want to update your stage length for in the left panel.

  3. Edit the start and end date in the panel that appears on the right

  4. 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.

  1. Expand the project to stage level from the project list

  2. Click on the stage name that you want to update your fee for in the left panel.

  3. Edit the fee in the panel that appears on the right

  4. 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.


Did this answer your question?