Field service operations

Billed visits vs serviced visits: which record to reconcile first

When a recurring route's billed visits and serviced visits disagree, work the dated serviced-visit record first, then the crew's workweek time record, then the invoice export.

Atom Backends ·

A field technician loading a service van at sunrise
The short answer

Reconcile the dated serviced-visit record first, then the crew's workweek time record, then the invoice export. That order is our proposal, not an agency rule. Run it on one route and one workweek, settle each record with its own evidence, and only then consider repricing or connector work.

The first fix

When billed visits and serviced visits disagree on a recurring route, we propose reconciling the dated serviced-visit record first, then the crew's workweek time record, then the invoice export. The order is our proposal, not a rule from any cited agency: the Internal Revenue Service sets standards for supporting documents but does not rank one route record above another. Run the sequence on one route and one payroll workweek before anyone reprices the route or repairs a connector.

Why the dated serviced visit comes first

The Internal Revenue Service says a business may choose any recordkeeping system suited to its business that clearly shows income and expenses, and that all requirements applying to hard-copy books and records also apply to electronic records. The IRS lists the supporting documents that back entries in your books and on your tax return: sales slips, paid bills, invoices, receipts, deposit slips and canceled checks. For purchases and expenses specifically, the guidance says supporting documents should identify the payee, the amount paid, proof of payment, the date incurred, and a description of the item or service.

Our reasoning, not an IRS conclusion about routes: if a recurring route invoice line cannot be tied to a dated serviced visit plus a supporting document showing amount, date and description, the invoice is harder to substantiate under those recordkeeping principles. The IRS frames the responsibility to substantiate entries, deductions and statements on tax returns as the burden of proof, and says employment tax records must be kept at least four years. The IRS also says good records help a business monitor its progress, prepare financial statements, identify sources of income and track deductible expenses, which is the numbers-you-trust case for settling the visit record before the invoice.

The first check on one route is to pull the week's scheduled visits, the serviced-visit log and the invoice lines, and confirm every billed visit has a dated serviced visit behind it. We propose holding each visit to a standard like the IRS elements for purchases and expenses: a date, a description of what was done, and something that shows proof of service. That is a proposed check built on IRS guidance, not a rule the IRS states for route visits.

The workweek test for crew hours

The second record to check is the crew's time, and it has to be checked at the workweek level, not the month. The Department of Labor's Fact Sheet #23, revised October 2019, says employees covered by the FLSA must receive overtime pay for hours worked in excess of 40 in a workweek at not less than time and one-half their regular rate, unless specifically exempted. The workweek is a fixed and regularly recurring period of 168 hours, and averaging of hours over two or more weeks is not permitted. Overtime earned in a particular workweek normally must be paid on the regular pay day for the period in which it was earned.

This is where billed vs serviced comparisons can mislead, and the point is our inference from the DOL rules: comparing monthly billed visits with monthly payroll totals can conceal a workweek-level overtime difference, because the Department of Labor applies overtime on a workweek basis and does not permit averaging across weeks. A route that looks fine on a monthly labor average may be carrying miscomputed overtime inside individual weeks.

The fact sheet also says the regular rate includes all remuneration for employment except certain payments excluded by the Act, and that overtime due for piece-rate, salary, commission or other earnings is computed on the average hourly rate derived by dividing total pay for the workweek, except statutory exclusions, by total hours actually worked. It gives a concrete example: a fixed salary for a regular workweek longer than 40 hours does not discharge FLSA overtime obligations. So when you post hours for a route, the check is whether each workweek's hours and pay reproduce the DOL calculation from the raw time entries. If the overtime number cannot be reproduced from the time records, treat that as a broken record, and confirm the pay treatment with qualified counsel or a payroll professional before repricing anything.

The invoice export last

Only after the serviced visits and the workweek hours hold up should you look at the invoice export or the QuickBooks sync. The IRS guidance supports the principle but not any field mapping: any recordkeeping system is acceptable if it is suited to your business and clearly shows income and expenses, and electronic systems must meet the same basic recordkeeping principles as paper books. No source we cite documents how a specific export or sync behaves, so treat what follows as a proposed check, not a documented failure mode: look for whether the export drops lines, duplicates them, or maps a completed job to invoice against the wrong customer. Our reasoning for putting this last is that fixing the export first would carry unverified upstream records into the books without settling which record is actually wrong. The evidence that settles this step is a one-route, one-week trace: the same visit appears once in the schedule, once as serviced, once on the invoice and once in payroll, with no double entry.

Labor assumptions differ by trade

Before you reprice a route or rebuild its job costing, we propose splitting labor cost into straight time and overtime using the DOL workweek method, and keeping the route, the payroll records and the supporting documents together with the calculation. That is a proposed step grounded in the fact sheet's computation rules, not a repricing formula.

The cited trade context is separate from the proposal. The U.S. Bureau of Labor Statistics reports a May 2025 median annual wage of $45,250, or $21.75 per hour, for pest control workers, and says state laws require pest control workers to be licensed. For grounds maintenance workers, BLS reports a May 2025 median hourly wage of $19.27 and says states may require licensing for workers who apply pesticides and fertilizers. BLS also notes most grounds maintenance work is done outdoors in all weather, some of it seasonal, while pest control work often involves kneeling, bending and crawling in tight spaces, with evening and weekend work common. The inference to weigh in your estimate vs actual math: a pest route and a mowing route with the same visit count should not share the same labor assumption, because the median pay, licensing and work conditions differ between the two occupations.

Who owns each step

A proposed division of labor for the one-route reconciliation: one person owns the route record, scheduled and serviced visits; one owns the payroll workweek and the time entries; one owns the invoice export and the sync into the books. Each signs off on the same one-route, one-week reconciliation before anyone changes a connector, a price or a software setting. As a proposed risk to watch, not an observed pattern: without that sign-off, check whether fixes land in whichever system the loudest person uses, and whether the mismatch then resurfaces at month-end close. Treat that as something to look for in your own shop, not a documented tendency.

When the approach changes

Two conditions change the recommendation. First, if the same route fails the same reconciliation after the first fix, weigh the inference that the problem is systemic rather than a single bad record; that repetition is the trigger for bringing in outside help. Second, if the workweek overtime calculation cannot be reproduced from the time records at all, stop and get the pay treatment confirmed by qualified counsel or a tax professional before repricing the route or the recurring monthly revenue it carries. For reference, Atom Backends publishes its prices on its home page: a Systems Audit at $5,500-$9,500 and a Stabilization Sprint at $15,000-$35,000+, with larger modernization work scoped after diagnosis. If your one-route trace comes back clean, it found no break on that route and that week; sample additional routes and weeks before concluding no project is needed.

Checks

  1. Pick one recurring route and one payroll workweek; do not start with a month or the whole book.
  2. Confirm every billed visit ties to a dated serviced visit with a description and proof of service, as a proposed standard modeled on IRS supporting-document elements.
  3. Recompute each workweek's overtime from raw time entries using the DOL regular-rate method; confirm any pay-plan treatment with counsel or a payroll professional.
  4. Trace one visit end to end: schedule, serviced record, invoice line, payroll hours, with no double entry.
  5. Assign one owner each to the route record, the payroll workweek and the invoice export, with sign-off before any connector or pricing change.
  6. Keep the reconciliation, the payroll records and the supporting documents together; employment tax records must be kept at least four years per the IRS.

Questions

Should I just re-run the sync and see if it fixes itself?

We propose leaving the export or sync alone until you know which record is wrong. No source we cite documents how a specific sync behaves, so treat this as a proposed caution: trace one route and one workweek first, and make the export the last record you touch.

Why can't I compare billed visits to payroll monthly?

Because the Department of Labor applies overtime on a workweek basis and does not permit averaging hours over two or more weeks, per Fact Sheet #23. A monthly comparison can hide overtime differences inside individual weeks; this is our inference from the DOL workweek rule.

What if the serviced-visit log itself is incomplete?

Start by capturing dated evidence of service at the stop. The IRS lists amount, date, proof of payment and description as elements for purchase and expense support; we propose building the visit record to a similar standard rather than treating it as an IRS rule for visits.

Does this apply differently to pest routes vs landscaping routes?

The check order is the same, but the labor assumptions differ. BLS reports different median wages, licensing rules and working conditions for pest control workers and grounds maintenance workers, so the estimate vs actual math should differ too.

Sources

  1. Pest Control Workers : Occupational Outlook Handbook : U.S. Bureau of Labor Statistics
  2. Grounds Maintenance Workers : Occupational Outlook Handbook : U.S. Bureau of Labor Statistics
  3. Fact Sheet #23: Overtime Pay Requirements of the FLSA | U.S. Department of Labor
  4. What kind of records should I keep | Internal Revenue Service
  5. Recordkeeping | Internal Revenue Service

How we write: AI-assisted drafts from the cited public sources, each checked by three separate automated reviews (technical accuracy, search intent and writing quality) before publication. About Atom Backends.