Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Stop Reading Sub-Meters and Building Tenant Utility Recharges in a Spreadsheet?
Problems We Solve

How Do We Stop Reading Sub-Meters and Building Tenant Utility Recharges in a Spreadsheet?

Commercial landlord sub-meter utility recharges rely on manual reads and spreadsheets. We build a recharge process from meter readings to tenant invoices.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Utility recharges go wrong because meter readings are taken on paper or photos, rates change with supplier contracts, and the calculation is rebuilt in a spreadsheet each period. We build a recharge process that collects readings from smart meters or a mobile form with a photo, checks them against history, applies your agreed rates, and produces tenant invoices that show the readings and working.

Meter reading day

At the start of each quarter someone from the building team walks round with a clipboard, reads the electricity sub-meters in each unit, and sometimes the water meters. The readings go into a spreadsheet at head office, where someone subtracts last quarter's figures, multiplies by the rate and adds standing charges. A tenant disputes their bill because the reading looks high, and nobody can show whether it was misread.

In the meantime the landlord's own supply contract has changed rate twice, and one meter was replaced mid-quarter.

Why recharging utilities is error-prone

The calculation is not complicated, but every input is fragile. Readings are handwritten. Meter serial numbers change when meters are replaced. Rates come from supplier bills in a different format each time. Some tenants have their own supply and nobody updated the schedule when they switched.

  • Readings are taken by hand, with no photo to check later.
  • Meter replacements reset readings and are not recorded.
  • Rates are copied from supplier bills that change.
  • Common area consumption is estimated rather than measured.
  • Tenants cannot see how their charge was calculated.

What it costs to do it by hand

Misreads lead to over and undercharges, and disputes that are hard to settle without evidence. The gap between what the landlord pays suppliers and what it recovers from tenants is not visible until the year end. Staff time goes on reading meters and rebuilding the spreadsheet. And tenants increasingly want to see their consumption for their own sustainability reporting, which the landlord cannot easily provide.

The recharge process we build

  1. Where meters can be read remotely, readings are collected automatically through the meter provider's data feed.
  2. Where they cannot, the building team uses a mobile form that asks for the reading and a photo of the meter, and records the time and who took it.
  3. Each reading is checked against the unit's history, and unusual jumps or drops are held for a person to look at before billing.
  4. Meter replacements are recorded with the closing and opening readings, so consumption carries across.
  5. Rates are taken from the supplier bills, extracted with AI and checked by a person, and applied under the recharge method your leases and advisers set.
  6. Invoices show the readings, the consumption, the rate and the photos where available, and are posted to your accounts system.
  7. A reconciliation compares what you paid suppliers with what you recovered, by building, so gaps show up each period.
StepClipboard and spreadsheetRecharge process
ReadingWritten on paperRemote feed or photo-backed form
CheckingNone until a tenant complainsChecked against history before billing
Meter changeOften missedRecorded with closing and opening reads
Tenant queryHard to answerPhoto and working on the invoice
Recovery gapSeen at year endSeen each period

What changes for the building team

Reading day is quicker, and a reading with a photo is hard to dispute. Head office stops rebuilding the spreadsheet. Tenants receive invoices that show their working, and can be given their consumption history for their own reporting. You can see where recovery is falling short and why.

The building manager walks the same route with a phone instead of a clipboard. If a reading looks wrong, the form asks them to check it again there and then, while they are standing in front of the meter, rather than a head office accountant querying it three weeks later. Meters that could not be reached, because a tenant's store room was locked, are listed so they are read before the invoices are run, not estimated without anyone knowing.

Signs you need this

  • Sub-meters are read by hand onto paper.
  • Tenants dispute utility recharges and you lack evidence.
  • You do not know how much of your utility cost you recover.
  • Meter replacements have caused billing errors.
  • Tenants ask for consumption data you cannot easily give.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we need smart meters?

No. The photo-backed mobile form works with existing meters, and smart meter feeds can be added where they exist.

Who decides the recharge rate?

Your leases and advisers. The system applies the method and rates you set.

Can tenants see their consumption?

Yes, through their invoices or a portal, which also helps tenants with their own reporting.

What affects the cost?

The number of meters, whether any can be read remotely and which accounts system invoices go to.

Keep reading

More on Problems We Solve

Start here

Tell us how your recharges are worked out today

Describe your buildings, how charges are split between tenants and which spreadsheets and systems are involved. We will tell you what we would automate and what should stay a person's decision, and if a change to your existing setup is enough, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →