Hotel Income Statement Template

Start with the Monthly Income Statement sheet. Enter your available rooms and occupied rooms at the top — these drive the ADR, RevPAR, and occupancy percentage calculations throughout. Then work through each revenue department: Rooms first, then Food & Beverage, then any operated departments like Spa or Parking. The departmental expense sections beneath each revenue block are pre-populated with standard cost categories; adjust the line item names to match your property's chart of accounts. Most hotel operators keep 80–90% of the categories as-is.

Once your revenue and departmental costs are entered, fill in the undistributed expenses section: administrative & general, sales & marketing, property operations & maintenance, and utilities. These are your overhead costs that aren't directly assigned to a single department. Below that, enter your fixed charges — management fees (typically entered as a percentage of total revenue), franchise fees if applicable, property taxes, insurance, and depreciation. The sheet calculates GOP and NOI automatically. Run the KPI Dashboard sheet to verify your ADR, RevPAR, and GOP% look reasonable before finalizing.

The real operational value comes from running this monthly and comparing to your budget. If you also have the hotel budget template, enter your planned figures there and this income statement captures your actuals — the variance between planned and actual GOP% is where most hotel managers focus their monthly review. Over time, the Annual Summary sheet becomes your primary reporting document for ownership, lenders, and management company reviews. Keep your prior-year figures in a separate column of the Annual Summary so year-over-year comparisons are always one sheet away.

Hotels measure profitability differently from almost any other business, and that difference matters when you're preparing financial statements for ownership review, bank covenants, or refinancing. The industry standard is USALI — the Uniform System of Accounts for the Lodging Industry — which organizes the income statement by department rather than by expense type. This format exists because hotel profitability is fundamentally driven by how each revenue center (Rooms, F&B, Events) contributes to the whole, and a generic P&L that lumps all labor or all revenue together makes it impossible to identify which departments need attention. A hotel that looks profitable on a simple P&L might be masking a loss-making F&B operation being subsidized by room revenue.

The key metrics that drive hotel financial management — ADR, RevPAR, GOPPAR, and GOP% — aren't vanity numbers. ADR tells you what you're charging; RevPAR tells you how well you're filling rooms at that price; GOPPAR (Gross Operating Profit per Available Room) tells you how efficiently your entire operation converts revenue into profit. Industry benchmarks vary significantly by property type: a select-service hotel should target GOP margins of 35–50%, while a full-service property with F&B and events might target 25–40% because of the higher overhead. Without these calculations built into your income statement, you're managing the business blind.

The practical discipline is to close your books monthly, run the income statement against your budget, and focus on two numbers first: GOP% and RevPAR. If GOP% is down, you need to know whether it's a revenue problem or a cost problem — and the departmental P&L tells you which department is responsible. If RevPAR is underperforming, the revenue management and distribution cost breakdown (OTA commissions, franchise fees) tells you whether you're filling rooms at the wrong price or through the wrong channels. This template is designed around that monthly review workflow so the numbers you need are on the screen the moment you open it.