Team members with access to the project can use the Project Summary Dashboard to add key project dates/info and view key financial metrics.
Overview
Filter By Reporting Period
Add Key Dates and Info
Add A Dashboard Summary
Key Financial Metrics and Graphs
FAQs
Overview
This dashboard provides a high-level view of a project’s financial performance, and is where you can add key dates and info about the project. Team members with access to the project can view this dashboard by going into the Project, then selecting the Reporting Tab.
Filter By Reporting Period
At the top of the reporting page, click Add Filter, then Reporting Period, and select a specific month. By using the Reporting Period filter, you can view all data “as at” a specific month, excluding any transactions dated after the selected period. This makes it ideal for month-end reporting, budget tracking, and executive summaries.
Add Key Dates and Info
You can add important Key Dates and Key Information to the Project Summary Dashboard as a reference for your project. These fields (Actual Start Date, Original Contract Completion Date, Forecast Completion Date, Extension of Time Approved, Practical Completion Date, Retention Release Date) help capture essential milestones and personnel details (staff roles and names), making it easier to track timelines and responsibilities throughout the project’s lifecycle.
Add A Dashboard Summary
The Dashboard Summary acts as an executive summary for the project. Users can add commentary to capture insights, progress updates, or notes. Multiple users can contribute to the summary, and it can be exported as a PDF for sharing. To do this, click Manage Summaries, then New Summary.
Key Financial Metrics and Graphs
The Project Summary Dashboard displays several linked graphs and a financial summary table to help track performance over time.
-
Forecast Margin = Revised Contract Value − Total Cost at Completion. Shows the past 12 months (relative to the current or filtered month) with a red baseline for budgeted margin. If costs are recorded without a contract value, then the margin will show as negative.
-
Revised Contract Value: Shows the original head contract plus all variations. Lentune treats all recorded variations as approved, with a red baseline for the original contract value.
-
Total Cost at Completion = Current Cost + Cost to Complete. Displays the original budget as baseline once a forecast cost to complete is set.
-
Claimed vs Spent: Compares monthly claims/invoices to spent costs, highlighting over- or under-claiming.
-
Cumulative Claimed vs Spent: Shows the ongoing gap between claims and costs, useful for cashflow planning.
-
Key Financial Information: Provides a table with two months of data for comparison and variance figures, including
| Metric | How it’s Calculated / Where it Comes From | What It Tells You |
|---|---|---|
| Original Budget | From the cost code tab in Projects | The original budget before any variations. |
| Budgeted Variations | From the variations tab in Projects | The sum of the budgeted variations. |
| Revised Budget | Original Budget + Budgeted Variations. | The updated budget value after variations. |
| Original Margin | Original Contract Value - Original Budget | The original margin before any variations. |
| Original Contract Value | From the Contract tab in Head Contracts. | The original agreed contract amount before any changes. |
| Head Contract Variations | From the Variations tab in Head Contracts. | The total value of changes (variations) to the contract. |
| Revised Contract Value | Original Contract Value + Head Contract Variations. | The updated contract value after variations. Compare to Total Cost at Completion to see margin changes. |
| Total Cost at Completion | From the Forecast dashboard. | The projected final total cost for the project. Compare to Revised Contract Value. |
| Forecast Margin | Revised Contract Value − Total Cost at Completion. | The forecasted margin for the project at completion. |
| Total Claimed to Date | From Head Contract Claims (Prepared status or higher) using the claim’s End Date. | The total value claimed so far. Compare to Spent to Date to ensure claims cover costs. |
| Spent to Date | From the Cost Code tab in Projects. Uses: Invoice Date, Claim End Date, Timesheet Date, Expense Claim Date. | The total costs actually spent to date. |
| Gross Margin | Total Claimed to Date − Spent to Date. | The margin achieved so far (live profitability). |
| Margin Declared to Date | Forecast Margin × % Complete by Cost. | The portion of the forecast margin recognised so far. |
| Work in Progress | Gross Margin − Margin Declared. | Difference between earned margin and recognised margin. Positive = over-claimed, negative = under-claimed. |
| Committed to Date | From the Cost Code tab in Projects (daily import). | Costs secured by purchase orders or subcontract agreements. |
| Current Cost | Committed + Spent + Adjustments. | The total cost already spent or committed. |
| Cost to Complete | Total Cost at Completion − Current Cost. | Remaining costs not yet spent or committed. |
| % Complete by Revenue (Invoiced) | Total Invoiced to Date ÷ Revised Contract Value. | Progress based on invoicing—compare with % Complete by Cost. |
| % Complete by Cost | Total Spent ÷ Total Cost at Completion. | Progress based on costs incurred—compare with % Complete by Revenue. |
| % Complete by Committed | Committed to Date ÷ Total Cost at Completion. | How much of the project’s costs are already secured through commitments. |
FAQs
Q: Who has access to these reports?
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 data by month?
A: Yes, you can filter your data by month by using the Reporting Period filter to view data as at a certain month. The system will exclude any transactions dated after the selected month.
Q: How can I know my margins on each project?
A: You can know your margins on each project by reviewing the multiple margin metrics in the reports, including:
-
Original/Budgeted Margin for baseline comparisons
-
Gross Margin for live margin to date
-
Forecast Margin for projected completion margin
Q: Can I see visual trends for margin, claims, and spend?
A: Yes, you can see visual trends for margin, claims, and spend by reviewing the graphs, which display trends for claimed vs spent and forecast margin over time.
Still need a hand? We’re happy to help - send us an email at support@lentune.com.
Last updated: 15 April 2025