To track an electricity bill properly, record the units used as well as the amount, compare each month with the same month last year, and look at the cost per unit when a bill surprises you. The rupee figure moves with the weather; the units tell you whether you are using more. It takes a couple of minutes when the bill arrives.
What should I record each month?
- Billing period and due date
- Units consumed, from the bill or the meter
- Amount payable, and the amount you actually paid
- Date and mode of payment
- Any late fee, arrears or adjustment, on its own line
- The meter reading, if you also like to check it yourself
How often does it arrive?
Monthly for most households, though some areas bill every two months and some meters are prepaid with top-ups of any amount. Look at your last bill to see the cycle. For a two-monthly bill, treat each payment as covering two months and, for planning, halve it. For a prepaid meter, record each top-up on the day, and keep a rough note of how many days it lasted.
A hypothetical year
To keep the arithmetic easy, say your bill is a fixed charge of ₹150 plus ₹7 per unit. Real tariffs are more complicated, so use this only to see the idea.
| Month | Units | Bill | Per unit |
|---|---|---|---|
| January | 180 | ₹1,410 | ₹7.83 |
| April | 300 | ₹2,250 | ₹7.50 |
| May | 380 | ₹2,810 | ₹7.39 |
| July | 260 | ₹1,970 | ₹7.58 |
Check the arithmetic: January is 150 + 7 × 180 = 150 + 1,260 = ₹1,410; April is 150 + 2,100 = ₹2,250; May is 150 + 2,660 = ₹2,810; July is 150 + 1,820 = ₹1,970. The cost per unit is the bill divided by the units, so 1,410 divided by 180 is about ₹7.83. In this example, it falls as the units rise because the fixed charge is spread over more units.
Can a spreadsheet help?
Yes. Put the month in column A, units in column B and the bill in column C, rows 2 to 13.
- =C2/B2 in column D gives the cost per unit for each month; copy it down
- =AVERAGE($C$2:$C$13) gives the average monthly bill for the year
- =MAX($C$2:$C$13) shows the most expensive month
- =SUMIFS($C$2:$C$13, $A$2:$A$13, "May") would pick the bill for a named month if the months are typed as text
Excel and Google Sheets both support these functions.
How do I spot a jump?
Compare units first. If the units rose a lot, something in the house changed, such as a new appliance, guests, or a hotter spell. If the units are about the same but the bill rose, look for a tariff revision, an arrear, a late fee or an estimated reading. If you see an estimated or unusual reading, ask the electricity company to explain it, using their official channel.
What does a sensible review look like?
- Each month: log units and amount in under a minute
- Each quarter: check the cost per unit and look for any unexplained change
- Each year: total the twelve bills, find the highest and lowest months and note what drove them
- Before a big purchase such as an air conditioner: look at your usage in the hottest months first
Where does SpendixAI fit?
SpendixAI can import the bank or card line for your electricity payment and file it under a Utilities category, and you can attach the bill as a receipt on the transaction. It records the rupee amount; the units stay on the bill, so keep them in your own small sheet if you want to compare months.
In short
- Record units as well as rupees
- Compare with the same month last year
- Check the cost per unit when a bill surprises you
- Keep late fees and arrears separate
- Save the bill with each payment
Useful ideas start with a clearer picture of your own spending.
Explore your reports

