Overview
The Job Profitability Report provides real-time visibility across all active contracting works by linking approved timesheets, purchase orders, asset charges, and supplier bills against client billing claims. It helps commercial directors, financial controllers, and project managers detect margin slip early, track unbilled WIP, and adjust forecasts before project completion.
📌 Access Note: Viewing this report requires the WIP Report (New) permission. Updating project forecast contingencies requires Edit Job Details permissions. A Super Admin can configure these under Settings > Roles & Permissions.
Key Areas in the Report
Figure 1: Job Profitability Dashboard overview showing summary cards, filter bar, interactive grid, and Export CSV button.
Portfolio Summary Cards – High-level aggregate totals for agreed contract value, actual incurred spend, projected profit, and unbilled WIP across all jobs in your active filter.
Interactive Project Grid – Tabular list showing job number, customer, project manager, status, and % Complete. Any underlined number opens an instant drilldown window.
Date & Accounting Filters – Switch between whole-of-life cost to date and specific accounting periods, with live data or frozen month-end snapshots.
Background CSV Export – Generate non-blocking CSV files via the Background Tasks tray without freezing your browser.
Summary Cards & Core Portfolio Metrics
The five summary cards at the top of the report aggregate live data across your filtered projects:
Contract Value (Revenue Potential)
Headline: Total agreed contract value of all filtered projects.
Invoiced: Cumulative revenue claimed and billed to clients to date.
Uninvoiced Quoted: Remaining unbilled contract balance (your forward revenue pipeline).
Cost to Date (Expenditure)
Headline: Actual cumulative spend incurred since project inception across labour, plant, POs, and supplier bills.
Cost in Period: Spend dated strictly within your active date filter.
Forecast Cost: Projected total cost at completion (Cost to Date + remaining budget + PM adjustments).
Forecast Profit (Margin Health)
Headline: Projected net profit dollars and gross margin percentage at project completion.
Actual Profit: Invoiced revenue minus actual cost to date, showing current earned cash margin.
Margin Fade: Variance in gross margin percentage points between original quote and forecast.
Jobs Forecasting Loss: Immediate count of projects currently projecting a negative gross margin.
Billing Position (Cash Flow Protection)
Headline: Net dollar position comparing client claims against physical work completed on site.
Calculation:
Invoiced to Date − (Contract Total × % Complete ÷ 100)Status Classifications:
Over-billed: Billing claims lead site progress (cash-flow positive).
Under-billed: Site delivery leads billing claims (the business is funding client WIP).
Even: Billing claims align with site delivery.
Needs Attention Summary – Aggregates projects currently breaching commercial or schedule risk thresholds: spend outstripping site progress, slipping margins, overdue completion, or unbilled WIP over $50,000.
Date & Accounting Filters
Commercial contracting operates on two distinct timelines: physical site delivery and monthly accounting cutoffs. SprintSuite provides four dedicated date filter modes and accounting methods so finance and operations teams can view the numbers through the right lens.
The Four Date Filter Modes
Activity in Period (Best for Monthly P&L Audits): Finds every job that generated an active financial transaction (timesheet, purchase order, supplier bill, or client invoice) dated within the selected period.
Open During Period (Best for WIP Governance): Finds jobs that started on or before the period end date and were not fully invoiced before the period start date.
Completed in Period (Best for Close-Out Reviews): Finds jobs whose final sales invoice was raised within the selected date window for final margin reconciliation.
Planned Dates (Best for Forward Resource Planning): Finds jobs whose scheduled start-to-end calendar window overlaps the selected reporting period.
Costs Incurred Accounting Method
Cost to Date (Whole-of-Life): Displays cumulative spend from project inception to today. Recommended for whole-of-life project profitability.
Cost in Period (Reporting Window): Restricts expenditure strictly to transactions dated within your chosen window. Recommended for monthly P&L alignment and departmental budget reviews.
Live Operational Reality vs Month-End Snapshots
Live as at Today: Reflects live operational reality. As technicians clock shifts on mobile, purchase orders are receipted, and supplier bills are entered, metrics update immediately.
Month-End Snapshots: SprintSuite automatically takes an immutable snapshot of all project metrics at the close of each calendar month. Prior month financial reviews remain static and verifiable for auditors.
💡 Best Practice: For weekly operational meetings, select Open During Period with Cost to Date. For month-end accounting reviews, select Activity in Period with Cost in Period to reconcile against the general ledger.
Financial Drilldown Windows
Every underlined financial number in the table is an interactive drilldown powered by Turbo Frames, allowing commercial managers to inspect underlying cost streams and margin calculations instantly without leaving the page.
1. Cost to Date Breakdown Window
Figure 2: Cost to Date breakdown window categorised by expenditure stream.
Clicking any underlined Cost to Date figure opens the breakdown window, displaying total dollar values and percentage share across four expenditure streams:
Bills: Approved supplier invoices and subcontractor progress claims matched to purchase orders.
Labour: Approved staff and contractor timesheets multiplied by each employee's configured job cost rate.
Assets: Plant, company vehicles, and heavy machinery hourly charge rates recorded against the job.
Receipts: Direct credit card purchases and out-of-pocket project receipts.
🔍 Audit Traceability: Every dollar in the breakdown traces directly back to underlying approved source transactions. If plant or asset hire costs exceed budgeted allocations, project managers can immediately open the Asset Matrix or timesheet registers to audit operational allocations before month-end sign-off.
2. Actual vs Forecast Profit Reconciliation Window
Figure 3: Actual vs Forecast Profit reconciliation window comparing revenue, costs, and margins.
Clicking any underlined Profit figure opens the reconciliation modal, contrasting current earned cash margins against expected completion figures:
Revenue: Compares cumulative invoiced revenue to date against total forecast contract revenue.
Costs: Compares actual incurred spend to date against full forecast completion cost.
Profit Position: Reconciles earned cash profit to date against expected final net profit dollars.
Visual Margin Badges: Colour-coded status pills indicating whether current gross margins are healthy (green), eroding (amber), or in a loss position (red).
💡 Timing Note: Early in a project lifecycle, actual profit may appear artificially elevated if milestone progress claims precede supplier invoices, or depressed if bulk materials are receipted before billing. Comparing actual profit directly alongside forecast profit normalises these timing variances.
Forecast Calculations & PM Overrides
SprintSuite automatically calculates the Estimate to Complete (ETC) from remaining budget allocations, while giving Project Managers direct control to record known site variations, scope changes, and contingencies.
The Master Forecast Cost Equation:
Forecast Cost = Cost to Date + Remaining Budget (ETC) + Manual Adjustment
Remaining Budget (ETC): Unspent labour budget plus unspent asset budget plus full inventory and miscellaneous budgets. If actual costs exceed the quoted category budget, remaining budget defaults to $0 (it never turns negative).
Completion Freeze Rule: When a job reaches 100% complete, or status changes to Awaiting Final Invoice or Closed, remaining budget automatically drops to $0 and Forecast Cost freezes to equal Cost to Date.
Figure 4: Project Manager Forecast Cost Adjustment Window with Additional Amount input.
How a Project Manager Updates the Forecast
Open the Forecast Window: Click on the underlined Forecast Cost figure in any active project row to open the adjustment modal.
Review Remaining Budget: Examine the automated calculation: Cost to Date plus Additional Budgeted Costs (ETC).
Enter Additional Contingency: If site delivery requires additional labour, plant, or materials, enter the dollar figure into the Additional Amount input field.
Save in Place: Click Save Forecast. The system recalculates forecast cost and margin instantly, flags the extra contingency in the grid, and confirms with a success alert.
Understanding Margin Fade
Margin Fade measures the difference between what was quoted and what will actually be delivered at completion:
Margin Fade = Forecast Margin % − Quoted Margin %
If a project was quoted at 25% gross margin but unexpected site delays cause the forecast margin to drop to 18%, SprintSuite displays −7.0 pts in red. This signals management to negotiate variation claims with the client, adjust crew compositions, or contain plant hire costs before profits erode.
Commercial Risk Indicators ("Needs Attention")
SprintSuite continuously scans live job financials, schedule milestones, and site progress to highlight projects requiring executive intervention:
Risk Badge | Trigger Condition | Operational Meaning | Recommended Action |
Under-billed | Billing position < −$50,000 | Work completed on site exceeds billed claims by $50,000+. Business is funding client WIP. | Submit a progress claim or progress invoice immediately. |
Budget ahead of progress | Budget spent % > % Complete + 8% | Cost burn is outpacing site delivery (e.g. 75% of budget spent, but only 50% of the job is complete). | Audit labour hours and plant hire to stop a cost blowout. |
Margin down X pts | Forecast margin < quoted by 0.05+ pts | Forecast gross margin is slipping below original quote. Turns critical red at 3.0+ points slip. | Review PM estimate to complete and seek customer variations. |
Forecast finish X days late | Forecast finish date > planned end | PM has updated the expected site finish date past the contract completion date. | Notify client of schedule variation or reassign resources. |
X days past planned end | Today's date > planned end date | Job remains open past its contract end date without final invoice or sign-off. | Confirm whether final invoice is pending or extend schedule. |
Asynchronous CSV Export
The Job Profitability Report supports comprehensive CSV exports that capture your currently active filtered view across all records and departments.
Figure 5: Background Tasks tray showing completed CSV export download.
Queue the Export: Click the Export CSV button in the top right header. The export runs on a background worker, allowing you to continue working without browser lockup.
Track in Background Tasks Tray: The Background Tasks tray automatically opens in the top navigation bar, showing live progress as the report is compiled.
Download File: Once complete, click Download in the tray to retrieve an injection-safe CSV file formatted for Excel, PowerBI, or corporate reporting tools.
How to Use This Report
Set Your View: Choose your Department, set Find Jobs By (e.g. Open During Period for active WIP governance), and select Cost to Date.
Triage Commercial Risks: Check the Needs Attention summary card to immediately identify under-billed jobs or projects where spend is outpacing site progress.
Audit Cost Drivers: Click underlined cost or profit figures on flagged jobs to drill down into labour hours, plant charges, or subcontractor bills.
Update Estimates: Have Project Managers open the Forecast Cost modal to record site variations or known cost overruns in the Additional Amount field.
Export & Reconcile: Generate a background CSV before WIP review meetings to reconcile unbilled WIP and gross margin trajectories.
Ideal For
Commercial Directors & General Managers: Reviewing company-wide gross margin health, unbilled WIP risk, and forward revenue pipeline.
Financial Controllers & Accountants: Reconciling monthly management accounts, auditing incurred costs, and conducting month-end WIP reviews.
Project Managers & Operations Leads: Monitoring project burn rates, adjusting completion forecasts, and identifying variation claim opportunities before job closure.
Monthly WIP & Commercial Review Meetings: Aligning operations and finance on live project trajectory.
💬 Need Help? For assistance configuring custom financial report layouts, setting up labour cost rate cards, or adjusting risk alert thresholds, please contact your SprintSuite Customer Success Manager or reach our helpdesk at [email protected].