Managing hotel finances shouldn't mean jumping between multiple reports to understand what happened during the day.
From guest payments and outstanding balances to revenue earned from completed stays, hotel accounting involves several moving parts. And when that information lives across different reports, daily reconciliation can become a time-consuming process.
That's why OpenHotel is introducing the Daily Reconciliation Report, a new tool designed to bring reservation financial activity into one convenient view.
The goal? Make daily reconciliation easier, improve financial visibility, and help your team identify discrepancies with less manual research.
Traditionally, reviewing daily hotel financial activity may require comparing audit reports, reservation charges, payments, and outstanding balances.
OpenHotel's Daily Reconciliation Report brings these important details together so your team can follow how each reservation's financial position changes throughout a specific business date.
Instead of simply identifying reservations with outstanding balances, the report provides a more complete picture of the activity behind those balances.
Here's what you can review:
Together, these details help your accounting team better understand where balances originate, how payments affect them, and what requires additional review.
Not every reservation represents revenue that has already been earned.
Consider a guest who books and pays for a stay scheduled several weeks from now. Your hotel may have already collected the payment, but the stay has not yet taken place.
That's where distinguishing between earned and unearned revenue becomes important.
In the Daily Reconciliation Report:
Earned Revenue represents revenue associated with stays that have been fully consumed or completed.
Unearned Revenue represents revenue associated with future stays.
Liability helps identify advance payments collected against revenue that has not yet been earned.
By separating these values, the report provides greater visibility into reservation revenue and payment timing, helping accounting teams review their financial position more effectively.
One of the most useful capabilities of the Daily Reconciliation Report is its ability to show why a reservation appears on a particular business date.
A guest's stay date and payment date aren't always the same.
With the Stay or Payment on Report Date option, a reservation can appear because the guest stayed at the property, a payment was processed, or both activities occurred on the selected date.
The report identifies this using three labels:
Imagine a guest staying at your hotel from June 12 through June 14.
On June 12, the guest is staying at the property and makes a payment.
The report identifies the reservation as Stay + Payment on Report Date.
On June 13, the guest is still staying at the property, but no additional payment is collected.
The report identifies the reservation as Stay on Report Date, while keeping prior payment information available for reference.
This additional context makes it easier to understand reservation activity without having to investigate each transaction separately.
A major part of daily reconciliation is understanding why a reservation has a remaining balance.
The Daily Reconciliation Report helps teams review the relationship between opening balances, new charges, payments, and closing balances.
The basic reconciliation flow is:
Opening Balance + Booked + Purchases + Taxes − Payments = Closing Balance
When a closing balance doesn't match expectations, your team has a clearer starting point for investigating potential issues, including:
Not every non-zero balance necessarily indicates an error, but having the details available in one report helps your team determine which balances require attention.
Every property has different accounting workflows.
The Daily Reconciliation Report includes filters that help your team focus on the information most relevant to its review.
You can narrow results using:
Whether you're reviewing a specific business date, investigating outstanding balances, or checking payment activity, these filters help reduce unnecessary information and make the report easier to navigate.
Daily reconciliation is an important part of maintaining accurate hotel financial records.
The more time your team spends gathering information from separate sources, the less time it has to investigate discrepancies and support other operational priorities.
With OpenHotel's Daily Reconciliation Report, accounting and management teams have a centralized view designed to help them:
For properties with detailed financial processes, including resorts, casinos, and multi-property operations, having a clearer reconciliation workflow can make a meaningful difference.
The Daily Reconciliation Report is available within the OpenHotel PMS.
Navigate to: Reports → Reconciliation Report (New)
Select your reporting date, apply the appropriate filters, and begin reviewing the financial activity associated with your reservations.
At OpenHotel, we believe your technology should make complex operations easier to manage.
The new Daily Reconciliation Report is another step toward giving hotel owners and operators the visibility they need to make informed decisions, simplify daily workflows, and stay connected to their property's financial performance.
Ready to explore the new report?
Log in to your OpenHotel PMS or contact our support team to learn more about the Daily Reconciliation Report.