These reports compare forecasted values and budgets against actuals and certifications, helping you proactively manage margins.
1. Accessing Cost Reports
Navigate to the Dashboard.
Select the Cost Reports tab from the available options.
Choose a report view or create a new one using the toolbar.
2. Understanding Cost Report Metrics
Cost Reports display multiple financial indicators in both the metrics card area and data table. The metrics are grouped into categories:
Forecast vs Original Values
Forecast Value - Original Value
Forecast Budget - Original Budget
Forecast Margin - Original Margin
Forecast Margin % - Original Margin %
Actuals & Certified
Certified Value
Certified Budget
Margin
Margin %
Each of these cards can be edited:
Click the three-dot menu on any card.
Change the source data for Value or Budget.
For Certified Value, options include: Certified Value, Applied Value, Actual Sales.
For Certified Budget, options include: Certified Budget, Applied Budget, Actual Costs.
The source data can be tied to a specific Payment Application, enabling tighter alignment with progress claims.
The Live Margin shown is dynamically calculated based on the selected value and budget metrics.
3. Grouping and Drilldowns
Use the Group By button to select:
Cost Code: View metrics per cost code.
Metric: View how cost codes compare across a single metric.
All groups can be expanded or collapsed to manage data visibility.
4. Filters & Customisation
Date Range: Set a custom period using the calendar selector.
Interval: Choose Monthly, Yearly, or All to change how data is displayed.
Metrics: Add/remove metrics using the toolbar.
Views: Save multiple custom views for different purposes (e.g. monthly board review, supplier overview).
5. Use Case Examples
Board Reports: Create a view grouped by Cost Code, with Forecast and Actual margins visible. Export monthly for board pack.
Budget Performance: Track Applied vs Actual Cost to flag overspend early.