Exception register

Every disagreement the reconciliation found, in one of three states. Nothing is averaged, and nothing is silently dropped.

Reconciledagreed
2,607
$802,965 settled without a human
Contestedboth values kept
4,376
$4,191,370 gross across every contested record
Quarantinedexcluded
7
$700 held out of the marts
Contested share of revenue
12.22%
watched by the recon.contested_share control

contested — 8 kinds

Two sources disagree and both values are retained. These flow into the executive totals flagged, never netted off. One kind — an unresolved supplier name — identifies a party rather than a transaction and carries no accounting period, so it is counted here but cannot appear in the per-clinic-month contested figures shown on the overview and revenue pages. That is the whole of the difference between the two totals.

KindStateExceptionsAmount
visit_unexplainedcontested3,503$1,972,715
package_allocation_contestedcontested318$840,025
package_unidentified_buyercontested231$680,705
vendor_unresolvedcontested1$443,572
package_awaiting_redemptioncontested55$160,780
cancellation_log_vs_processorcontested139$49,260
reversal_parent_unknowncontested101$42,188
cancellation_total_mismatchcontested28$2,125
Total4,376$4,191,370

quarantined — 1 kind

Held out of the marts because the record could not be trusted. Excluded from revenue, visible here.

KindStateExceptionsAmount
payment_unexplainedquarantined7$700
Total7$700

reconciled — 2 kinds

Two sources agreed, or one explained the other. No human needed.

KindStateExceptionsAmount
service_attribution_ambiguousreconciled1,350$662,235
cancellation_status_recoveredreconciled1,257$140,730
Total2,607$802,965

How package sales were identified

a payment rarely says it is a package; the evidence for each conclusion is recorded
BasisPackagesValue
inferred_corroborated1,444$4,126,415
declared1,369$3,819,990
contested318$840,025
unidentified_buyer231$680,705
inferred_unique129$240,845
awaiting_redemption55$160,780