Forecast Costs and Revenue in the Project Reporting Tab

Use the Forecast Dashboard within the Project Reporting tab to confidently plan your project’s future costs and revenue, track key financial metrics, and manage cashflow with ease.

Overview

Key Graphs

Cost Forecasting

Revenue Forecasting

Overview

The Forecast Dashboard brings together cost forecasting, revenue forecasting, and essential performance metrics in one place.
It’s designed to help you see exactly where your numbers come from, update them as your project progresses, and understand the combined impact of your cost and revenue forecasts on overall cashflow.

Team members with access to the project can view this dashboard by going into the Project, then selecting the Reporting Tab. 

Key Graphs

• Forecasts Graph – Displays Forecast Margin, Revised Contract Value, and Total Cost at Completion over the last 12 months relative to the current or filtered month. 

• Claimed vs Spent – Monthly view comparing claims/invoices to spent costs.

• Cumulative Claimed vs Spent – Cumulative view to highlight the gap between claims and costs, useful for identifying cashflow risks.

Revenue Forecasting

The Revenue Forecasting tool helps you plan future income based on your contract lines and any variations.

How it works:

• Contract lines and variations flow automatically into the table.
• You’ll see the Scheduled Value (contract or quoted price), Claim to Date, and Balance to Finish.
• Click the menu in the top right (three horizontal lines) and select Edit Revenue Forecasting.
• Use the Spread button to automatically distribute revenue (Linear, Frontloaded, Backloaded, or S-Curve).

Once saved, your revenue forecasts appear as a dotted line on the Claimed vs Spent graphs, alongside your cost forecasts. This gives you a full picture of what’s coming in and going out over the months ahead.

Cost Forecasting

The Cost Forecasting table is used to plan future costs that are not yet recorded as Current (spent), Committed (via purchase orders or subcontracts), or Adjustments.

Forecasting

To update forecasts:

1. Click the menu in the top right (three horizontal lines) and select Edit Cost Forecasting.

2. Edit the forecast values for each cost code.

3. For more detail, click the pencil icon next to a cost code to open Advanced Forecasting.

In Advanced Forecasting, you can break down the Cost to Complete into:

• Lump sums (e.g., timber, materials)

• Quantity-based costs (e.g., 1 unit @ $580)

• Time-related costs (e.g., 2 days @ $300/day)

You can export these details so your team can review how forecasts were built and adjust them in future months.
To keep forecasts accurate, remove any items that are completed and spent—this will automatically update the Cost to Complete.

Cashflow

The Cashflow tab is used to allocate when forecast costs will be incurred.

1. Select a start and end month.

2. Either:

   • Manually enter the monthly amounts, or

   • Click Spread to automatically distribute the cost (Linear, Frontloaded, Backloaded, or S-Curve).

3. A graph preview will show how the cost will be spread before you apply the changes

FAQs

Q: Who has access to the Forecast Dashboard?
A: Anyone with access to the project can view the project-level reports, and only users with access to the administration tab can view the company-level dashboard.

Q: Can I filter my forecast data by month?
A: Yes, you can filter by Reporting Period to see the forecast as at a certain month, excluding transactions dated after that month.

Q: Can I export these reports?
A: Yes, you can export these reports either as a PDF or a CSV depending on the report type.
To do this, click the menu at the top right of each report (the three horizontal lines).

Last updated: 15 April 2025