The USALI Hotel Financial Reporting Toolkit

A complete, professional-grade accounting workbook — built to the Uniform System of Accounts for the Lodging Industry, 11th Revised Edition. Offered free to a select group of hotel owners and operators.

Why we built this

Most hotels in India do not fail because of bad food, tired rooms, or unfriendly staff. They struggle because nobody can answer a simple question with confidence: where is the money actually going?

A general manager can tell you occupancy. A front office team can recite ADR. But ask for the gross operating profit per available room, the true cost of food sales as a percentage of food revenue, or how much undistributed overhead is quietly eroding the bottom line — and the answers often arrive as guesses, or as numbers stitched together from three different spreadsheets that no two people calculate the same way.

This is not a talent problem. It is a structure problem. Hotels are unusually complex businesses. A single property is really a collection of businesses operating under one roof — rooms, food and beverage, spa, parking, laundry, retail — each with its own revenue logic, its own cost base, and its own margin profile. Without a common language to organize all of it, financial reporting becomes a matter of opinion. And opinion is a terrible foundation for a multi-crore asset.

The global hospitality industry solved this problem decades ago. The solution is called the Uniform System of Accounts for the Lodging Industry — USALI — now in its 11th Revised Edition, maintained by Hospitality Financial and Technology Professionals (HFTP) and the American Hotel & Lodging Association. It is the accounting standard that owners, operators, lenders, investors, and brand companies the world over use to speak the same financial language. When a hotel reports in USALI format, a banker in Mumbai, an asset manager in Dubai, and an operator in Singapore can all read the same statement and understand it identically.

What you actually get

This is not a sample. It is not a teaser with the useful parts locked behind a paywall. It is a complete, ready-to-use Microsoft Excel workbook containing 24 fully linked worksheets and nearly 6,000 working formulas, structured precisely to the USALI 11th Edition. Every schedule the standard recommends is present, built, and wired together.

Two summary operating statements sit at the top. One is structured for operators — the people running the hotel day to day — and carries the statement down to EBITDA after replacement reserve. The other is structured for owners and continues all the way through interest, depreciation, amortization, and income taxes to net income. This is exactly the distinction USALI draws, because operators and owners care about different lines, and a serious reporting pack respects that.

Beneath the summaries sit the full set of departmental schedules. Rooms. Food and Beverage. Other Operated Departments — with dedicated sub-schedules for Golf, Health Club and Spa, Parking, a generic operated department you can rename for anything from a business centre to a water-sports desk, and a roll-up for minor operated departments. Then the undistributed expense schedules that quietly decide whether a profitable-looking hotel is actually profitable: Administrative and General, Information and Telecommunications Systems, Sales and Marketing, Property Operation and Maintenance, and Utilities. And finally Management Fees, Non-Operating Income and Expenses, House Laundry, Staff Dining, and Payroll-Related Expenses.

Every schedule follows the standard USALI reporting layout — Current Period and Year-to-Date, each shown as Actual, Budget, and Prior Year, with percentage columns alongside the rupee columns. This is the format lenders expect, the format asset managers expect, and the format any future brand or buyer of your hotel will expect.

A dedicated Operating Metrics and Ratios sheet does the analytical heavy lifting automatically. It calculates occupancy, ADR, RevPAR, and Total RevPAR; departmental profit margins; cost of food and beverage sales as a percentage of revenue; gross operating profit, GOP margin, and GOPPAR; and EBITDA and EBITDA margin.

Get in touch today!