Shortening DSO: Connecting Field Tickets to Invoicing and Payroll
The short answer. Days sales outstanding does not start when you send the invoice. It starts when the work is done. Paper tickets add days or weeks before an invoice can even go out, and every typo or missing signature adds more. A digital ticket that is signed on location, approved by a supervisor the same day, and attached to the invoice automatically takes most of that lag out, and the same record can drive stage bonuses in payroll.
In field services, every completed stage, hauled load, and standby hour is revenue. In a lot of companies, it is still written on a carbon-copy pad that rides in the truck until the end of the hitch. By the time the office sees it, the work is a week or two old, and the ticket has coffee and mud on it.
Then the office work begins. Billing deciphers handwriting and re-types ticket numbers, well names, and rates. One transposed digit and the operator's billing portal kicks it back. Someone chases a missing company man signature. Payroll is working from separate notes to figure out stage bonuses, and when those notes don't match billing, you either pay for stages the customer never approved or shortchange a hand who earned it.
I've written about why paper field tickets slow down an operation and how to build a field ticket workflow in Power Automate. This one is about the money: where the days go, and how one approved ticket can serve billing and payroll at once.
Where the Days Go
- Transit time. Tickets ride in trucks until someone turns them in. That can be the end of the week or the end of the hitch.
- Re-keying. Every ticket typed by hand is a chance for a wrong rate, a wrong well, or a missing line item.
- Rejections. Operators send back invoices without legible, signed backup or with numbers that do not match the PO, and the clock restarts.
- Bonus mismatches. Payroll and billing count stages from different sources and come up with different numbers.
- No current view of margin. Management cannot see what a job made until weeks after it ended.
| Stage | Paper Tickets | Digital Ticket Workflow |
|---|---|---|
| Capture | Carbon-copy pad signed on a truck hood | Mobile form signed on the phone |
| Signature | Hard to read, hard to verify | Signature captured with name and timestamp |
| Supervisor approval | Weekend review, if it happens | One-tap approval in Teams |
| Billing | Clerk re-keys into accounting | Approved ticket attached to a draft invoice |
| Stage bonuses | Calculated from separate notes | Pulled from the same approved ticket |
| Time to invoice | Days or weeks after the job | As soon as the supervisor approves |
Before You Buy a Ticketing Platform
Dedicated field ticketing platforms can work well, especially for larger operations with complex integrations. For smaller service companies, the usual sticking points are annual licensing costs, mobile screens that try to do too much, multi-year contracts, and integrations that do not quite reach the accounting system. If the app is slow, hands go back to paper.
If you already pay for Microsoft 365, you may not need another platform. Forms or Power Apps, Power Automate, SharePoint, and Teams can carry a ticket from location to invoice.
How the Pipeline Works
1. Capture on location
The field lead opens a ticket on his phone. Customer, lease, and rate sheet are pre-filled. He logs stages, equipment hours, and crew, and the company man signs on the screen. For locations without reliable signal, a Power Apps form can save the ticket and send it once the phone reconnects.
2. Supervisor approval
Submitting the ticket kicks off a flow that sends it to the superintendent in Teams. He checks stage counts, hours, and the signature, then approves or sends it back with a note. Once approved, changes are tracked, and nothing gets lost in a text thread.
3. Billing and payroll from the same record
The approved ticket goes two ways at once:
- Invoicing. A clean PDF of the ticket attaches to the invoice in your accounting system, and billing can send it to the operator that day.
- Payroll. Verified stage counts and day rates go to payroll so bonuses match what was billed. If anyone on the crew is on hybrid pay, the variable pay is added as separate line items and the base salary is left alone.
Five Steps to Get There
- Clean up the ticket fields. Drop the questions nobody answers and standardize well identifiers, job codes, and crew roles.
- Build a mobile-first form. It has to work on any phone, with gloves on.
- Add supervisor approval in Teams. Catch errors before they reach the customer's billing portal.
- Automate the billing package. Turn every approved ticket into invoice backup without anyone touching it.
- Feed payroll from the same ticket. Stage counts and day rates should come from one approved record.
Frequently Asked Questions
How does digital field ticketing reduce days sales outstanding?
It removes the time tickets spend traveling from location to the office and the time spent re-keying them. A ticket signed on location and approved by a supervisor the same day can be attached to an invoice right away, and cleaner backup means fewer rejections from operators, which keeps the clock from restarting.
How do you connect field tickets to payroll and stage bonuses?
Use the supervisor's approval as the trigger. Once a ticket is approved, an automated flow sends the verified stage counts, hours, and day rates to payroll, so bonuses are calculated from the same numbers that were billed and nobody builds a separate spreadsheet.
Why do paper field tickets lead to invoice rejections?
Handwriting is hard to read, signatures go missing, and stage counts get typed wrong when tickets are re-keyed. Operators reject invoices with mismatched POs or missing backup, and each rejection pushes payment further out.
Want to see how many days your tickets spend in the truck? Book a free 15-minute Workflow Review and we'll trace one ticket from location to deposit.