From a week of spreadsheets to two days: how one TPA rebuilt its medical premium billing

The challenge

Medical premium billing is not one number per group. A single employer invoice can carry dozens of distinct lines: administrative fees, reinsurance, network access, broker commissions, care management, utilization review, pharmacy, and level-funding settlements, each with its own rate and its own effective date.

All of it was assembled by hand. The TPA generated billing data in its core claims system, rebuilt the reconciliation in Excel, then keyed the results into its general ledger. Every cycle meant re-checking formulas, chasing rate changes, and moving the same numbers between systems that were never designed to talk to each other.

The result was a billing close that took more than a week and pulled in six or more people every cycle. The team named three problems with the old approach:

• Manual reconciliation and data gathering. Pulling billing data together was its own project before an invoice could go out.
• Spreadsheet and formula risk. The recon workbooks were load-bearing, and rate changes were the single most common source of billing errors. On medical plans, one missed renewal rate can flow into every line on the invoice.
• It did not scale with growth. Adding employer groups meant adding hours and adding people, not adding efficiency.

At more than a thousand invoices per cycle across 500 to 1,500 employer groups, the math stopped working. The only way to bill more groups was to hire.

Why they made the change

Growth forced the issue. Volume was climbing, and leadership could see that a spreadsheet-driven close would either cap how fast the organization could take on new groups or quietly grow the finance headcount to match. They went looking for a billing platform built specifically for how TPAs actually bill.

The implementation

Because the scope covered their full medical book across multiple core claims platforms, plus a full integration into the accounting stack, implementation ran across several months rather than several weeks.

The single biggest factor in getting it done, in their words, was a dedicated internal owner: one person accountable for decisions, data, and timeline on the customer side, working alongside the TPA Stream implementation team. Rate logic, invoice templates, and downstream exports all got configured once, correctly, instead of being rebuilt every month.

The results

• Invoicing dropped from over a week to one or two days, a 51 to 75% reduction in time per cycle.
• The cycle no longer takes six or more people. Staff who used to be pulled into reconciliation every month are back on higher-value work.
• Fewer errors and less rework. Automated rate logic meaningfully reduced the credits, rebills, and disputes that used to follow a bad formula.
• Invoices go out earlier and more consistently, which improves cash timing and cuts down on inbound questions from employer groups.
• Scale without hiring. The team can take on more employer groups without expanding the billing staff to match.

“Implementing TPA Stream has been a journey, but the collaboration between our teams has been exceptional. The continued investment in the platform gives us confidence that it will play a key role in supporting our future growth.”

Finance leader at a national TPA