Cancellation-Adjusted Revenue Reconciliation
Reconcile gross booking value into net commercial revenue across cancellations, refunds, modifications and matured booking states.
Gross booking value is not final commercial contribution. Revenue reconciliation should recalculate economic state as the booking lifecycle matures. The same booking can move through several economically different states before it is safe to recognize as final revenue.
Trigger
Start reconciliation when provider settlement, cancellation callbacks or finance totals differ from the gross booking ledger, or when a booking crosses its configured maturity window without a final commercial state.
State model and evidence
Distinguish gross, modified, cancelled, refunded and matured/settled bookings. Use booking references, value history, cancellation/refund data, commission rules, maturity dates and provider settlement records.
Calculation
Net revenue depends on contract semantics: whether commission survives cancellation, how partial refunds work and whether no-shows remain billable.
Failure modes
Avoid treating gross bookings as revenue, missing cancellation events, currency mismatches, duplicate refunds and settlement-period shifts.
Metrics and prevention
Track gross-to-net delta, cancellation-adjusted revenue, matured-booking ratio, unreconciled settlement and retroactive adjustments. Also monitor aged bookings that remain neither cancelled nor matured. Derive revenue from booking lifecycle rather than one mutable field.
Planning a similar integration?
We can review requirements, feed/API design and the production approach with you.