All articles
Operations

Why Your Field Techs Are Costing You Money on Pricebook Errors

A single mispriced line item, picked 12 times a day across 6 trucks, is a five-figure annual leak. Here is how to find it and stop it.

May 1, 20265 min read

The most common margin leak we find in a contractor’s books is not theft and it is not unbilled time. It is the pricebook. A line item that should bill at $185 but is set at $148 gets picked on every job that needs it. Multiply that by six trucks across 240 working days and you can lose $40,000 a year and never see it on a weekly report.

How the leak forms

  • A supplier raises a part cost by 8% and your pricebook does not update
  • A flat-rate book gets imported once and never re-priced for the local labor rate
  • A tech adds a custom one-off line item at the wrong rate and it gets reused
  • A promo discount from last spring never gets removed

The diagnostic — run this report this week

For the 50 most-frequently-billed line items in the last 90 days, calculate the average billed price and compare it to the current target price. Any line where billed price is lower than target by more than 5% is bleeding money on every job.

In one Tampa plumbing shop we audited, three line items — drain-clearing service, water-heater install labor, and 1/2" copper — accounted for 78% of the total margin leak. Fixing those three line items in the pricebook recovered roughly $31,000 in annual gross margin without raising a single customer’s bill unfairly.

The systemic fix

Three controls stop the leak from coming back:

  • Material-price alerts. When a vendor invoice comes in with a price more than 3% above what the pricebook expects, you get notified. This is built into the AP three-way match in Trade Books.
  • Pricebook re-review on a calendar. Twice a year, every line item gets re-priced. Put it on the calendar like you put oil changes on the truck.
  • Tech can suggest, office approves. Field techs should never be able to create a new pricebook line item that other techs can reuse. Suggestions go to a queue the office approves weekly.

The quiet version of the same leak

Watch out for time. A "1-hour" job that consistently takes 1.4 hours and bills at flat-rate is the same leak in a different shape. The job-profitability report by line item will surface it if you can actually pull one — which goes back to whether your job costs are real.

See it on your own data

Trade Books runs field service and accounting from one database.

No setup fee. No credit card. Cancel anytime.

Start Free Trial