Ferdinando MercuriManagement control

Services

Services for single properties

For hotels, campsites and non-hotel accommodation with a single property. The process starts with a free check-up; paid services are activated according to its findings and after assessing the client's requirements. The essential steps are the free check-up, service 01, and service 02; the activities in service 03 are strongly recommended, while those in service 04 are added when the year or season needs planning. Service 05, training for administrative staff, is available with service 02 and is free of charge if service 03 is also taken. Groups with several properties or companies have a dedicated page.

How to get started

  1. Online self-assessmentLess than 10 minutes, or by phone together with me
  2. First meetingFree of charge: on site in Lombardy, online in other regions
  3. Initial check-up (01)Free of charge, continues remotely on your data
  4. ProposalThe services that suit the property, with a written quote

Start the self-assessment

Initial check-up Free of charge

A preliminary review, at no cost, of how revenue, costs and consumption are recorded today, to establish where to start.

What it is

Before proposing any service I review how the property's data is organised today: software, accounting, revenue, inventory and payroll. The check-up includes a first meeting at your premises for properties in Lombardy (online via Microsoft Teams in other regions) and continues remotely; further on-site meetings are not included and are agreed in the quote. To access the check-up, you start with the online self-assessment of less than 10 minutes, or with a phone call in which we fill it in together.

What it includes

  • Review of the software in use (accounting, property management system – PMS, point-of-sale, inventory, payroll) and of the active modules, in particular the cost accounting module (cost and revenue centres)
  • Comparison between revenue recorded in the accounts and revenue in the PMS, with an examination of any differences
  • Review of how inventory is managed and how consumption is recorded (receipts, issues, stock counts)
  • Review of how payroll costs are recorded and whether the department each person works in is indicated
  • Check of whether the accounts already follow the USALI scheme
  • A short report on the findings, indicating the most suitable form of service 02 for the property

Who it is for

Any property that wants to know, before committing, what it takes to have reliable management control.

What I need

List of the software and modules in use; chart of accounts; a recent trial balance; the PMS revenue extract for the same period; how inventory is managed; a staff list with role and department.

USALI restatement and monthly reporting Core service

The income statement organised by department according to USALI, the international standard of the lodging industry, every month and YTD, compared with the prior year and the budget.

What it is

Every month the property's income statement is presented in the statements required by USALI (Uniform System of Accounts for the Lodging Industry, 12th Revised Edition), for the month and YTD (year to date). The approach depends on whether the accounts already follow the USALI scheme.

What it includes

If the accounts do not yet follow USALI · Set-up (once)
  • Excel export of the chart of accounts and mapping of each account to the corresponding USALI line
  • Collection of the property data: available units (rooms or pitches), departments, food and beverage outlets, floor areas and seats
  • Definition, together with the owners, of the criteria for charging costs to departments and of the allocation drivers (for example staff hours worked, items processed by the house laundry, consumption). As USALI requires, undistributed expenses (administrative and general, information systems, sales and marketing, maintenance, energy, water and waste) remain reported separately from the departments
  • First set-up: if a comparison with the prior year is wanted, the same work is also carried out on the prior year's data
If the accounts do not yet follow USALI · Every month
  • Export of the monthly income statement from the accounts, of revenue and statistics from the PMS (rooms sold, guest-nights, covers), of payroll data (cost and hours worked by department) and of inventory movements. All files are loaded into our software
  • Reconciliation of revenue between the accounts and the PMS, with meals included in the rate (half board, full board, breakfast) and packages assigned to the correct departments
  • Food and beverage cost of sales calculated from inventory (counted or estimated), net of employee meals
  • Summary Operating Statement and Schedules (detailed statements by department and cost centre), for the month and YTD, with the rooms statistics: rooms available and sold, occupancy, average daily rate (ADR), revenue per available room (RevPAR) and total revenue per available room (TRevPAR)
  • Key indicators: gross operating profit (GOP) and GOP margin, GOP per available room (GOPPAR), EBITDA, cost per occupied room, payroll cost as a share of revenue, full-time-equivalent staff (FTE) by department
  • Comparison with the prior year and, where available, the budget, monthly and YTD, with commentary on the main variances and a monthly online meeting with the owners to read the figures and decide on actions (on-site meetings on request, as per the quote)
If the accounts already follow USALI · 12th Edition compliance review and monthly analysis
  • Review of the chart of accounts and of the statements in use against the changes of the 12th Edition, including: the single Energy, Water, and Waste line; the full-time-equivalent payroll schedule (Schedule 15); the new loyalty programme expense lines; gross versus net revenue; meals included in the rate assigned to food and beverage; employee meals excluded from cost of sales; for properties with a brand or management company, the annual brand and operator costs schedule (Schedule 16)
  • List of the corrections needed and support in applying them
  • Every month: consistency check of the statements, key indicators, commentary on variances against the prior year and the budget, monthly and YTD, and a monthly online meeting with the owners (on-site meetings on request, as per the quote)
  • Alternatively, the data can be processed with our software, as in the previous case

Who it is for

Hotels, campsites and non-hotel accommodation that want to know what each department earns, starting from accounts kept only for statutory and tax purposes or from a USALI scheme already in use.

What I need

Chart of accounts; monthly trial balances; PMS extracts; payroll cost per employee and hours worked by department; inventory movements and stock counts; the budget, if any; for the first set-up, the same data for the prior year.

Additional reporting and indicators Recommended

Recommended analyses, based on the USALI statements and indicators, to understand what drives the results: guests, sales channels, food and beverage, staff and consumption.

What it is

It builds on service 02 with further schedules and indicators from Part V of USALI and, on request, with the financial statements of Part IV. It is a recommended service: the monthly reporting of service 02 is already complete for the control of operations.

What it includes

  • Rooms: revenue by guest segment (Transient Rooms Revenue by Subsegment) and by sales channel (Rooms Revenue by Channel Mix), occupancy and guest statistics, average length of stay
  • Food and beverage by outlet: revenue and profit, covers by meal period (breakfast, lunch, dinner), average check, revenue per available seat, food and beverage cost percentages
  • Staff: payroll cost statistics by department (Consolidated Payroll Cost Statistics), overtime (Overtime Statistics), hours worked per occupied room or per cover
  • Energy, water and waste: costs and consumption per occupied room and per square metre
  • Other departments (for example spa, golf, parking), where present: the specific indicators provided by USALI
  • On request, USALI financial statements: Statement of Income, Balance Sheet and Statement of Cash Flows, with liquidity, solvency, activity (average collection and payment days) and profitability ratios, including EBITDA per available room, flow-through and flex

Who it is for

Managers and owners who, with monthly reporting already in place, want a detailed analysis of guests, food and beverage, staff and consumption.

What I need

PMS statistics by segment and channel; point-of-sale data by outlet and meal period; regular and overtime hours by department; meter readings; for the financial statements, the balance sheet and loan schedules.

Budget for the next year or season

The budget month by month in the same USALI scheme as the actuals, so that the monthly and YTD comparison is immediate.

What it is

Together we build the budget in the same USALI scheme used for the actuals, separating, as USALI suggests, variable, semi-variable and fixed costs.

What it includes

  • Analysis of the restated actuals (service 02) and of the owners' targets
  • Revenue forecast: rooms available and sold by month, average rate by segment and channel, guest-nights, food and beverage covers and average check, other departments
  • Staffing plan: headcount by department, hours and FTE, seasonal hiring periods, hourly cost
  • Variable costs linked to volumes (cost of sales, laundry, guest supplies, commissions), semi-variable and fixed costs (maintenance, energy, insurance, property taxes, rent, management fees)
  • Budget by department and in total, month by month, in the format of the Summary Operating Statement and the Schedules, down to GOP and EBITDA
  • Price and volume simulations to support decisions
  • Loading of the approved budget into our software for the monthly and YTD comparison with actuals (service 02)
  • On request, an update during the year (forecast) with projections for the remaining months

Who it is for

Properties that want to plan the year or season and monitor performance during the year.

What I need

Restated actuals for at least one year; rate sheets and pricing policies; opening calendar; occupancy and event forecasts; planned headcount; main contracts (suppliers, leases, management); the owners' targets.

Training for administrative staff Free with 02 and 03

A training course for accounting staff on the content and objectives of the USALI standard.

What it is

The training helps those who keep the property's accounts understand the logic of the monthly statements and record data correctly from the start. The service is available only together with service 02 and is free of charge if the property takes both service 02 and service 03. Duration to be agreed; sessions take place online via Microsoft Teams, and any on-site sessions are agreed in the quote.

What it includes

  • Content: the departmental structure, the difference between departmental and undistributed expenses, the Summary Operating Statement and the Schedules
  • Objectives: making results comparable across periods and properties, measuring what each department earns, arriving at GOP and EBITDA
  • Differences from the Italian statutory financial statements, starting from the property's chart of accounts
  • How day-to-day postings affect the USALI statements: assignment to departments, meals included in the rate, employee meals, inventory
  • For those already following USALI, the changes of the 12th Edition
  • Support material and answers to participants' questions

Who it is for

Administrative and accounting staff of properties that take service 02.

What I need

The participants' names and their availability for the sessions.

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

Not sure where to start?

The initial check-up (service 01) is free of charge: you start with the online self-assessment, then in the first meeting (at your premises in Lombardy, online via Teams in other regions) we look at the data available together and decide where it makes sense to begin.

Book a meetingStart the self-assessment