Hotel Budget Template

Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Monthly Budget sheet: review the pre-loaded revenue and expense categories and adjust any line items that don't match your property's setup. Most hotels keep the USALI department structure as-is and add or rename a few specific line items (like a particular F&B outlet or a branded amenity fee). Set your ADR and occupancy targets for the year in the input cells at the top — room revenue will calculate automatically from there.

Once the structure is set, work through each month's expense budget. Use your prior year actuals as a baseline if you have them, or industry benchmarks if you're in the planning phase. Labor is usually the biggest budget exercise: enter headcount and average wages by department rather than guessing a lump sum. The template tracks labor as a percentage of departmental revenue so you can see immediately if your rooms labor ratio or F&B labor ratio is in line with where it should be. Fill in OTA commission rates for your major channels and the sheet deducts them from net room revenue automatically.

The real value comes from the monthly Budget vs Actual comparison. After each month closes, enter your actual figures from your PMS or accounting system — it typically takes 20–30 minutes once your books are reconciled. The variance sheet will show you exactly where you're over or under in each department, which drives your conversations with department heads. Most hotel GMs who use this template review it in their monthly department manager meetings, then share the Dashboard tab with ownership or the asset management company as part of their monthly reporting package.

Hotel budgeting is more complex than most business types because revenue has two independent variables — ADR and occupancy — and expenses are spread across multiple departments that each need their own profit tracking. A restaurant has food cost and labor. A hotel has rooms labor, F&B labor, spa labor, maintenance, OTA commissions, franchise fees, and a dozen other line items that move differently depending on the season, the channel mix, and group business versus transient. Most operators who skip structured budgeting don't realize their F&B department is losing money until it's a systemic problem.

The hospitality industry uses a standardized accounting framework called USALI (Uniform System of Accounts for the Lodging Industry) for exactly this reason — it gives everyone a common structure for comparing departmental performance. A properly built hotel budget follows this structure: total operated departments (Rooms, F&B, Events, Spa, Other), undistributed expenses (Sales & Marketing, Property & Maintenance, Utilities, Admin & General), and fixed charges (Management Fees, Insurance, Depreciation). RevPAR — Revenue per Available Room — is the single most important top-line metric, and it only makes sense when paired with ADR and occupancy separately. A hotel running 90% occupancy at a low ADR is a different problem than one running 60% occupancy at a premium rate.

The budget works best when it drives department-level accountability. Rather than giving each head of department a single number to hit, break it into the categories they actually control: rooms managers control upsell revenue and labor scheduling, F&B managers control COGS and their department's labor, sales manages channel mix and OTA commission percentages. When the budget is structured around USALI departments, each manager owns a section of the spreadsheet and the GM can see at month-end exactly which department drove the variance — instead of trying to reverse-engineer a single P&L.