Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityHospitality OperationsHotel Occupancy & Revenue Report

SpreadsheetHospitality OperationsFree

Hotel Occupancy & Revenue Report

Daily rooms sold and room revenue turned into occupancy, ADR and RevPAR for the period.

Shown with sample data

Colour

Hotel Occupancy & Revenue Report

Daily rooms sold and room revenue turned into occupancy, ADR and RevPAR for the period.

Occupancy
76%
ADR
$126.11
Average daily rate
RevPAR
$95.74
Revenue per available room
Room revenue
$36,572
Occupancy by night
Nov 2, 2026Nov 9, 2026

Latest: 63.8%

How to use it

  1. 1Enter one row per night.
  2. 2Use rooms available for sale, excluding rooms out of order.
  3. 3Compare weekday and weekend performance on the summary.
  4. 4Track RevPAR against the same period last year.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The three numbers every hotelier lives by, calculated for you. Enter rooms available, rooms sold and room revenue for each night; the sheet gives occupancy, average daily rate and revenue per available room by day, compares weekdays with weekends and totals the period.

Who it’s for

  • Daily and monthly revenue reports
  • Seeing whether to push rate or occupancy
  • Small properties without a revenue system

What’s included

  • Daily sheet: One row per night.
  • Summary by Day type sheet: Room revenue and the number of entries for each day type, calculated from the Daily sheet.

How to use it

  1. 1Enter one row per night.
  2. 2Use rooms available for sale, excluding rooms out of order.
  3. 3Compare weekday and weekend performance on the summary.
  4. 4Track RevPAR against the same period last year.

Questions

What is RevPAR?

Revenue per available room: room revenue divided by rooms available. It combines occupancy and rate, so it rises only when the mix of both improves.

Related searcheshotel occupancy reportrevpar calculatoradr average daily ratehotel revenue reporthotel kpi

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHospitality OperationsFree

Hotel Occupancy & Revenue Report

Daily rooms sold and room revenue turned into occupancy, ADR and RevPAR for the period.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More hospitality operations templates

View all
Recipe & Menu Costing Calculator2 sheets

Dishes costed

4

Average food cost

23%

Dishes above 35%

1

ABCD
1DishCategoryPortions per batchMenu price
2Tomato & basil soupStarter10$7.50
3Grilled chicken saladMain4$16.00
4Beef burger with friesMain4$13.00
5Chocolate brownieDessert12$6.50
Menu
SpreadsheetHospitality Operations

Recipe & Menu Costing Calculator

Cost every dish from its ingredients, see food cost percentage and margin, and get a price that hits your target.

10 min setupPreview
Vacation Rental Booking & Income Tracker2 sheets

Nights booked

30

Net income

$5,262

Average nightly rate

$169

Fees by platform
$309
$45.20
$38.40
Booking.comVrboAirbnb
SpreadsheetHospitality Operations

Vacation Rental Booking & Income Tracker

Bookings from every platform with nights, fees and net payout, plus occupancy and income for the season.

10 min setupPreview
Hotel Housekeeping Schedule2 sheets

Rooms to clean

6

Done

3

Early arrivals

2

ABCD
1RoomRoom statusPriorityHousekeeper
2101Check-outEarly arrivalRosa
3102Stay-overNormalRosa
4103Check-outNormalAhmed
5104Vacant cleanNormalN/A
Today
SpreadsheetHospitality Operations

Hotel Housekeeping Schedule

Assign rooms to housekeepers with room status, priority and inspection results.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ