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
| Item | Amount |
|---|---|
| Guest booking total | Rp 2,000,000 |
| Illustrative taxes/fees excluded from room revenue | Rp 200,000 |
| Room revenue under example policy | Rp 1,800,000 |
| Illustrative OTA commission | Rp 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
- Set the period and cutoff: specify stay dates, business date, timezone, and accounting close.
- Define metrics: distinguish gross charges, net room revenue, taxes, commissions, deposits, and cash.
- Export source records: obtain transaction-level PMS, OTA, ledger, and settlement data when available.
- Normalize fields: align reservation IDs, currency, date formats, booking status, and tax treatment.
- Build a reconciliation bridge: document each adjustment between starting and ending totals.
- Investigate exceptions: review duplicates, missing entries, refunds, corrections, and timing differences.
- Approve and retain evidence: record reviewer, cutoff, source version, and unresolved differences.
Hotel revenue reconciliation checklist
- Same property, currency, reporting period, and timezone?
- Room revenue separated from taxes, service charges, and other revenue?
- Cancelled and amended bookings handled consistently?
- OTA commissions and settlements reconciled separately?
- Advance deposits distinguished from earned revenue?
- Duplicate records and summary rows removed?
- All adjustments documented and reviewed?
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.