Why manual energy data collection stops working – and when

Most property companies don’t decide to collect energy data manually. It just happens that way. One building, one utility provider, a spreadsheet that does the job fine. Then a few more buildings. Then an acquisition. Then a sustainability report that needs figures for 40 meters across six different suppliers, and someone spending two days logging into portals, downloading files, and hoping nothing has changed since last month.

At some point, the spreadsheet stops being a practical tool and starts being a liability. The question is usually not whether to change the approach – it is recognising when that point has passed.

The problem is not the spreadsheet

Manual collection works reasonably well when the infrastructure is simple. One or two utility providers, a stable portfolio, modest reporting requirements. In those circumstances, the effort is manageable and the risk of errors is low.

The trouble starts when complexity grows. Different utility providers send data at different times, in different formats, with different levels of completeness. Some update their portals mid-month. Others require a separate login for each property. A meter gets replaced and suddenly three months of readings are missing with no explanation. None of these problems are insurmountable individually – but together, across a portfolio of any real size, they add up to a process that takes far longer than it should and produces results that are harder to defend than they look.

There are two specific situations where manual collection becomes genuinely costly. The first is when reporting requirements increase – a GRESB submission, a CSRD report, a bank requesting energy performance data as part of a green financing review. These processes require data that is not just present, but complete, timely and traceable. Gaps matter. Estimations need to be documented. A figure that came from a manually downloaded file six months ago is harder to verify than one with a clear collection timestamp and source log.

The second is when the portfolio grows. Each acquisition adds new utility providers, new meter types, new formats to handle. The manual process that worked at 20 buildings does not scale to 60. The time spent on collection grows proportionally; the capacity to deal with it usually does not.

What automated collection actually does differently

The practical difference between manual and automated collection is not that the data magically improves. It is that the process runs continuously rather than when someone gets around to it, and that every step is logged.

Metry connects to over 700 data sources across northern Europe – utility portals, smart meters, metering gateways, file transfers and more. When a new meter appears at a connected source, it shows up in your inbox automatically. When a collection fails, the system flags it. When data arrives, it is validated against historical values and neighbouring meters before it is stored. The source and timestamp of every data point is logged.

For a portfolio manager dealing with 30 utility providers, that means one place to see what has been collected and what is missing – rather than 30 portals to check. For a sustainability manager preparing a CSRD report, it means a dataset that already has the traceability the auditor will ask for.

A practical way to think about the switch

Automated collection is not the right fit for every organisation at every stage. A company with a small, stable portfolio and straightforward reporting requirements may not see enough benefit to justify the change right now.

The calculation shifts when any of the following are true: the portfolio is growing through acquisitions, reporting requirements have increased, the time spent on manual collection has become noticeable, or data gaps have caused problems in a reporting process. When one or more of those things are happening, the cost of staying manual tends to be higher than it looks.

If you want to see how Metry handles collection for a portfolio like yours, we are happy to walk you through it.