Reconcile pharmaceutical manufacturing sites and offices before ESG reporting

A pharmaceutical company’s electricity total can be correct while its site figures are wrong. When a laboratory function moves, a familiar activity label may follow the people and work into the new building. The electricity meters do not necessarily move with it. A collection sheet that joins records by that label can silently assign consumption to the wrong physical location.
This fictional exercise helps finance, engineering, quality-document custodians and reporting owners review a laboratory move. It starts after the corporate boundary has been approved. Its output is a four-location electricity schedule with traceable meter intervals, rather than a decision about licensing, laboratory qualification, product quality or plant operation.
State the included locations before following the move
Boundary record B1 includes manufacturing campus M, former laboratory building L, replacement laboratory building N and headquarters H for all of April–June 2026. Each has its own dedicated external electricity meter. There are no third-party loads, exports, acquisitions, disposals or changes to the approved boundary in this example. All quantities are invented MWh inputs.
GHG Protocol’s Corporate Standard addresses the consolidation approach in chapter 3. Chapter 7 addresses documentation, changes and aggregation checks. Those principles inform this preparation exercise; the records, numbers and joining decisions below are original teaching material.
Facilities note F1 says that laboratory work moved from L to N on 16 May. Engineering note E1 confirms preparatory electricity use at N before the move and security and ventilation loads at L afterwards. B1 keeps both buildings included throughout. The reviewer neither assesses the necessity of those systems nor recommends operating changes.
Quality extract Q1 refers to the manufacturing campus and the laboratory function. It does not list headquarters H. That absence describes Q1’s coverage; it does not revise B1. An office should not vanish from the approved collection population because it is absent from a manufacturing-oriented document.
Separate a fixed location from a changing activity label
The reporting spreadsheet calls the function “Central Lab” before and after 16 May. Give L and N separate physical location IDs and link that functional label to its actual dates at each location. Do not use the label as a substitute for a meter ID. Keep headquarters and manufacturing in their own rows, even when departments send records in one file.
The useful crosswalk has four relationships: physical location to external meter; meter to supplier account; account to consumption interval; and activity to location and dates. These relationships can change independently. Ask the relevant custodian to confirm each one rather than assuming that the move date changed all four.
For each input, retain its location, meter, account alias, interval, quantity, unit and source reference. Mark whether it contributes to the calculation, is a component of another input, or is a check total. A summary can help verify a quantity without becoming an additional quantity to add.
Read the actual meter intervals
M1 supplies campus M and records 180 MWh for the quarter. H1 supplies headquarters H and records 24 MWh. L1 supplies former laboratory L and records 18 MWh from 1 April through 15 May, followed by 6 MWh from 16 May through 30 June. L’s quarter quantity is therefore 24 MWh.
N1 supplies replacement laboratory N. Account NL-old records 14 MWh from 1 April through 15 May; replacement account NL-new records 22 MWh from 16 May through 30 June. Engineering and the account crosswalk confirm that both accounts refer to N1. N’s quarter quantity is 36 MWh, including the preparation period before laboratory work moved there.
Quarter summary NS reports the same 36 MWh and explicitly includes both N1 intervals. Use either its confirmed quarter amount or the two constituent quantities as additive inputs, with the other retained as a check. Adding NS and both intervals would double N’s consumption. All supplied intervals are complete and non-overlapping; no estimate is used in this case.
The correctly located quarter schedule is M 180, L 24, N 36 and H 24 MWh. Its total is 180 + 24 + 36 + 24 = 264 MWh. The activity-move date explains the operational context of the L and N records; it does not change where the electricity was measured.

Find a wrong site assignment behind a correct total
The submitted sheet instead assigns every laboratory-labelled consumption interval before 16 May to L and every interval from 16 May onward to N. It combines L1’s earlier 18 MWh with N1’s earlier 14 MWh, giving L 32 MWh. It combines N1’s later 22 MWh with L1’s later 6 MWh, giving N 28 MWh.
M and H remain 180 and 24 MWh. The submitted total is 180 + 32 + 28 + 24 = 264 MWh, exactly matching the correct total. Every supplied quantity occurs once. The failure is physical attribution, so a duplicate search or total-only comparison would not catch it.
Correct L by removing N1’s 14 and restoring L1’s 6: 32 − 14 + 6 = 24 MWh. Correct N by removing L1’s 6 and restoring N1’s 14: 28 − 6 + 14 = 36 MWh. Each location changes by 8 MWh in opposite directions. Retain the earlier version and identify both reassigned meter intervals in the correction note.
Do not describe the correction only as “no numerical impact”. It has no impact on the corporate electricity total, but it changes both laboratory-building figures. A location comparison, site request or management explanation could be affected. If a disclosure has already been released, route the affected statements to the responsible owner’s correction process rather than silently replacing them.
Keep an unresolved relationship visible
Suppose NL-new names “Central Lab” but contains no meter reference, and the engineering confirmation is missing. The name alone cannot establish N1. Keep the 22 MWh relationship unresolved and request the existing account-to-meter evidence. The move date is not a substitute for that evidence.
If the 22 MWh quantity itself is unavailable, the 14 MWh earlier record is only partial coverage. Do not present it as a quarter total or insert an estimate chosen to match 36. A real estimate needs a documented method, responsible owner and separate review. Those are outside this complete-data illustration.
Hand over a schedule another reader can reconstruct
Include B1, F1, E1, the account crosswalk, the meter-input hierarchy and both collection-sheet versions. Ask a second reader to explain why N has energy before the move, why L retains energy afterwards, why NS is not added again, and why H remains included even though Q1 omits it.
The schedule establishes only this fictional electricity account. It does not supply emission factors, renewable-electricity evidence, product allocation or a manufacturing-intensity denominator. Water, waste, workforce and other ESG measures require their own definitions and populations; this electricity crosswalk cannot automatically settle them.
Use the corporate boundary guide for the prior inclusion decision. To discuss an evidence handover, contact Nitium Advisory with a non-confidential outline of the locations, period and unresolved relationships. Keep restricted quality documents, formulations and personal records with their authorised custodians.
Source and limits
GHG Protocol Corporate Standard, revised edition: chapter 3, printed page 18; chapter 7, printed pages 51–52. Source rechecked 14 October 2026. No real company was assessed. This exercise provides no legal, GMP, technical-operating, certification or independent-assurance conclusion.



Comments