| Purpose | Understand how report dates affect revenue and reporting results in Cloudbeds. |
| Best for | Property managers, general managers, administrators, and owners comparing Occupancy and Financial reporting or investigating differences in historical revenue. |
| Use this when | Revenue for the same day looks different between reports, a past Stay Date changed, or you need to decide which date field to use for property performance or financial reconciliation. |
| Requirements | Access to the relevant Reporting content and the reporting permissions required to review the Occupancy or Financial data you are investigating. |
| Expected result | You can identify which date answers your reporting question, understand why reports can show different values for the same calendar day, and investigate unexpected revenue differences. |
Introduction
Cloudbeds reports can use different date fields to organize the same stay or financial activity. Choosing the right date depends on the question you are trying to answer.
This guide explains the difference between Stay Date, Service Date, Business Date, and Transaction Date/Time, how each date affects reporting results, and what to check when revenue appears different between reports.
Table of contents
- Why the same day can show different revenue
- Understand the four report dates
- Example: Why revenue changed for a past date
- Choose the right date for your reporting question
- Investigate a revenue difference
- Frequently asked questions
- Key takeaway
Why the same day can show different revenue
You may notice that revenue for the same day looks different between Occupancy and Financial reporting. This does not necessarily mean something is wrong.
Cloudbeds tracks different dates because each one answers a different question. For example, a room charge may belong to a guest's stay on June 9 but not be recorded until June 15. Depending on the date used by the report, that revenue can appear against June 9 or June 15.
The key difference
- Occupancy reporting shows how your property performed for each Stay Date. Revenue for a past stay can change when applicable charges are added or corrected.
- Financial reporting using Business Date shows when transactions were posted for accounting purposes. Once a business day is closed, its financial totals do not change.
Understanding these dates helps you choose the right reporting perspective, explain changes in historical revenue, and reconcile financial activity more confidently.
Understand the four report dates
Each date represents a different point in the lifecycle of a stay or transaction. Use the comparison below as a quick reference before reviewing each date in more detail.
| Date | What it means | What it helps you understand |
|---|---|---|
| Stay Date | The night a guest stays in a room. | How did my property perform that night? |
| Service Date | The date a charge belongs to. | Which day should this charge be attributed to? |
| Business Date | The accounting day in which a transaction was posted. | Which accounting day was this transaction recorded in? |
| Transaction Date/Time | The exact date and time a transaction was recorded. | When exactly did this transaction occur? |
Stay Date: Which night did the guest stay?
Stay Date represents the night a guest stays at your property. For example, a guest who checks in on June 8 and checks out on June 10 has two Stay Dates: June 8 and June 9.
Occupancy reporting uses Stay Date to show property-performance metrics such as:
- Rooms Sold
- Occupancy %
- Average Daily Rate (ADR)
- Revenue per Available Room (RevPAR)
- Room Revenue
Occupancy revenue includes applicable posted and pending charges. Revenue associated with a past Stay Date can therefore change when charges are added or corrected.
Service Date: Which day does the charge belong to?
Service Date is the date a charge belongs to. It can be different from the date the charge was entered.
For example, if a room charge belongs to June 9 but is entered on June 15, its Service Date can be June 9. This allows the revenue to be attributed to the appropriate day even though the transaction was recorded later.
Once a transaction has been posted, its Service Date cannot be edited directly. If a correction is needed, staff must void or adjust the original transaction and record the appropriate correction.
How Stay Date and Service Date work together: Occupancy reporting uses the Service Date of applicable room-revenue charges to attribute that revenue to the corresponding Stay Date. Stay Date describes the room night. Service Date describes the charge.
Business Date: Which accounting day was this posted in?
Business Date is the accounting day in which a transaction was posted. Unlike a calendar day, which runs from midnight to midnight, your property's business day follows its Night Audit process.
For example, if Night Audit runs at 2:00 AM, a charge posted at 1:30 AM on June 11 still belongs to the June 10 Business Date.
Once a business day is closed, its financial totals are locked and do not change. New transactions or corrections are recorded against the currently open Business Date, even when they relate to an earlier stay.
Use Business Date when you need to:
- Reconcile posted financial activity.
- Close or review a financial period.
- Review accounting totals that should remain unchanged after the business day closes.
Transaction Date/Time: When was the transaction recorded?
Transaction Date/Time is the exact date and time a transaction was recorded in Cloudbeds.
Unlike Business Date, which represents your property's accounting day, Transaction Date/Time shows the actual moment the transaction was recorded.
Use Transaction Date/Time when you need to know exactly when a transaction occurred.
Example: Why revenue changed for a past date
A guest stays on June 9 and checks out on June 10. On June 15, your team discovers that the guest was undercharged by $150 for the June 9 room night.
The team posts an additional $150 room-revenue adjustment with a Service Date of June 9.
Which dates does the new transaction use?
The new transaction records the date the charge belongs to separately from the accounting day and exact time when it was recorded:
| Date | Value | Why |
|---|---|---|
| Service Date | June 9 | The night the additional room revenue belongs to. |
| Business Date | June 15 | The accounting day the adjustment was posted. |
| Transaction Date/Time | June 15, 10:42 AM | The exact moment the adjustment was recorded. |
How does the adjustment affect the reports?
Assume June 9 originally had $10,000 in room revenue.
| Report | June 9 before | June 9 after | Where the additional $150 appears |
|---|---|---|---|
| Occupancy using Stay Date | $10,000 | $10,150 | June 9 |
| Financial using Business Date | $10,000 | $10,000 | June 15 |
Why are the results different?
The Occupancy report attributes the additional revenue to June 9 because that is the night the room charge belongs to. The Financial report, when grouped by Business Date, records the additional charge on June 15 because that is the accounting day when it was posted.
Both reports can be correct. They are showing the same financial activity from different reporting perspectives.
Revenue for a past Stay Date can change when charges are added or corrected. Financial totals for a closed Business Date remain unchanged because later corrections are recorded against the currently open accounting day.
Choose the right date for your reporting question
Choose the date based on what you are trying to understand rather than expecting every date field to return the same result.
| I want to... | Use | Reporting perspective |
|---|---|---|
| Review occupancy, ADR, RevPAR, or room revenue by night. | Stay Date | Occupancy |
| Reconcile posted financial activity for a day or month. | Business Date | Financial |
| See which day a charge belongs to. | Service Date | Financial |
| Find out exactly when a transaction was recorded. | Transaction Date/Time | Financial |
Quick tip: Use Stay Date to understand how your property performed. Use Business Date to review posted financial activity by accounting day, with totals that remain unchanged once that day is closed.
Investigate a revenue difference
If revenue for a past Stay Date changes, an additional charge or correction may have been recorded with a Service Date in the past.
For example, a room charge posted on June 15 with a Service Date of June 9 can increase the room revenue shown for June 9 in Occupancy reporting.
To investigate:
- Open the relevant Financial report in Cloudbeds Insights.
- Filter Service Date to the date you are investigating.
- Add Business Date, Transaction Date/Time, and the relevant transaction details as columns.
- Look for transactions with a Business Date later than their Service Date.
- Review those transactions to determine whether they explain the difference.
A later Business Date does not automatically mean that a correction was made. It means the transaction was posted in a later accounting period than its Service Date.
If the totals still do not match, confirm that both reports use comparable:
- Revenue fields.
- Transaction statuses.
- Filters.
Also remember that applicable Occupancy revenue includes both posted and pending charges, while Business Date reporting reflects posted financial activity.
Frequently asked questions
Use these answers for common questions about date fields and revenue differences. If you are not sure which question applies, select Expand all, then use Ctrl+F on Windows or Cmd+F on Mac to search the expanded answers.
Why don't my Occupancy and Financial revenue totals match?
The reports may attribute revenue to different dates.
Occupancy reporting uses Stay Date to show revenue associated with each night. Financial reporting can use Business Date to show when transactions were posted.
For example, a room charge posted today for a stay last week may appear against last week's Stay Date in Occupancy reporting but today's Business Date in Financial reporting.
Applicable Occupancy revenue also includes pending charges, which can create differences when compared with posted financial activity. Differences can also result from the revenue fields or filters selected in each report.
Why did revenue for a past Stay Date change?
Revenue associated with a past Stay Date can change when charges are added or corrected after the stay.
For example, if an additional room charge is recorded with a Service Date in the past, it can update the revenue attributed to that night in Occupancy reporting. This allows Occupancy reporting to reflect the updated revenue associated with the stay.
Can Business Date totals change after Night Audit?
No. Once a business day is closed, its financial totals are locked and do not change.
If a correction is made later, it is recorded against the currently open Business Date rather than changing the closed day's totals. This is why Business Date is recommended for accounting reconciliation and final posted financial totals.
Can I use Business Date in Occupancy reporting?
No. Occupancy reporting uses Stay Date to measure property performance by night.
To review transactions based on the accounting day in which they were posted, use Business Date in Financial reporting.
Does Occupancy revenue include pending charges?
Yes. Applicable Occupancy revenue metrics include both posted and pending charges.
This means Occupancy revenue may differ from Financial reporting that includes only posted transactions. Pending charges can also contribute to changes in Occupancy revenue for past Stay Dates.
Can I change the Service Date of a posted transaction?
No. Once a transaction is posted, its Service Date cannot be edited directly.
If a correction is needed, staff must void or adjust the original transaction and record the appropriate correction. The new transaction is recorded against the currently open Business Date, while its Service Date can reflect the date the charge belongs to.
Key takeaway
Different report dates answer different questions:
- Stay Date: When did the guest stay?
- Service Date: Which day does the charge belong to?
- Business Date: Which accounting day was the transaction posted?
- Transaction Date/Time: When exactly was the transaction recorded?
For property performance, use Stay Date. For financial reconciliation and final accounting totals, use Business Date.
Understanding the difference helps you choose the right reporting perspective, explain changes in historical revenue, and reconcile financial information with the correct date context.
Related articles
Use these resources for additional Reporting and Cloudbeds Insights guidance:
Comments
Please sign in to leave a comment.