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 know if my bookkeeping is accurate?
Bank reconciliation is the foundation. Beyond that, your financial statements should match reality: actual cash, receivables you recognize, margins that make sense. If the numbers surprise you, something's off.
Read answerHow do I handle tip reporting for restaurant employees?
Employees report tips to you monthly, and you withhold payroll taxes on them just like regular wages. Restaurants with more than 10 employees must also file Form 8027 annually with the IRS.
Read answerWhat's a 13-week cash flow forecast?
A 13-week cash flow forecast is a week-by-week projection of money coming in and going out over the next three months. It shows your cash position each week so you can spot shortfalls before they happen and plan accordingly.
Read answerWhat accounting does an e-commerce business need?
E-commerce businesses need multi-channel revenue tracking, inventory and COGS accounting, payment processor reconciliation, and sales tax compliance across multiple states.
Read answerWhat bookkeeping do home service companies need?
Home service companies need more than basic transaction recording. You need job-level profitability tracking, labor cost visibility, cash flow planning for seasonal slowdowns, and proper invoicing and collections systems.
Read answerHow do I know when to upgrade from bookkeeping to CFO services?
The signal isn't a revenue number. It's when you're making significant decisions without the financial insight to evaluate them properly. If you're flying blind on pricing, growth investments, or cash planning, you've likely outgrown basic bookkeeping.
Read answer