AnyGen
What should a hospitality report template include?
A useful hospitality report template is a repeatable operating document for a hotel, resort, restaurant, venue, or serviced accommodation business. It should show what happened during one stated period, why performance changed, and which owner, general manager, department head, or sales lead owns the next action.
For a hotel monthly report, start with six sections in this order: executive snapshot; rooms and revenue; departmental costs; guest experience; sales and market activity; and actions due next period. This order lets a reader see the result before reviewing the operational evidence behind it.
Use this six-section reporting structure
| Section | What to report | Decision it supports |
|---|---|---|
| Executive snapshot | Period, occupancy, ADR, RevPAR, total revenue, operating result, and top three variances | Where leadership should focus first |
| Rooms and revenue | Available rooms, rooms sold, room revenue, channel mix, cancellations, group and transient pace | Rate, inventory, and channel decisions |
| Departmental costs | Payroll, F&B cost, utilities, maintenance, commissions, actual versus budget | Cost control and staffing decisions |
| Guest experience | Review score, response time, recurring complaint themes, recovery cases | Service recovery and quality priorities |
| Sales and market activity | Leads, site inspections, proposals sent, group pipeline, competitor-set comparison where available | Commercial follow-up and target accounts |
| Actions and owners | Action, owner, due date, success measure | Accountability before the next report |
Which KPIs belong in a hotel hospitality report template?
Occupancy, average daily rate, and revenue per available room are the core rooms KPIs. CoStar’s STR Benchmark guidance identifies occupancy, ADR, and RevPAR as the three top-line measures used in hotel benchmarking; use them together because a full hotel can still underperform if the achieved rate is too low.
Occupancy measures rooms sold as a share of available rooms. ADR measures room revenue earned on sold rooms. RevPAR measures room revenue across every available room, sold or unsold. Record rooms out of order separately so a reader can reconcile operational inventory with the available-room denominator used in the report.
Copy these formulas into your report
| KPI | Formula | Worked example |
|---|---|---|
| Occupancy | Rooms sold ÷ available rooms × 100 | 1,860 rooms sold ÷ 2,400 available rooms × 100 = 77.5% |
| ADR | Room revenue ÷ rooms sold | $334,800 room revenue ÷ 1,860 rooms sold = $180.00 |
| RevPAR | Room revenue ÷ available rooms, or ADR × occupancy | $334,800 ÷ 2,400 = $139.50; $180.00 × 77.5% = $139.50 |
| Room revenue variance | Actual room revenue − budget room revenue | $334,800 actual − $345,000 budget = −$10,200 |
| Budget variance percent | (Actual − budget) ÷ budget × 100 | ($334,800 − $345,000) ÷ $345,000 × 100 = −3.0% |
In the worked example, the property sold 1,860 of 2,400 available room nights during a 30-day period, achieved $180.00 ADR, and generated $139.50 RevPAR. If the budget was $345,000 in room revenue, the report should separate whether the gap came from fewer rooms sold, a lower ADR, or both.
How do you write a monthly hospitality report with real numbers?
Write the monthly report as a short decision record, not a data dump. Begin with a one-paragraph result, then show the calculation table, the variance explanation, and a named action. The example below uses one internally consistent 80-room hotel scenario for a 30-day month, or 2,400 available room nights.
Executive snapshot example
July result: occupancy was 77.5%, ADR was $180.00, and RevPAR was $139.50. Room revenue was $334,800 against a $345,000 budget, a negative variance of $10,200 or 3.0%. The property was 2.5 percentage points below an 80.0% occupancy budget, while ADR was $3.75 above a $176.25 budget. The primary issue was room nights sold rather than achieved rate.
| Metric | Actual | Budget | Variance | Management note |
|---|---|---|---|---|
| Available room nights | 2,400 | 2,400 | 0 | Inventory unchanged |
| Rooms sold | 1,860 | 1,920 | −60 | Occupancy gap drove revenue shortfall |
| Occupancy | 77.5% | 80.0% | −2.5 points | Review need dates and group wash |
| ADR | $180.00 | $176.25 | +$3.75 | Rate held above budget |
| RevPAR | $139.50 | $141.67 | −$2.17 | Lower occupancy outweighed ADR gain |
| Room revenue | $334,800 | $345,000 | −$10,200 | Prioritize 60 additional room nights |
Turn the variance into actions
- Revenue manager: review the 10 lowest-occupancy dates within 48 hours; test fenced offers only where forecast occupancy remains below 75%.
- Sales manager: contact the five most recent unconverted group enquiries; record decision date, lost reason, and next follow-up in the pipeline.
- Front office manager: audit all July cancellations and no-shows by booking channel; report the count and estimated lost room revenue next month.
- General manager: close the report with three actions only, each carrying an owner, due date, and measurable outcome.
How should a hospitality report cover guest feedback and operating costs?
Guest feedback and operating costs belong beside rooms performance because revenue alone does not explain the quality or profitability of a stay. Keep each metric traceable to its source system: PMS for room nights and revenue, accounting system for expenses, review platform or survey tool for feedback, and CRM for sales activity.
For guest experience, report the review score, number of reviews, response rate, average response time, and the three most frequent themes. A monthly statement such as “review score fell” is incomplete; write “32 reviews averaged 4.3 out of 5, versus 4.5 out of 5 in June; 11 reviews mentioned breakfast wait time, compared with 4 in June.”
| Area | Minimum evidence | Example management question |
|---|---|---|
| Guest feedback | Review count, average score, response rate, top three themes | Which recurring issue can be removed before next month? |
| Payroll | Actual payroll, budget payroll, variance dollars and percent, hours where available | Did staffing rise with occupancy or independently of demand? |
| Food and beverage | Revenue, cost of sales, covers, average check, waste or voids where tracked | Did cost rise faster than revenue? |
| Maintenance | Open work orders, overdue work orders, room downtime, urgent incidents | Which defect risks taking rooms out of inventory? |
| Sales pipeline | Qualified leads, proposals sent, value, conversion, lost reasons | Which proposal needs follow-up before its decision date? |
Use an exception rule to keep the report short: explain any cost line that differs from budget by more than 5% or by more than a dollar threshold your property sets. State the rule in the report header, apply it every month, and show both the dollar and percentage variance so a small base does not create a misleading percentage.
How do you write a hospitality business proposal from a hospitality report?
A hospitality business proposal uses the same evidence as the report, but changes the reader’s question from “what happened?” to “why should we approve or book this?” Whether the audience is an owner, lender, event client, corporate account, or management company, make the proposal specific about the offer, scope, commercial terms, and expected outcome.
Proposal Kit’s 2026 hospitality proposal guidance calls for a clear hotel vision, mission, unique selling proposition, and marketing plan with SMART goals. For a practical hotel sales proposal, Typsy’s hotel sales guidance emphasizes that the prospective client needs the booking processes and costs. Use both principles without burying the client in generic brand language.
Use this seven-part hospitality business proposal structure
| Proposal section | What to write | Concrete example |
|---|---|---|
| Client need | Event, stay, operating challenge, dates, attendance, or target guest | Three-night leadership meeting for 40 delegates |
| Recommended solution | Rooms, meeting space, food and beverage, service level, and differentiator | 40 rooms nightly, one boardroom, breakfast, and two hosted dinners |
| Scope and schedule | Arrival, departure, setup, service moments, and decision deadlines | Arrival October 12; boardroom setup by 16:00; departure October 15 |
| Commercial summary | Rate, quantity, tax treatment, deposits, concessions, and total | 120 room nights at $180 equals $21,600 before applicable taxes and fees |
| Evidence | Relevant report results, guest feedback, delivery capability, or prior outcome | July ADR held at $180 while occupancy reached 77.5% in the worked report example |
| Terms and assumptions | Expiry date, attrition, cancellation, payment timing, exclusions | Proposal valid for seven calendar days; final terms subject to signed agreement |
| Next step | Named contact, deadline, and required approval | Confirm room block by 17:00 on August 14 to hold the proposed inventory |
Check every total before sending. In the example, 40 rooms for 3 nights equals 120 room nights, and 120 multiplied by $180 equals $21,600. If breakfast is $25 per person for 40 delegates across 3 days, the separate breakfast line is 40 × 3 × $25 = $3,000. Show exclusions instead of silently assuming them.
How can AnyGen create a hospitality report template?
Use AnyGen when you have the source numbers but need a clean, editable hospitality report template or proposal quickly. Paste a reporting period, available rooms, rooms sold, room revenue, budget figures, guest-review themes, and action owners; then ask for the exact six-section report structure used on this page.
For the 80-room, 30-day worked example, provide 2,400 available room nights, 1,860 rooms sold, $334,800 room revenue, and $345,000 room-revenue budget. Ask AnyGen to calculate occupancy, ADR, RevPAR, dollar variance, and variance percent, and to preserve the formulas beside the results for an audit-friendly management review.
Copy this input checklist
- Reporting period, property name, property type, and number of rooms or covers.
- Actual and budget values for available rooms, rooms sold, room revenue, payroll, F&B revenue, F&B cost, and maintenance.
- Guest feedback count, average score, response rate, and the three most repeated themes.
- Sales leads, proposals sent, pipeline value, conversion, lost reasons, and dated follow-ups.
- Three required actions, each with one owner, one due date, and one success measure.
- For a business proposal: client name, dates, attendee count, rooms, meeting space, rates, fees, terms, and expiry date.
Frequently asked questions
What is a hospitality report template?
A hospitality report template is a repeatable weekly or monthly format for reporting operational results. For hotels, it normally includes occupancy, ADR, RevPAR, revenue, cost variances, guest feedback, sales pipeline, and owner-assigned actions.
What should be in a hotel monthly report template?
Include an executive summary, rooms and revenue KPIs, actual-versus-budget variances, departmental costs, guest experience, sales activity, and an action log. State the reporting period and the source system for each KPI.
How do I calculate occupancy in a hospitality report?
Divide rooms sold by available rooms and multiply by 100. For example, 1,860 rooms sold divided by 2,400 available room nights equals 77.5% occupancy.
How do I calculate ADR and RevPAR in a hotel report?
ADR equals room revenue divided by rooms sold. RevPAR equals room revenue divided by available rooms, or ADR multiplied by occupancy. With $334,800 revenue, 1,860 rooms sold, and 2,400 available rooms, ADR is $180.00 and RevPAR is $139.50.
What is the difference between ADR and RevPAR?
ADR measures the achieved average rate on rooms sold. RevPAR spreads room revenue across all available rooms, including unsold inventory. RevPAR therefore shows the combined effect of price and occupancy.
How often should a hospitality report be produced?
Use daily flash reporting for immediate operations, weekly reporting for pace and staffing decisions, and a monthly management report after finance and PMS figures are reconciled. Keep definitions and comparison periods consistent across each cadence.
How do I write a hospitality business proposal?
Write seven sections: client need, recommended solution, scope and schedule, commercial summary, evidence, terms and assumptions, and next step. Check quantity math line by line; for example, 40 rooms for 3 nights equals 120 room nights.
Can I use a hospitality report template for a hotel proposal?
Yes. Use the report’s verified performance evidence in the proposal, but separate historical results from promised commercial terms. A report explains performance; a proposal explains the offer, price, conditions, and approval step.