How do I track subcontractor expenses by project?
The key is linking every sub invoice to a specific job or project in your accounting system. Without that link, subcontractor costs get lumped together and you lose visibility into which jobs made money and which ones ate your margin.
Start with your accounting software setup. In QuickBooks, this means enabling jobs or projects under each customer, or using classes to track projects. Every expense needs a place to land. If your chart of accounts isn’t structured for job costing, the data goes in but you can’t pull it back out in a useful way.
When you receive an invoice from a subcontractor, it needs to include the job name or number. Make this a requirement upfront. Tell your subs that invoices without a job reference will get held until you can verify which project it belongs to. Most subs will comply once they realize it affects how quickly they get paid.
Enter each invoice with the project code attached. If a sub worked on multiple jobs in one invoice, split the line items by project. This takes more time than entering one lump sum, but the time you spend now saves hours later when you’re trying to figure out why a job that should have been profitable ended up losing money.
For larger projects with multiple phases, track at the phase level too. A sub who pours the foundation is a different cost from the same sub who comes back for flatwork. Breaking costs down by phase helps you bid more accurately on future jobs because you’ll know where the money actually went.
Reconcile sub costs against your original estimates regularly. If you budgeted $15,000 for electrical and you’re at $12,000 with the job half done, you might be headed for trouble. Catching this mid-project gives you options. Catching it after the fact just tells you what went wrong.
Don’t forget 1099 tracking. Every sub you pay $600 or more in a calendar year needs a 1099. Your accounting system should be tracking this automatically if vendors are set up correctly. Having sub expenses tied to projects doesn’t affect 1099 requirements, but it does mean you have clean records if questions come up later.
The reporting is where the value shows up. With sub expenses properly coded, you can pull a report showing total subcontractor cost per job, compare it to your bid, and calculate actual margins. Many contractors in MetroWest work with local bookkeepers to set up this tracking correctly from the start rather than trying to fix it later when the data is already scattered.
This data informs how you price future work and which types of projects are worth pursuing. Without it, you’re guessing. With it, you’re making decisions based on what actually happened.
Greater Boston's Trusted Bookkeeping Partner
The Next Step:
A Short Conversation
We'll ask a few questions, figure out what you need, and give you a straightforward quote.
More Questions
How do I find a bookkeeper who knows Massachusetts tax laws?
Look for a bookkeeper based in Massachusetts who regularly works with small businesses in the state. They should understand PFML payroll requirements, meals tax rules, and state withholding. Local experience matters more than memorizing tax code.
Read answerHow do cleaning companies track job profitability?
Track labor hours by job or client, assign supply costs, allocate vehicle and equipment overhead, then compare actual costs to your bid. Labor is your biggest variable, so time tracking is where profitability visibility starts.
Read answerWhat's the best accounting software for restaurants?
QuickBooks Online is the standard for restaurants. But the software matters less than how well it integrates with your POS system and whether it's configured for restaurant operations.
Read answerWhat accounting do plumbers and electricians need?
Plumbers and electricians need job costing to track profitability by project, expense tracking for materials and vehicle costs, and systems for invoicing and cash flow. Good accounting shows which jobs make money and which don't.
Read answerHow often should a small business do bookkeeping?
Monthly is the absolute minimum for accurate books. Weekly transaction review catches errors while they're fresh and prevents the dreaded backlog. Most small businesses benefit from consistent monthly closes with weekly check-ins during busy periods.
Read answerWhat's the best way to manage accounts receivable?
Invoice promptly with clear payment terms, make it easy for customers to pay, and follow up consistently when payments are late. The key is having a systematic process rather than chasing invoices randomly when cash gets tight.
Read answer