TL;DR: A Phoenix staffing firm was losing $34,000 monthly to revenue leakage. The culprit? Three systems (HubSpot, timesheets, QuickBooks) that should have agreed but didn't. Rate discrepancies, missing hours, and contract changes fell through the gaps. A five-stage reconciliation agent caught 94% of errors within 24 hours, recovering $408K annually. Same clients, same work, same team. Just accurate billing.
The quarterly review started the way it always did. Projected revenue on one screen. Actual revenue on the other. The gap between them staring everyone in the face.
Sarah, the CFO, had seen this movie before. Every quarter, the numbers didn't match. Sales would project based on active contracts and quoted rates. Finance would report based on what actually got invoiced and paid. And every quarter, actual came in 6-8% lower than projected.
"Market conditions," someone would say. "Client churn," another would offer. "Seasonal variation."
But Sarah knew better. The company's client retention was strong. The market was stable. Something else was happening.
Her finance manager, Jennifer, had a theory. Every Friday afternoon, she'd spend three hours cross-referencing systems. HubSpot against timesheets. Timesheets against QuickBooks. She'd find things. A client quoted at $47 per hour but billed at $42. Overtime hours approved but never invoiced. A rate increase agreed to in January still not reflected in March invoices.
Small things. Individually, they barely registered. But Jennifer couldn't check everything. With 1,200 placements per quarter and 340 active client accounts, she could only spot-check maybe 10% of the transactions.
The rest? They just slipped through.
Revenue doesn't disappear in dramatic failures. It leaks. Slowly. Quietly. In the gap between "we did the work" and "we got paid for it."
The Company Behind the Numbers
Horizon Staffing Solutions isn't a startup figuring things out. They're a mid-size staffing and recruitment firm in Phoenix, Arizona. Ninety employees. Twenty-eight years in business. They place temporary and contract workers across manufacturing and logistics throughout the Southwest.
They're good at what they do. Strong client relationships. Low placement failure rates. Contracts with major manufacturers who've been with them for a decade or more.
Three hundred forty active client accounts. Twelve hundred placements per quarter. Revenue based on hourly rates that vary by role, shift differential, contract terms, and client-specific agreements.
The operations were solid. The client work was solid. The revenue collection? That's where things got messy.
Like most companies their size, they'd grown into a patchwork of systems. HubSpot managed the sales pipeline and client relationships. A workforce management platform tracked timesheets and approvals. QuickBooks handled invoicing and accounting.
Each system did its job well. But they didn't talk to each other.
Sales would quote a rate in HubSpot. Operations would approve hours in the timesheet system. Finance would create invoices in QuickBooks based on... well, based on whatever information they had, which wasn't always complete.
Three systems. Three versions of the truth. And in the gaps between them, revenue was quietly walking out the door.
Where the Money Actually Went
Jennifer knew they were leaking revenue. She just couldn't quantify it. Every time she dug into the data, she'd find problems.
Rate discrepancies were the most common. A client relationship manager would negotiate a rate increase. They'd update HubSpot. They'd even send a confirmation email. But somehow, QuickBooks would still have the old rate. So invoices would go out at $42 per hour when the contract clearly stated $47.
The client wouldn't complain. Why would they? They were getting a discount they didn't ask for.
Missing hours were the silent killer. Timesheets would get approved in the workforce management system. The hours were legitimate. The work was done. But somewhere in the handoff to invoicing, they'd just... not make it. Especially overtime hours. Especially holiday and weekend shifts.
Those hours had higher rates. Losing them hurt more than losing regular hours.
Contract changes created ongoing bleeding. A client would agree to new terms. The deal would close in HubSpot. Everyone would celebrate. But the actual billing rates in QuickBooks? Those would stay the same for weeks, sometimes months. Every invoice during that period was wrong.
Credit memos compounded the problem. When clients disputed an invoice (which happened because the invoices were frequently wrong), finance would issue a credit. But they rarely tracked back to fix the underlying issue. So the same error would appear on the next invoice. They'd credit it again. The pattern would repeat.
Jennifer showed Sarah a spreadsheet one afternoon. She'd spent two full days doing a deep reconciliation of one month's invoicing.
Her conservative estimate: $28,000 in that month alone. Unbilled hours. Underbilled rates. Duplicate credits that never got corrected.
Multiply that by twelve months? They were losing over $300,000 annually. And that was just what she could find in a two-day manual audit.
"I knew we were leaking," Jennifer told me later. "I just couldn't spend every week hunting for it. I had a job to do that wasn't playing detective with three different systems."
The design is next. The design, the build guide, the running costs and the take-away are free to subscribers. Enter your email below and the rest of this Blueprint opens. New ones arrive every Tuesday and Friday.
