FOR HOTELS, RESORTS & GROUPS
The Report That Tells You What You Actually Made
The dashboard shows today’s numbers. Revenue and occupancy reports show last month’s, broken down by room type, compared against the month before, and checked against what actually reached your bank account.
Every booking, refund and payout rolls up into one number you can trust, not a spreadsheet you rebuild by hand at the end of every month.
No setup fee. No commission.
What happens without a proper revenue report
Most properties can say whether business feels good this week. Far fewer can say, with a number they would defend, whether last month actually beat the month before it, because that answer does not live in one place. It is split across a booking list, a payments app, and whatever the owner remembers checking.
A live dashboard is built to answer a different question, what does today look like, not what did last month add up to. Nobody opens a real time view in February to work out how January went, room type by room type, and few dashboards are built to answer that question even if someone tried.
So the job usually falls to whoever is willing to rebuild it by hand. Most months that means the owner, at the end of the month, going through the booking list line by line and matching it against whatever the bank statement shows. It takes an evening when nothing is wrong, longer when something does not add up, and it is exactly the kind of task that gets pushed to next week the moment anything more urgent comes up, which on a working property is most weeks.
The problem compounds once a manager or accountant needs the same numbers. Without one report both can point to, each ends up with a slightly different version, one counting a refund the other missed, one working from a different date range, and small disagreements about the numbers turn into long conversations that were never really about the numbers at all.
None of this is anyone’s fault. Booking software is generally built to help take and manage a reservation, not to answer a month end question about what that reservation was actually worth once fees, refunds and a partial cancellation are accounted for. That gap has to be closed somewhere, and for most properties it currently gets closed manually, one spreadsheet at a time.
The scale of the gap is easy to underestimate until it is written down. A property with sixty bookings in a month, across several room types, two payment methods and a handful of refunds, has enough moving pieces that reconstructing it by memory is genuinely unreliable, not just inconvenient. Nobody is bad at this task, the task itself is not one memory was built to do well.
What guessing at the numbers actually costs
The most immediate cost is time. Rebuilding a month of revenue and occupancy by hand from a booking list is not a five minute task, and it is time spent on data entry rather than anything that grows the property, at exactly the point in the month when that time is usually already scarce.
There is a decision making cost that is harder to see. Without reliable revenue and occupancy reports, pricing decisions end up based on gut feeling rather than an actual comparison, was the new weekend rate a good call, did the festival pricing rule earn more than it cost in lower occupancy. Those are answerable questions, but only with numbers that can actually be trusted.
There is a payout cost too. Money collected through an online booking rarely reaches a bank account as a single clean transfer, gateway fees, refunds and adjustments all shave a little off, and without a report that reconciles gross revenue against what actually landed, a shortfall can sit unnoticed for months. By the time it is spotted by accident, the paper trail needed to dispute it is often gone.
There is a tax and accounting cost. A GST filing, an income statement, or a bank loan application usually needs a clean revenue figure for a specific period, not a rough estimate from memory. Producing that figure at the last minute, under deadline pressure, is a worse experience than having it ready on demand.
There is a cost to the owner personally as well, less obvious but real. Reconstructing last month’s numbers by hand at eleven at night after a full day of running the property is not a rare inconvenience, for many owners it is a monthly ritual, and it eats into exactly the time that should be going toward decisions, rest, or family, rather than data entry a system should have been keeping all along.
There is also a comparison cost that only shows up over time. Without consistent revenue and occupancy reports, this March is never properly measured against last March, so a genuinely good or bad season can pass without the property learning anything reusable from it. A rate that worked well during a festival week two years ago is easy to forget entirely, and a mistake that cost real revenue can quietly repeat itself the following year, because nothing kept a clear enough record to recognise it happening again.
None of this shows up as one dramatic loss. It shows up as a slow tax on attention, a pricing call made on instinct that a report would have corrected, a payout gap nobody caught, and an evening spent rebuilding a spreadsheet instead of doing anything else.
What revenue and occupancy reports actually give you
Revenue and occupancy reports take every booking, refund, payment and payout for a chosen period, a week, a month, a custom range, and roll them into a small set of numbers that answer the question directly: what did the property make, how full was it, and does the payout match what it should.
Four numbers sit at the top of every report: total revenue for the period, occupancy as a percentage of available room nights, average daily rate, and revenue per available room, the number that combines how full the property was with how much each night actually sold for. Each one is shown next to the same figure from the period before, so a good or bad month is immediately obvious rather than something that has to be worked out separately.
Below that sits a monthly trend, so the current period is never read in isolation. A strong July only means something once it is visible against a slower April and a busier December, and a report that only ever shows the current period misses exactly the comparison an owner actually needs.
The same numbers are broken down by room type, so it is clear which rooms are actually earning their keep. A property with several room types can see that the lake view rooms are running near ninety percent occupancy while the standard rooms sit closer to sixty, a decision-relevant fact a single blended occupancy number hides completely.
Revenue and occupancy for the month, compared against last month, broken down by room type.
Every number here is drawn from the same underlying booking data the reservations dashboard already uses, so a report and a dashboard checked on the same day never quietly disagree with each other.
None of this asks the owner to define anything up front. Room types, rates and payment methods are already set up elsewhere in the account, and these reports simply read from that same configuration every time a period is generated, so there is no separate setup step and nothing that can quietly drift out of sync with how the property is actually run.
What is actually in a revenue and occupancy report
Revenue at a glance
Total revenue, average daily rate and revenue per available room for any period, shown next to the same numbers from the period before so a good month is obvious without having to calculate it.
Occupancy that means something
Occupancy shown as a percentage of available room nights, not just a room count, and broken down by room type so it is clear which rooms are actually filling up and which are not.
Payout reconciliation
Gross revenue matched against gateway fees, refunds and the amount that actually reached the bank account, with anything that does not add up flagged automatically rather than discovered by accident.
Exportable, on demand
Any period can be downloaded as a spreadsheet in a few seconds, ready for an accountant, a GST filing, or a loan application, without rebuilding it from the booking list by hand.
SEE IT IN ACTION
A resort in Manali catches a payout shortfall before it becomes a pattern
Lakeview Residency closes its books for July and, like every month, the owner opens the monthly payout summary before anything else. May and June both show as matched, gross revenue minus fees lining up exactly with what reached the bank account.
The July payout is flagged automatically the moment it does not reconcile.
July does not match. Sixty eight bookings, gross revenue of ₹4,82,600, and a payout that lands ₹1,240 short of what the fees alone should account for. Without a report doing this comparison automatically, a shortfall this size would likely have gone unnoticed entirely, a few thousand rupees is easy to miss against half a lakh of monthly revenue, especially spread across dozens of individual transactions.
Because the report flags it the moment the numbers are pulled, the owner catches it within the first ten minutes of the month, not three months later while doing annual tax preparation, by which point the specific transaction would have been far harder to trace. A short email to the payment provider, with the exact booking dates and amounts already laid out by the report, resolves it within a few days.
The same report also shows something more encouraging. Revenue is up eighteen percent on June, and the six month trend makes clear this is not a one month blip, it follows a steady climb since April. Occupancy for the Deluxe Lake View rooms is running well ahead of the Standard rooms, a fact the owner uses the following week to shift a little more of the marketing budget toward the room type that is clearly earning it.
None of this required a spreadsheet, a call to an accountant, or an evening of manual reconciliation. It took the time it takes to open a revenue and occupancy report that was already sitting there, current, at the start of the month it describes.
A similar story plays out differently at a five property group outside Coimbatore. The group’s accountant used to request a manual revenue summary from each property manager separately, then spend a day reconciling five slightly different spreadsheets into one portfolio number before a monthly owners’ call. With a shared report format across all five properties, that day of reconciliation disappears entirely, the portfolio view is already built, and the call spends its time discussing what the numbers mean rather than agreeing on what they are.
Mistakes properties make without a real revenue report
- Rebuilding last month’s numbers from the booking list by hand every month, instead of having a report generate them automatically.
- Trusting the dashboard’s real time snapshot as if it were a historical record, when it is built to show today, not a comparison across months.
- Never actually checking that a payout matches what was earned, so a gateway fee error or a short credit goes unnoticed indefinitely.
- Making pricing decisions on instinct alone, because there is no reliable revenue and occupancy report to check whether last season’s rate change actually paid off.
- Scrambling to produce a clean revenue figure at tax filing time, instead of having one ready on demand for any period.
- Treating occupancy as a single blended number, missing that some room types are running near full while others sit half empty.
- Losing the ability to explain a specific month’s numbers to a co-owner, investor or lender, because the only record was a mental impression rather than an exportable report.
- Assuming a payout that looks roughly right is right, without ever checking the specific numbers against what was actually earned.
- Keeping revenue records in a format that changes slightly every month, so comparisons quietly stop being apples to apples without anyone noticing.
None of these come from carelessness. They come from treating month end reporting as a task to survive rather than a habit worth building properly, something rebuilt from scratch under time pressure instead of something that already exists the moment it is needed.
The same numbers, whichever period or property you are checking
Revenue and occupancy reports for last month should use exactly the same definitions as one for last week, or for the same month a year ago, occupancy calculated the same way, revenue counted the same way, refunds handled the same way every time. Reports that quietly change their own math between periods are harder to trust than no report at all.
For a group running more than one property, the same report structure rolls up into a combined view without losing the ability to look at any single property on its own. A group owner can see the portfolio’s total revenue for the month, then drop into any one property to see exactly what drove it, without switching between two differently built systems to do so.
This consistency is what actually makes a report useful for comparison. A number that means one thing in March and something subtly different in April is not a number anyone can plan around, and the entire value of revenue and occupancy reports depends on being able to trust that this month’s ninety percent occupancy means the same thing as last month’s eighty five percent.
This also protects against a subtler failure mode, a report that looks trustworthy but silently changes its own rules. A dashboard that counts a same-day cancellation differently in June than it did in January, without saying so, produces numbers that are internally consistent with nothing, including themselves. Reports built on one fixed set of definitions avoid that failure entirely, because the same booking, refunded the same way, always lands in the same place in the numbers, whichever month it happens to fall in.
Who actually opens these reports
An owner running a single property checks it monthly, mostly to confirm the payout is clean and to see which room type is pulling its weight. That habit alone tends to catch most discrepancies well before they become large enough to be a real problem.
A manager running day to day operations checks it less often but more specifically, usually after a pricing change, to see whether occupancy held up or dropped once the new rate went live. That specific comparison is hard to make with anything less structured than a proper report.
An accountant or a lender reviewing the property from outside cares about a different thing entirely, a clean, exportable number for a defined period that does not need to be reconstructed or explained line by line before it can be trusted.
How this fits with the rest of OpenStays
The reservations dashboard already shows revenue and occupancy at a glance, today’s booked revenue and the coming week’s occupancy, built to be read in five seconds during a busy shift. Revenue and occupancy reports are built for a different moment, sitting down at the end of a week or month to actually understand it, with the same numbers extended into trends, comparisons and payout reconciliation the dashboard was never meant to hold.
Every figure in the report traces back to the same rates set up through room and rate plan setup, so a report never disagrees with the pricing screens that actually produced those numbers. Payout reconciliation checks against the same payment records tracked by the 0% UPI payment gateway, and for a property running staff logins with roles, full revenue and payout detail stays visible to the Owner role by default, with a manager seeing enough to run the property well without needing the complete financial picture. For a group with several properties, the same rollup extends cleanly from multi-property management.
Revenue and occupancy reports vs. the alternatives
Most properties compare this against whatever they currently do to work out how a month went, usually a manual spreadsheet rebuilt from the booking list, or simply checking the bank balance and trusting that whatever landed is roughly right.
| A manual spreadsheet | Checking the bank balance | OpenStays | |
|---|---|---|---|
| Ready without rebuilding it | No, redone from scratch each month | N/A, no breakdown exists | Yes, generated automatically |
| Flags a payout shortfall | Only if someone checks the maths | No, a low balance could mean anything | Yes, automatically, by period |
| Breaks revenue down by room type | Rarely, most spreadsheets stay blended | No | Yes, every period |
| Comparable month to month | Only if the format never changes | No | Yes, same definitions every time |
| Time to produce for a given month | An hour or more, done by hand | A few minutes, but tells you little | Seconds, already calculated |
GETTING STARTED
Reading revenue and occupancy reports
How to read and use revenue and occupancy reports on OpenStays.
Total Time: 10 minutes
Open the report for the period you need
From the dashboard, choose a week, month or custom date range to generate a revenue and occupancy report for that period.
Check the headline numbers first
Look at total revenue, occupancy, average daily rate and revenue per room against the previous period, before going into any detail.
Review the room type breakdown
See which room types are driving revenue and which are underperforming, to inform the next pricing or marketing decision.
Confirm the payout reconciliation is clean
Check that gross revenue minus fees and refunds matches what actually reached the bank account, and follow up immediately on anything flagged.
Export it if it is needed elsewhere
Download the report as a spreadsheet for an accountant, a GST filing, a co-owner update, or a loan application.
What to check in any revenue reporting system
- Does the report cover a full period, a week or month, not just a real time snapshot of right now?
- Is occupancy shown as a genuine percentage of available room nights, not just a raw booking count?
- Does it reconcile gross revenue against what actually reached the bank account, flagging anything that does not match?
- Can revenue be broken down by room type, not just shown as one blended number for the whole property?
- Can a specific period be exported as a spreadsheet without rebuilding it by hand?
- Does the report use the same definitions every time, so one month is genuinely comparable to another?
- Does the system make it obvious which numbers are estimates and which are exact, rather than presenting both with the same confidence?
A system that cannot answer these clearly is asking an owner to keep trusting a number nobody has actually checked.
It is also worth asking who inside the property can actually see this level of financial detail. A report that exposes full payout and revenue figures to every login on the account is solving one problem while creating another, the same reasoning that keeps staff logins with roles limiting full financial visibility to the owner by default.
What is actually inside revenue and occupancy reports
Revenue is counted the way it is actually earned, the full booking value, minus anything refunded or cancelled, for the date range selected, against the date of the stay rather than the date the booking was made. A booking made in March for a July stay counts toward July’s revenue, not March’s, which matters for anyone trying to understand seasonality accurately.
Occupancy is calculated as room nights sold divided by room nights available for the period, accounting for the actual number of rooms in inventory, not a rough guess. A five room property that sells eighteen room nights in a thirty day month is at twelve percent occupancy, not eighteen bookings out of some unclear total.
Average daily rate divides total room revenue by room nights sold, and revenue per available room divides the same revenue by total room nights available, whether sold or not. The two numbers together tell a fuller story than either alone, a high rate on a mostly empty property and a lower rate on a mostly full one can land at a similar revenue per room, and the report shows both so that distinction is not lost.
Payout reconciliation lines up gross revenue against the specific deductions, payment gateway fees, refunds, any adjustment, that separate what a guest paid from what actually reaches the property’s bank account, flagging any gap that does not explain itself.
Refunds and partial cancellations are handled the same way regardless of when they happen relative to the stay. A booking cancelled with a partial refund three weeks before arrival still counts, net of that refund, against the month the stay was scheduled for, not the month the cancellation happened, which keeps a cancellation heavy month from distorting an otherwise ordinary one.
Multiple payment methods are combined into one number rather than reported separately by default. A guest who paid partly through a direct UPI transfer and partly through a card at check-in shows up as one booking with one total, with the underlying payment method breakdown still available for anyone who needs that level of detail specifically.
None of this requires touching a formula or building a spreadsheet. It is generated automatically the moment the period is selected, from the same booking and payment data already flowing through the account for every reservation.
Frequently asked questions
What period can a revenue and occupancy report cover?
Any period: last week, last month, last quarter, or a custom date range chosen directly.
Does the report update in real time or only at month end?
It is generated on demand for any period, including the current month in progress, so it does not need to wait until the month closes.
How is occupancy calculated?
Room nights sold divided by room nights available for the selected period, based on the property’s actual room count.
What counts as revenue, the booking date or the stay date?
Revenue is counted against the stay date, not the date the booking was made, so seasonality is reflected accurately.
Can I break revenue down by room type?
Yes, every report includes a room type breakdown showing nights sold, average rate and revenue for each.
Does the report reconcile payouts automatically?
Yes, gross revenue is checked against fees, refunds and the amount that reached the bank account, with mismatches flagged.
What happens if a payout does not match?
The specific period is flagged as under review, with enough detail to trace the discrepancy without rebuilding it manually.
Can I export the report?
Yes, any period can be downloaded as a spreadsheet, ready for an accountant, a GST filing or a loan application.
Who can see the full revenue and occupancy report?
By default, the Owner role sees full revenue and payout detail, and a Manager sees enough to run the property without full financial detail, under staff logins with roles.
Does this work for a property with multiple room types?
Yes, the breakdown by room type is included automatically for any property with more than one room type set up.
Can I compare this month against the same month last year?
Yes, any two periods can be compared directly, including year over year.
Does the report include cancellations and refunds?
Yes, cancellations and refunds are reflected in the revenue figures for the period they affected, not hidden from the total.
Is there a separate report for each property in a group?
Yes, a group account sees both a combined portfolio view and the ability to open any single property’s report on its own.
How far back does the reporting history go?
Reporting history goes back to the property’s first booking on OpenStays, so a full year or more of comparison is available as the account matures.
Does the report account for payment gateway fees?
Yes, gateway fees are included in the payout reconciliation, so gross revenue and actual payout can be compared honestly.
Can I share a report with a co-owner or accountant who does not use OpenStays daily?
Yes, an exported report can be shared as a spreadsheet with anyone who needs it, without giving them full account access.
What changes in the first month
The first report an owner opens is usually the most eye opening, because it is the first time revenue, occupancy and payout have all sat in one place at once, rather than three separate mental estimates. Most owners spend the first few minutes simply comparing it against what they expected, and are mildly surprised in one direction or the other.
The first genuinely useful moment usually comes at the end of the first full month, when there is finally a previous period to compare against. A single month of data tells you what happened, two months start to tell you whether it is a trend.
Payout reconciliation tends to matter earliest for properties on a payment gateway with per-transaction fees, where a small shortfall is easy to lose in the noise of daily bookings but obvious the moment a monthly total is checked against what actually arrived.
By the second or third month, checking the report becomes a five minute habit rather than an event, glance at the headline numbers, confirm the payout matches, note anything that shifted meaningfully from last month. The evening spent rebuilding a spreadsheet by hand stops happening at all.
For a property that has been running for a while before adopting this, the first report can also surface a year or more of history it never had a clean view of before, letting an owner finally see a full season, not just the month currently ending. That retrospective view tends to be where the more useful insights show up first, not in the current month, but in finally being able to compare this season honestly against the last one.
Owners who make the switch usually describe the same shift: less time spent reconstructing what already happened, and more time spent deciding what to do about it, a rate to adjust, a room type to promote, a payout question worth a short email before it becomes a bigger one.
See exactly what your property made, every month
No setup fee, no commission. Your first revenue and occupancy report is ready the moment your first booking is.