How should a plumbing company set up QuickBooks for job tracking?
Start with the right version. You need QuickBooks Online Plus or Advanced to use the Projects feature. Essentials and Simple Start won’t cut it. The Projects module is what lets you see profitability by job, and without it you’re flying blind on which work actually makes money.
Once you’re on the right plan, set up a project for each job. A project is a container that captures every dollar in and out for that specific work. Time entries, material purchases, subcontractor payments, and customer invoices all get tagged to the project. At any point you can pull a project profitability report and see labor, materials, and margin for that job.
Build out your service items next. Plumbing work isn’t one thing. Emergency repairs, remodel roughs, water heater installs, drain cleaning, and maintenance contracts all have different pricing and different margins. Create separate service items for each work type you bill. When you invoice, pick the right item. This gets you revenue reporting by work type, which tells you where your real money comes from.
Set up your chart of accounts with trade-specific categories. Cost of goods sold should break out materials, subcontractor labor, direct labor, permits, and equipment rentals. General expenses cover trucks, fuel, insurance, licenses, and shop overhead. Resist the urge to lump everything into generic buckets. The extra granularity is what makes the financials useful.
Use classes or locations to track crews, trucks, or service areas. If you run two trucks and want to know which one generates more revenue, classes handle that. If you do both residential and commercial work and want separate P&Ls for each line, that’s also classes. Turn this on in settings before you start entering transactions, because retrofitting class assignments later is painful.
For time tracking, connect a tool like QuickBooks Time (formerly TSheets) so field techs can clock in and assign their hours to a project right from their phone. That labor cost flows directly into job costing. Same with vendor bills for materials. When you enter a bill from your supply house, tag it to the right project so the material cost hits the job.
The reports you’ll actually use are Project Profitability, Profit and Loss by Class, and Sales by Product/Service. Run them monthly to see which jobs, crews, and work types are pulling their weight.
Setup like this isn’t complicated but it’s detailed, and doing it wrong means the reports don’t mean anything. If you’d rather have someone configure it correctly from the start, QuickBooks setup and training is one of the services we handle for trades clients. We also work with plenty of Pasadena bookkeepers referrals who inherited a poorly configured QuickBooks file and need it rebuilt before the numbers make sense.
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
What bookkeeping software is best for a small business in the San Gabriel Valley?
QuickBooks Online is the default for most small businesses because it handles the common needs and nearly every local bookkeeper knows it. Xero is a solid alternative, and industry-specific tools like Yardi or Jobber fit certain businesses better. The right choice depends on your industry, transaction volume, and payroll complexity.
Read answerShould I use Yardi or QuickBooks for my rental property accounting?
QuickBooks works well for small residential portfolios of roughly 1-10 properties. Yardi is purpose-built for property management with features like tenant portals, lease tracking, CAM calculations, and trust accounting that QuickBooks can't match. Portfolio size and complexity decide the right tool.
Read answerWhat are the most common bookkeeping mistakes construction companies make?
The most common construction bookkeeping mistakes are mixing personal and business expenses, not separating job costs from overhead, mishandling retainage, failing to reconcile subcontractor payments to 1099s, and not monitoring work-in-progress against budget.
Read answerWhat are the biggest bookkeeping mistakes real estate investors make?
The biggest mistakes are commingling personal and property funds, not tracking expenses by property, missing depreciation deductions, sloppy receipt habits, misclassifying repairs as improvements, and skipping 1099 filings. Most of these compound over time and show up as expensive problems at tax time or during a sale.
Read answerDo I need a bookkeeper if I'm a small remodeling contractor in Pasadena?
Even a one or two-person remodeling operation benefits from organized books. Job costing, permit fees, material purchases, and sub payments add up fast, and without tracking them per project you won't know which jobs actually make money.
Read answerCan I use QuickBooks Online for rental property management?
Yes, QuickBooks Online works for small rental portfolios when set up with classes or locations for each property. It handles the accounting side well but lacks lease tracking, tenant portals, and CAM calculations, which matters once you scale past 10 units.
Read answer
