A US-based IT hardware consultant was losing significant revenue every month — not because he wasn't doing the work, but because reconciling his phone bill manually was so painful he often gave up and didn't bill at all.
Client details have been fictionalized to protect confidentiality under NDA. The results and solution are real.
Jason is an independent IT hardware consultant based in the US. His work is specialised — hardware procurement, configuration, and support — and his client relationships involve regular phone contact that is billable and should be recharged monthly.
The problem was his phone bill. Every month it arrived as a long itemised list — date, time, duration, number, direction (incoming or outgoing) — with no indication of who any of those numbers belonged to or whether the call was billable. Client calls, personal calls, supplier calls, spam calls, all mixed together on the same bill, sometimes running to many pages.
To identify and invoice billable calls, Jason had to manually work through the entire bill each month, cross-reference every number against his client list, categorise each call, and then compile a recharge report. Different carriers format their bills differently. Formats change without notice. Numbers change hands. The same number can mean different things in different months.
The result was predictable: most billable calls went uninvoiced. Not because Jason didn't care, but because the manual process was genuinely painful — and when something is that frustrating to do consistently, it either gets done badly or doesn't get done at all. Some months the reconciliation was simply abandoned. The recharges were written off not through oversight but through a rational decision that the effort wasn't worth it.
The revenue loss wasn't just from calls missed during an imperfect manual process. It was also from the months where Jason looked at the volume of calls, the complexity of the bill, and the time required — and decided it wasn't worth it. Those months, the recharges went entirely unbilled.
This is a pattern that shows up repeatedly in small consulting businesses. The work gets done. The calls happen. The value is delivered. But the billing process is broken enough that a meaningful portion of earned revenue never gets invoiced. It's invisible loss — it doesn't appear anywhere as a problem, it just quietly reduces what the business actually collects each month.
The solution was a purpose-built Excel system designed around exactly how Jason's billing actually works — not a generic tool, but something built for the specific problem of mixed phone bills and client recharge reconciliation.
The system has four core components. A live phone number database holds every number Jason regularly deals with — client contacts, personal numbers, suppliers, known spam numbers — each tagged with a name and a relationship category. This database grows and is maintained over time as new numbers are identified.
A master data import sheet accumulates call records month by month, building up a complete historical record. Call data fields — date, time, duration, number, incoming or outgoing — are all captured, giving Jason a fully searchable archive of every call going back to implementation.
A current cycle data sheet pulls in this month's calls and automatically enriches each record with name and category data via lookups from the phone number database. What arrives as a raw list of numbers and durations is transformed into a categorised, named call log without manual effort.
A dashboard brings it together — calls grouped by category and then by individual client, drillable to the underlying data so Jason can handle client queries and pushbacks with actual records. Billable calls are clearly separated and ready to invoice. Unknown numbers are flagged for review so the database stays current.
The Excel system is the mechanism. The real value is that Jason never has to deal with source data pain again.
Phone bill formats change without notice. Carriers restructure their exports. New number formats appear. Data quality varies. In a manual process, every one of those changes creates work and introduces errors. In this arrangement, those problems are handled before the data reaches Jason — the import process absorbs format variations, and any structural changes to source data are dealt with as part of the ongoing service.
The same applies to the monthly update itself. Jason sends the bill. Everything else is handled. He receives a completed recharge report and a list of unknown numbers to review. That accountability — consistent, reliable, every month without fail — is what makes the 400% ROI sustainable rather than a one-off improvement.
Jason pays for a solution that works. Not for hours of someone else's time spent wrestling with data formats.
"The challenge is this is an Excel thing and I hate spreadsheets — I've got better things to do."
— Jason, IT Hardware Consultant, US
Exactly. He doesn't touch it. That's the point.
The 400% ROI figure comes from comparing Jason's rebillable call recovery in the quarters before implementation against the quarters after — same metric, same billing period length, same client base, completely different result.
The improvement came from two sources. Calls previously missed during an imperfect manual process are now captured automatically. More significantly, the months where reconciliation was abandoned entirely no longer exist. Every month gets done. Every billable call gets invoiced. Revenue that was being consistently written off is now consistently collected.
The system delivered a positive return in its first month of operation and has continued to do so every month since.
Manual reconciliation of mixed billing data is a common problem across consulting and service businesses — not just phone recharges. Any situation where billable activity is recorded in a format that mixes billable and non-billable items, requires cross-referencing against client records, and needs to be processed consistently every month is a candidate for this kind of solution.
The symptoms are usually the same: reconciliation takes too long, happens inconsistently, produces incomplete results, or in the worst cases simply doesn't happen because the manual process is too painful. If any of that sounds familiar, the revenue impact is almost certainly larger than it appears.
Consider how many of these scenarios apply to your business. You bill clients for phone time or call costs but rely on a monthly carrier bill that lists every call — personal, client, supplier, spam — with no categorisation. You bill for time spent on client sites or travelling but reconcile from a calendar or notes rather than a structured system, and you know you miss entries. You have expense categories that should be recharged to clients but the effort of splitting and attributing them means some months it doesn't happen. You use subcontractors whose costs should be passed through to clients but the invoices arrive at different times and in different formats, making accurate reconciliation a monthly headache.
In each case the underlying problem is the same: the raw data exists, the billable activity happened, but the process of converting that raw data into accurate client invoices is manual, time-consuming, and inconsistent enough that revenue leaks out every single month.
The other factor worth considering is what changes when the process becomes reliable. Jason's 400% ROI wasn't just from catching more calls — it was from the consistency of doing it every month without fail. Irregular reconciliation that happens when there's time produces irregular results. A process that runs the same way every month, regardless of how busy things get, produces compounding returns because nothing ever falls through the cracks.
If your current reconciliation process depends on you having a quiet month, it isn't really a process — it's a best intention. And best intentions are where billable revenue goes to quietly disappear.
30 minutes to look at how your reconciliation actually works — and what fixing it would be worth.
Book a free 30-minute call →The same problem-first approach applied to different business challenges.
Book a free 30-minute call and we'll look at your specific billing situation.
Book a free call →