> ## Documentation Index > Fetch the complete documentation index at: https://help.kwentra.com/llms.txt > Use this file to discover all available pages before exploring further. # Consolidated Balance Sheet Report > Run the British Balance Sheet for every British-system hotel in the group, summed into one combined statement. Run the British Balance Sheet for every British-system hotel in the group as one combined statement. ### **Business Value** * Replaces the spreadsheet that merges each hotel's balance sheet by hand. * Shows what the whole group owns and owes in one run. * Sums each hotel's own result into the forwarded profit line. * Stops the run when the selected hotels use different financial years. * Opens only for the Multi Property Financial Controller permission. ### **Use Cases** * Group financial controller produces the month-end position for the portfolio in one run. * External auditor reviews one group statement instead of one per hotel. * Corporate analyst compares group assets and liabilities against last year. ### **How It Works** | **Where:** Multi-Property Hub → Reports → GL → Balance Sheet | | - | Before, the British Balance Sheet ran on one hotel at a time. Group users opened each hotel and added the figures up by hand. **The report keeps its existing shape.** Sections, rows, columns, order, subtotals and the ODS layout match the single-property [British Balance Sheet](/back-office/bo-reports/balance-sheet-report#british-accounting-system). Only the figures change. Each one is the sum of the same figure across the selected hotels. #### **Running the report** | **Parameter** | Description | | - | - | | **Date** | Required. Month picker. The statement is as at the end of the selected month. The day is ignored. | | **Zero balance** | Required. Show or Don't Show. On Don't Show, a line is hidden only when **all four** of its figures are zero in **all** selected hotels. A line that is zero in one hotel but not another still appears. | | **Last Year** | Required. Show or Don't Show. It controls the two prior-year columns. | | **Details level** | Required. Main accounts, or T0 to T4. The level applies to every hotel in the run. | | **Calendar** | Required. Gregorian or Hijri. | | **Hotels** | Multi-select. Only hotels with the British Accounting System are listed. Leave it empty to run all of them. | | **Note:** Hotels without the British Accounting System are not listed. None of their data is included. Demo and head-office instances are never included. | | - | #### **The two sides** Assets and Liabilities print as their own sheets, as today. * **Assets** covers accounts of type *Assets*. It leaves out the internal control accounts: Reservation, PayMaster, OnHold\_AR, Basic\_AR and City Ledger. * **Liabilities** covers accounts of type *Liabilities*, *Equity* and *Creditor*, grouped by account type. #### **How the rows are built** * Each line is one account line. Lines are grouped by **Main Account**, then by **Account Group**. Each group has a subtotal, and each side a grand total. * At Details level T0 to T4, each line splits further by the analysis code at that level. At **Main accounts** those columns are blank. * Lines are matched across hotels by main account code, account group and analysis code. The same line from different hotels becomes **one row** with the amounts summed. * An account that exists in only some of the selected hotels **still appears**. It carries the total of the hotels that have it. #### **Report columns** Each line has the same four money columns as the single-property statement, in two groups. Each one is the sum of that figure across the selected hotels. The movement columns are summed as movements. | **Group** | **Column** | What it shows | | - | - | - | | Current | This month | The movement during the selected month: the month-end balance less the previous month-end balance. | | Current | YTD | The position as at the selected month-end. | | Last year | This month | The same month one year earlier. | | Last year | YTD | The position at the same month-end one year earlier. | The Last-year pair prints only when **Last Year** is set to Show. | **Note:** On the account lines, **YTD is the accumulated position**. It is the account's balance as at the selected month-end, including amounts posted in earlier financial years. It is not a movement from the financial-year opening. The one figure measured from the financial-year opening is the **Profit/Loss - Forwarded From P\&L** line below. | | - | | **Note:** Amounts are summed as they are, with **no currency conversion**. All figures come from the stored month-end account balances, the same source the single-property report reads. | | - | #### **The Profit/Loss — Forwarded From P\&L line** The last line of the Liabilities side carries the group's profit. It is profit not yet closed into retained earnings. Revenue and expense accounts sit on neither side. The sheet needs this line to balance. Consolidated, it is **the sum of each hotel's own result**. Each hotel's revenue less its expenses, then added together. It is **not** worked out again from group revenue and expense balances. * **This month** is each hotel's revenue less expenses for the selected month, summed. * **YTD** is each hotel's revenue less expenses **from the opening of its financial year** to the selected month-end, summed. * The two Last-year columns work the same way, against the previous financial year's opening. Worked example — two hotels, report month August 2026, financial year opening 1 April: | | Hotel A | Hotel B | Consolidated | | - | - | - | - | | Revenue in August | 3,000,000 | 1,100,000 | 4,100,000 | | Expenses in August | 2,300,000 | 900,000 | 3,200,000 | | **Forwarded P\&L — This month** | 700,000 | 200,000 | **900,000** | | Revenue since 1 April | 15,000,000 | 5,400,000 | 20,400,000 | | Expenses since 1 April | 10,800,000 | 4,300,000 | 15,100,000 | | **Forwarded P\&L — YTD** | 4,200,000 | 1,100,000 | **5,300,000** | **Total Liabilities** is the group's summed liabilities, equity and creditors **plus** the forwarded P\&L line. This is the same as single-property. In the example, the group's liabilities, equity and creditors come to 1,300,000 for the month and 26,000,000 year to date. Total Liabilities then reads **2,200,000** for the month and **31,300,000** year to date. #### **What the report checks before it runs** * **All selected hotels must share the same financial-year opening month.** The forwarded P\&L line is measured from that opening. If the hotels disagree, the report **refuses to run** and names the hotels that differ. * **The sheet must balance.** Total Assets equals Total Liabilities, forwarded P\&L line included. This holds at every details level, in both calendars and on both zero-balance settings. * Selecting one hotel gives output identical to that hotel's single-property Balance Sheet. * A hotel with no data for the period contributes zero. It does not remove or duplicate any line. #### **Groups that run a head office instance** The report is offered only to companies that do **not** run a head office instance on the British Accounting System. A group that runs one uses that instance's own statement. Every property is already posted there. * For those companies the report is **not listed** in the Multi-Property Hub reports menu. Even a user with the Multi Property Financial Controller permission does not see the entry. * A head office instance **without** the British Accounting System does not hide the report. The company still sees it and runs it. * Companies with no head office instance are unaffected. * Visibility follows the head office flag. Flagging or unflagging an instance changes the menu on its next load. | **Note:** Hiding is limited to the menu. A direct link or a saved call still runs the report and returns the consolidated figures. | | - | #### **Permissions** The report uses the same permission as the single-property British Balance Sheet. It is granted to the **Multi Property Financial Controller** role. Without it, users do not see the report in the hub. | **Note:** This is one combined statement. There is no Hotel column and no per-hotel breakdown. To see one property, run the Balance Sheet on that hotel. The classic (non-British) Balance Sheet and the single-property British Balance Sheet are both unchanged. | | - | This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.