SUMS STUDIOHospitality Intelligence

HOTEL FINANCE · REPORTING INTELLIGENCE

Hotel Revenue Reconciliation: Why PMS, Excel & Finance Reports Don't Match

Your PMS shows one room-revenue number. Finance has another. The bank settlement is different again. Here's how to determine whether the discrepancy is a timing difference, a classification problem, or something that needs investigation.

SUMS Studio Editorial · October 16, 2026

Why hotel revenue reports don't match

Revenue earned, invoices posted, and cash collected are not interchangeable. A property management system (PMS), spreadsheet, OTA statement, and accounting ledger may measure different events, periods, or transaction categories. Before comparing totals, agree on the reporting period, revenue definition, and source of truth for each metric.

Seven common causes of hotel revenue discrepancies

1. Booking date versus stay date

A September booking for an October stay does not automatically create September room revenue. Compare revenue for the applicable stay nights according to your accounting policy.

2. Business date versus accounting posting date

Night audit, late entries, and backdated corrections can place operational and ledger entries in different periods.

3. OTA commissions and payout models

Gross booking value, PMS room revenue, and the net OTA payout are different figures. Separate commissions, processing fees, taxes, and merchant-versus-agency settlement models.

4. Taxes and service fees

Confirm whether source amounts include taxes and service charges and whether they belong in the room-revenue category. Follow applicable rules and the property's accounting policy.

5. Refunds, cancellations, and no-shows

Late reversals and adjustments may affect a different reporting period than the original booking.

6. Deposits and payment timing

Cash received before a future stay is not necessarily earned room revenue. Reconcile deposits, receivables, settlements, and recognized revenue separately.

7. Spreadsheet mapping and duplicate records

Summary rows, repeated reservation IDs, inconsistent date formats, or a column labeled Total Amount mistakenly mapped as Room Revenue can distort a dashboard.

Worked example: OTA booking versus cash settlement

ItemAmount
Guest booking totalRp 2,000,000
Illustrative taxes/fees excluded from room revenueRp 200,000
Room revenue under example policyRp 1,800,000
Illustrative OTA commissionRp 270,000
Illustrative net settlement (before other adjustments)Rp 1,530,000

The Rp 1,530,000 settlement should not be treated as equivalent to Rp 1,800,000 room revenue. A reconciliation bridge explains the difference. The commission and tax treatment in this example are assumptions, not universal rules.

How to reconcile hotel revenue step by step

  1. Set the period and cutoff: specify stay dates, business date, timezone, and accounting close.
  2. Define metrics: distinguish gross charges, net room revenue, taxes, commissions, deposits, and cash.
  3. Export source records: obtain transaction-level PMS, OTA, ledger, and settlement data when available.
  4. Normalize fields: align reservation IDs, currency, date formats, booking status, and tax treatment.
  5. Build a reconciliation bridge: document each adjustment between starting and ending totals.
  6. Investigate exceptions: review duplicates, missing entries, refunds, corrections, and timing differences.
  7. Approve and retain evidence: record reviewer, cutoff, source version, and unresolved differences.

Hotel revenue reconciliation checklist

Where business intelligence helps

SUMS Studio supports hospitality reporting analysis using supported Excel/CSV imports and selected Google Sheets reporting data, with field mapping and validation before approval. Available dashboards can show occupancy, ADR, RevPAR, revenue comparisons, and property views when source data supports those metrics. Ask SUMS can assist with analysis of accessible workspace reporting data. These capabilities do not replace accounting controls or imply automatic transaction-level reconciliation.

For the wider reporting workflow, see hotel reporting automation, explore hotel solutions, or request a hospitality demo.

Frequently asked questions

Why does PMS revenue differ from accounting revenue?

Typical reasons include business-date cutoffs, recognition policy, tax classification, refunds, and later corrections. Investigate at transaction level before assuming either total is wrong.

Is an OTA payout the same as room revenue?

No. Payouts may be net of commissions, fees, and adjustments, and may arrive in a different period.

Can Excel be used for hotel revenue reconciliation?

Yes, provided the process uses consistent definitions, traceable source records, documented adjustments, and review controls.

Does SUMS Studio automatically reconcile the hotel general ledger?

No such capability is claimed here. SUMS Studio supports reporting-data preparation and business analysis; accounting reconciliation remains subject to the hotel's processes and controls.

Further reading

See Cloudbeds hospitality resources and Mews hospitality resources for additional PMS and financial reporting context. Always verify treatment against your property's accounting standards and local regulations.