A hotel can have a busy day and still have no single system that tells the full financial story.
The front desk may have closed 80 rooms. The restaurant might have processed hundreds of checks. Several guests booked through an OTA, while others paid directly at the property. Card payments may still be sitting with the payment processor, and some OTA money may not reach the bank for several days.
All of that is normal. The problem starts when nobody connects those pieces.
Hotel revenue reconciliation is the process of doing exactly that. It gives the accounting team a way to compare what the hotel says it earned with what was actually collected and deposited. When the process is done properly, differences are not simply adjusted away. They are understood.
For anyone responsible for hotel revenue accounting, that distinction matters.
Why the Numbers Rarely Match at First
It is easy to assume that a hotel's daily revenue should equal its daily deposits. In practice, that almost never happens.
Take a guest who books a $300 room through an OTA. The PMS may record the $300 room charge. The OTA may deduct its commission before sending the hotel its money. The bank might then show the resulting payment two or three days later.
Now look at the restaurant accounting system. The guest charges $120 to the room, so the POS records the sale, but the bank does not receive $120 from that transaction. It becomes part of the guest's hotel folio and is eventually settled according to the hotel's payment arrangements.
So if someone compares the PMS, POS and bank statement line by line, the figures can look wrong even when the transactions are perfectly legitimate.
The job of reconciliation is to explain those differences.
Start With the PMS, But Don't Stop There
The PMS is usually the natural starting point for room revenue.
At the end of the day, the night audit and daily revenue reports provide information about rooms sold, room charges, taxes, discounts, cancellations, no-shows and adjustments. Those figures form the operational record of what happened with the hotel's rooms.
The hotel revenue management accounting team can use that report to establish the day's room revenue and then compare it with the corresponding entries in the general ledger.
This is also a good point to look for unusual items. A large manual adjustment, an unexpected refund or a cluster of cancelled reservations may be perfectly valid, but it should have a reason behind it.
The important thing is not to force the PMS total to match another report. If the numbers differ, find out why.
Restaurant Sales Add Another Layer
Hotels that operate restaurants, bars, spas or banquet facilities have considerably more revenue and expenses to keep track of.
A restaurant POS might report $15,000 in sales for the day. That does not mean the bank should show a $15,000 deposit.
Some customers may have paid cash. Others used credit cards. Hotel guests may have charged meals to their rooms. There could also be refunds, discounts, tips and taxes included in the POS figures.
This is where hospitality POS accounting becomes particularly important.
The accounting team needs to understand not only how much the outlet sold, but how those sales were paid and where the money should appear in the books. It is important to understand how to properly handle different items in restaurant accounting.
Good POS accounting integration for hotels and restaurants can reduce some of the manual work involved here. When the POS and accounting system communicate properly, sales information can move into the books without someone having to re-enter every transaction.
Even with an integration, reconciliation is still necessary. An automated transfer can be wrong just as easily as a manual entry can be.
OTA Revenue Needs a Different Approach
Online travel agencies are another common source of confusion.
Suppose a guest books a room for $1,000 through an OTA. The PMS may show the $1,000 booking value, while the OTA statement shows a commission deduction of $150. The hotel may ultimately receive $850.
Looking only at the PMS and bank statement, it might appear that $150 has disappeared.
It hasn't. It has been deducted according to the OTA agreement.
This is why the OTA statement needs to be part of the reconciliation. The hotel revenue management accounting team should be able to connect the reservation in the PMS with the corresponding OTA booking and then with the eventual payout.
Useful details to compare include the reservation number, stay dates, room amount, taxes, commission, adjustments and payout amount.
It is important to remember that the booking date, stay date and payout date can all be different.
Matching the OTA Payout to the Bank
The final part is checking that the OTA actually paid what it said it would. This can make hotel bookkeeping a bit complex. It is also essential to ensure accounts receivable aging is under control.
OTAs often group several reservations into a single settlement. The bank might show one deposit for $4,850, while the OTA statement contains ten separate bookings that make up that amount.
Trying to match the bank deposit to one reservation will obviously lead nowhere.
Instead, use the OTA settlement report. Look for the settlement reference, date and total amount, then trace the individual reservations included in that payout.
A simple reconciliation might look like this:
Gross bookings: $5,400
OTA commissions and adjustments: $550
Expected payout: $4,850
Bank deposit: $4,850
That is a completed reconciliation. The gross revenue and bank deposit are different, but there is a clear explanation for the difference.
Card Payments Can Be Just as Tricky
Credit card transactions create a similar issue.
A hotel might record $30,000 in card sales on Friday. The payment processor may not deposit the money until Monday. Processing fees may also be deducted, and a refund or chargeback could change the final amount.
If $30,000 in card sales produces a $29,300 bank deposit, the $700 difference needs to be explained. Perhaps it is processing fees. Perhaps some transactions have not settled yet. Perhaps there was a refund.
The reconciliation should identify the reason rather than simply recording a $700 miscellaneous difference.
Where Hotel Bookkeeping Often Goes Wrong
Most reconciliation problems aren't dramatic. They tend to be small issues that are allowed to accumulate. Some common bookkeeping mistakes could be:
- A POS transaction might fail to transfer.
- Someone may enter a transaction manually even though it has already been imported
- An OTA commission could be posted to the wrong account.
- A refund might be recorded twice.
There are also classification problems.
A restaurant sale accidentally posted as room revenue may not change the hotel's total income, but it will make departmental reporting inaccurate. Management could then make decisions using figures that don't represent what each part of the property actually earned.
This is one reason hotel bookkeeping requires more than entering transactions and making sure the trial balance balances.
How to Track Hotel Room Revenue Accurately
If you're trying to work out how to track hotel room revenue accurately, consistency is more useful than an elaborate process that nobody follows.
A hotel should establish a routine for comparing its main sources of revenue and payment information. For a busy property, that may happen every day. A smaller operation might work on a slightly different schedule, but the principle remains the same.
Start with the PMS room revenue. Compare it with the hotel revenue accounting records. Review OTA activity separately. Check payment settlements against the bank. Investigate anything that doesn't have an obvious explanation.
And keep the supporting reports.
If someone asks three months later why an OTA deposit was $850 rather than $1,000, the answer should not depend on someone's memory.
When Outside Bookkeeping Support Makes Sense
As a hotel gets larger, the accounting workload grows quickly. There may be several OTAs, multiple bank accounts, different payment processors and several outlets feeding transactions into the books.
This is where hotel bookkeeping services can be useful, particularly when the hotel's internal staff are already busy with daily operations.
Specialized hospitality accounting services can help establish a reconciliation process, review the reports coming from operational systems, investigate differences and keep the accounting records up to date.
Hospitality Accounting Services With AccountiPro
Hotel revenue reconciliation isn't about making every report show the same number.
The PMS records hotel activity. The POS records outlet sales. OTAs report reservations and settlements and so on. Connecting all the numbers can be complex with large volumes of transactions.
For hotels, it makes sense to seek support from hotel bookkeeping services like AccountiPro. Our hospitality accounting services are tailored to the requirements of hospitality businesses. With our expertise and use of advanced accounting tools, you can understand the business financial statements better, allowing you to make informed decisions promptly. To understand your hotel revenue accounting better, contact us today to book an appointment with one of our professionals.
