---
title: "Provider Commercial Report Variance Investigation"
description: "Diagnose differences between provider commercial reports, invoices and internal analytics across scope, timing, currency and maturity."
slug: "provider-commercial-report-variance-investigation"
translationKey: "playbook-provider-commercial-report-variance"
locale: "en"
type: "playbook"
category: "operations"
tags: ["provider","report","variance","reconciliation","commercial"]
publishedAt: "2026-09-26"
updatedAt: "2026-09-26"
reviewedAt: "2026-09-26"
---

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.