What you get
One number per insurance company: what it costs you for every $100 it pays
Here's what the check shows for a made-up practice, so you know what to expect before you gather anything.
| Insurance company | Paid in 90 days | Cost per $100 paid | Compared |
|---|---|---|---|
| Sample Plan A | $935,709 | $0.69 | |
| Sample Plan B | $703,261 | $2.91 | |
| Sample Plan C | $675,079 | $7.15 | |
| Sample Plan D | $686,025 | $5.60 |
In this example, Plan C costs the practice about ten times what Plan A does for every dollar it pays, mostly from payments short of contract and slow payment. The full results break each payer down by denials, lower-level payments, short payments, reversals and days to pay, and name the claims worth pulling.
What you'll need
Two files your billing team already has
On a phone? Everything here is readable, but the check itself works best on the computer where your billing files are saved. Open this same link there.
Insurance payment files, ideally the last 90 days
Your clearinghouse or billing system can export these. They often go by ERA, 835 or electronic remittance. If someone else handles your billing, ask them for "the 835 files for the last 90 days" and they'll know what you mean.
Nothing chosen yet
Your contracted rates
A spreadsheet with one row for each insurance company and billing code: the insurance company's name (as it appears on its payments), the code and your contracted rate. Download the template, fill it in, and save it as a CSV file. Leave the "effective" column blank unless a rate changed partway through, and then type the date as 2026-01-01.
Nothing chosen yet
Adjust the assumptions (optional)
Staff minutes each time a claim needs handling again: 20 to work a denial, 15 to review a visit paid at a lower code, 5 for a short pay, 10 to re-post a reversal, 6 for a status check on a slow claim. These and the hourly cost are illustrative. The 46% is the rest of Premier's figure from hospitals and health systems on 2022 claims (March 21, 2024: 54.3% of claims private payers first denied were eventually paid), so put in your own rate if you track it.
Run it
It reads everything on this computer and shows the results below. Larger practices may take a minute.
The easiest path is often to forward this page to whoever handles your billing. They'll have both files.
What each payer costs
| Payer | Cost per $100 paid | Claims | Paid | Denied claims | Paid at a lower code | Paid short of contract | Reversed claims | Median days to pay |
|---|
Wide table: scroll sideways to see every column.
Cost per $100 paid adds the dollars paid short (lower codes and short pays, priced at your contract), denied dollars never recovered, and staff time, then sets it against what the payer paid.
Save the results to this computer
The two summaries hold totals only, with no patient-level fields. The chart-pull list has a row for every flagged line with its patient account number, so keep it on this computer.
What it looks at
Only what's on the payment files
From each payment file: the insurance company, each claim's account number, status and date received, the treating provider, and each line's codes, dates, amounts and adjustment codes. It skips the patient's name. No AI runs here, only plain calculations anyone can read in this page's code.