Payer Underpayment Recovery Process Template
Four documents and three sheets, where a variance with no contract clause behind it never leaves the building.
Free download · No account needed
Underpayment Register
One row per paid line, with the reason it closed at the wrong number
The register is per line rather than per claim, because a payer underpays a line and pays the rest of the claim correctly. The two right-hand columns are what a payer can act on.
| Claim | Line | Code | Units | Place of service | Schedule version | Schedule amount | Contract % | Expected allowable | Paid | Variance | Basis | Clause |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
How the two derived columns work
Expected allowable is the contracted percentage times the schedule amount the contract names, times units. Variance is expected allowable minus what the payer actually allowed. Both are arithmetic. Neither is a claim yet.
Basis, and why the cell cannot be empty
Basis takes one of five values, each tied to a clause in the contract: contracted multiple never applied, priced off the prior year schedule, facility differential on an office service, unit or bilateral denied as duplicate, separate service bundled. A row with a variance and no basis is not sendable. It is a number nobody at the payer can do anything with.
Two columns that catch the practice's own errors first
Schedule version and place of service. Reading last year's schedule, or reading the facility amount for a service performed in the office, produces a variance that is entirely yours. Recording both on the row is what stops a recovery letter from being wrong.
A denied claim announces itself. An underpaid claim does not: it adjudicates, it pays, the remittance looks ordinary, and no appeal window ever opens. The only way to see it is to compute what the contract said the line was worth and compare. For a contract written as a percentage of a published schedule that number is derived rather than guessed, because the schedule amount is the product of the relative value units, the geographic adjustment factor and the conversion factor by regulation.
Deriving the variance is the easy half. The half practices skip is the next column: basis. A variance is a number, and a payer receiving a spreadsheet of numbers closes the enquiry. A basis is a reason with a clause behind it, and the register in this pack will not accept a row without one. Five values are permitted, each mapped to a contract provision, so every claimed dollar arrives attached to the specific thing the payer did and the specific term it contradicts.
Then the basis column does a second job nobody expects. Group a quarter by basis instead of by claim and 1,262 underpaid Ridgeline Health lines at Halstead Orthopaedic Associates collapse into five letters worth 39,852.40. Two of those bases are invisible per claim: 903 lines short by 11.20 each look paid. That is also why a stale schedule version on your own side has to be ruled out first, which is what payer contract and fee schedule review is for.
What's in the pack
How the Basis Column Works
The method before the sheets: the expected-allowable formula, the five permitted basis values with the clause each one cites, and the non-nullable rule that stops a spreadsheet of numbers going out as a claim.
Contract Reading Note
What to establish before computing anything: which schedule the contract incorporates, which year of it, whether facility and office amounts are distinguished, and which external edit policies the contract does and does not adopt.
Underpayment Register
One row per paid line carrying schedule version, place of service, expected allowable, variance, basis and clause, plus a sendable flag that is No until the basis cell is filled.
Payer Pattern Analysis
The quarter collapsed by basis, with rank by average variance and rank by total in adjacent columns because they disagree, and the payer-side fix named for each row.
Recovery Letter by Payer
One letter per basis rather than per claim, quoting the clause, stating the derivation, and attaching the line schedule. The letter asks for a reprocessing run, not a review.
Recovery Tracking
Lines claimed against lines accepted, with the refusal recorded in the payer's own words, which is what separates a coding error on your side from a contract dispute on theirs.
Escalation Procedure
What to do with a refusal or a silence, in order, ending at the contract's own dispute clause and the regulator that actually has jurisdiction over that plan type.
Handoffs that keep this register honest
A claim the payer never paid at all is a receivable with a clock on it, so it belongs in the AR and collections pack. A denied line needs an argument, which is the denial appeal pack.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent derive expected allowable across your remittance file, or download the blank Word and CSV files instantly and work one payer by hand.
- 2
Read the contract before the remittance
Which schedule, which year, which percentage, and whether facility and office amounts are separated. Get this wrong and every variance you compute is your own arithmetic error.
- 3
Derive, then assign a basis to every variance
Expected allowable minus allowed, per line. Then the basis, or the row stays unsendable. Rows whose basis is your own stale schedule get fixed rather than claimed.
- 4
Group by basis and send one letter each
Five letters beat 1,262 line items. Log what came back verbatim, because the refusal wording is what tells you whether to escalate or to fix something on your side.
Frequently asked questions
Is this template free?
Yes. The four documents and three sheets download as Word and CSV files with no signup and no card. "Edit with AI" is the optional path for practices that want expected allowable derived across a whole remittance file. The rest of the library is at the template library.
What format are the downloaded files?
Word documents for the method note, the contract reading note, the recovery letter and the escalation procedure, plus CSV for the three registers, zipped into one file. They open in Word, Pages, Google Docs, Excel, Numbers and Sheets with nothing to convert first.
How is expected allowable derived rather than assumed?
The contracted percentage times the schedule amount the contract names, times units. Where that schedule is the physician fee schedule, its components are set in regulation rather than by the payer. CMS establishes relative value units for work, practice expense and malpractice insurance. The fee schedule amount is those units times the geographic adjustment factor times the conversion factor, so the expected number is reproducible.
Why can the basis cell not be left empty?
Because a variance with no reason is unactionable at the other end. The register marks such a row unsendable, which sounds bureaucratic until you watch the alternative: a list of numbers goes out, the payer closes it as an enquiry, and the practice records that the payer refused. The payer was never told what to fix.
Why group by basis rather than working claim by claim?
Because the arithmetic favours it heavily and the small variances are the ones claim review cannot see. In the worked quarter, 903 lines were each short by 11.20, which looks like a paid claim every single time and adds up to 10,113.60. Five letters replaced 1,262 line items.
Does this decide whether the payer owes the money?
No. It states what the contract says, what was paid, the difference, and the clause the two disagree on, so a practice manager or a healthcare attorney can decide what to pursue. The register's own refusal column exists precisely because some variances turn out to be the practice's coding rather than the payer's pricing.
Does this handle denials or unpaid claims?
Neither. An underpayment adjudicated and paid, which is why nobody catches it. A whole remittance gets sorted first by remittance and denial triage, and a line denied outright needs an argument written against its reason code rather than a rate comparison.
Find out what your paid claims were actually worth
Send a remittance file and the contracted percentage and schedule your contract names. The first thing back is the quarter grouped by basis, with the practice's own errors separated out.
Edit with AI