The chart looks convincing: consumption fell sharply in August, and the team is ready to credit the new operating schedule. Then someone notices a missing bill. The apparent improvement is a data gap.
Energy analytics depend on ordinary details that are easy to overlook. Before interpreting a trend, verify that each record represents the right meter, period, unit, and reading type. This checklist turns a bill upload into a dependable operating record.
In this guide
Identify the meter before the amount
Keep a register linking each utility account and meter to a property, fuel, and measurement boundary. A property may have separate tenant, common-area, and exterior accounts. Account numbers can change after a contract renewal or service change, so preserve the relationship between old and new identifiers.
Ask whether the bill measures the whole building or only part of it. Never sum a main meter and its submeters as though they represent separate purchases. When boundaries are uncertain, mark the record for review rather than letting it enter a portfolio total unquestioned.
Check the service period
Use service start and end dates, not the invoice date, to describe consumption. Record billing days and identify overlaps or gaps. Different utilities may use different boundary conventions, so document whether the final day is included. Reconcile a sequence against the supplier's own dates.
A 35-day invoice cannot be compared directly with a 28-day invoice. Daily averages can help with an initial review, but allocating monthly consumption evenly across calendar days remains an estimate. Label that allocation method whenever calendar-month reporting requires it.
Keep consumption and money in separate fields
Store electricity in kWh and demand in kW. Preserve the original gas unit; cubic metres and gigajoules are not interchangeable. If converting units, record the factor, source, and period rather than relying on an unexplained constant. Cost fields should distinguish charges, tax, credits, and balance adjustments.
An amount due can include an unpaid previous balance. It is not necessarily the cost of the current service period. Use the invoice's current-period charges for analysis and retain the source document so finance can reconcile the difference.
Catch corrections and duplicate uploads
A duplicate can arrive through manual entry, a spreadsheet import, and a scanned bill. Check for the same account, fuel, service dates, and invoice identifier before accepting another record. Similar amounts alone are not enough to identify a duplicate.
When the supplier issues a corrected invoice, link it to the original and make the replacement status explicit. Keep the original for traceability while excluding it from active totals. A negative adjustment may be legitimate; investigate its purpose rather than deleting it to make the chart look normal.
Flag estimates and missing readings
Record whether the utility reading is actual or estimated. An estimated low bill followed by a catch-up bill can create a false efficiency gain and then a false equipment alarm. Keep both records, but interpret the combined period and explain the limitation.
The ENERGY STAR score eligibility guidance illustrates why complete, suitable building data matters to benchmarking. A platform can organize records; the operating team still needs to confirm what those records represent.
Use a reconciliation example
Consider an illustrative property with 20,000 kWh on its original July invoice and a replacement showing 22,400 kWh for the same service period. Counting both creates 42,400 kWh. The active consumption should be 22,400 kWh, with the first invoice retained as superseded.
At an assumed $0.16/kWh energy rate, the duplicated 20,000 kWh would create a $3,200 error in a simplified energy-cost calculation. The real invoice may contain demand charges, fixed fees, or other adjustments, so reconcile its actual line items separately.
Create a sign-off rule
Before closing the month, check that expected accounts are present, service periods connect, units are valid, and corrections are resolved. Compare unusually high or low entries with the source bill. Give unresolved records a visible status and an owner.
For Energy Wiz users, bill scanning and spreadsheet imports can reduce entry effort, but extracted values should still be checked against the document. A readable source, a reviewed record, and a clearly defined property boundary are stronger foundations than a perfectly styled chart.
Turn your next energy review into action
Bring your utility records, operating observations, and improvement priorities together with Energy Wiz.
Get started