Consolidated Profit and Loss Summary Report

Run one Profit and Loss Summary across every British-system hotel in the group, with amounts summed into a single statement.

Business Value

Replaces the manual monthly consolidation of every hotel’s P&L in a spreadsheet.
Produces the whole group’s profit and loss position in one run.
Mirrors the single-property statement exactly — same sections, same columns.
Recomputes percentages and ratio KPIs from consolidated totals, never averaged.
Restricts access through a dedicated multi-property permission.

Use Cases

Group financial controller runs month-end P&L for the entire portfolio in one pass.
Corporate finance analyst compares budget against actuals across all properties at once.
Group management reviews consolidated GOP and NOP without opening each hotel separately.

How It Works

Where: Multi-Property Hub → Reports → GL → Profit and Loss Summary

Running the report

Parameter	Description
Date	Mandatory. Month picker — only the month is considered, the selected day is ignored.
Zero balance	Mandatory. Show or Don’t Show. On Don’t Show, lines with no activity across all selected hotels are hidden.
Calendar	Mandatory. Gregorian or Hijri.
Hotels	Multi-select. Only hotels with the British Accounting System enabled are offered. Leave empty to run all eligible hotels.

Note: Hotels without the British Accounting System enabled are excluded entirely — they are not offered in the Hotels parameter and none of their data is included. Demo and head-office instances are never offered or included.

How figures are consolidated

Lines are matched across hotels by their department or line code — the same line from different hotels becomes one row with the amounts summed.
Currency: no conversion. Amounts are summed as-is, matching the other consolidated reports.
Budget figures are the sum of the selected hotels’ budgets for the same lines.
Percentages (% of total revenue) are recomputed from the consolidated totals — never summed or averaged from the individual hotels’ percentages.
Hotel Statistics: room counts such as occupied rooms and rooms to sell are summed, while ratio KPIs such as Occupancy % and revenue per available room are recomputed from the combined totals.
YTD and last-year windows use the financial year shared by all hotels in the group.

Report columns

The statement is structured identically to the single-property Profit and Loss Summary, with the monthly columns to the left of the line description and the yearly columns to the right. Each amount column carries its own percentage.

Column	Description	Example
Last-Year MTD	The same month last year, summed across the selected hotels.	1,840,000
Budget	Budgeted amount for the selected month, summed across the selected hotels.	2,000,000
Current MTD	Actual figures for the month the report is run for.	2,145,000
Description	The P&L line — a department’s revenue, cost, payroll, or expense.	Rooms — Revenue
Current YTD	Year to date through the selected month.	12,430,000
YTD Budget	Budget from the start of the financial year through the selected month.	12,000,000
Last-Year YTD	The same year-to-date period last year, for comparison.	11,210,000

Every section of the single-property statement carries over: Revenue, Cost, Payroll and Other Expenses for each department (Rooms, F&B, and so on), Department Profit, OH Expenses, G.O.P, Deductions, NOP, and the Hotel Statistics section.

Note: This is one combined statement — there is no Hotel column and no per-hotel breakdown. To see a single property’s figures, run the Profit and Loss Summary on that hotel.

Permissions

Running the report requires a dedicated permission, granted to the Multi Property Financial Controller role. Users without it do not see the report in the Reports menu.

Note: This report is separate from the Profit and Loss tab in Insights, which shows top-line KPIs only (revenue, expenses, GOP, TRevPAR, GOPPAR). Both remain available — use this report for the full departmental statement.

​Business Value

​Use Cases

​How It Works

​Running the report

​How figures are consolidated

​Report columns

​Permissions