To check one payer’s payment, first establish its share of the allowance. Use the confirmed patient and other-payer allocations—not the amounts those parties happened to pay. The example below shows why that distinction matters.
Ask who the number belongs to
Keep four columns distinct: expected allowance, allocated patient share, allocated other-payer share and the remainder for the payer under review. Those allocations need an appropriate source. They should not be inferred simply by subtracting an observed payment from the allowance.
Establish the allocation from the relevant benefit and payment records first. The worksheet does not perform coordination of benefits.
Use only an established allocation
With the allocation supplied and no other modeled adjustment, the arithmetic is:
The formula does not decide which payer is primary, calculate patient benefits, or apply special payment rules. It only makes an already established split visible. A negative remainder is a prompt to review the inputs, not a meaningful negative benefit.
One allowance, three allocated shares
Suppose the reviewed allowance is $300, the established patient share is $40 and the established other-payer allocation is $60. The remaining share is $300 − $40 − $60 = $200. If the payer under review has sent $190, the comparison is $10. These are illustrative allocations for arithmetic, not a benefit-design example.
If the patient has paid only $10 of their $40 share, do not replace the allocated $40 with the collected $10. That would turn the worksheet expectation into $230 and misassign the unpaid $30 to the payer. Responsibility and collection answer different questions.
Keep each payment in its own lane
- Patient receipts belong with patient collection, not payer receipts.
- Another payer’s payment is not this payer’s payment.
- A supplement belongs only once in the comparison.
- A reversal changes the relevant payment history; it is not a new benefit allocation.
Use an observation date so a later payment does not accidentally appear in both the original total and the supplement column.
If the split is still unclear
Record the missing allocation and the source needed to resolve it. Avoid filling the gap with a benchmark or average. You can still review the allowance and service scope while the responsibility check remains open.
Put this check to work
Related reading
Sources
Check the agreement and payment records for the case you are reviewing.
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.