The Jobs You Think Are Profitable but Aren't: Real-Time Job Costing for Contractors

Picture a residential contractor doing about $3 million a year in custom homes and high-end remodels, the kind of work where clients have opinions about every finish. Good reputation, busy schedule, crews that show up on time. Then the year-end financials land and the number does not make sense. Three million in revenue, prices raised twice during the year, and a net profit somewhere around $45,000.

That is roughly 1.5% net margin. You could make more money managing a retail store.

The number is not even the worst part. The worst part is what a contractor in this position usually believes about the work. The two largest projects, the high-dollar jobs that kept the crews busy for months, feel like the most profitable ones. Big revenue reads as big profit.

Properly allocated costs often say the opposite. The showcase custom home comes in around 2% net. The whole-house remodel loses money once every cost is counted against it. The most profitable job of the year turns out to be a small kitchen renovation that almost got turned down for being too little work.

That is not a revenue problem. It is a job costing problem. And it is common.

The Margin Illusion

Here is the fundamental problem with job costing in construction: the costs are generated in a dozen different places by a dozen different people, and none of them are talking to each other.

Labor costs live in timesheets — paper timesheets, a time clock app, or the foreman’s memory. Material costs live in purchase orders that were emailed to suppliers, invoices that arrived in the mail or as PDF attachments, and credit card receipts in someone’s wallet. Subcontractor costs live in contracts that were signed months ago, invoices that arrive monthly, and change orders that may or may not have been formally documented. Equipment costs live in rental invoices and internal allocation rates that nobody updates.

For a contractor running eight active projects, the cost data for any single job is scattered across:

• Timesheets (daily, from each foreman or crew lead)
• Material purchase orders (from the PM, superintendent, or foreman)
• Supplier invoices (mailed, emailed, or uploaded to a portal)
• Subcontractor invoices (monthly pay applications)
• Equipment rental invoices (from one or more rental companies)
• Credit card receipts (from field purchases at Home Depot, lumber yards, specialty suppliers)
• Change orders (some approved, some pending, some verbal)

Getting all of that into a single job cost report requires someone to manually collect, code, and enter every line item. In most small to mid-size firms, that someone is either the owner, a bookkeeper working part-time, or a project manager who would rather be managing projects.

The result is predictable: job cost data is always behind. Always incomplete. Always a little bit wrong. And by the time you have a clear picture of what a job actually cost, the job is over and there is nothing you can do about it.

Walking Through the Math

Let me make this concrete with a worked example. Take a $680,000 custom home.

The original estimate broke down roughly like this:

Category	Estimated Cost	Estimated %
Labor (own crews)	$170,000	25%
Materials	$204,000	30%
Subcontractors	$176,800	26%
Equipment	$20,400	3%
Overhead allocation	$40,800	6%
Total estimated cost	$612,000	90%
Estimated profit	$68,000	10%

A 10% margin on a $680K project. Reasonable for custom residential. Here is what actually happened.

Labor came in at $198,000. That is $28,000 over estimate, a 16% overrun. The framing took two weeks longer than planned because the roof structure details were poorly drawn, and the crew spent extra days working through complex intersections that should have been flagged during preconstruction. But the daily timesheets did not get coded back to the estimate line items until the bookkeeper processed them at month-end. By then, the framing was done and the money was spent.

Materials came in at $221,000. Lumber prices had increased 8% between the estimate date and procurement. The allowances for tile and fixtures were blown when the homeowner upgraded selections — technically change order territory, but the upgrades happened in conversations between the homeowner and the superintendent on site, and nobody wrote a change order until the PM discovered the invoices two months later.

Subcontractors came in at $189,000. The HVAC sub had a legitimate extra for ductwork redesign caused by a beam relocation. The landscaping sub billed for irrigation work that was arguably in the original scope. Both were handled informally and settled in the sub’s favor because there was no contemporaneous documentation to dispute.

Total actual cost: $666,200. Actual profit: $13,800. Actual margin: 2.0%.

In a monthly-close process, none of this surfaces until the accountant reconciles the books months after the certificate of occupancy.

If job costs were reviewed weekly, with labor actuals compared against estimated hours by cost code, materials tracked against purchase orders, and sub invoices matched against committed costs, the labor overrun shows up in week three of framing. The material allowance blow-out gets caught when the tile invoices come in. There is contemporaneous documentation to properly handle the sub extras.

Not every overrun is preventable. But catching $20,000-$30,000 of it in time to do something about it is realistic. On a project with $68,000 of estimated profit, that is the difference between a good job and a disaster.

Why the Spreadsheet Stops Working

Most contractors start with some version of a job costing spreadsheet. It is usually an Excel file or a Google Sheet with a tab for each project, cost codes running down the left side, and columns for budget, committed, actual, and projected final cost.

The spreadsheet itself is fine. The structure is correct. The problem is that keeping it current requires someone to manually enter every cost transaction, and that someone is always behind.

Here is the typical cycle:

1. Week 1: Project starts. Spreadsheet is up to date because it only has the estimate.
2. Week 3: Foreman timesheets are piling up but have not been entered. A few material invoices arrived but are sitting in the AP inbox.
3. Week 6: PM realizes the spreadsheet has not been updated in three weeks. Spends a Saturday morning entering data. Discovers two cost codes are already over budget.
4. Week 10: Spreadsheet abandoned. PM is too busy running the project to maintain the spreadsheet. Job costing becomes “we’ll figure it out at the end.”

This is not a discipline problem. This is a capacity problem. The PM who is supposed to maintain the spreadsheet is also managing submittals, coordinating subs, handling owner communications, and solving problems on site. Manual data entry loses every time.

Sage 300 CRE and QuickBooks both have job costing modules that are more capable than a spreadsheet. Sage in particular is the industry standard for mid-size commercial contractors. But the data entry bottleneck is the same — someone has to get the costs into the system, coded to the right job and cost code, in a timely manner.

The Real-Time Difference

Let me contrast two scenarios. Same contractor, same $500,000 project, same cost structure.

Scenario A: Monthly review. The PM reviews job costs at the end of each month. In month two, he discovers that the concrete subcontractor submitted a pay application that includes $18,000 for footings that were deeper than specified — a legitimate extra, but one that was never formally documented as a change order. The sub did the work, billed for it, and the contractor has to either eat the cost or try to recover it from the owner after the fact with no contemporaneous documentation. At 5% net margin, that $18,000 is more than half the profit on the entire project.

Scenario B: Automated weekly tracking. When the concrete sub submits the pay application, the automated system flags it: the billed amount exceeds the committed cost by $18,000. The PM gets an alert within 48 hours. He reviews the pay app, identifies the footing overage, and issues a change order request to the owner before the concrete sub’s next mobilization. The extra is documented, priced with proper markup, and incorporated into the next pay application to the owner.

Same situation. One version costs you $18,000. The other version makes you $2,700 in markup on a legitimate extra. The $20,700 swing happened because one contractor had real-time visibility and the other was looking in the rearview mirror.

Building Automated Job Cost Tracking

The tools most contractors already use contain the data needed to automate job cost tracking. The problem is that the data lives in silos — invoices in email, budgets in spreadsheets, timesheets in a separate system — and nobody is synthesizing it into a real-time cost picture.

The Numbers That Matter

Let me run the ROI calculation on automating job costing for a $3 million contractor.

Current state costs:

Cost Category	Annual Impact
Unbilled change orders (estimated 1-2% of revenue)	$30,000-$60,000
Labor overruns caught too late to correct	$15,000-$45,000
Administrative time for manual cost tracking (8-12 hrs/week at $45/hr)	$18,700-$28,000
Material cost variances not caught at procurement	$10,000-$20,000
Underbilling from inaccurate WIP (cost of carrying)	$5,000-$15,000
Total annual cost of poor job costing	$78,700-$168,000

What automation addresses:

You are not going to eliminate every overrun. Construction has legitimate cost variability — weather delays, design errors, unforeseen conditions. But you can eliminate the overruns caused by late information, poor documentation, and the inability to see what is happening on your jobs in real time.

Conservative estimates from contractors who have implemented real-time job costing suggest a 40-60% reduction in the preventable losses above. On a $3 million contractor, that is $31,000-$101,000 in recovered margin annually.

The administrative time savings alone are substantial. If your PM or bookkeeper is spending 10 hours a week on manual job cost data entry and reporting, and automation reduces that to 2 hours of review and exception handling, you have freed up 400 hours per year. At a fully loaded PM rate of $55/hour, that is $22,000 in capacity returned to productive work.

The margin multiplier effect. Here is the math that most contractors miss: on a 5% net margin, every dollar you save in costs drops straight to the bottom line. Recovering $50,000 in job cost leakage is equivalent to winning $1,000,000 in new revenue at a 5% margin. You do not need more work. You need more visibility into the work you already have.

What Top-Performing Contractors Do Differently

CFMA data consistently shows that contractors in the top quartile of profitability — the ones achieving 10-12% net margins instead of 5-6% — share several job costing practices:

They review costs weekly, not monthly. The data is current enough to act on. A cost overrun identified in week two of a four-month project can be managed. A cost overrun identified at project closeout is just an autopsy.

They track committed costs, not just actual costs. When a subcontract is signed or a purchase order is issued, that cost is immediately reflected in the job cost projection. Most contractors only recognize costs when the invoice arrives, which means their projections are always understated.

They project final cost, not just cost-to-date. Cost-to-date tells you what has happened. Projected final cost tells you what is going to happen. The calculation is straightforward — take cost-to-date, divide by percent complete, and you have a projected final cost. But it requires current data to be meaningful.

They separate production efficiency from cost variance. A cost code can be over budget for two different reasons: the work cost more per unit than estimated (a rate problem) or there was more work than estimated (a quantity problem). The fix for each is different, and you cannot tell the difference without tracking both.

They close out job costs within 30 days of substantial completion. Not 90 days. Not “when we get around to it.” Thirty days. Because every open job with unreconciled costs is a margin surprise waiting to happen.

These are not exotic practices. They are not technologically complex. They are basic financial management applied to project-based work. The reason most contractors do not do them is not that they do not know they should — it is that the manual effort to maintain current, accurate job cost data across multiple active projects exceeds their administrative capacity.

That is what automation solves. Not the analysis. Not the decision-making. The relentless, tedious, time-consuming process of getting the right numbers into the right place fast enough to matter.

The Year-End Surprise Nobody Needs

The alternative does not require abandoning QuickBooks or spreadsheet estimates. It requires the costs to flow into job cost tracking automatically. Invoices are captured and coded when they arrive, timesheets are matched against estimated labor hours by cost code, and a weekly one-page summary shows projected margin versus estimated margin for every active project.

Consider what that early warning is worth. A remodel that starts tracking a few points below estimated margin three weeks into the job, often because a crew is working below estimated production rates on conditions that were not visible during preconstruction, can be corrected with a modest labor adjustment while there is still project left to run. A second carpenter for a couple of weeks might cost a few thousand dollars. The same margin erosion left unseen compounds across the remaining weeks and shows up as a much larger loss at closeout.

Catching a small problem three weeks in beats discovering a large one three months later. That is not sophisticated financial management. It is just having current information.

The jobs you think are profitable might not be. The only way to know for certain is to look — and to look often enough that you can still do something about what you find.