Hotel Budgeting and Forecasting — Rooms, F&B and Payroll Worked Example

Hotel budgeting and forecasting starts with assumptions that department heads can verify. Room nights, room rates, restaurant covers and staffing costs explain why the latest forecast differs from the approved budget.

This worked example uses a fictional 100-room hotel in a 30-day month. Revenue excludes GST. The food and beverage figures cover one restaurant. Banquets and other outlets are outside the example.

1. Forecast rooms revenue from occupancy and rate

With all 100 rooms available each day, the hotel has 3,000 available room nights. Multiply available room nights by occupancy to estimate room nights sold, then multiply room nights sold by the average daily rate (ADR) to estimate rooms revenue.

Rooms revenue is forecast ₹4,05,000 above budget. The extra 150 room nights add ₹6,30,000 at the budget rate. The ₹100 lower rate reduces revenue by ₹2,25,000 across the 2,250 forecast room nights. Together, the volume and rate effects explain the change.

In a rolling forecast, use actual room nights and revenue for elapsed days. For the remaining dates, start with bookings on the books, estimate additional bookings and allow for cancellations. Check event dates and low-demand nights separately when expected rates differ materially. Record any rooms temporarily out of service and apply a consistent definition of available room nights when comparing the budget and forecast.

2. Forecast restaurant revenue from covers and average spend

Estimate the number of covers and multiply by average spend per cover. Review the assumptions by meal period if breakfast, lunch and dinner have different traffic or spend patterns.

Restaurant revenue is forecast ₹1,40,000 above budget. The extra 100 covers add ₹1,10,000 at the budget spend. The ₹20 higher spend adds ₹30,000 across all forecast covers.

Check the forecast against outlet sales, reservations and expected walk-ins. If a room package includes breakfast, follow the hotel’s revenue allocation policy so the breakfast component is counted once. Forecast banquets separately using expected event dates, guest counts and agreed package rates where applicable.

3. Forecast payroll from staffing and the roster

Start with scheduled pay and employer costs by department. Add expected overtime and temporary staffing costs within the hotel’s payroll reporting scope. Review joining dates, vacancies and shift coverage with department heads.

Payroll is forecast ₹1,00,000 over budget. Ask which departments need extra shifts and on which dates. Match the forecast to the roster so the reviewer can trace the additional cost to a staffing decision. If a temporary worker is invoiced through an agency, confirm where the cost is recorded before including it in the forecast.

Reconcile payroll actuals before updating the forecast

Check the payroll inputs against the approved roster, attendance and overtime records. Reconcile gross pay and employer contributions from the payroll register to the corresponding expense accounts in the general ledger. For agency staff, check invoices and accruals against the staffing costs included in the forecast.

Match net salary payable to the bank payment file and track held or rejected payments separately. Reconcile deduction and contribution balances to the corresponding liability accounts. Use reconciled payroll expense for elapsed dates, then estimate the cost of future shifts and any work already performed that still needs to be accrued. Check the ledger before adding an accrual to avoid counting the same cost twice.

For the ₹1,00,000 staffing increase in this example, record the extra shifts, expected rates and approval owner by department. At month-end, compare those assumptions with actual hours and agency charges and explain the difference. Payroll Reconciliation: Complete Process, Checklist & Journal Entries

4. Summarise the forecast for management

The final row measures the impact of the items in this example. Include food and beverage costs, distribution commissions, utilities and other operating costs in the hotel’s reporting format to forecast operating profit.

How to review a rolling hotel forecast

Keep the approved budget as the comparison point. Update the forecast with reconciled actuals for elapsed dates and the latest assumptions for the remaining dates. For each significant change, record the amount, the driver, the department owner and the date the assumption will next be reviewed.

Use the review to check whether changes in one department affect another. If the rooms team expects more guests on event dates, ask the restaurant about breakfast covers and housekeeping about extra shifts. Keep the explanation tied to the dates and volumes in the forecast so managers can verify the operational assumptions.

Before sending the report, check that rooms sold fit within available inventory, outlet covers are consistent with the sales assumptions, and staffing changes agree with the roster. Tie the actuals portion back to the daily reports and payroll records before explaining variances.

Related TaxNexus guides

Use reconciled daily revenue for the actuals portion of the forecast. Hotel Daily Revenue Reconciliation Checklist

Review room postings, guest-ledger balances and exceptions before closing the day. Hotel Night Audit — Worked Example and Checklist