How should a general contractor track subcontractor costs by project?
Every subcontractor payment needs to be coded to a specific job. That’s the foundation. If your bookkeeping system lumps all sub payments into a single “subcontractor expense” account with no job assignment, you have no idea which projects are profitable and which are bleeding cash.
In QuickBooks, this means setting up each project as a job (or customer/sub-customer) and assigning every bill from a sub to that job. When the framing sub sends an invoice for the Miller residence, it gets entered with the Miller job tagged. Same for the electrician, the plumber, the drywall crew. At any point, you can pull a job cost report and see exactly what’s been spent on subs for that project.
The next piece is tracking actual sub costs against what you originally bid or budgeted. Before the project starts, enter the estimate by cost category. Framing budgeted at $45,000, electrical at $28,000, and so on. As bills come in, the system compares actual to budget. When the framing sub hits $42,000 and still has two weeks of work left, you see the problem before it becomes a $15,000 loss.
Change orders need the same discipline. If the homeowner adds a bathroom and the plumbing sub’s scope grows, update the budget and get a signed change order. Otherwise you’ll have sub costs that look like overruns when they’re actually approved additions. This is where most contractors lose track. The project has 40 small scope changes and no one updated the budget, so the final numbers look like chaos.
Collect W-9s before you cut the first check. Every sub, every time. It’s much easier to hold a payment until the W-9 arrives than to chase down tax information in January from a sub you haven’t worked with in six months. Any sub paid $600 or more during the year needs a 1099-NEC filed by January 31. If you’ve been coding payments correctly and collecting W-9s throughout the year, running 1099s takes an hour instead of a week. Experienced Pasadena bookkeepers should have a process that keeps 1099 tracking current month by month, not a year-end fire drill.
Retention is another piece that trips people up. If you’re holding back 10% on sub payments until the project closes, that retained amount is still a committed cost. Your job cost report should reflect the full invoiced amount, not just what you’ve paid, or your margins will look better than reality until the retention gets released.
Weekly or biweekly review is where this actually pays off. Pull the job cost report, compare sub costs to budget, flag anything trending over. Catching a framing overrun in week three lets you adjust. Finding out at closeout means you eat the loss. Real construction job costing isn’t about entering data, it’s about using the data to run the project before the project runs you.
Pasadena's Small Business Bookkeeper
The Next Step:
A 15-Minute Call
Tell us where your books stand today. We'll ask a few questions, share how we can help, and give you a clear quote.
More Questions
How do I handle material purchases that span multiple construction jobs?
Hold bulk purchases in inventory when you buy them, then allocate cost to each job based on actual quantities used. This keeps your job cost reports accurate and prevents a single large purchase from distorting one project's margins.
Read answerWhat is a 1031 exchange and what bookkeeping records do I need?
A 1031 exchange lets you defer capital gains tax by selling an investment property and rolling the proceeds into a like-kind replacement. Your books need to track the deferred gain, the carryover basis, and every exchange-related expense so the tax treatment holds up years later.
Read answerHow long does a Yardi accounting implementation take?
Simple portfolios can be set up in a week or two. Large portfolios with data migration, custom reporting, and multi-entity structures often take three to six months. Data quality and decision-making speed usually drive the timeline more than the software itself.
Read answerWhat bookkeeping do I need for a fix-and-flip project?
Track every cost tied to the property in four categories: acquisition, renovation, holding, and selling. Flip profits are taxed as ordinary income, not capital gains, and 1031 exchanges do not apply.
Read answerHow do I track renovation costs separately from operating expenses on a rental?
Renovation costs are capital improvements that get recorded as assets and depreciated over time. Operating expenses like repairs and maintenance get expensed in the current period. Set up separate accounts for each so your books reflect the difference from day one.
Read answerDo I need a business license to operate in Pasadena, California?
Yes, the City of Pasadena requires a Business Tax Certificate for every business operating within city limits, including home-based and online businesses. It renews annually and is separate from state and county requirements.
Read answer
