Here is how one of the companies we talked to runs a job.
The dispatcher takes the call and writes the job on a paper ticket. At the end of the day, someone types those tickets into an Excel sheet. At the end of the week or the month, someone types the Excel rows into QuickBooks so the invoices can go out.
That is the same job written three times, by hand, by different people, days apart. A lot of service companies run exactly this way, because each tool was added when it was needed and nobody had time to connect them.
Every copy is a chance to lose something
When a job lives in three places, it has to make it across two gaps. Most of the time it does. Sometimes it doesn’t:
- The ticket never makes it to Excel because it stayed in a truck, got stuck to another sheet, or sat under a coffee cup on the dispatch desk.
- The row never makes it to QuickBooks because it was typed on a tab nobody checked, or below the range someone copied.
- The job makes it across with a mistake, like a rate from last year, 4 hours typed instead of 6, or a customer name close enough that someone picks the wrong account.
The company we talked to found jobs that were done but never billed. Nobody had been careless. A ticket had fallen through one of those gaps, and nothing in the process would ever notice it was missing.
Busy season is when it breaks
Double entry holds up fine when things are slow. The office has time to catch up, cross-check and chase a missing ticket.
Busy season takes that time away. More jobs come in, crews work longer, and the person doing the typing is also answering the phone. The pile of tickets waiting to be entered grows, and the longer a ticket waits, the more likely it goes missing or gets typed from memory.
So the months when you do the most work are the months you are most likely to miss billing some of it.
The small tickets are the first to go
The big jobs rarely get lost, because everyone remembers the three-day job for your best customer.
It is the small ones that slip: a one-hour call-out, a quick delivery, a short extra on a job that was already invoiced. They are easy to forget or to assume someone else entered, and small enough that nobody misses them at month end. They still add up, and they are often the ones with the best margin.
What it actually costs
The first cost is the typing itself. Every job typed three times is office time spent copying instead of quoting, scheduling or collecting. Data quality consultant Thomas Redman calls this the “hidden data factory”: the extra work people do to find, check and fix information before they can use it. He estimates it eats up to half of knowledge workers’ time.1
The second is mistakes. People make typing errors, and checking by eye doesn’t catch as many as you would think. In a controlled study by Kimberly Barchard and Larry Pace, visually checking typed data was not significantly better than not checking at all.2 Careful audits of real spreadsheets find errors in roughly 1% to 2.5% of cells.3 Each copy step is another round of those odds.
The third cost, and the most expensive, is work you never bill. You can fix a typo later, but nobody goes looking for a ticket they don’t know is lost, so that revenue is simply gone.
To put rough numbers on it, take an example company. It runs 40 tickets a week, and each one takes about 3 minutes to copy at each step after the paper: once into Excel, once into QuickBooks. That is about 4 hours a week of copying, or more than 200 hours a year. If 1 small ticket in 100 slips through, at $250 each, that is about $5,000 a year in work done and never billed. Your numbers will be different. Both costs are real, but you only see the lost billing if you go looking for it.
Signs this is happening to you
- Tickets sit in a pile or a tray waiting to be “entered.”
- Month end means a day or more of catching up the books.
- You have found a job that was done but never invoiced, more than once.
- Customers sometimes call about a charge that doesn’t match what the crew did.
- Only one person really knows how the paper, the spreadsheet and the accounting fit together.
If two or more of these sound familiar, double entry is costing you money.
Enter each job once
Typing faster or checking harder won’t close the gaps. You close them by entering the job once.
When the job is created once and every later step builds on that same record, there is nothing to retype and no gap for a ticket to fall through. The crew updates the job from their phone, the office reviews it, and the invoice is built from the finished job. Your bookkeeping still happens in your accounting software, but it gets the invoice from the job instead of from someone’s typing.
That is how Dispatch works. A job is entered once, crews close it out from a link on their phone, and the invoice is built from the completed tickets with each client’s rates already applied. Unbilled work stays visible until it is invoiced, so a small ticket can’t quietly disappear. Invoices and payments then go to your books: Dispatch sends them to QuickBooks Online, QuickBooks Desktop, Xero, Sage, FreshBooks, Wave or Zoho Books. You keep your accountant and your accounting software, and nobody has to type every job twice.
If you are running on paper, spreadsheets and accounting software today, you don’t have to change it all at once. We can move your data over for you and set it up with you before your next busy season.
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 ↩
-
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 ↩
-
Raymond R. Panko, “Spreadsheet Errors: What We Know. What We Think We Can Do,” Proceedings of the EuSpRIG 2000 Symposium, 2000. https://arxiv.org/abs/0802.3457 ↩