Every morning after the night audit, someone at a hotel has to answer the same questions: how full were we last night, what rate did we get, and are we on track for the month? A hotel daily revenue report answers them on one page. Large chains get it from their property management system (PMS) and a revenue team. A 20- to 80-room inn, motel or B&B often ends up copying numbers from the PMS into a spreadsheet anyway, because the owner wants a one-page summary, with a budget line, that doesn’t change every time the software does.
This page gives you a free hotel daily revenue report template in Excel. You enter one row per night, and it calculates occupancy, ADR, RevPAR and TRevPAR for the day and month to date, compares them with your budget, and splits weekday and weekend nights. There’s also an online version you can fill in right here. Below it we walk through a worked example and explain every formula.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. One workbook per month (up to 31 days), with a printable daily report, a daily occupancy chart and a month-end pace line.
Free online hotel daily revenue report calculator
Enter your total rooms, the report date and your budget occupancy and ADR. Then add one row per night: rooms out of order, rooms sold, comp rooms, room revenue, F&B and other revenue. You can also click Load example. The report shows today, month to date, budget and variance side by side, along with a daily occupancy chart, a weekday vs. weekend split and a month-end pace. You can print it, save it as a PDF, download it as Excel, Word or CSV, or email a link to the owner or your bookkeeper.
3. Daily revenue report
Today, month to date and budget
Daily occupancy this month
Weekday vs. weekend (MTD)
Month-end pace
Day by day
Occupancy = rooms sold ÷ rooms available. ADR = room revenue ÷ rooms sold. RevPAR = room revenue ÷ rooms available (= occupancy × ADR). TRevPAR = total revenue ÷ rooms available. Month-to-date figures are totals divided, not averages of daily percentages. Prepared by: ______________ Reviewed by: ______________
Made with the free hotel daily revenue report tool at bookkeepingsheets.com
What is a hotel daily revenue report?
A hotel daily revenue report (also called a daily flash report or manager’s report) is a one-page summary of the previous night’s results, produced after the night audit closes the day. It usually shows three columns: today, month to date (MTD) and budget, sometimes with last year added. Rows cover rooms available and sold, the three core statistics (occupancy, ADR and RevPAR) and revenue by department.
It is not the same as the daily cash report. The revenue report is about what the hotel earned (room nights and charges posted to guest folios). The cash report is about what it collected (cash, cards, direct bills) and whether the deposit matches. You need both, and they reconcile through guest ledger and city ledger balances.
The key hotel metrics, in plain English
- Rooms available: the rooms you could have sold that night. Under the Uniform System of Accounts for the Lodging Industry (USALI), which most US hotels and STR/CoStar benchmarks follow, out-of-order rooms stay in rooms available. Only rooms taken out of the inventory for a long time (seasonal closure, permanent house use) come out. The template follows that by default, but you can switch it off if your owner wants occupancy on sellable rooms.
- Occupancy = rooms sold ÷ rooms available. Complimentary rooms are not “sold”, so they are shown separately as occupancy including comps.
- ADR (average daily rate) = room revenue ÷ rooms sold. It’s the average price you got per paid room night.
- RevPAR (revenue per available room) = room revenue ÷ rooms available, which is the same as occupancy × ADR. It’s the single best number for “how did the rooms do”, because filling the hotel at a low rate and charging a high rate to an empty hotel both show up in it.
- TRevPAR (total revenue per available room) = rooms + F&B + other revenue, divided by rooms available. It matters more if you have a restaurant, bar, parking or resort fees.
For context, CoStar and Tourism Economics’ August 2026 forecast put US hotel occupancy for 2026 at about 63%. Your own budget and your own comp set matter more than any national average, though.
What’s inside the template
- Start Here: instructions and the formulas in one place.
- Setup: hotel name, total rooms, the month, the report date, the out-of-order switch, budget occupancy and ADR, budget F&B and other revenue per occupied room, and your lodging tax rate.
- Daily Log: 31 rows with dates filled in automatically from the month. You enter out of order, rooms sold, comp rooms, room revenue, F&B and other revenue. The sheet calculates rooms available, occupancy, ADR, RevPAR, total revenue, TRevPAR and lodging tax collected. It shades Friday and Saturday nights, and a Check column flags rows where sold + comp + out of order is more than the hotel’s rooms, or where there are rooms without revenue (or revenue without rooms).
- Daily Report: the printable one-pager for the report date. It shows today, MTD, budget MTD, variance and variance %, the weekday vs. weekend split, the best and lowest RevPAR days, a month-end run-rate and a daily occupancy chart.
How to use it every morning
- Set up the month once. On Setup, enter your rooms, any date in the month, your budget occupancy and ADR, and your lodging tax rate. Save a copy of the file for each month.
- Take the numbers from the night audit. Your PMS’s manager or end-of-day report has rooms sold, comps, out of order and revenue by department. Use room revenue net of taxes: occupancy and sales taxes are money you collect for the city or state, not revenue.
- Fill in one row in Daily Log. If a day is missing, the report counts it as empty rooms and tells you how many days are missing.
- Change the report date on Setup and print or PDF the Daily Report sheet for the owner or GM.
- Check the variance column. If RevPAR is behind budget, look at which part is behind: occupancy (demand, distribution, reviews) or ADR (discounting, channel mix).
Worked example: a 42-room inn, October 1–14
Harborview Inn has 42 rooms. The budget for October is 72% occupancy at a $142 ADR, so budget RevPAR is 72% × $142 = $102.24. Here is the daily report for Wednesday, October 14, the 14th day of the month:
| Metric | Today | Month to date | Budget MTD | Variance |
|---|---|---|---|---|
| Rooms available | 42 | 588 | 588 | 0 |
| Rooms sold (paid) | 32 | 437 | 423 | +14 |
| Occupancy | 76.2% | 74.3% | 72.0% | +2.3 pts |
| ADR | $135.15 | $142.66 | $142.00 | +$0.66 |
| RevPAR | $102.97 | $106.02 | $102.24 | +$3.78 |
| Room revenue | $4,324.80 | $62,341.20 | $60,117.12 | +$2,224.08 |
| Total revenue (rooms + F&B + other) | $5,024.80 | $73,891.20 | $70,277.76 | +$3,613.44 |
| TRevPAR | $119.64 | $125.67 | $119.52 | +$6.15 |
Month to date, the inn is $2,224 ahead of budget on room revenue, and almost all of it comes from occupancy (74.3% vs. 72%). ADR is right on budget. Comp rooms (6) and out-of-order rooms (8) don’t change rooms available, because the inn follows the USALI convention. The weekday vs. weekend split shows where the business comes from:
| Nights (Oct 1–14) | Occupancy | ADR | RevPAR |
|---|---|---|---|
| Sun–Thu (10 nights) | 65.5% | $130.16 | $85.23 |
| Fri–Sat (4 nights) | 96.4% | $163.87 | $158.01 |
Weekends are nearly full at a high rate, so there’s little upside left there. The opportunity is midweek: each extra point of Sunday–Thursday occupancy is worth more than squeezing a few dollars more out of Saturday. At the current pace, October room revenue lands at about $138,041 against a full-month budget of $133,116.
The formulas behind the report
- Rooms available (day):
=TotalRooms-IF(CountOOO="No",OutOfOrder,0) - Occupancy:
=RoomsSold/RoomsAvailable. ADR:=RoomRevenue/RoomsSold. RevPAR:=RoomRevenue/RoomsAvailable - Month to date: totals with
SUMIFSfrom the first of the month to the report date, for example=SUMIFS(dRoomRev,dDate,">="&MonthStart,dDate,"<="&ReportDate), then divided. MTD occupancy is total rooms sold ÷ total rooms available, not the average of the daily percentages. - Today:
INDEX/MATCHon the report date. - Budget MTD: rooms available = total rooms × days elapsed; rooms sold = that × budget occupancy; room revenue = budget rooms sold × budget ADR.
- Month-end pace: MTD room revenue ÷ days elapsed × days in the month. This is a straight line, not a forecast. For a real forecast, use the reservations already on the books in your PMS.
The template uses only INDEX/MATCH, SUMIFS and COUNTIFS (no XLOOKUP), so it works the same in Google Sheets and older Excel versions.
Common mistakes
- Averaging daily occupancy or ADR. A full Saturday and a half-empty Monday don’t average to the month’s ADR. Always add up rooms and revenue first, then divide.
- Counting comp rooms as sold. It lowers ADR and makes occupancy look better than paid demand. Track comps separately.
- Including taxes in room revenue. Lodging and sales taxes are a liability you pay to the tax office. The template shows tax collected on its own line so you can match it to your tax return.
- Dropping out-of-order rooms quietly. If you take rooms out of available, occupancy looks better. Decide on one method, write it down, and use the same one as your benchmark reports.
- Mixing up F&B and package revenue. If breakfast is included in the rate, decide whether you split it out. USALI generally moves the package value to F&B, but small hotels often leave it in rooms. Be consistent month to month.
- Not reconciling to the PMS and the bank. Once a month, tie room revenue to the PMS revenue report and to deposits. A bank reconciliation catches card batches that never settled.
Frequently asked questions
How do you calculate RevPAR?
RevPAR = room revenue ÷ rooms available. Using the example, $62,341.20 ÷ 588 = $106.02. You get the same answer from occupancy × ADR: 74.3% × $142.66 = $106.02.
Should out-of-order rooms be included in rooms available?
Under USALI and in STR/CoStar benchmarking, yes. Only long-term removals such as a seasonal closure or permanent house use come out. Some owners and PMS reports also show occupancy on sellable rooms. The template’s Yes/No switch lets you show either, but compare like with like.
Are complimentary rooms included in occupancy?
In headline occupancy, no: occupancy uses paid rooms sold. Comps are shown separately as occupancy including comps, so you can see how full the house really was.
What’s the difference between a daily revenue report and a daily cash report?
The revenue report shows what was earned (charges posted for the night). The cash report shows what was collected and deposited. A guest who checked out on a direct-bill account adds to revenue but not to cash, until the invoice is paid. For the cash side, use our daily cash report template.
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, dropdowns and checks carry over.
Related calculators and templates
- Small Business Bookkeeping Spreadsheet
- Monthly Bank Reconciliation Template
- 13-Week Cash Flow Forecast Template
- RevPAR, ADR and Occupancy Calculator
- Daily Cash Report Template
- Break-Even Calculator
- Airbnb Host Profit Calculator
This guide and template are for general record-keeping and information. They aren’t accounting or tax advice. Lodging tax rates and rules differ by state, county and city, and USALI definitions can be applied differently by owners, brands and lenders. For questions about your own property, talk to a qualified accountant or your local tax office.