QuickBooks handles a plumbing shop's books well when you have a small trusted team. But once you hit a certain point, you'll quickly see QuickBooks' limits with WIP, retainage, change orders, and job costs. Outgrowing it is actually a great sign that your business is thriving and upgrading will unlock new capabilities in how you manage your team.
We install construction accounting systems for plumbing contractors. Tina Rehberg, Troy Guevara, and Mohammed Ali explain how to recognize when QuickBooks no longer meets your needs and what moving to Sage 100 Contractor or Sage Intacct Construction involves.
QuickBooks may have been the right bookkeeping system when the business was smaller. Growth eventually requires software built to manage construction.
Where QuickBooks job costing falls short
The limits of QuickBooks become clear when you need job-cost detail from the general ledger.
QuickBooks doesn't do construction accounting. It does a really good job of identifying categorically where checks and invoices go, but it doesn't provide you true job cost information.
Troy Guevara · Construction TechnologistEventually, you need more detail than where a check was recorded in the general ledger. You need to know what happened on a specific project, which cost code and cost type were affected, and what those costs mean for project profitability.
A simple test reveals the difference: try producing a P&L across dimensions such as customer, location, project, and item. QuickBooks does not provide the dimensional chart of accounts needed to create that view without manually reorganizing the information. In Sage Intacct Construction, the project is a dimension in the general ledger, so you can run a P&L by project, cost code, cost type, or location without exporting the data.
Many QuickBooks users do not use projects consistently, if they use them at all, so this approach may be unfamiliar. Once the project is part of the ledger, you can move beyond seeing where an expense was recorded and understand what it means for that project.
Why MEP contractors face more job-cost exposure
MEP contractors share accounting and operational demands that set them apart from other trades on a project.
A plumbing contractor may arrive near the beginning of a project to complete underground work and remain involved through rough-in and final fixture installation. Troy Guevara describes how long that involvement can last:
As soon as you put footings in the ground you've got underground plumbing going in, most likely underground electrical. But you don't put toilets and faucets in until the very end, you don't put wall outlets and switches in till the very end, you put light bulbs in at the very end.
Troy Guevara · Construction TechnologistThat long timeline creates more opportunities for a project to drift from its budget. A plumbing contractor carries labor, scheduling, change-order, and procurement risk through most of the project. By comparison, some trades complete their scope during a much shorter window.
A mason or a concrete guy comes in, boom, does their job, and they're out of there. A roofer, he's in and he's out. These guys are there the entire length of the job, and because of that they have a lot more exposure for bleeding profit margin. They're going to bleed it because they don't see it.
Troy Guevara · Construction TechnologistRough-in is one point where that exposure becomes visible. If no one compares actual labor and costs with the budget when that phase ends, you may not discover the overrun until finish work begins. At that point, the remaining work has to make up the difference. Staffing adds another constraint because plumbing requires licensed workers, so you cannot always assign the work to whoever is available.
The back office may also be billing two different kinds of work out of the same set of books because many plumbing contractors run a service division alongside project work. Material exposure differs as well. Plumbing contractors may have less exposure to price changes for raw materials such as PVC than some other trades, while fixtures can present a greater risk when specified products are unavailable at the time the project needs them.
Because plumbing contractors remain on a project for so long, poor job-cost visibility has more time to become expensive.
Signs that you have outgrown QuickBooks
Revenue can be a useful indicator, but operations provide a better test. Ask these questions:
- How many projects are running at the same time?
- How long do projects remain open?
- How much labor do you self-perform?
- Have change orders and WIP reporting outgrown your spreadsheets?
Construction companies often begin to feel these pressures around $1 million in revenue, although two contractors with the same revenue can have very different accounting needs based on project duration, labor model, and the number of concurrent jobs. The clearest sign is often a report you cannot produce directly from QuickBooks. When management, a bank, a bonding company, a state agency, or a private-equity owner asks for information in a new format, your team has to rebuild the report outside QuickBooks because the system cannot organize the data in the requested way.
Other warning signs usually appear at the same time. Multiple legal entities require separate QuickBooks files and spreadsheet work to create consolidated reports. Higher transaction volumes can slow performance and force difficult decisions about how much historical data to retain. Integrations may also require manual imports instead of using real-time web services.
Your team can still get the work done. The issue is how much staff time, CPA support, and workaround maintenance it takes.
One Texas plumbing contractor shows how extensive these workarounds can become. The company had operated for roughly 35 years, employed about 120 people, and had seven or eight people in the back office. QuickBooks had stopped meeting its needs years earlier, so the team built a detailed paper-based process for project invoicing, matching invoices to projects, and processing change orders. The company was not even using Excel for these tasks.
The employees kept the process working, but Troy Guevara described the limits plainly:
To their credit they've done a good job, but they're still building a Mickey Mouse system.
Troy Guevara · Construction TechnologistWhy job-cost information arrives too late to use
Controllers sometimes describe the problem as inaccurate job costs, but the deeper problem is usually timing. Troy Guevara put it this way:
The numbers are the numbers. It's a delay of the data. It's the not real-time job costing.
Troy Guevara · Construction TechnologistA final job-cost report may reconcile perfectly and still be useless for managing the project. If your team does not see the results until the work is complete, there is nothing left to change.
With QuickBooks, you may not learn how a project performed last week until the following week. Real-time construction job costing shows where the project stands at the end of each day, while there is still time to respond.
Labor makes timely information especially important because it is usually the largest variable on a construction project. Unlike a known quantity of materials, labor costs are difficult to predict precisely.
I can build a school. I know how many brick it takes, I know how much concrete it's going to take. If something's out of whack on any of that, I get a change order, so I'm compensated. But I can't control my labor. I literally have to guess what it costs me to lay every brick and pour every yard of concrete. It's an educated guess, but it's a guess. If I can't control that number I'm going to lose money, and if I control that number I make money.
Troy Guevara · Construction TechnologistYou should rebudget active projects every week. Review how much work remains and what it will cost to finish, then determine whether projected profitability has improved or declined. If material costs increase unexpectedly, determine where the project can recover that cost. Daily visibility gives you time to make those decisions before the project ends.
The same principle applies to bank, bonding, and WIP reporting. With a bookkeeping system, your team may spend hours rebuilding these reports whenever someone requests them. In Sage Intacct Construction, you can design the report once using construction dimensions and refresh it with current data.
Moving from QuickBooks
Moving from QuickBooks to a construction accounting system changes how the business organizes and discusses its financial information. It goes beyond replacing one piece of software with another.
Sage is the family, but we speak a little bit different language when you go to different software. 100 speaks a different language than 300, 300 speaks a different language than Intacct, but the core is the same. If you compare it to talking to someone from the West Coast to the East Coast, it's a minor language barrier. QuickBooks is a completely different country.
Tina Rehberg · Senior Sage Intacct ConsultantA company already using Sage 100 Contractor or Sage 300 CRE usually has some construction accounting structure in place. QuickBooks users often understand their customers and vendors well, but they may need more training to adopt a dimensional model that includes locations, projects, cost codes, cost types, and project IDs.
System selection comes next. Sage 100 Contractor can give a smaller plumbing contractor a strong foundation in construction accounting. Sage Intacct Construction, which is different from the standard Sage Intacct product, is designed for the needs of a mid-market construction company.
Implementation begins with understanding how the contractor operates and describes the business. The implementation team can then map those processes and terms to the new accounting structure rather than simply copying records from one system to another.
Inventory adds complexity. Ackerman, a plumbing contractor moving from QuickBooks, had detailed inventory requirements that included item IDs and part numbers. The implementation team had to model that structure carefully instead of treating the project as a standard QuickBooks conversion.
Migration also creates an opportunity to improve processes. Identify which steps serve a real business need and which ones exist only because QuickBooks required them. Keep the necessary controls without recreating unnecessary workarounds in the new system.
That work requires an implementation partner who understands more than software configuration. Construction accounting has its own language, including WIP, retainage, and conditional, unconditional, partial, and full lien waivers. The implementation team needs to understand what you mean before deciding how to configure the system.
The decision often comes down to whether the existing processes still serve the business. QuickBooks may have been exactly the right place to start, but once defending the workarounds takes more effort than changing the system, the balance has shifted.
This is the plumbing of your money — this is how your money moves. Money coming in, money going out. You want it to be simple. The biggest problem a plumber has is when they get into these old houses and think 'why did they do it this way?' I guarantee I can get into your ERP and your tech stack and say the same thing.
Mohammed Ali · ERP AdvisorWorkarounds become familiar, and familiar pain is easy to mistake for a necessary part of the job. If WIP, retainage, and change orders already live in Excel or on paper, QuickBooks is already the old house.
You do not have to regret how it was built. You only have to recognize when it is time to redo the plumbing.
The right foundation for your next stage of growth
Our team of experts is here to help guide you every step of the way. Let’s start your ERP journey today!
