How to Track Plumbing Service Calls and Invoices in a Spreadsheet

Plumbers lose money when parts used on a job never hit the invoice, or when completed work sits in “done” without a bill sent. A free plumbing service call tracker spreadsheet logs calls, work done, parts, and invoice status from scheduled through paid.

One row per service call

Capture in the field:

1. Customer and address
2. Issue and work performed — short notes for repeat visits
3. Parts used — quantity and cost or price
4. Labor — flat trip fee or hourly
5. Invoice amount and status — scheduled, completed, invoiced, paid

Phone-friendly updates in the van beat reconstructing the day from memory at 9 p.m.

Parts column is where margin leaks

If parts live only on the truck receipt, they never hit the customer invoice. Log parts on the row when you install — even approximate cost — then true-up when the supplier invoice arrives.

Pair high-volume pricing with job estimates for installs; this tracker is for service call flow and AR.

Weekly invoice batch

Friday: filter completed, not invoiced, generate invoices, mark rows sent. Monday: filter sent, unpaid for follow-up. Small discipline prevents a month of unbilled calls.

When FSM software replaces the log

Dispatch routing, GPS, mobile payments, and inventory sync earn their cost at multi-truck scale. Solo plumbers and small shops often run faster on a sheet until missed parts and unpaid calls cost more than subscription fees.

These templates are front-office field tools, not licensed plumbing compliance records.