A hotel can report a strong occupancy night and still have inaccurate revenue records by the next morning. A missed POS batch, an unposted resort fee, a duplicate OTA settlement, or an unresolved guest folio can quickly distort daily results. Knowing how to reconcile hotel revenues gives owners and finance leaders a dependable way to confirm what was earned, what was collected, and what still requires follow-up.
Revenue reconciliation is not simply matching a bank deposit to a sales number. Hotels process revenue through multiple systems, payment types, departments, and timing rules. A disciplined process connects those records, identifies exceptions early, and creates financial reporting management can rely on.
The first requirement is a defined source-of-truth structure. Most hotels use a property management system (PMS) for room charges and guest folios, a point-of-sale (POS) system for food, beverage, spa, parking, and other outlets, and payment processors for card transactions. Online travel agencies, group sales records, and accounting software may add more data to the process.
Reconciliation works best when the finance team knows which report is responsible for each part of the transaction. The PMS daily revenue report may establish room revenue and guest ledger balances. POS closeout reports support outlet revenue. Merchant processor reports support card collections. Bank activity confirms funds received. The general ledger records the final accounting position.
Before beginning the daily process, establish consistent cutoff times and a formal business date. A hotel operating past midnight may have activity that belongs to the prior business day under its night audit policy. If one system closes on calendar time while another uses a hotel business date, apparent variances may be timing differences rather than errors. Those differences still need documentation and resolution.
The revenue records generally need to cover at least these categories:
A chart of accounts that separates these categories is essential. Combining all receipts into a single revenue account may seem efficient, but it prevents management from seeing whether room revenue, outlet performance, taxes, or payment settlement activity is causing a variance.
One common reconciliation error is treating revenue and cash as the same figure. They are related, but they do not always occur on the same day.
A guest may check out and create room revenue today, while the credit card settlement reaches the bank two days later. An OTA may collect funds from the guest, subtract its commission, and remit a net amount weeks after the stay. A corporate account may be billed after checkout and paid on thirty-day terms. A group may pay a deposit before its event occurs, which should generally remain a liability until the related services are delivered.
For this reason, the reconciliation should follow the transaction from revenue creation through settlement. The accounting team should be able to explain the difference between gross revenue, net cash received, payment processor fees, OTA commissions, accounts receivable, and deferred revenue. This provides a more accurate picture of operating performance and liquidity.
For example, if the PMS shows $50,000 in room revenue but the bank reflects only $41,000 in deposits, the variance is not automatically a problem. It may include unsettled card batches, OTA receivables, city ledger charges, and deposits applied to guest folios. The issue becomes a concern when those items cannot be supported by a report, an aging schedule, or a documented timing explanation.
Daily reconciliation should begin after night audit close. The objective is to validate the prior business day while details are still available and staff can explain unusual activity.
First, reconcile the PMS daily revenue report to the guest ledger. Confirm that room revenue, fees, taxes, and payments posted to guest folios agree with the daily audit totals. Review occupied rooms, departures, no-shows, complimentary rooms, out-of-order rooms, rate overrides, and manual postings. These operational details often explain the first signs of a revenue issue.
Next, reconcile POS activity to PMS postings and outlet closeout reports. If restaurant, bar, spa, or parking charges can be posted to room folios, the POS total must agree with both the outlet report and the PMS posting report. Cash sales, card sales, voids, discounts, and tips should be separately visible. A variance may arise when an outlet closes late, a charge is posted to the wrong room, or a card batch is not transmitted successfully.
Then reconcile payment methods. Compare PMS and POS card totals to the merchant processor's batch settlement report. Check that the batch was closed, funded, and recorded net of processing fees where applicable. For cash, reconcile cashier activity to counted cash and deposit slips. Cash overages and shortages should be recorded promptly and reviewed by management rather than carried forward without explanation.
Direct-bill and city-ledger activity requires its own review. Confirm that charges transferred from guest folios to accounts receivable are authorized and supported by billing documentation. Reconcile the daily transfers to the city-ledger report, then monitor collections through the accounts receivable aging report. A hotel can appear profitable while cash flow deteriorates if direct-bill balances are allowed to age without active follow-up.
Finally, compare expected deposits with actual bank activity. This is often a next-day or two-day process because settlement timing varies by processor, card type, and banking day. Maintain a deposit-clearing account when needed so that daily card revenue is recorded correctly before the cash reaches the operating bank account. This avoids forcing deposits to match revenue on the same date when the underlying settlement cycle does not support it.
A reconciliation is only as useful as its exception process. A generic unexplained difference account can conceal recurring issues for months. Instead, classify variances so management can identify patterns and assign accountability.
Timing differences should be tracked separately from actual errors. A card settlement pending for one business day is different from a missing batch. An OTA remittance that reflects commission deductions is different from an incorrect room rate or an unrecorded cancellation fee. The finance team should document each item with its source, owner, expected resolution date, and final outcome.
Pay close attention to refunds, chargebacks, allowances, and manager comps. These transactions may be legitimate, but they create opportunities for revenue leakage when approval requirements are unclear. Set authorization thresholds and require supporting documentation for manual adjustments. The person approving a refund or comp should not be the only person able to enter it into the system.
Negative folios, unusually high discounts, repeated rate overrides, and frequent voids should also be reviewed. They do not necessarily indicate misconduct. They may point to training gaps, configuration errors, or a weak handoff between front desk and accounting. The value of daily reconciliation is that it identifies these patterns before they become a month-end surprise.
Once operational reports and payment activity have been reconciled, accounting can post the results to the general ledger. The journal entry should reflect the hotel's revenue recognition policy and clearly separate revenue, taxes payable, payment clearing, accounts receivable, deposits, and cash.
Hotels that receive OTA payments should record gross room revenue and commission expense when appropriate, rather than recording only the net remittance as revenue. Similarly, sales taxes, occupancy taxes, and certain service charges should not inflate operating revenue when the hotel is collecting them on behalf of a taxing authority or another party.
Month-end adds another layer of review. Reconcile daily totals to monthly revenue reports, general ledger balances, bank reconciliations, merchant clearing accounts, accounts receivable aging, and deferred revenue schedules. Investigate aged clearing-account balances promptly. Items left unresolved in clearing accounts are often evidence of duplicate postings, missing deposits, or transactions recorded to the wrong period.
A well-designed process needs documented ownership. Night audit should complete operational closeout procedures. Accounting should perform independent review and general ledger posting. Management should approve material adjustments and review exception reports. Segregating these responsibilities reduces the risk that one person can initiate, approve, and conceal an error.
Standard reconciliation templates also improve consistency, particularly for multi-property operators. Each property may have different outlets, processors, and fee structures, but the control objectives remain the same: verify revenue completeness, confirm payment settlement, identify liabilities, and clear exceptions on time.
For operators without a full internal accounting department, an outsourced finance partner can provide the recurring review, reporting discipline, and month-end support needed to keep reconciliations current. Global Virtuoso Accounting can support hospitality businesses with bookkeeping, financial reporting, accounts receivable oversight, and internal control assistance aligned with their operating requirements.
Accurate hotel revenue reconciliation is not achieved by waiting for month-end and hoping the bank balance makes sense. It is built through a daily routine that follows each transaction from guest folio or outlet sale to settlement, ledger entry, and management review. When exceptions are visible and assigned quickly, financial reporting becomes a practical operating tool rather than a record of problems discovered too late.
