The Hotel Month-End Close: Integrating OTA Reclaim into Your Accounting Workflow

Most hotels treat OTA reclaim as an operational task. The monthly queue lives in a spreadsheet, disputes get filed, refunds show up eventually, and the P&L just reflects the net commission number. That's fine if reclaim is a small part of your economics. It's not fine once it's $5,000–$25,000 a month — at which point it belongs in your accounting workflow with a proper receivable and a proper journal entry, not in a spreadsheet.

Here's how to integrate reclaim into your standard month-end close without adding a fourth weekend to January.

01The standard hotel month-end close (12 tasks)

1. 1Close the PMS (no more back-posting for the closed month)
2. 2Reconcile city-ledger accounts (corporate, group, wholesale)
3. 3Post night-audit adjustments
4. 4Reconcile bank accounts
5. 5Reconcile credit-card merchant deposits vs processor statement
6. 6Record monthly accruals (payroll, utilities, PMS subscription)
7. 7Post depreciation
8. 8Reconcile inter-company (for multi-property groups)
9. 9Close sub-ledgers (AP, AR)
10. 10Run financial statements draft
11. 11Variance analysis vs budget
12. 12Lock the period

02Three new tasks for OTA reclaim

Task 13 — Reconcile OTA invoices against PMS revenue (by the 2nd)

Pull the Expedia Partner Central invoice CSV and Booking.com Extranet statements for the closed month. Join against your PMS revenue report by itinerary ID. Flag any delta above $5 per booking.

Expected deltas come from: rate modifications after booking, waived cancellation fees not yet refunded, virtual-card reconciliation gaps, tax-on-commission jurisdiction errors. Each flagged delta becomes a candidate for phase 14.

Task 14 — File disputes before the 4th

Expedia's Reconcilable Bookings window closes on the 4th. Any no-show, early departure, or waived fee not filed by end-of-day the 3rd is locked-in commission. Booking.com's 48-hour window is rolling, so anything from the closed month is already past — file via Partner Messages for delayed disputes.

Task 15 — Record pending reclaims as receivables

This is the step most hotels miss. Once a dispute is filed (status: DISPUTING), it's a reasonable expectation of future cash. GAAP allows you to book it as a receivable when the likelihood of collection is 'probable' (more-likely-than-not).

03The journal entries

Three status transitions, three journal entries.

Entry 1 — Filing a dispute (OPEN → DISPUTING)

Dr  OTA Reclaim Receivable    $[amount]
  Cr  OTA Commission Expense    $[amount]
  (To record expected recovery of commission on [itinerary ID])

This reduces commission expense on the income statement and creates a receivable on the balance sheet. The commission expense reversal only flows through if the dispute is ultimately approved — we handle denial below.

Entry 2 — Dispute approved (DISPUTING → RECLAIMED)

Dr  Cash [or OTA Payable reduction]    $[amount]
  Cr  OTA Reclaim Receivable              $[amount]
  (To record cash receipt of [itinerary ID] reclaim)

Settle the receivable when the credit appears on the next OTA invoice or lands in your bank account.

Entry 3 — Dispute denied (DISPUTING → DENIED)

Dr  OTA Commission Expense          $[amount]
  Cr  OTA Reclaim Receivable        $[amount]
  (To reverse expected recovery; dispute denied on [itinerary ID])

04Presentation on the financial statements

Most hotel CFOs report OTA commission as a contra-revenue item — 'Room revenue, less OTA commission' — rather than an operating expense. The reclaim receivable line sits under Trade Receivables on the balance sheet, typically with a parenthetical note like '(includes $X,XXX of OTA reclaim receivables)' for transparency.

Your owner reports should show three related numbers: gross OTA revenue, gross commission charged, net reclaim recovered — with a ratio for reclaim recovery rate (dollars recovered ÷ dollars disputed).

05What your auditor will ask

1. 1Supporting documentation for each open reclaim receivable — the dispute message sent, the evidence attached, the Expedia/Booking.com confirmation of the dispute being filed.
2. 2Your historical recovery rate — to assess whether booking 100% of the expected amount is reasonable or whether you should apply a probability-weighted haircut.
3. 3Aging of the reclaim receivables — balances over 90 days old should either be collected or written off.
4. 4Internal controls on the dispute-filing process — who authorises, who files, who reconciles to cash when it lands.

06The simplification: probability-weighted accrual

If your historical recovery rate is 62% (our cohort average), some auditors will ask you to book reclaim receivables at 62% of the gross disputed amount rather than 100%. This is conservative but defensible. The other 38% gets re-classified as contingent assets with a disclosure in the notes.

For growing hotels this matters less — the cash shows up within 2–3 months anyway. For mature properties with a lot of aged reclaims in the pipeline, probability-weighting is the auditor-friendly approach.