Plumbing Chart of Accounts Setup in QuickBooks

Your chart of accounts determines what every financial report you produce is capable of telling you, and if yours came from QuickBooks Online's default template, it was built for a generic small business rather than for a plumbing contractor running several different types of work with very different economics.

That's why most plumbers look at their monthly P&L, see numbers that technically add up, and still have no idea whether their service work is subsidizing their new construction work or the other way around.

A properly structured plumbing chart of accounts separates your revenue by type of work, organizes cost of goods sold so materials and burdened labor are visible distinctly, and groups operating expenses so you can see where overhead is concentrated. This post walks through how to build that structure in QuickBooks Online so your reports start telling you what you actually need to know to run the business.

For the broader view of plumbing bookkeeping, see Plumbing Bookkeeping: What to Track and Why.

For the job costing that this chart of accounts structure makes possible, see Plumbing Job Costing: How to Track Profit by Job.

Why the default QuickBooks chart of accounts fails plumbers

QuickBooks Online ships with a chart of accounts built around a generic service or product business, which means one or two revenue lines, a thin cost of goods sold section, and a long alphabetical list of expenses. That works fine for a business that sells one thing, but it fails a plumbing contractor for a few specific reasons.

The default setup gives you a single income line that blends emergency service calls, water heater replacements, new construction rough-ins, and whole-home repipes into one number.

These types of work have dramatically different margin profiles, as we covered in Plumbing Profit Margins: What's Normal for a Plumbing Business?, where service work commonly runs 50 to 65 percent gross margin while new construction often runs 25 to 40 percent.

When they're blended into one revenue line, you can see total revenue but you cannot see which side of your business is actually carrying the profitability. That blindness is expensive, because it means you might be chasing new construction volume that barely covers its cost while underpricing the service work that's actually funding the company.

The default cost of goods sold section is similarly underbuilt.

Fixtures, pipe and fittings, burdened labor, and subcontractor costs all need to be visible separately because they tell you different things. When they're lumped into a generic materials line, you can't tell whether a margin problem comes from fixture pricing, material waste, or labor running longer than estimated.

The operating expenses section defaults to alphabetical order, which scatters your vehicle costs across multiple lines, mixes software with professional services, and separates categories that should be grouped for analysis.

The result is a P&L that requires mental effort to interpret rather than one that surfaces patterns on sight.

The five sections a plumbing chart of accounts needs

A working plumbing chart of accounts has five sections on the P&L: revenue, cost of goods sold, gross profit (calculated automatically), operating expenses, and net profit (calculated automatically). What separates a useful structure from a generic one is how each section is organized.

The revenue section needs separate income accounts for each type of work you do, because that's the only way to see margin by work type.

At minimum you want Service and Repair Revenue, New Construction Revenue, and Repipe and Specialty Revenue as distinct lines.

Many plumbing businesses also benefit from separating Drain and Sewer Revenue, since that work has its own cost structure and its own demand pattern, which in Florida spikes during the rainy season when heavy rainfall drives drain backups and sewer line issues.

If you run commercial work as a meaningful share of the business, Commercial Revenue deserves its own line as well, since commercial payment cycles and margins differ from residential.

The cost of goods sold section needs to distinguish the major direct cost categories.

Fixtures and Equipment covers water heaters, toilets, faucets, sinks, and disposals, and it deserves its own line because fixture margin is a meaningful metric on its own.

Parts and Materials covers pipe, fittings, valves, supply lines, and the many small consumables that go into plumbing work.

Burdened Labor captures crew payroll including payroll taxes, workers comp, and benefits, not just base wages, and in Florida the workers comp component for plumbing trades is substantial enough that using base wages instead of burdened cost will make every job look more profitable than it actually was.

Variable Vehicle Costs, meaning fuel, maintenance, and repairs, belongs in COGS because these scale directly with how much work your crews are doing.

Subcontractor Costs and Permit Fees round out the section, since both are job-specific and tracking them here rather than burying them in overhead keeps your gross margin honest.

The operating expenses section should group by function rather than alphabetically. The fixed portion of your vehicle costs (truck payments, insurance, registration) belongs here since those exist whether you run five jobs or fifty. Office, marketing, administrative, and licensing costs each group together, and owner compensation gets its own line.

Setting up the revenue accounts

Open your chart of accounts under the gear icon in QuickBooks Online. For each revenue stream, click New, set the account type to Income, choose Service/Fee Income as the detail type, and name the account clearly.

Create Service and Repair Revenue first, since for most residential plumbing businesses this is the highest-margin and highest-volume line.

Then create New Construction Revenue, then Repipe and Specialty Revenue. Add Drain and Sewer Revenue if that's a meaningful part of your work, and Commercial Revenue if commercial makes up a real share of your business.

The reason this granularity matters more for plumbing than for many trades is that the margin spread between your work types is wide. A plumbing business doing heavy new construction volume alongside a strong service department has two businesses inside one company, and the P&L needs to show both.

Once the new accounts exist, handle historical transactions by creating the new structure alongside the old accounts rather than deleting anything, then committing to the new categorization from a specific date forward.

Historical data stays in the old accounts, new transactions flow into the new ones, and over time the old accounts empty out. If you want to recategorize history, QuickBooks Online's Reclassify Transactions tool under the gear icon lets you bulk reassign transactions by date range, which makes year-over-year comparison cleaner once the rebuild is done.

Setting up the cost of goods sold accounts

This is where a plumbing chart of accounts rebuild adds the most value, because the default structure almost always blends costs that need to be seen separately.

Create Fixtures and Equipment as a Cost of Goods Sold account with the detail type set to Supplies and Materials – COGS.

This holds water heaters, toilets, faucets, sinks, disposals, and similar installed equipment. It earns its own line because fixture markup is a distinct pricing decision, and you can't evaluate whether your fixture pricing is working if fixture cost is buried in a general materials account.

Create Parts and Materials as a separate COGS account for pipe, fittings, valves, supply lines, solder, wax rings, and the many small components that flow through a plumbing job. These are individually small but collectively significant, and separating them from fixtures lets you see material cost trends that would otherwise be invisible.

This separation matters in Florida specifically, where coastal air and hard water drive demand for corrosion-resistant materials and grades that cost more than the cheapest available option. If you're specifying better materials because the Florida environment requires it, you want to see that cost clearly rather than have it disappear into a blended line.

Create Burdened Labor as a COGS account that captures the real cost of crew labor including payroll taxes, workers comp, and benefits. Setting this up correctly usually takes coordination with your payroll provider so the burden flows into QuickBooks rather than just base wages. The payoff is job costing that reflects reality instead of job costing that flatters you.

Create Variable Vehicle Costs as a COGS account for fuel, maintenance, and repairs. These scale with job volume, so putting them in COGS produces a gross margin that reflects the true cost of doing the work. A month heavy on repipe jobs burns more fuel and puts more wear on trucks, and that cost should land against the revenue it helped produce.

Create Subcontractor Costs for any 1099 work you sub out, and Permit and Inspection Fees for the job-specific permitting costs that Florida plumbing work requires. Both are genuinely job costs rather than overhead, and tracking them here keeps your margins honest.

Setting up the operating expenses

The operating expense section benefits more from organization than from new accounts, since most of the categories already exist in some form.

The fixed portion of vehicle costs lives here, separate from the variable vehicle costs in COGS. Vehicle Payments or Lease, Vehicle Insurance, and Vehicle Registration all belong in operating expenses because they exist regardless of job volume, which makes them committed overhead rather than a cost of doing work. Splitting vehicle costs across the two sections this way is what produces a gross margin that reflects job economics and an overhead number that reflects the fixed cost of being in business.

Licensing and Compliance deserves its own grouping for plumbing specifically. Florida requires plumbing contractors to hold a state certification or county competency card, and the licensing fees, bond costs, and continuing education required to maintain licensure are real recurring expenses. Grouping them makes them visible rather than scattered across miscellaneous lines.

Office costs, marketing and sales costs, and administrative costs each group together, and Owner Compensation gets its own line separated from crew payroll so your gross margin calculations aren't distorted by your own pay.

Common mistakes to avoid

The most common error is creating too many accounts chasing granularity. A chart of accounts with two hundred lines isn't more useful than one with sixty, it's just harder to maintain and produces reports nobody reads. The right level of detail is the minimum that surfaces the patterns you need to see, with customer, job, or class tracking handling the finer slicing.

The second common error is misplacing costs between sections, and vehicle costs are the usual offender. Putting all vehicle cost in operating expenses inflates gross margin by excluding real job-related fuel and maintenance. Putting all of it in COGS distorts gross margin downward in slow months when the truck payment still hits but little work is happening. The variable-versus-fixed split solves both.

The third common error is leaving owner compensation blended with crew payroll. If you're paying yourself through the same payroll run as your plumbers, the system needs to split your pay into a separate Owner Compensation account, or your gross margin and job profitability reports will be distorted by your own draw.

The fourth is treating the chart of accounts as a one-time setup. As your business shifts, adding a drain and sewer division or moving more heavily into commercial work, the structure needs to evolve with it. A quarterly or annual review keeps the chart of accounts aligned with how the business actually operates.

When to bring in a specialist

For plumbing contractors doing $500,000 or more in revenue, a chart of accounts rebuild is usually worth professional help. Someone who has done this for other plumbing businesses can complete the rebuild in a few weeks, train your office staff on the categorization discipline that keeps it clean, and connect the structure to your job costing so all the reports work together.

The alternative is staying with a generic structure because changing it feels like a hassle, and the cost of that decision is invisible but real. It shows up as pricing decisions made on blended numbers, new construction work you kept chasing because you couldn't see the margin, and service work you underpriced because nothing in your reports told you it was carrying the company.

At Prophet Accounting, we work with plumbing contractors and other home service trades across Port St. Lucie, the Treasure Coast, and nationwide.

We rebuild chart of accounts structures that separate service, new construction, and repipe revenue, treat labor and materials correctly, and produce monthly reports that show you which work is actually making money.

If your P&L can't tell you that today, schedule a consultation at prophetaccounting.com/contractors.

For a quick read on monthly bookkeeping costs, our pricing calculator gives you a ballpark in about two minutes.