A variance is the difference between two defined amounts. First decide whether you are comparing allowances or payer payments. Then keep the positive and negative results visible, along with the scope and payment date behind each one.
Choose the comparison before the formula
Allowance variance compares expected allowed with reported allowed. Payer-payment variance compares expected payer responsibility with payer payments. Charge-to-payment differences answer yet another question. Label the comparison in the title of the report instead of calling all of them “variance.”
The DueMD tool uses the second comparison. It subtracts expected patient and other-payer shares from the allowance, then subtracts initial and additional payer payments. It cannot verify those allocations.
Do not cancel out unrelated findings
A +$40 difference and a −$40 difference add to zero, but neither has been explained. Show positive and negative groups separately before presenting any net total. Otherwise incorrect scopes or duplicate payments can disappear in an aggregate.
For a dashboard, show the number of comparable records, the number excluded for missing evidence, and the observation date. Unknown cases should not silently improve an apparent match rate.
Timing can change the answer
The same expectation can be compared with different payment snapshots. A supplemental payment reduces a difference only when it is additional and belongs to the same scope. Payment and remittance evidence have different roles; keep that distinction in your review.
To assess the effect of a recovery process, document the connection between the action taken and the later receipt rather than relying on timing alone.
Three possible comparison results
Illustrative example.
| Expected payer share | Payer payments | Signed difference | Next question |
|---|---|---|---|
| $144 | $134 | +$10 | Is something missing or was the expectation wrong? |
| $144 | $144 | $0 | Were the inputs and allocations correct? |
| $144 | $150 | −$6 | Is the scope or payment count wrong? |
Two comparisons at +$10 and −$6 produce a net +$4. Keep both in view; netting does not resolve either. DueMD’s one-cent display tolerance is not an accounting write-off policy.
Where a variance report can mislead
- Using the same reported value on both sides of a supposed independent comparison.
- Netting unrelated positives and negatives before review.
- Leaving missing rates out of the denominator without disclosure.
- Treating a zero difference as proof of correct benefits or coverage.
Before summarizing the differences
- Name the type of comparison.
- Fix the scope and observation date.
- Separate unsupported cases and signed groups.
- Recalculate after verified new payment evidence.
Keep reading
Sources
Apply the agreement and records relevant to your review. Examples explain the method; they do not determine a payment obligation.
- Health Care Payment and Remittance Advice
- Payment, remittance advice and EFT transactions
- Allowed amount
Need a term or calculation explained?
Read an answer or send a general question about the step you are working on.
Calculator values are not attached. Leave out patient and confidential information.