A meter reading sheet format is a register with one row per meter per reading cycle: meter or connection ID, consumer or unit, previous reading, current reading, consumption, the date, who read it, and remarks. Add a dial photo and a GPS location for each reading and the sheet becomes something you can defend when a resident or tenant questions a bill.
The template on this page works for housing societies, commercial complexes, facility management companies, and small utilities and franchisees reading water, electricity, gas or generator hour meters.
The columns a meter reading register needs
| Column | Why it matters | Example |
|---|---|---|
| Reading date | Consumption only means something over a known period. | 29-09-2026 |
| Reader | Who took the reading. The first question in any dispute. | Suresh Yadav |
| Area / block | Groups meters into rounds and shows which areas were covered. | Wing A |
| Meter / connection ID | The unique key. Never identify a meter only by flat number; meters get replaced and flats get merged. | WTR-A-101 |
| Consumer / flat / unit | Who gets billed for this meter. | Flat A-101 |
| Meter type | Electricity, water, gas or DG hours. Keeps different units apart. | Water |
| Previous reading | Copied from the last cycle, not asked of the reader. | 1452 |
| Current reading | The number on the dial today, exactly as shown. | 1478 |
| Consumption | Current minus previous. Calculate it; do not let anyone type it. | 26 |
| Unit | kWh, kL, m³ or hours. Stops someone adding water to electricity. | kL |
| Meter status | OK, faulty, locked or not accessible. Explains every missing reading. | OK |
| Dial photo | Proof of the reading, and the fastest way to settle a dispute. | Yes |
| GPS / location | Shows the reader was at the meter, which matters most for spread-out sites. | 18.5602, 73.7769 |
| Remarks | Leaks, tampering, a broken seal, a stopped dial. | Flat locked, retry 04-10-2026 |
A filled-in example
One reader's morning in a housing society, as it should appear in the register:
| Meter ID | Unit | Previous | Current | Consumption | Status | Remarks |
|---|---|---|---|---|---|---|
| WTR-A-101 | Flat A-101 | 1452 | 1478 | 26 kL | OK | |
| EB-COM-01 | Common lighting and pumps | 48210 | 49135 | 925 kWh | OK | Pump room meter |
| WTR-A-102 | Flat A-102 | 987 | (not read) | (none) | Locked | Retry 04-10-2026 |
The locked flat still gets a row. Without it, the committee cannot tell a meter that was missed from a meter that was never on the round.
Checks that catch wrong readings
Most billing disputes start with a reading that was guessed, copied or misread. A few simple checks in the sheet catch most of them before the bills go out.
- Negative consumption. The current reading is lower than the previous one. Either the reading is wrong, the meter was replaced, or the dial rolled over. Always check.
- Zero consumption on an occupied unit. Possibly a stuck meter, possibly a reading copied from last month.
- Consumption far above normal. Compare with the same meter's last three cycles. A sudden jump is often a leak, a running tap or a misplaced digit.
- Same reading as last cycle across many meters. A sign the round was done at a desk, not at the meters.
Tip: in Excel, use conditional formatting on the consumption column to shade negative values and values more than double the meter's average. It takes five minutes to set up and saves an argument every month.
Six rules for a meter reading register
- One row per meter per cycle. Never overwrite last month's row; add a new one.
- The meter ID is the key, spelt exactly the same way every time.
- Previous readings come from the sheet, not from the reader. Showing the reader last month's number invites them to write something close to it.
- Record the dial as shown, including leading digits. Round nothing.
- A photo for every reading, or at least for every unusual one.
- A status for every unread meter, with the date of the next attempt.
Paper registers, forms and smart meters
A paper register works for a small society with one reader, as long as someone types it up the same day. A Google Form is a step up: the data lands in a sheet directly, although readers still have to type every field and attach the photo separately. Smart and remotely read meters remove the reading round altogether where they are installed, and are worth considering for large sites. For everyone else, the reading is still a person standing at a meter with a phone.
Getting readings in without typing
With vBol, the reader saves one WhatsApp number as a contact and, at each meter, sends a photo of the dial and a short voice note in their own language, Marathi, Hindi, Tamil, Telugu, Kannada or any of the others vBol supports:
vBol transcribes the note, fills in your meter reading record (meter, reading, unit) and reads it back on WhatsApp in the reader's language, with buttons to confirm or fix a field. Nothing is written until they confirm. The confirmed row lands in your Google Sheet, an Excel workbook on OneDrive or SharePoint, or Ekatm ERP, with the dial photo and GPS location attached to the row. Your consumption formula and checks then run on it like any other row; see how WhatsApp messages become Google Sheets rows.
At 7 PM the facility manager gets one WhatsApp message: what was filed, by whom, and which readers sent nothing that day. There is no app to install and no login for readers, and Vritti sets up the record type and the sheet with you. It is free for 30 days (up to 5 confirmed reports per person per day during the trial), then ₹199 per user per month for teams of up to 100 users, with a custom plan for bigger teams. See pricing.
Prefer to stay on a spreadsheet? Download the free template on this page. It has the columns above, dropdowns for meter type, status and dial photo, and three example rows you can overwrite.
Frequently asked questions
What is a meter reading sheet?
A meter reading sheet, or meter reading register, lists every meter read in a cycle: meter ID, consumer or unit, previous and current reading, consumption, date, who read it and any remarks. It is the source for billing and for spotting leaks or faulty meters.
How do you calculate consumption from meter readings?
Consumption is the current reading minus the previous reading for the same meter. In Excel, put a formula such as =H2-G2 in the consumption column, and check any row where the result is negative or far above that meter's usual figure.
Why take a photo of the meter dial?
A dial photo lets anyone check the reading later. It settles billing disputes quickly and makes guessed or copied readings much harder to get away with.
What should be recorded when a meter cannot be read?
Still make a row for it, with the reason (locked, not accessible, faulty) and the date of the next attempt. A blank row with a reason is far more useful than a missing row or a copied previous reading.