Ferdinando MercuriManagement control

Management control · Hospitality

Comparable numbers for better decisions.

I restate the accounts of hotels, campsites and non-hotel accommodation to the USALI standard and turn them into clear KPIs for management and owners.

First meeting free and without obligation: at your premises in Lombardy, online via Microsoft Teams in other regions.

The same income statement, read two ways
Departmental revenue2,400
Departmental expenses−820
Departmental profit1,580
Undistributed expenses−610
GOP · 40.4%970
Fees, rent, property taxes−250
EBITDA720

USALI format: revenue and costs by department. You see how much each department earns and how much overheads weigh before GOP.

Illustrative example · € thousands

Occupancy
72%
ADR
€ 144
RevPAR
€ 104
GOPPAR
€ 60

Illustrative example: 60 rooms, 270 opening days, same data as the chart.

The USALI scheme starts from departmental revenue and ends at operating profit, so two different properties can be compared under the same rules.

Method

From chart of accounts to report

  1. Departmental revenueRooms, F&B, other
  2. Departmental expensesDepartmental profit
  3. Undistributed expensesA&G, IT, sales, maintenance, energy
  4. Gross Operating Profit (GOP)Operating result
  5. Fees, rent, property taxesEBITDA

The core is the free check-up (01) and service 02; 03 is recommended, and 04 and 05 are added if requested. G marks the additional activities for groups.

  • Set-upOnce, reviewed only if something changes
  • Every monthThe same calculations, under the same rules
  • Every yearPlanning and a check of the rules
The method in detail

KPIs

The indicators I use

Simple definitions, always calculated the same way, property by property.

Occupancy
Rooms sold over rooms available
ADR
Rooms revenue per room sold
RevPAR
Rooms revenue per available room
TRevPAR
Total revenue per available room
GOP margin
GOP as a percentage of revenue
GOPPAR
GOP per available room
CPOR
Rooms costs per occupied room
Payroll / revenue
Weight of labour cost

For campsites and B&Bs I adapt the scheme: accommodation units instead of rooms, opening days to account for seasonality.

Calculate your KPIs

I work on the data exported from your software

No need to change systems: I start from the exports of the programs your property already uses (trial balance, ledgers, occupancy and revenue statistics) and rework them into the USALI scheme.

Already have a management control module? Many properties already have dedicated software or a module, but lack the time to keep it updated, or use only part of it. In these cases I can work in your tool, completing the setup, fixing the cost allocations and keeping the data updated every month, or process the data with our software. Either way, you get reports you actually read.

Software names are trademarks of their respective owners and are mentioned only to indicate data compatibility.

Accounting and ERP

  • Zucchetti
  • Mago
  • Dylog
  • TeamSystem
  • eSOLVER
  • and many more

Hospitality software

  • Ericsoft
  • Opera
  • Passepartout
  • and the other main hotel management systems

Contact

Let's talk about your numbers

Tell me about your property or group: I'll explain how I can help and where it makes sense to start. The initial check-up is free and without obligation: it is activated after the online self-assessment of less than 10 minutes, or after a short phone call in which we fill it in together, and begins with a first meeting at your premises for properties in Lombardy, online via Microsoft Teams for other regions. The check-up then continues remotely.

or controller.fm@outlook.com · Vertemate (CO)