Construction
Job costing in construction: how to know the margin of every job
The company P&L closes positive while two specific jobs drain the cash. Without job costing, you see neither of them.
Job costing means separating revenue and cost by job, instead of dumping everything into one expense account. Without it, the company P&L can close positive while two or three specific jobs eat the profit from the others, and nobody notices until payroll is short. With job costing in QuickBooks, each job becomes a project with revenue, material, labor and subcontractors separated, and the margin of each one closes every month.
Why the company P&L hides the problem
Picture a builder that closed the year with 1.2 million in revenue and a 9 percent margin. Looks healthy. Now break that number down by job.
| Job | Revenue | Cost | Margin |
|---|---|---|---|
| Residential remodel A | 320k | 246k | 23% |
| Commercial B | 410k | 336k | 18% |
| Remodel C | 180k | 191k | minus 6% |
| Addition D | 290k | 319k | minus 10% |
The first two jobs carried the year. The last two gave back a good part of what they earned. On the consolidated P&L this shows up as a 9 percent margin and nothing else. The owner closes the year thinking the business yields 9 percent, when in reality what he does well yields 20 and what he does badly loses money.
The decision he makes the following year with that information is wrong by construction: he will keep taking both types of job.
What to separate in every job
Job costing is not just tagging an expense with the job name. It is separating by nature, because each nature behaves differently and has a different owner.
- Material. The easiest to tie out and the one that blows up most from unbudgeted purchases.
- In house labor. Needs hour tracking per job, otherwise the cost sits entirely in a generic payroll account.
- Subcontractors. Usually the biggest line and the messiest, because payment goes out by check or transfer with no link to the job.
- Equipment and rentals. Crane, dumpster, scaffolding. An item sitting idle on site is cost running with no output.
- Permits and fees. Small in value, but when not tied to the job it distorts comparison between projects.
- Rework. Worth isolating. It is the cost nobody budgets and the one that best explains a job that turned into a loss.
How this works in QuickBooks
QuickBooks has a projects feature, which is where job costing happens. The minimum structure that works is this.
- Each job becomes a project, with a name the crew recognizes, not an internal code.
- The chart of accounts separates direct job cost from company overhead.
- Every cost transaction gets the project assigned at entry, not at month end.
- Job revenue is recognized in the same project, so the margin makes sense.
- The profitability by project report joins the monthly close, next to the P&L.
Reconciling with Buildertrend
Anyone using Buildertrend already enters budgets, change orders and purchases by job in there. The classic problem is that this data lives apart from the books, and the two sides never match.
The fix is to treat each system for what it does best. Buildertrend stays the source for job operations, QuickBooks stays the source for accounting, and there is a periodic reconciliation between them. That way you do not enter data twice and do not live with two different numbers for the same job.
Subcontractors, W-9 and 1099
This is the line that causes the most headaches in January, and the cause is always the same: the payment happened, the paperwork did not. The routine that prevents it has three simple rules.
- W-9 before the first payment. No exceptions. Once the work is done, the odds of getting the document drop sharply.
- Payment always tied to the job. A loose check with no reference is a cost that exists and shows up on no job at all.
- Year to date total per contractor. That is what defines who needs a 1099, and checking it in January is late.
What changes after three months of job costing
The gain is not the report, it is what the report lets you decide. After a quarter with cost separated by job, three things change.
- Quoting stops being a guess. You start quoting with the real cost from your own history, not a rule of thumb percentage.
- You learn to say no. It becomes clear which type of job, which value range and which client profile consistently loses money.
- Correction happens mid job. With margin tracked monthly, you can renegotiate scope or a change order while the contract is still open.
{T(('Dúvidas frequentes','Frequently asked','Preguntas frecuentes'))}
{T(('Perguntas sobre este tema','Questions on this topic','Preguntas sobre este tema'))}
Does job costing work for a small builder?
It does, and strictly speaking that is where it matters most. A small builder has no cushion to carry a losing job, and is exactly the one that usually lacks the information. With three to five simultaneous jobs the control is already simple to maintain.
Do I need to switch from Buildertrend to QuickBooks?
No. They have different functions and should coexist. Buildertrend is the job management system, QuickBooks is the financial system. What has to exist is reconciliation between them, so there are not two numbers for the same job.
How do I tie employee hours to a job?
With hour tracking per job, which can come from Buildertrend itself or from a simple time clock. Without it, in house labor sits entirely in a generic payroll account and margin per job comes out incomplete.
What about jobs that already finished?
They can be rebuilt, as long as statements and invoices from the period exist. It is usually worth rebuilding the last three to six jobs, because that sample reveals the pattern of what makes money and what does not.
{T(('Continue lendo','Keep reading','Sigue leyendo'))}
{T(('Relacionados','Related','Relacionados'))}
Bookkeeping for construction
Job costing, subcontractors and margin per job in QuickBooks.
Late books: what to do
The path when the close is months behind.
How much a bookkeeper costs
The five variables that set the price.