The merge. Three source reports share no common key: patient counts exist only by insurance company, while dollars exist only by case type. No field links an individual insurer to its dollars, so insurers and case types are rolled into aligned payer groups — the finest level at which volume and dollars both aggregate truthfully.
Reading it. Self-Pay / Wellness drives collections (highest collection rate — cash pay collects most of what's billed). Commercial insurers show low rates on gross charges because of large contractual write-offs. One provider accounts for the large majority of collections.
Note: "Policies enrolled" exceeds unique patients seen because some patients carry more than one active policy, so Mix % sums slightly above 100%.
Medicare Part B, Allstate (Claims Division) and State Farm together account for more than half of everything collected this period.
Gross vs. net. Collection rate against gross charges understates performance, because contractual write-offs are deducted before a payer ever pays. Net collection rate — collected ÷ charges less write-offs — is the truer measure.
Maturity. Claims keep paying for months after the date of service, so the most recent period is always understated. Treat the newer period as directional until it settles.