Hotel Daily Revenue Report Template (Occupancy, ADR, RevPAR)

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.

1. Hotel and budget

2. Daily figures from the night audit

DateOut of orderRooms sold (paid)Comp roomsRoom revenue ($)F&B revenue ($)Other revenue ($)

One row per night. Room revenue is net of lodging taxes and before F&B. Comp rooms are free stays and are not counted as sold. The report covers the month of the report date, from the 1st to that date. Your data stays in your browser. Nothing is sent to our server unless you choose to save it to your account.

3. Daily revenue report

Today, month to date and budget

Daily occupancy this month

Sun–Thu nightFri–Sat nightBudget occupancy

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

  1. 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.
  2. 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.
  3. 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.
  4. Change the report date on Setup and print or PDF the Daily Report sheet for the owner or GM.
  5. 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:

MetricTodayMonth to dateBudget MTDVariance
Rooms available425885880
Rooms sold (paid)32437423+14
Occupancy76.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)OccupancyADRRevPAR
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 SUMIFS from 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/MATCH on 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.

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.