Provider Commercial Report Variance Investigation

When provider reports and internal analytics disagree, align scope definitions before comparing totals. A small reporting-definition mismatch can create a large apparent revenue variance even when every underlying booking record is technically correct.

Trigger

Open an investigation when report variance exceeds the agreed tolerance, when invoice totals cannot be reproduced from booking-level data, or when a previously stable provider develops a sudden period-over-period difference.

Triage

Compare booking versus stay date, timezone/cutoff, gross versus matured state, FX timing, attribution windows, commission/tax inclusion and treatment of late modifications or cancellations.

Evidence

Use reporting period, booking/provider IDs, booking state, value/currency, FX rule, commission, cancellation/refund history and attribution source.

Variance classification

Classify scope, timing, state, FX, attribution and genuine missing/duplicate-record differences. Keep an explicit unexplained bucket until evidence is found instead of forcing every variance into a known category.

Stop condition and metrics

Explain variance into known buckets until residual falls below agreed tolerance. Track unexplained variance, late adjustments, missing bookings, duplicate settlement and period shifts.

Prevention

Make metric definitions and cutoff rules visible on commercial dashboards.