How are water and electricity consumption calculated?

Consumption = current reading minus previous reading, amount = consumption × rate.

What if the rates change?

Enter two rates and the change month on the “Settings” sheet; the new rate applies from the next period.

How do I see whether I owe anything?

In the bottom row of “Charges” the balance is a running total: negative is a debt, positive is an overpayment.

Can I add my own service?

Yes, up to 12 services; the calculation method is by meter, by area or fixed.

← All templates

Utility Bills Tracker — Excel Template

Meter readings, rates, monthly charges, payments and balance; the rate can change mid-year.

≈ $3.59

290 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

Utility bills are easy to mix up: what is metered, what is by area, what has been paid. Enter readings and payments — the workbook calculates consumption, charges and balance, and shows whether there is a debt or an overpayment.

What is inside

“Settings”: address, floor area, year, services with rates and the month the rates change.
“Readings”: meter consumption is calculated from the previous reading.
“Payments”: payments for each month.
“Charges”: a matrix of services by month, total, paid and balance.
“Summary”: yearly totals by service and a chart.

Who it is for

Homeowners and tenants, building managers and residents’ associations, and small offices that pay utility bills and want to keep an eye on costs.

What you get

An empty template and a filled-in sample with fictitious data, so you can see how the formulas and checks work. It is an Excel template built on ordinary formulas. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Rates are in the settings: take them from your bill. The calculation is indicative. The file is in English.

📘 How to Track Utility Bills and Meter Readings in Excel

Questions and answers

How are water and electricity consumption calculated?: Consumption = current reading minus previous reading, amount = consumption × rate.
What if the rates change?: Enter two rates and the change month on the “Settings” sheet; the new rate applies from the next period.
How do I see whether I owe anything?: In the bottom row of “Charges” the balance is a running total: negative is a debt, positive is an overpayment.
Can I add my own service?: Yes, up to 12 services; the calculation method is by meter, by area or fixed.