Key takeaways
- Decide the source of truth for each record: jobs, estimates and invoices in the field software; the books, bills and payroll in QuickBooks.
- Map price book items to a short list of income accounts by job type, so profit by line of work is visible without extra reports.
- Handle payments, processor fees and deposits deliberately; most sync problems start with money that arrives in lumps.
- Job costing needs materials and labor tied to the job, not just revenue; payroll is about 27% of receipts across the industry.
- Reconcile the sync every month with a short checklist, before small errors pile up.
Why the sync matters
Most plumbing shops run two systems that must agree: field service software where jobs, estimates and invoices live, and QuickBooks where the books, taxes and payroll live. When the sync between them is set up badly, the symptoms are familiar: duplicate customers, invoices posted to the wrong income account, payments that never match deposits and a bookkeeper who spends days each month fixing things by hand.
Getting it right is worth the effort because labor and payroll are such a large share of the business. Payroll equalled about 27% of receipts across plumbing, heating and AC contractors in 2022[1], and average annual payroll per employee was about $73,700 in 2023[2]. If you cannot see labor and materials against each job, you cannot see which work actually makes money.
- Payroll share of receipts 26.9%
Source: U.S. Census Bureau, 2022[1]
Show the data
| Item | Value |
|---|---|
| Payroll share of receipts | 26.9% |
Decide the source of truth
| Record | Created in | Synced to | Edited where |
|---|---|---|---|
| Customers and service addresses | Field software | QuickBooks | Field software only |
| Price book items | Field software | QuickBooks (as products and services) | Field software only |
| Estimates | Field software | Usually not synced | Field software |
| Invoices | Field software | QuickBooks | Field software; never edit synced invoices in QuickBooks |
| Payments | Field software or processor | QuickBooks | Field software |
| Bills, supplier invoices, expenses | QuickBooks | Not synced back | QuickBooks |
| Payroll | Payroll system or QuickBooks | Not synced back | Payroll system |
The rule that prevents most problems: if a record was created in the field software, change it there. Editing a synced invoice in QuickBooks breaks the link and creates mismatches.
Sync settings, step by step
Clean up QuickBooks first
Merge duplicate customers, inactivate old products and services, and close the books for prior periods so the sync cannot change them.
Set up a short income account list
Create income accounts by line of work, such as service and repair, water heaters, drain and sewer, installs and remodels, and maintenance agreements. Five to seven accounts are enough for most shops.
Map every price book item
Point each item or category in the field software to one income account. Map materials and equipment sold separately if you want material revenue visible on its own.
Choose classes or locations
If you want profit by branch, by residential versus commercial, or by tech, use QuickBooks classes or locations and map them from the job type or business unit.
Set tax codes
Match sales tax settings in both systems and test a taxable and a non-taxable job, since rules on parts and labor vary by state.
Set the sync start date
Pick the date from which invoices and payments sync, and make sure nothing before it is imported twice.
Run test transactions
Sync a paid invoice, a partial payment, a refund and a job with a deposit, and check each lands correctly before going live.
Payments, fees and deposits
Money moves in ways that confuse a basic sync. A card processor might pay out ten invoices in one lump, minus fees, two days later. A customer might pay a deposit on an estimate weeks before the job. Set each of these up on purpose.
- Payouts: record payments into a clearing or undeposited funds account, then match each processor payout to the payments it contains.
- Processor fees: record fees as an expense on the payout date, so the deposit matches the bank exactly.
- Deposits on estimates: record them as a customer deposit liability, not income, until the work is done and invoiced.
- Refunds: issue them in the field software so the credit syncs, then match the refund to the bank.
- Financing: treat funded amounts from a consumer financing provider as a separate payment method, with the provider's fee as an expense.
Job costing that works
Revenue by job type is half the picture. To see margin, costs must reach the same job. Materials are the easier half: enter supplier bills in QuickBooks against the customer or job, or use the field software's purchase tracking if it syncs costs. Labor is harder, because payroll pays people, not jobs. The practical approach for most shops is to use time tracking in the field software and allocate labor cost to jobs at an average loaded rate per tech hour.
The loaded rate needs to include more than wages. Average hourly earnings at plumbing, heating and AC contractors were $42.38 in September 2026, up about 4.4% in a year[3], and benefits averaged 30% of total compensation costs across private industry[4]. Recalculate the loaded rate at least once a year.
Example: a fictional shop's tech earns $40 an hour; with payroll taxes, workers' compensation and benefits, the loaded cost is about $54 an hour. A water heater replacement takes 4.5 tech hours and $1,150 in materials and is invoiced at $2,600. Job cost is $243 of labor plus $1,150 of materials, or $1,393, for a gross margin of about 46%. Run the same math across all water heater jobs for a quarter and you have a real margin by line of work.
Maintenance agreements in the books
Agreements are easy to sell and easy to record badly. When a member pays for a year up front, the shop has not yet earned the money; it owes the visits. Ask your accountant how they want agreement revenue handled, but most will suggest the same pattern.
- Record annual agreement payments to a deferred revenue or unearned income account, not straight to income.
- Move the earned portion to the maintenance agreement income account each month, or when each included visit is completed.
- Monthly-billed agreements can usually go straight to income, since each payment covers the current month.
- Keep a simple monthly report of active agreements, visits owed and renewals due, and check it against the deferred balance.
Reports to build once the sync is clean
A clean sync pays off in a handful of reports you can trust. Build them once in QuickBooks or your field software and review them every month with the same person.
- Profit and loss by income account, showing revenue, materials, labor and gross margin for each line of work.
- Profit and loss by class or location, if you track branches or residential versus commercial work.
- Accounts receivable aging, with every invoice over 30 days assigned to someone to chase.
- Gross margin by technician for the quarter, using allocated labor and materials.
- Customer deposits and deferred agreement revenue, so liabilities are never mistaken for cash you have earned.
When these numbers look odd, check the sync first. A sudden jump in one income account often means new price book items were mapped to the wrong place.
Common sync problems and fixes
| Symptom | Likely cause | Fix |
|---|---|---|
| Duplicate customers in QuickBooks | Customers created in both systems | Create customers only in the field software; merge duplicates once |
| Income all in one account | Items not mapped, falling back to a default | Map every item and category; check new items monthly |
| Bank deposits don't match payments | Processor payouts net of fees | Use a clearing account and record fees on payout |
| Sales tax off by cents | Different rounding or tax settings | Align tax settings and test before go-live |
| Invoice totals differ between systems | Synced invoice edited in QuickBooks | Edit only in the field software; re-sync |
| Deposits showing as income | Deposit recorded as a payment on a non-existent invoice | Use a customer deposit liability account |
A monthly reconciliation routine
- Compare total invoiced in the field software with income in QuickBooks for the month; investigate any gap.
- Match every processor payout to its payments and fees.
- Check the customer deposits account: every balance should belong to an open job.
- Review the sync error log and fix every failed record.
- Check that new price book items added this month are mapped to an income account.
- Flag subcontractors paid this year; for tax years beginning after 2025, the 1099-NEC reporting threshold for nonemployee compensation is $2,000[5], so make sure vendor records are marked for 1099 tracking.
Thirty minutes a month keeps the sync clean. Leave it for a quarter and it can take days to untangle. For the full year-end list, see the year-end checklist for plumbing owners, and for margin targets, gross margin for plumbing companies.
Who should own the sync
Give one person responsibility for the sync: often the office manager, with the outside bookkeeper or accountant checking monthly. That person approves new income accounts, maps new items and reviews the error log. Techs and CSRs should never need to touch QuickBooks. If you are choosing new software, ask every vendor to demonstrate the sync with your own chart of accounts before you sign; see software for small plumbing shops for where accounting fits in a small stack.
Frequently asked questions
Should invoices be created in QuickBooks or in plumbing software?
In the field service software, then synced to QuickBooks. Creating or editing invoices in both places causes duplicates and mismatched totals.
How do I see profit by job type in QuickBooks?
Map price book items to a short list of income accounts by line of work, such as service, water heaters, drains and maintenance agreements, and allocate materials and labor to jobs.
How should deposits on estimates be recorded?
As a customer deposit liability until the work is done and invoiced, not as income when the deposit is received.
Why don't my bank deposits match payments?
Card processors usually pay out several payments at once, minus fees. Record payments into a clearing account and record the fee when the payout arrives.
References
U.S. Census Bureau (2022). Statistics of U.S. Businesses 2022: U.S. and states, 6-digit NAICS (opens in a new tab) โ
U.S. Census Bureau (2023). County Business Patterns 2023, U.S. national file (cbp23us) (opens in a new tab) โ
U.S. Bureau of Labor Statistics, Current Employment Statistics (2026). Average hourly earnings of all employees, plumbing, heating, and air-conditioning contractors (CEU2023822003) (opens in a new tab) โ
U.S. Bureau of Labor Statistics (2026). Employer Costs for Employee Compensation - June 2026 (opens in a new tab) โ
Internal Revenue Service (2026). Instructions for Forms 1099-MISC and 1099-NEC (opens in a new tab) โ