The purchasing file may call a quantity the hotel’s load, while accounting calls another number usage. The two numbers can both be valid and still answer different questions. Before treating their difference as a contract issue, identify how each was produced and what it is supposed to measure.
The contracts hub explains quantity and price review. This guide builds the reconciliation ledger connecting an agreed reference with actual account data. It does not assume that a supplier forecast, occupancy plan or billed estimate becomes the contractual quantity merely because it appears in a spreadsheet.
Which quantity did the agreement actually adopt?
Collect the signed product schedule and any accepted revisions. Identify whether the reference is forecast energy, a fixed block, a requirements quantity or another defined input. Record the unit and period next to the number. A field headed volume without those details is incomplete for contract analysis.
The 2025 New York business filing contains account and quantity schedule references. The dated supplier forms illustrate document fields; they are not current hotel offers or proof that every product uses the same reference.
Find the version that was accepted, not only the forecast sent for quoting. A supplier might use one dataset to evaluate an offer and a different schedule in the executed product. Ask for clarification if the signed documents refer to a schedule that is missing or inconsistent with the retained workbook.
What does the meter record include?
Confirm utility account, meter identifier, service address and physical boundary. Shared kitchens, laundry, parking or another building may be behind the same meter. Conversely, one hotel can have several meters with different products and service periods. Do not add them together before confirming which accounts the contract comparison covers.
Identify whether a quantity comes from an actual reading, interval export, billed estimate or later correction. Preserve the source and retrieval date. The interval-data definition describes the measurement record; applying it to a supply agreement requires additional reference and period checks.
If the meter or account changed during the review period, establish the transition boundary. A final old-meter reading and first new-meter reading are not automatically a continuous interval series. Ask the utility or authorized data provider for the applicable records rather than filling the transition with an unexplained total.
| Layer | Evidence | Comparison limit |
|---|---|---|
| Contract reference | Signed schedule and approved revision | Defined purpose, units and periods |
| Measurement | Meter readings or interval export | Physical boundary and time convention |
| Estimate | Billing or analytical method | Not independently measured data |
| Correction | Replacement record and affected period | Retain the earlier version |
| Disposition | Recomputed difference and supplier response | No fee inferred without terms |
How should the periods and clocks be aligned?
Compare actual service dates rather than invoice issue dates. A bill received in one calendar month can describe service extending into another. Record start, end, interval duration and the convention used to label each interval. Ask whether the timestamp represents the beginning or end of the measured period when that affects the comparison.
Check time zones and clock changes for an hourly or time-specific product. A dataset with shifted timestamps can have a plausible total while associating energy with the wrong price or block. Preserve the original export before making an approved conversion, and document the conversion method.
The DOE EMIS guidance distinguishes interval analysis, models and backfilled data. Its federal analytical context does not determine hotel contract settlement. The practical lesson is to label transformations clearly so the reviewer can separate measurement from reconstruction.
What does a transparent variance calculation look like?
Assume a fictional contract reference of 100,000 kWh for a defined month and a matched actual measurement of 112,000 kWh. The arithmetic difference is 12,000 kWh, or twelve percent of the assumed reference. These are invented teaching inputs, not a supplier tolerance, hotel benchmark or actual measured result.
Suppose the fictional record originally contained 106,000 kWh and a later accepted correction added 6,000 kWh. The revised total is 112,000 kWh. Preserve both datasets and the correction rather than silently replacing the original. The supplier and accounting team need to know which version was used in a previous calculation.
The example establishes quantity arithmetic only. It says nothing about whether a charge, credit or change in price follows. Those results require the actual signed method and any applicable exceptions. A spreadsheet’s percentage formatting should not be mistaken for a contractual conclusion.
Why can an annual total conceal a product mismatch?
An annual energy total loses information about when electricity was used. A fixed block or indexed residual calculation may depend on shorter periods. Two profiles with identical totals can therefore require different comparisons within the product’s adopted windows. Do not smooth the dataset merely to make it match a yearly forecast.
The pricing-structure guide explains product alternatives. For the selected agreement, obtain the complete block or reference schedule and identify any sellback or residual treatment that is actually included. A marketing label alone is not enough to reproduce settlement.
Retain the forecast and measurement in their original resolutions, then create a documented comparison view. That allows the hotel to check both overall totals and period-specific differences without treating an analytical aggregation as a new contractual reference.
How should changes in hotel operation be explained?
Create an operating-change log alongside the quantity ledger. Record phased opening, closures, equipment commissioning and service schedule changes that actually occurred. Separate those observations from assumptions made when the hotel originally requested bids. An unfulfilled opening plan can explain a forecast difference without proving the supplier calculation is wrong.
The historical Delaware electricity RFP used account-specific historical and project information. Its March 2019 government terms illustrate a documented load record; they do not give a hotel the same change rights or tolerance conditions.
Use engineering records to describe affected systems and dates. Occupied rooms can supply context, but common-area, water, ventilation and other continuing loads need their own consideration. Do not rewrite the measured total to match an occupancy-based expectation. Investigate the explanation while preserving the actual account data.
When can the tolerance or adjustment method be applied?
Read the bandwidth and swing guide after the reference and measurement have been matched. Identify the adopted period, quantity basis, calculation and exception wording in the actual agreement. A familiar percentage from another supplier form should not enter the model as a default.
Ask the supplier to show the inputs and intermediate steps for any resulting amount. Reconcile its reference version, measured version and corrections with the hotel’s ledger. If a broker assists, document compensation and whether settlement review is included in the service; preserve the calculation within the hotel’s own account file.
- Locate the signed quantity schedule and approved revisions.
- Confirm the meter boundary and service periods.
- Mark actual, estimated and reconstructed records.
- Align clocks and preserve documented transformations.
- Recompute variance using the specified quantities.
- Review contractual treatment and retain the supplier’s disposition.
What should remain in the monthly reconciliation record?
Retain the reference, original export, corrected export, calculation version, operational explanation and unresolved questions. Give each variance a factual status: data mismatch, identified operating change, accepted calculation or awaiting explanation. Avoid a single category called overage that assumes contractual treatment before review.
The material-change guide addresses notifications when projects alter operation. A monthly reconciliation can reveal an unreported change, but it does not retroactively complete notice or approval. Route that issue through the actual change process.
The final account note should explain which quantities were compared and why. That makes a later correction reproducible and helps the next procurement cycle use a more credible forecast. It also prevents a realistic-looking total from hiding an incorrect meter, clock, reference period or contract version.