Construction Bookkeeping in Pittsburgh: 5 Costly Mistakes

The $1.4M Cranberry Contractor Who Couldn't Tell Which Jobs Made Money

A general contractor in Cranberry called us last fall. $1.4 million in revenue, 11 active jobs, and a QuickBooks file where every single transaction was coded to "Cost of Goods Sold." No job costing. No class tracking. No way to tell which jobs made money and which ones bled cash.

We rebuilt his books with proper job costing in five weeks. Three of his "good" jobs were running at 2% gross margin. Two were losing money. Two others he assumed were break-even were running 38%. He fired the bad work. Bid 12% higher on the rest. Six months later his net margin was up 9 points on the same revenue base.

Most Pittsburgh contractor books look like his did. The contractor knows the work, the foreman, the customer. He doesn't know his numbers. Here are the five mistakes we see Pittsburgh-area contractors making every quarter, and what to fix.

Mistake 1: No Real Job Costing in QuickBooks

The single biggest miss. Most contractor QBO files have customers but no jobs. Or jobs but no class tracking. Or both, but every invoice gets coded to one giant "Construction Income" account with no allocation back to the job.

Real job costing means every dollar of labor, material, sub, and equipment hits a specific job. Every invoice and every change order ties back. At month end you can pull a Job Profitability report that shows you which jobs are making money and which are killing you.

Without it, you can't bid the next job correctly. You're guessing. And in a market where general contractor margins typically run 8 to 15%, guessing wrong by 5% on a $200,000 job is the difference between a $20,000 profit and break-even.

Mistake 2: Treating Material Markup the Same as Labor Markup

Pennsylvania has a specific exemption that most contractor bookkeepers miss. When a contractor buys materials and installs them as part of a real-property improvement, the contractor is the end user. PA sales tax gets paid on the purchase. The contractor doesn't collect sales tax from the customer on those materials.

But for repair work that doesn't qualify as real-property improvement, sales tax DOES apply to the labor portion. And for retail sales of materials (selling without installing), it's a third treatment.

Three transaction types, three sales tax treatments. Most QuickBooks setups have one tax code applied to everything. The result: either underpaying PA sales tax (which the state will eventually find) or overpaying and eating margin you didn't have to eat. PA's tax system punishes the simple approach.

Mistake 3: AIA Billing Done in Spreadsheets, Not in QuickBooks

Most commercial GCs bill on AIA G702/G703 forms. Pencils-down-by-the-25th, submit by the 30th, get paid 30 to 60 days later. Retainage held back at 10% on every draw.

The trap: contractors run AIA billing in Excel and never bring those numbers into QuickBooks until tax time. Receivables don't show up properly. Retainage doesn't appear on the balance sheet. The P&L thinks income hits when the AIA goes out. Cash flow visibility goes to zero.

QuickBooks Online supports proper progress invoicing tied to estimates. We set up a Schedule of Values with line-item tracking, mirror it to the AIA, and run the receivable through QuickBooks the way it should be. Retainage gets tracked as a separate liability account so you always know what's owed and when it's coming.

Mistake 4: Certified Payroll Left to Whoever Has Time

Any prevailing wage work (Davis-Bacon federal projects, PA Public Works Employment Act jobs, school district work, municipal projects) requires certified payroll reports filed weekly. Form WH-347 federally, plus PA's specific filings.

The penalties for missing or wrong certified payroll: project payment held, debarment from future public work, back wages owed plus liquidated damages. We've seen contractors lose six-figure project payments because their certified payroll filing was rejected on a technicality.

Certified payroll isn't bookkeeping in the strict sense. But the data lives in your payroll system, and someone has to translate it to the right form weekly. If your bookkeeper isn't doing it and your foreman isn't doing it, it's not getting done right.

Mistake 5: No Visibility on Subcontractor 1099 Compliance Until January

Construction generates more 1099s than any other industry we work with. Subs, equipment rentals, individual tradesmen, materials suppliers who incorporated as sole props. The IRS threshold is $600 a year per vendor. The penalty for missing a 1099 starts at $60 per form and goes up to $310 per form depending on how late you file.

We see contractors hit December 31st with no W-9s on file for half their subs. Then they spend January chasing tax IDs from people who'd rather not provide them. Or worse, they file 1099s with wrong tax IDs and get IRS notices six months later.

The fix: collect W-9s at the start of every sub relationship, not at year-end. Code every payment to a 1099-eligible vendor account. Run a 1099 verification report every quarter. When books get ignored, this is the area that creates the biggest IRS exposure.

What Pittsburgh Contractor Bookkeeping Should Actually Look Like Each Month

1. Bank, credit card, line of credit reconciled. Every account, every month. No exceptions. If your bookkeeper "doesn't have time this month," they're not running real bookkeeping.
2. Job profitability report. One per active job, every month. Revenue to date, costs to date, percent complete, projected final margin. This is the report that drives bid decisions.
3. Aged receivables and retainage report. Who owes you, how long it's been outstanding, and how much retainage is sitting on the balance sheet ready to release.
4. 1099 vendor report. Every quarter. Anyone over the $600 threshold who doesn't have a W-9 on file gets flagged.
5. Sales tax accrual. Material purchases tagged correctly, repair labor flagged separately, retail sales of materials handled on PA-3 returns. Most contractor bookkeepers skip this entirely.

Picking the Right Construction Bookkeeper in Pittsburgh

Generic CPA firms can do your tax return. They typically can't run weekly job costing or set up retainage tracking in QuickBooks. National outsourced services can do the data entry but rarely understand prevailing wage or PA sales tax exemptions on real-property work.

Three questions to ask any contractor bookkeeper.

Can you set up job costing properly in QuickBooks Online? Not just customer tracking. Real Schedule of Values, progress invoicing, class tracking by phase if needed.

Have you handled certified payroll for PA prevailing wage jobs? If they don't know what WH-347 is or what the PA Public Works Employment Act requires, keep looking.

Do you understand PA sales tax on real-property improvement vs repair? If they treat all material purchases the same, they're going to either underpay or overpay. Both cost you money.

We work with Pittsburgh-area general contractors, residential remodelers, electrical and mechanical subs, and specialty trades. Our construction bookkeeping setup is built around the way contractors actually work, not generic small-business accounting templates.

Frequently Asked Questions

How much does construction bookkeeping cost in Pittsburgh?

Plans start at $399 a month for Essentials, $599 a month for Growth (adds payroll support and quarterly job profitability reviews), and $1,199 a month for Scale (adds fractional CFO services and weekly job costing). Most Pittsburgh contractors with under $500K in revenue fit Essentials. $500K to $2M usually fits Growth. $2M+ with multiple active jobs typically needs Scale. See full pricing.

Do you handle certified payroll for PA prevailing wage projects?

Yes. We handle Form WH-347 weekly filings for federal Davis-Bacon work and the PA Public Works Employment Act filings for state and municipal projects. We set up your payroll system to track project codes, work classifications, and fringe benefit allocations the way prevailing wage requires.

Can you fix a contractor QuickBooks file with no job costing?

Yes. We rebuild the chart of accounts to support proper job costing, set up customers and jobs, configure class tracking if needed, and reconstruct prior project profitability where the data exists. Typical rebuild for a contractor with one tax year of bad coding runs 3 to 5 weeks. Catch-up bookkeeping pricing applies to the historical reconstruction.

What's the difference between job costing in QuickBooks Online vs Desktop?

Both can do real job costing. QuickBooks Desktop has more powerful job-cost reporting out of the box, but Desktop is on its way out (Intuit is sunsetting it for new users). QuickBooks Online with the Plus or Advanced subscription handles class tracking, project profitability, and progress invoicing well enough for most contractors under $5M in revenue. We set up new clients on QBO Plus by default.

Do you work with both general contractors and subs?

Yes. The bookkeeping mechanics are similar but the focus shifts. GCs need AIA billing, retainage tracking, and 1099 management for their subs. Subs need certified payroll, fast cash flow visibility, and tight tracking on retainage owed back to them. We adjust the QuickBooks setup for each.

Get Your Construction Books Running Right

If you're a Pittsburgh-area contractor, residential remodeler, or trade subcontractor and you can't pull a job profitability report this month, you're flying blind on margin. Book a free Financial Health Check. We'll look at your QuickBooks file and tell you what's working, what's broken, and what it'd take to get your books running like a contractor's books should. Or call (412) 407-7420 if you'd rather talk first.