Reconcile whole-building energy with landlord and tenant reporting boundaries

A whole-building electricity total can arrive after the property team has already collected landlord bills, tenant bills and submeter readings. Adding the new total to those records makes the workbook larger without identifying any new consumption. First establish which records cover the same electricity. Then build the particular reporting view the reader needs.

This exercise is for real-estate asset managers, facilities teams and corporate reporting owners. It follows one fictional building through two decisions: which quantities can be added to obtain its electricity total, and which parts belong in a specified owner-operated management view. All records, organisations and values are invented.

Name the two outputs before combining records

The UK government’s Environmental Reporting Guidelines discuss collecting meter data, invoices and supplier statements, and separately address landlord/tenant responsibility where the energy consumer and purchaser may differ. This is UK-specific guidance, dated March 2019. The exercise uses that distinction as context; it does not apply UK reporting obligations to another jurisdiction or decide a company’s emissions boundary.

Write two output labels on the working file: “whole-property grid electricity, April 2025 to March 2026” and “owner-operated electricity, same property and period, under the case’s approved management definition”. Keep the physical coverage of the first separate from the reporting decision behind the second. Neither label should disappear when the numbers leave the property team.

Follow the connections at Juniper House

The fictional property contains common plant, one vacant unit, a serviced suite occupied by Tenant S, and separately supplied spaces occupied by Tenants B and C. For the whole year, the only energy input is grid electricity. There is no on-site generation, export, backup fuel or separately purchased heat or cooling. The case stipulates matched reading periods and verified coverage, with no unmeasured branch or distribution loss.

• U-ALL: the utility’s aggregate is 1,200,000 kWh. Its supplied connection list contains M-L, M-B and M-C, covering this property only.

• M-L: the landlord account records 420,000 kWh. Its branch readings are 330,000 for common plant, 40,000 for the vacant unit and 50,000 for Tenant S’s suite.

• M-B and M-C: tenant utility accounts record 470,000 and 310,000 kWh respectively. They are separate incoming connections, outside M-L.

• S-SUITE: the 50,000 kWh suite submeter is downstream of M-L. It measures part of M-L’s 420,000, rather than another incoming supply.

U-ALL is an aggregation of three incoming connections. S-SUITE is a subset within one of those connections. These are different relationships. Record them explicitly beside the values, using connection identifiers and the facilities diagram. A spreadsheet column labelled “electricity” cannot communicate either relationship on its own.

Choose one complete path through the evidence

The branch path gives 420,000 + 470,000 + 310,000 = 1,200,000 kWh. It agrees with U-ALL. Use one path for the whole-property total and retain the other as a cross-check. Here the selected total is U-ALL’s 1,200,000 kWh, with its connection list and the three-account reconciliation attached.

An import that adds every available row produces 1,200,000 + 420,000 + 470,000 + 310,000 + 50,000 = 2,450,000 kWh. The first 1,200,000 is repeated through its component accounts, then the suite’s 50,000 is repeated once more. No meter has identified the additional 1,250,000 kWh implied by that sum.

Retain all five records. Mark U-ALL as the selected total; M-L, M-B and M-C as its supporting components; and S-SUITE as detail inside M-L. Excluding a row from the total does not make the record useless or justify deleting it. S-SUITE will be essential for the second output.

Agreement between two paths also has limits. If both omitted an outbuilding, matching totals would not discover it. In a real handover, confirm the addresses, spaces, connections, fuels and period against the property’s facilities records before describing the result as complete. Record any gap separately rather than forcing a balancing entry.

Original fictional case, all quantities in kWh for one matched year. The utility aggregate and its components are alternative total paths. The suite submeter is nested inside the landlord account. The management split is a stated case assumption, not an emissions classification.

Build the owner’s view from the same physical map

For this management exercise only, the owner’s reporting lead has approved a view covering the common plant and vacant unit that the owner operates. The serviced suite and B/C spaces are operated by their respective tenants and sit outside that selected view. These are stipulated case decisions. They do not establish operational control, lease treatment or emissions scopes for an actual business.

The owner-operated view is 330,000 + 40,000 = 370,000 kWh. The other selected spaces account for 50,000 + 470,000 + 310,000 = 830,000 kWh. Together they reconcile to the physical total: 370,000 + 830,000 = 1,200,000. Keep the 830,000 visible as electricity in the building but outside this particular owner-operated view.

Using the landlord invoice alone would give 420,000 kWh, including Tenant S’s 50,000. Using the aggregate would give 1,200,000, including all tenant spaces. Both amounts are useful records with different coverage. Neither matches the approved 370,000 kWh view merely because the owner possesses the document.

Tenant S can receive its 50,000 kWh submeter record with the connection reference and period. Any proposed share of common services needs a separate, supported decision. This exercise has made no such allocation. For corporate reporting, attach the relevant organisation’s approved boundary decision and route each component under its applicable method; a property reconciliation does not assign emissions scopes.

The property total and owner-operated figure are two views of overlapping records. Do not sum 1,200,000 and 370,000 into a new total. Likewise, quantities supplied to different organisations must retain their reporting purpose. A cross-organisation total needs its own consolidation rule.

Test what changes when evidence is missing

Remove S-SUITE and the other branch readings inside M-L. The three incoming accounts still support 1,200,000 kWh for the building. But M-L’s 420,000 no longer identifies the owner-operated 370,000 and suite 50,000 split. Retain “owner/suite split unresolved” and request the missing branch evidence; do not assign the suite zero.

Now keep the branch records but remove U-ALL. The three checked incoming accounts still total 1,200,000 under the case’s coverage assumptions. The aggregate was a useful corroborating path, not a fourth source of energy. These two tests show why the same missing document can matter differently to different outputs.

If a later utility revision changes U-ALL without matching changes to the component records, preserve both versions and investigate the date window, connection list and corrected readings. Recalculate only after identifying what changed. A small difference is still unexplained until the evidence or an explicitly approved estimation method accounts for it.

Hand over the relationship, not just the total

Deliver the 1,200,000 kWh whole-property result, its three incoming-account components, and the 370,000/830,000 management split with their labels. Keep the connection map, period, nested-record flags, record versions and approved view definition together. The recipient should be able to trace why each number is included, excluded from a sum, or retained for a different purpose.

Use the shared-meter and leased-premises guide when a supported tenant allocation is needed. For comparisons across properties, the property portfolio comparison guide examines area, time and asset mix. Establish this building’s coverage before carrying its numbers into either task.

Source checked 14 October 2026: Environmental Reporting Guidelines, March 2019, printed pages 46 and 48. Contains public sector information licensed under the Open Government Licence v3.0. The connection map, numerical example and reporting-view tests are original fictional teaching material.