Skip to content

Free download

Get Hotel Budget by Department

The full hotel budget with made-up sample data to start from. Leave your name and work email and the download button appears right away.

  • Plain Excel. No macros, no add-ins.
  • Twelve months, the budget year and last year, line by line.
  • The summary prints on one landscape page.
  • Sample data from a made-up 80-room hotel to start from.
Free Excel templatePlanningHospitality

Free hotel budget template

Build next year's hotel budget from the drivers, not last year plus a percentage.

Most hotel budgets start as last year's P&L plus a percentage. This template builds the budget the way operators think. You enter occupancy and ADR by month for transient, group and contract business, covers and average checks by outlet, and the cost drivers of each department. It builds a monthly departmental P&L down to GOP and EBITDA, compares every line with last year and shows what a change in occupancy or rate does to GOP.

Free · Excel

The top of the Budget Summary tab in Hotel Budget by Department for the made-up Larch Bay Hotel: all 12 checks pass, the budget headline and what-if line, twelve KPI tiles from occupancy to EBITDA, the USALI-style summary against last year and RevPAR by month, on sample data.

Highlights

  • Two points of occupancy for eight dollars of rate?

    Two what-if levers run a second P&L next to the budget, with every cost driver kept, so you see the flow-through to GOP and EBITDA. In the sample, the higher rate more than pays for the lost occupancy.

  • The budget on one page

    Twelve KPI tiles from occupancy, ADR and RevPAR to GOPPAR, CPOR, payroll as a share of revenue and EBITDA, and a USALI-style summary against last year with traffic lights.

  • Twelve checks before the owner sees it

    Occupancy never over 100%, last year complete and reconciled to your ledger and PMS, totals that tie and GOP rebuilt line by line. They prove the model adds up, not that the assumptions are right.

Why build a hotel budget from drivers?

A hotel budget built from drivers shows why the numbers move. Rooms revenue is rooms sold times rate by segment, F&B is covers times average check by outlet, and costs move with occupied rooms or revenue. Last year plus a percentage hides all of that.

Drivers also answer the questions owners ask. Change a driver and the departmental P&L, the KPIs and the comparison with last year all update, so the answer to a what-if is one step away.

Where hotel CFOs and controllers use it

  • The annual budget cycle, built from drivers and presented to the owner or asset manager on one page.
  • Owner and management company talks about what a rate or occupancy change does to GOP and to the base and incentive fees.
  • Re-running the budget mid-year with updated drivers, compared with last year line by line.
  • Board and investor packs, with the Budget Summary printed on one landscape page.

What's inside

Six tabs. On the working tabs only the blue cells are inputs, everything else is a formula.

  1. About Vena and MCC

    Who built the template, and what changes when the same budget runs in Vena.

  2. Use with AI

    Eleven ready-made prompts for the AI assistant your company already uses, and a context block that tells the AI how the file works.

  3. Budget Summary

    The headline, the what-if line, twelve KPI tiles, the USALI-style summary against last year and the what-if, RevPAR and GOP by month, and the twelve checks.

  4. Assumptions

    Every budget input in nine sections. Property and settings, what-if levers, rooms by month, F&B, other income, department cost drivers and FTEs, undistributed costs, fees and costs below GOP, and the budget status, GOP margin target and traffic-light thresholds.

  5. Departmental P&L

    Twelve budget months, the budget year, last year and the change, plus the what-if months and year, down to GOP, EBITDA and EBITDA less FF&E reserve. A labour memo shows payroll and FTEs by department.

  6. Prior Year

    Last year by month, actual months and latest forecast, on the same rows as the P&L, plus a block that reconciles the year to your ledger and PMS totals.

One file, the whole budget

Enter the drivers on Assumptions and last year on Prior Year. The P&L and the summary build themselves.

  • Hotel Budget by Department

    The yearly operating budget for one hotel with rooms, F&B and events.

    Rooms by segment, a restaurant, a bar and banqueting, other operated departments, five undistributed lines, the base and incentive management fees, property taxes, insurance, rent and the FF&E reserve. The incentive fee follows the basis in your management agreement: monthly GOP, annual GOP or annual GOP above the owner's priority. EBITDA less FF&E reserve is an operating measure, not cash flow.

    Tabs

    • About Vena and MCC
    • Use with AI
    • Budget Summary
    • Assumptions
    • Departmental P&L
    • Prior Year

How to use it

  1. Step 1: Load last year

    Paste last year's figures into the Prior Year tab, then type five year totals from your ledger and PMS so last year reconciles.

  2. Step 2: Set the drivers

    Occupancy and ADR by month and segment, covers and checks, cost drivers, FTEs, undistributed costs and fees on Assumptions.

  3. Step 3: Test a what-if

    Move the occupancy and rate levers and read the flow-through to GOP and EBITDA on the Budget Summary.

  4. Step 4: Read the checks

    All twelve should show OK before the budget goes to the owner. A red banner appears if the GOP margin falls below your target.

Use it with AI

The file comes with a Use with AI tab. Attach a copy of the file to the AI assistant your company allows, paste a prompt and fill in the brackets. Each prompt tells the AI to read the tab first, so it knows how the file works and what not to break.

  • Eleven ready-made prompts, from setting the file up for your hotel and loading last year from your reports to writing the budget commentary and reviewing it like an owner.
  • A check of your management agreement's fee terms against the fee settings in the file.
  • AI can be wrong. Check its numbers against the file and keep all twelve checks showing OK before you share anything.

Questions about the template

Is the hotel budget template really free?

Yes. Leave your name and work email and the download appears right away. The file is yours to keep and change.

Do I need Vena to use it?

Not to start. The hotel budget template runs in plain Excel, with no macros and no add-ins. Vena comes in when department heads enter their own drivers, approvals are needed, or several properties and monthly actuals from the PMS and the ledger have to live in one place.

Is it the full USALI reporting package?

No. The template is a USALI-style summary down to GOP, EBITDA and EBITDA less FF&E reserve, with a departmental P&L for rooms, food and beverage and other operated departments. It does not include every departmental schedule.

Does it work out the management incentive fee?

Yes. Pick the basis from your management agreement (monthly GOP, annual GOP or annual GOP above the owner's priority) and set the rate. A check confirms the year's fee matches the basis.

Can I use it with ChatGPT, Claude or Copilot?

Yes. The Use with AI tab has eleven ready-made prompts and a context block for any AI assistant your company allows. Check the AI's numbers against the file before you use them.

Is the sample data real?

No. Larch Bay Hotel, a made-up 80-room hotel, and its numbers are made up, so you can see how the budget works before you type in your own.

The company, customers and figures in this template are made-up sample data. MCC is an independent Vena partner.

Last updated

From a spreadsheet to a process you can trust

When department heads need to enter their own drivers, or several hotels and monthly actuals from the PMS and the ledger come in, MCC can set the same budget up in Vena for you.

Talk to our team
  1. 1

    Use this template

    Free, in plain Excel. Change the blue inputs and the rest updates.

  2. 2

    Have MCC set it up in Vena

    Keep the Excel layout, and add one Vena data model, approvals and an audit trail. We build it and check that it ties.

  • The top of the Summary tab in Hotel Renovation and Expansion Budget for the made-up Larch Bay Hotel, 80 rooms today and 120 after: all 13 checks pass, a one-line verdict and twelve tiles from total project cost and equity to return on cost, IRR, NPV, payback and DSCR, on sample data.
    • Hospitality
    • Planning

    Hotel Renovation and Expansion Budget

    Is the renovation worth it? Renovate against doing nothing, month by month for 10 years, with closure, ramp-up, the loan, equity returns and seven stress tests.

    Free · ExcelDownload free

  • The top of the Summary tab in the Three-Statement Driver Model for a made-up Sample Company: nine model checks all OK, two plan years side by side with profit and cash figures, and a chart of closing cash against the revolver and the minimum cash line, on sample data.
    • Planning
    • Forecasting
    • Cash

    Three-Statement Driver Model

    Your P&L, balance sheet and cash flow linked month by month for 24 months. Change a driver and profit, working capital, cash and the revolver all move together.

    Free · ExcelDownload free

  • The top of the Weekly Report tab in the 13-Week Cash Flow Forecast for the made-up Brightwater Distribution Co.: six summary tiles, then weeks 1 to 13 side by side with receipts, payments and total, on sample data.
    • Cash
    • Forecasting

    13-Week Cash Flow Forecast

    See every week of cash for the next quarter, when you'll touch the credit line, and whether the bank statement agrees. Two versions, Weekly or Weeks + Months.

    Free · Excel, 2 versions: Weekly and Weeks + MonthsDownload free

Got a problem a template doesn't cover?

Talk to our team about it. Not ready for a call? Watch the Finance Speedrun and see how we solve a real finance problem live every week.