Technology AI

QuickBooks and plumbing software: getting the sync right

How to set up the sync between plumbing field service software and QuickBooks: source of truth, item and account mapping, payments, deposits, job costing.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing6 min read

On this page
  1. Why the sync matters
  2. Decide the source of truth
  3. Sync settings, step by step
  4. Payments, fees and deposits
  5. Job costing that works
  6. Maintenance agreements in the books
  7. Reports to build once the sync is clean
  8. Common sync problems and fixes
  9. A monthly reconciliation routine
  10. Who should own the sync
  11. Frequently asked questions
  12. References
Technology AI: QuickBooks and plumbing software: getting the sync rightArticle coverTECHNOLOGY AIQuickBooks and plumbingsoftware: getting thesync rightAva for PlumbersInsightsTechnology AI: QuickBooks and plumbing software: getting the sync rightArticle coverTECHNOLOGY AIQuickBooks andplumbing software:getting the syncrightAva for Plumbers

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 as a share of receipts, plumbing, heating and AC contractors, 2022
Payroll as a share of receipts, plumbing, heating and AC contractors, 2022Donut chart. Payroll share of receipts: 26.9%.Payroll share of receipts: 26.9%26.9%
  • Payroll share of receipts 26.9%

Source: U.S. Census Bureau, 2022[1]

Show the data
ItemValue
Payroll share of receipts26.9%

Decide the source of truth

Example source-of-truth plan for a plumbing shop using field service software with QuickBooks.
RecordCreated inSynced toEdited where
Customers and service addressesField softwareQuickBooksField software only
Price book itemsField softwareQuickBooks (as products and services)Field software only
EstimatesField softwareUsually not syncedField software
InvoicesField softwareQuickBooksField software; never edit synced invoices in QuickBooks
PaymentsField software or processorQuickBooksField software
Bills, supplier invoices, expensesQuickBooksNot synced backQuickBooks
PayrollPayroll system or QuickBooksNot synced backPayroll 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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. Set the sync start date

    Pick the date from which invoices and payments sync, and make sure nothing before it is imported twice.

  7. 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.

  1. Profit and loss by income account, showing revenue, materials, labor and gross margin for each line of work.
  2. Profit and loss by class or location, if you track branches or residential versus commercial work.
  3. Accounts receivable aging, with every invoice over 30 days assigned to someone to chase.
  4. Gross margin by technician for the quarter, using allocated labor and materials.
  5. 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

Example troubleshooting guide for field service software and QuickBooks sync.
SymptomLikely causeFix
Duplicate customers in QuickBooksCustomers created in both systemsCreate customers only in the field software; merge duplicates once
Income all in one accountItems not mapped, falling back to a defaultMap every item and category; check new items monthly
Bank deposits don't match paymentsProcessor payouts net of feesUse a clearing account and record fees on payout
Sales tax off by centsDifferent rounding or tax settingsAlign tax settings and test before go-live
Invoice totals differ between systemsSynced invoice edited in QuickBooksEdit only in the field software; re-sync
Deposits showing as incomeDeposit recorded as a payment on a non-existent invoiceUse a customer deposit liability account

A monthly reconciliation routine

  1. Compare total invoiced in the field software with income in QuickBooks for the month; investigate any gap.
  2. Match every processor payout to its payments and fees.
  3. Check the customer deposits account: every balance should belong to an open job.
  4. Review the sync error log and fix every failed record.
  5. Check that new price book items added this month are mapped to an income account.
  6. 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

  1. U.S. Census Bureau (2022). Statistics of U.S. Businesses 2022: U.S. and states, 6-digit NAICS (opens in a new tab) โ†‘

  2. U.S. Census Bureau (2023). County Business Patterns 2023, U.S. national file (cbp23us) (opens in a new tab) โ†‘

  3. 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) โ†‘

  4. U.S. Bureau of Labor Statistics (2026). Employer Costs for Employee Compensation - June 2026 (opens in a new tab) โ†‘

  5. Internal Revenue Service (2026). Instructions for Forms 1099-MISC and 1099-NEC (opens in a new tab) โ†‘

Book a demo

See Ava handle your calls.

Book a short demo. Weโ€™ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo