Live Google Sheet Dashboard

Electricity Bill Dashboard

Choose any visible month sheet from your ledger and view total usage, recharge, unit price, common bill, tenant bills, paid amounts, dues, and month-by-month comparisons.

Open Google Sheet

API key setup

Connect exact sheet tabs

This version uses the official Google Sheets API so newly added month sheets appear automatically. Paste your restricted Google Sheets API key once; it will be saved only in this browser.

Preparing dashboard...

Selected month

No sheet loaded

— —

Tenant details

Sub-meter, Meter Bill, Common Bill, Paid & Due

User Sub-meter Unit Usage vs Prev. Meter Bill Common Space Bill Total Bill Paid Due Status

Due chart

Positive Due by User

Billing analytics

Useful Month-by-Month Insights

All loaded sheets

Monthly Snapshot

Sheet Total Monthly Usage Total Monthly Recharge Per Unit Price Total Common Bill Total Tenant Bill Total Paid Total Due Users