Utility Usage Report

✅ Verify summary

Loading files…

Months to display

Data files

0 selected

Search by Customer ID

Filter by Block

Residents

—

Months available

—

Latest month total

—

Avg / Flat

—

Usage Trend

—

Non-working Meters

—

latest month

⚠️ Note: Some readings may appear higher than normal. This could be due to meter issues or incorrect pulse generation causing reading jumps.

💧 Water

🔥 Gas

⚡ Electricity

💰 Amount & Balance

⚙️ Cost & Config Check

⚠️ Unrecognised Customer IDs (grouped as "Unknown") — 0 IDs

These IDs did not match any block pattern. Share them to fix the parsing logic.

🔇 Non-Working Meters — 0 total (zero consumption in latest month)

New this month — 0 (was working last month)

Persistently non-working — 0 (zero both months)

Recovered this month — 0 (was zero last month)

🔧 Meter Reading Issues — 0 records (excluded from water consumption totals)

Month	Customer ID	Meter	Present Reading	Previous Reading	Difference	Consumption Col	Issue

Flat

Charts could not be loaded (chart library unavailable) — the monthly table below still has all the figures.

💧 Water usage kL / month

🔥 Gas usage units / month

⚡ Electricity usage kWh / month

💰 Monthly charges ₹ — electricity, water, gas and maintenance

🏦 Closing balance ₹ at month end — below zero means dues

📋 Month-by-month

✅ Verify monthly summary sheet

Checks the summary workbook (block sheets and the Summary tab) against the MIS report of the same month in Drive — every flat, every block and the overall totals. The workbook is read in your browser; it is not uploaded anywhere.

1. Summary workbook (.xlsx)

2. MIS report in Drive (picked by month)

Allowed difference (₹)

🔐 Sign in to view Utility Usage Report