Very few service companies run entirely on paper anymore. Most run on a mix: a scheduling app or a whiteboard for dispatch, paper tickets in the trucks, a spreadsheet for rates, and accounting software in the office. Each piece made sense when it was added.
The trouble is not any single piece. It is the gaps between them, where a person has to carry information from one system to the next by hand. That is where tickets go missing, numbers change on the way through, and nobody can say for sure who changed what. This article looks at the risks of manual data entry and disconnected systems, what research says about each one, and how to find the gaps in your own setup.
Why half-and-half can be worse than all paper
An all-paper company at least has one version of the truth: the ticket. A half-and-half company often has three. The schedule says the job was four hours. The paper ticket says five. The invoice, typed from memory because the ticket was late, says four and a half.
When those disagree, someone has to find out which one is right. Data quality consultant Thomas Redman calls this the “hidden data factory”: the extra steps one department adds to catch and correct errors created upstream, some of which still leak through to customers.1 In a service company, the upstream department is usually the field, and the downstream one is whoever does the billing. Every system you add without connecting it creates another hand-off where this can happen.
Risk 1: Tickets that never make it back
A paper ticket only exists in one place. If it gets lost between the truck and the office, the work is still done, the fuel and wages are still spent, but nothing reminds anyone to bill it.
Software on one side of the gap doesn’t help if the other side is paper. The scheduling app knows the job was assigned; it doesn’t know whether the ticket came back. Unless someone compares the two lists by hand, a missing ticket looks exactly like a job that hasn’t happened yet.
The fix is less about technology than about where the record starts. If the job is created once, the crew closes it from the field, and the office invoices from that same record, then “completed but not invoiced” becomes a list you can look at instead of a hole you discover at year end. Our guide to replacing paper job tickets goes into how that works.
Risk 2: Double entry and the errors it brings
Every time a person copies information from one place to another, some of it changes. This is not carelessness; it is how people work.
How often people make mistakes
Human error research has found that for simple but non-trivial tasks like writing, calculating and entering data, people make errors on roughly 1% to 5% of actions. Raymond Panko, who has studied human and spreadsheet error for many years at the University of Hawaii, notes this range shows up both in lab experiments and in data from real organizations.2
Why checking doesn’t catch them
The usual defence is to have someone look it over. Unfortunately, people are much better at doing a task accurately than at spotting errors afterward. Panko cites proofreading data where readers caught 81% of simple spelling errors but only 66% of more complex ones.2
A controlled study by Kimberly Barchard and Larry Pace makes the point even more sharply. They had 195 people enter the same data sheets using single entry, single entry plus a visual check, or double entry (typing everything twice and letting the computer flag differences). The visual-check group made about 30 times as many errors as the double-entry group, and visual checking was not significantly better than no check at all.3
Most offices rely on the visual check. Someone types the ticket into the invoice, glances back at the paper, and moves on.
What it looks like when it goes wrong
Copy-and-paste mistakes are not only a small-company problem. In 2003, Calgary-based TransAlta took a US$24 million hit after a bidding error. Its CEO at the time described it as “literally a cut-and-paste error in an Excel spreadsheet that we did not detect” before the bids went in.4
In 2023, a review of trainee anesthesiologist recruitment in the UK found that a scoring spreadsheet had made every candidate in Wales “unappointable.” Among the causes it identified: manual transfer of data between regional spreadsheets and a master spreadsheet, and problems with copy and paste.5
Your stakes are smaller, but so is your margin. On a service invoice, a transposed rate or a missed line item comes straight off the bottom line. Customers tend to call about the errors that cost them money. The ones that cost you money usually go unnoticed.
Risk 3: No audit trail
An audit trail answers a simple question: what happened, who did it, and when. Paper can’t answer the last two. A rate crossed out and rewritten on a ticket tells you it changed, not who changed it or why. A spreadsheet that several people edit tells you even less.
The Canada Revenue Agency takes this seriously. Its guidance on electronic record keeping defines an audit trail as the information required to re-create the sequence of events related to a business transaction, and says electronic records must show a trail from the source documents, paper or electronic, to the summarized financial accounts. It also says that before putting in a new business system, a business must make sure the audit trail of each transaction will be preserved so CRA auditors can verify its taxes.6
For a service company, the audit trail matters most in two places:
- Billing disputes. When a customer questions an invoice, you want to show the ticket, the photos, the hours and the approved rate, and show that none of it was changed after the fact. Our article on audit trails and billing disputes covers this in more detail.
- Rate and price changes. If a dispatcher can change a customer’s rate on a job, you want to know when it happened and who approved it.
When the record is split between paper and three apps, that history is scattered or doesn’t exist.
Find the gaps in your own setup
You can map your risk in about half an hour. Follow one job from the first phone call to the payment and write down every time information moves from one place to another by hand. For each hand-off, ask:
- If this step is skipped or lost, does anything flag it?
- Is the information typed again, or does it flow through?
- If a number changes here, can we tell who changed it and when?
Every “no” is a gap. You don’t have to close them all at once. Start with the one closest to the money, usually the step between a finished ticket and an invoice.
Where Dispatch fits
Dispatch closes the gaps by putting the quote, the job ticket, the invoice and the payment on one record. Crews open a link on their phone to update job status and add photos and notes, with nothing to install, so the office isn’t waiting on paper. Invoices are built from completed tickets with each client’s rates applied, so nothing gets retyped. Dispatch keeps an audit log of key actions such as voids, rate overrides and quote revisions, so you can see who did what and when, and rate overrides set by a dispatcher can require approval. You can read more on reports and the audit trail.
Dispatch is not accounting software. It sends clean invoice data to the accounting system you already use, so the books stay where they are. If you’d like to see your own job flow with fewer hand-offs, book a demo.
Footnotes
-
Thomas C. Redman, “Bad Data Costs the U.S. $3 Trillion Per Year,” Harvard Business Review, September 22, 2016. https://hbr.org/2016/09/bad-data-costs-the-u-s-3-trillion-per-year ↩
-
Raymond R. Panko, “What We Don’t Know About Spreadsheet Errors Today: The Facts, Why We Don’t Believe Them, and What We Need to Do,” Proceedings of the EuSpRIG 2015 Conference, 2015. https://arxiv.org/abs/1602.02601 ↩ ↩2
-
Kimberly A. Barchard and Larry A. Pace, “Preventing human error: The impact of data entry methods on data accuracy and statistical results,” Computers in Human Behavior 27(5), 2011. https://doi.org/10.1016/j.chb.2011.04.004 ↩
-
Drew Cullen, “Excel snafu costs firm $24m,” The Register, June 19, 2003. https://www.theregister.com/2003/06/19/excel_snafu_costs_firm_24m/ ↩
-
European Spreadsheet Risks Interest Group, “Horror Stories” (entry POB2309, “Frankensheet sorting errors hamper recruitment”), 2023. https://eusprig.org/research-info/horror-stories/ ↩
-
Canada Revenue Agency, “IC05-1R1 Electronic Record Keeping,” 2010. https://www.canada.ca/en/revenue-agency/services/forms-publications/publications/ic05-1/electronic-record-keeping.html ↩
