Reading the OTA Reconciliation report
The OTA Reconciliation module produces one report per OTA per month. The report is dense but not complicated. This guide walks each column and shows how to turn a flagged line into an actual commission dispute the OTA will pay.
Where the report lives. Open the Weareplonet dashboard, go to OTA Reconciliation → Reports, and pick the month and the OTA channel. The report opens inline; you can also download it as PDF or CSV.
Column 1 — OTA reference. The reservation ID exactly as it appears on the OTA commission statement. This is the anchor for any dispute — the OTA finance team keys off this number, not your Protel confirmation number.
Column 2 — Protel confirmation. The matched Protel reservation. If this cell is empty, the module could not find a Protel reservation that matches the OTA line — that is a strong signal for a phantom commission and worth investigating first.
Column 3 — Stay dates and status. Arrival and departure in Protel, followed by the Protel reservation status: Checked-in, Departed, Cancelled, No-show. Any commission billed on a Cancelled or No-show reservation should not have been billed unless your OTA contract includes a cancellation penalty — check clause by clause.
Column 4 — Nights billed vs stayed. The OTA statement's night count against the actual Protel night count. A mismatch is usually the result of an early departure — some OTAs still bill the original length of stay. This is disputable in most contracts.
Column 5 — Net rate billed vs booked. The rate the OTA billed commission on against the rate visible on the Protel reservation. Mismatches here are the most common finding — rate overrides at check-in that the OTA never learned about, or vice versa.
Column 6 — Commission delta. The number that matters. If positive, the OTA over-invoiced by this amount; if negative, they under-invoiced (rare but does happen). Sum the positive column for a "recoverable" figure at the report footer.
Column 7 — Suggested action. One of: Accept, Dispute, Investigate. Accept means the line reconciles cleanly; Dispute means there is a clear-cut discrepancy with a suggested dispute letter; Investigate means the module found a mismatch it cannot resolve algorithmically.
Sending the dispute. Click on any Dispute line and the module shows a pre-populated dispute letter — headers, references, calculation, and the polite ask. Copy it into your OTA finance mailbox, or route it directly from the dashboard if you have configured OTA finance addresses under Settings → OTA channels. Most disputes are resolved within two to four weeks; particularly stubborn ones we handle jointly with the customer.