How CFOs Can Identify Profit Leakage Using Power BI Dashboards
Introduction: Where the Money Goes
Construction companies almost never lose money because of one big mistake. It’s usually death by a thousand cuts — a change order that sits in pending status for months, equipment charged to the wrong job for weeks on end, retainage that never gets billed because nobody flagged the completion date. None of these things look like a big deal in isolation. But add them up across a project, and you’re often looking at 2 to 5 percent of margin walking out the door. The problem is that most of this stuff is invisible until the job is closed out and the numbers are already locked in. That’s where Power BI comes in. A well-built dashboard, with the right alerts and reports, gives CFOs an early warning system, a way to see where money is leaking while there’s still time to do something about it, instead of finding out after the fact. Below are six of the most common ways contractors bleed margin, and how the right dashboard setup can catch each one before it eats into your bottom line.
Leakage Sources
- Unbilled Change Orders
- Misallocated Equipment Costs
- Labor Cost Code Mispostings
- Retainage Not Billed at Completion
- Overhead Creep Across Jobs
- Underbilling on T&M Work
Leakage Source 1: Unbilled Change Orders
How it bleeds margin:
Sometimes a change order is approved verbally on-site, and the project manager starts the work, but the paperwork is delayed. Weeks later, the costs are posted to the job, but the change order was never formally approved, priced, or billed. On busy projects with many changes, it’s common to find $150,000 to $300,000 in approved but unbilled work stuck in limbo. That’s revenue the company earned but hasn’t collected.
How Power BI catches it:
A change order aging report checks every change order in the system against its billing status. If a change order is marked as approved or in progress but hasn’t been included on a payment application, it is flagged. The dashboard then shows the total value of unbilled changes by job, by project manager, and by how long they’ve been outstanding (30, 60, or 90+ days).
Here’s the alert in action:
If a job’s unbilled change orders top $50,000, or any single change order sits unbilled past 45 days, a red flag pops up on the CFO’s dashboard. That’s the cue to dig in—pull up the specific change orders and get the project manager on the phone to clear them out. This isn’t just tidiness. CFMA’s 2023 benchmarking data shows top-quartile contractors who bill change orders within 30 days of approval capture up to $250,000 in cash flow benefits per $10 million in revenue.
Leakage Source 2: Misallocated Equipment Costs
How it bleeds margin:
Equipment costs are tough to allocate correctly in construction. For example, a crane might be sent to Job A but end up working on Job B for a few days. If no one updates the allocation, the charge stays on Job A. Over the course of a year, these misallocated costs can distort job profitability by 1 to 3 percent per project. This means the CFO sees margin numbers that don’t match reality.
How Power BI identifies it:
The dashboard checks equipment hours or charges against the job schedule. If equipment is charged to a job when no work is scheduled, the system signals it. It also compares equipment costs, as a percentage of the total job cost, to the original budget. For example, if a job was budgeted for 8 percent equipment cost but is running at 14 percent, the dashboard flags the difference automatically.
Alert example:
A yellow warning appears if equipment costs exceed the budget by more than 3 percentage points. A red alert appears if equipment charges are posted to a job without matching labor charges for that time. The CFO can review the details—equipment, dates, and job—to determine whether the allocation is correct or requires correction. Having a central data warehouse that combines equipment logs and job schedules enables this.
Leakage Source 3: Labor Cost Code Mispostings
How it bleeds margin:
A foreman entered 40 hours of concrete work under cost code 31000 (Concrete) when it should have been posted under 32000 (Structural Steel). The job cost report now overstates concrete spend and understates steel spend. The PM reviews the report and decides concrete is over budget, so she reassigns resources. Meanwhile, the steel budget is overrun, and nobody notices until the job is 80% complete.
How Power BI catches it:
The dashboard analyzes cost-code variances for each job and compares them with past trends. If a cost code uses labor much faster than usual, like 40 percent above the average for similar jobs, it flags an anomaly. It also flags cost codes with no charges when the schedule shows work should be happening, indicating possible mispostings.
Alert example:
The dashboard shows a data quality flag for cost codes with unusual variance patterns. This means the timecard entries should be reviewed. The CFO or controller can click to review specific timecard entries, identify mispostings, and make corrections before the month ends. Companies with automated workflow tools can send these corrections straight to the field supervisor for approval.
Leakage Source 4: Retainage Not Billed at Completion
How it bleeds margin:
When a project is substantially complete, the contractor can bill for retainage. But often, retainage remains a receivable on the balance sheet for months because no one initiates billing. For example, on a $10 million project with 10 percent retainage, that’s $1 million in earned revenue not being invoiced. While it doesn’t lower profit on paper, it hurts cash flow and creates opportunity costs.
How Power BI catches it:
The dashboard tracks project status and compares it to retainage receivable balances. When a job is marked as substantially complete or is more than 95 percent complete, it checks whether retainage billing has been submitted. If not, the dashboard sends a notification. That matters because even a 30-day delay in collecting retainage on a mid-size portfolio can tie up $500,000 or more in working capital.
Alert example:
A retainage aging report lists every job with outstanding retainage receivable, sorted by the number of days since substantial completion. Jobs over 30 days are marked in yellow, and those over 60 days are marked in red. These alerts mean billing should be started. The CFO can quickly see the total outstanding retainage across all jobs. The accounting department can act on these alerts as soon as they appear.
Leakage Source 5: Overhead Creep Across Jobs
How it bleeds margin:
Overhead should be allocated consistently, either as a fixed percentage across all jobs or based on revenue or labor hours. But in reality, overhead often creeps up. A project manager might absorb a corporate cost to avoid going over budget, or an admin might code an indirect cost to a job by mistake. Over time, some jobs accumulate more overhead than they should, making it hard to see the true cost of running the business.
How Power BI identifies it:
The dashboard calculates indirect costs as a percentage of direct costs for each active job and compares it to the company standard. If a job’s overhead exceeds the standard by more than 2 percentage points, it is flagged for review. The dashboard also tracks overhead trends over time, allowing the CFO to monitor significant changes.
Alert example:
A variance heatmap displays overhead percentages by job, color-coded based on the company target. The CFO can quickly spot which jobs are incurring excessive overhead, and the controller can investigate the specific general ledger entries driving the variance. This means the overhead allocation should be reviewed. Creating this view requires advanced reporting that links general ledger and job cost data in a single model.
Leakage Source 6: Underbilling on T&M Work
How it bleeds margin:
Time-and-material contracts appear straightforward, but T&M work is often underbilled. For example, a crew may work 4 hours on a task, but only 3 are recorded. Materials may be used from stock without proper cost logging. As a result, the markup intended to cover overhead and profit is applied to a lower base, reducing the job’s margin.
How Power BI catches it:
The dashboard compares labor hours billed on T&M invoices to the hours recorded in the timekeeping system. If there’s a difference, it means some hours haven’t been billed. It also checks material costs posted to the job against what’s shown on T&M invoices. For example, if $8,000 in materials were charged to the job but only $5,500 is billed, the dashboard displays the $2,500 difference.
Alert example:
A T&M reconciliation view displays the difference between costs incurred and amounts billed for each job. Any job with a gap of $1,000 or more is flagged. This means the job should be checked for underbilling. The CFO can view total underbilling across all T&M work and promptly initiate corrections. Digitizing T&M tickets at the job site can prevent most of this leakage.
Building a Profit Leakage Dashboard With Proxsoft
Proxsoft Technologies develops dashboards specifically for construction CFOs. We have identified these profit-leakage sources across contractor projects ranging from $20 million specialty firms to $500 million general contractors. The fundamental patterns stay consistent, with financial impact increasing alongside company size. Most contractors aren’t actually bad at the business side—they just can’t see what’s happening until it’s too late. Take a mid-sized general contractor I worked with on a multi-phase commercial build. The project started with a solid 12 percent margin. By the time it wrapped up, that margin had slipped to just over 8 percent, thanks to unbilled change orders and equipment costs that got charged to the wrong jobs. Nobody caught it until months after closeout—long past the point where anything could be done. That’s the pattern: jobs start healthy, then bleed margin quietly during execution because nobody’s watching in real time. By the time the numbers show up in a report, the money’s already gone. A live profit-leakage dashboard—something built in Power BI, for instance—fixes this. It flags margin erosion as it happens, not months later, so contractors can actually act on problems instead of just documenting them after the fact.
We integrate with leading ERP systems to ensure broad compatibility and enhanced data reliability. Our integration partners include:
We build scalable data models and configure alerts based on your organization’s specific thresholds. Our ERP consulting and implementation team follows industry best practices to ensure dashboards consistently extract accurate data from the correct tables, in accordance with your controller’s official records and supporting dependable financial reporting as your company expands.
Conclusion
Profit leakage on construction projects rarely comes from one big problem — it’s usually six small ones happening at the same time: unbilled change orders, misallocated equipment costs, labor posted to the wrong job, uncollected retainage, overhead creep, and underbilled T&M work. Individually minor, but together they quietly chip away at margins. Power BI dashboards give CFOs a way to catch this early instead of finding it during month-end close. Set up alerts for each leakage source, review exception reports regularly, and investigate flagged items right away — the longer they sit, the harder they are to trace. Contact Proxsoft for a complimentary assessment of your most significant profit-leakage risks. We will demonstrate which dashboards can deliver the greatest impact for your portfolio.
