Affiliate Click → Booking Reconciliation Playbook

Affiliate reconciliation links click events with provider booking/report records inside one commercial journey. It becomes operationally important when finance, analytics and partner dashboards all report different conversion totals for the same period.

Trigger and evidence

Investigate clicks without bookings, bookings without clicks, multi-click conflicts or disagreement with provider reports. Use click ID, partner/sub-ID, deep link, booking reference, timestamps, attribution window, value/currency, cancellation state and settlement period.

Matching order

Prefer exact click ID, then stable provider/sub-ID evidence, and only then constrained fuzzy matching. Keep fuzzy matches explicitly lower-confidence.

Reconciliation

Separate gross, cancelled and matured bookings. Click analytics and provider settlement reports may use different horizons. Keep exact and fuzzy matches in separate fields so later finance reconciliation can distinguish deterministic attribution from inferred attribution.

Failure modes

Common failures include stripped sub-IDs during redirects, delayed partner reports, duplicate booking rows, rebooked reservations and attribution windows that differ between internal analytics and partner settlement.

Metrics and prevention

Track exact-match rate, unmatched bookings/clicks, conflicts, fuzzy-match share and lag. Preserve stable click/sub-ID in partner handoff contracts.