Hotel Monthly Report Template

What should a hotel monthly report template include?

A hotel monthly report template should show the month’s commercial result, operating profit, guest and team performance, risks, and the decisions requested from management or the board. Start with a one-page executive summary, then support it with rooms, revenue, departmental, cost, maintenance and forward-booking pages.

For a practical monthly close, use the same reporting period across every source: for example, June 1–30, 2026. Freeze PMS room statistics after night audit, reconcile room revenue to the general ledger, reconcile food and beverage revenue to POS settlement, and state whether figures are actual, budget, prior year or forecast.

Use this 10-part hotel monthly report structure

• Executive summary: three wins, three misses, month-end cash or profit headline, and decisions required.
• Rooms dashboard: available rooms, rooms sold, occupancy, ADR, RevPAR, cancellations and no-shows.
• Revenue mix: rooms, food and beverage, meetings and events, spa or other outlets, with actual versus budget and prior year.
• Profitability: gross operating profit, GOP margin, GOPPAR, payroll and undistributed expenses.
• Channel and segment mix: direct, OTA, GDS, corporate, group, wholesale and walk-in production.
• Guest experience: review score, complaints, service recovery cases and top recurring themes.
• Operations: housekeeping productivity, maintenance backlog, utility use and major incidents.
• People: headcount, payroll, overtime, turnover, training and open roles.
• Forward view: next 90 days on-the-books occupancy, group pace, demand dates and pricing actions.
• Action log: owner, deadline, expected financial or service impact, and status.

Which hotel KPIs belong in a monthly management report?

Put occupancy, ADR, RevPAR, total revenue, GOP, GOP margin and GOPPAR on the first dashboard. SiteMinder’s May 29, 2026 RevPAR guide defines RevPAR as total room revenue divided by total available rooms; Cvent’s February 13, 2026 GOPPAR guide defines GOP as hotel revenue less operating expenses.

Keep numerator and denominator consistent. A 120-room hotel open for 30 days has 3,600 available room nights. If 2,700 rooms are sold for 405,000 dollars of room revenue, occupancy is 75.0%, ADR is 150.00 dollars, and RevPAR is 112.50 dollars. The check is simple: 150.00 dollars multiplied by 75.0% equals 112.50 dollars.

How do you fill out a hotel monthly report template?

Use this worked June example for a 120-room hotel open 30 days. It is a copy-and-do illustration rather than market benchmark data: 3,600 available rooms, 2,700 rooms sold, 405,000 dollars of room revenue and 540,000 dollars of total hotel revenue.

Write the executive summary from the table, not around it: “June occupancy exceeded budget by 3.0 points and room revenue beat budget by 3,240 dollars. ADR missed budget by 5.00 dollars, and operating expenses exceeded budget by 9,100 dollars, reducing GOP by 4,100 dollars. The July action is to review overtime and linen cost by department by July 10.”

Five monthly close steps

• Day 1: export final PMS room nights, room revenue, cancellations and segment data after night audit.
• Day 2: reconcile PMS room revenue, POS outlet revenue and payment settlements to the accounting ledger.
• Day 3: compare actuals with approved budget, prior-year same month and latest forecast; explain every material variance.
• Day 4: collect departmental commentary from rooms, food and beverage, sales, engineering and human resources.
• Day 5: obtain general manager sign-off, publish the management pack, and track actions at the next operating meeting.

What is the difference between a hotel management report template and a hotel board report template?

A hotel management report template is an operating pack: it contains detailed departmental measures, exceptions and named actions. A hotel board report template is a shorter governance pack: it focuses on results versus plan, forecast, capital items, material risks and decisions. Use the same verified monthly numbers, but change the level of detail.

For the board version, condense June’s worked example to four messages: revenue was 5,000 dollars above budget; GOP was 4,100 dollars below budget; the profit miss came from 9,100 dollars of excess operating expense; and management requests approval or acknowledgement of the July cost-control action. Put source schedules behind the board pack, not in the opening pages.

How do you turn a hotel monthly report template into an annual report?

Create the annual hotel report by stacking the 12 closed monthly reports and adding a full-year comparison. Keep the definitions fixed from January through December so that annual occupancy, ADR, RevPAR, GOP and GOPPAR are comparable rather than an average of mismatched calculations.

For annual occupancy, divide total rooms sold for the year by total available rooms for the year. For annual ADR, divide annual room revenue by annual rooms sold. For annual RevPAR, divide annual room revenue by annual available rooms. Do not calculate annual ADR or RevPAR by simply averaging 12 monthly percentages or rates unless each month has identical room inventory and days.

Annual report additions

• A 12-month line for occupancy, ADR, RevPAR, total revenue, GOP and GOPPAR.
• Actual versus annual budget and actual versus prior year for every headline metric.
• Peak and low months, with an explanation tied to group business, events, seasonality, closures or pricing.
• Full-year segment and channel mix, including commission impact where it is booked.
• Capital expenditure completed, deferred or requested, with approved amount, actual amount and expected completion date.
• Year-end forecast or approved plan for the next year.

If you use STR benchmarking, label the comparison precisely. Lighthouse’s May 12, 2025 STAR report guide describes STR reports as comparisons of a hotel’s occupancy, ADR and RevPAR against a selected competitive set. Show the reporting period, comp-set definition and index basis; do not imply that an internal budget is a market benchmark.

How can AnyGen create a hotel monthly report template from your monthly close?

Use AnyGen when you have the monthly close inputs but need a consistent hotel monthly report template for owners, managers or a board. Provide your closed PMS, accounting, budget and department figures; then use the report structure on this page to turn those inputs into an editable management or board pack.

Prepare these four inputs before generating

• Rooms data: available rooms, rooms sold, room revenue, cancellations, no-shows, channel and segment production.
• Financial data: total revenue by department, operating expenses, budget, prior year and forecast.
• Operating data: review score, complaints, payroll or overtime, maintenance tickets, utility or linen exceptions.
• Management commentary: the top three results, top three risks, requested decisions, owners and due dates.

Prompt with the actual reporting period and numbers, for example: “Create a June 2026 hotel monthly management report for a 120-room hotel. Use 3,600 available rooms, 2,700 rooms sold, 405,000 dollars room revenue, 540,000 dollars total revenue, 405,000 dollars operating expenses, 135,000 dollars GOP and the budget comparison in this template. Include an executive summary, KPI dashboard, variance table, operations actions and a board summary.” Review every calculation against the closed ledger before distribution.

Frequently asked questions