To compare electricity bills across the year, make a sheet with one row per bill and columns for units, amount, cost per unit and a note on what changed. Add a simple column chart of units and the seasonal pattern appears. Within a year you will see which months are expensive and why.
What columns should the sheet have?
- A: Bill month or billing period
- B: Units consumed, from the bill
- C: Amount paid, in rupees
- D: Cost per unit, with =C2/B2
- E: Note: guests, a new air conditioner, a week away, a different billing period
- F: Reading date, if the bill shows one
If your bills come every two months, enter them as they come, and add a column for days in the billing period. Then add G with units per day, =B2/days, so a 35-day bill and a 30-day bill can be compared fairly.
What does the pattern look like?
| Month | Units | Amount (₹) | Cost per unit (₹) | Note |
|---|---|---|---|---|
| January | 120 | 600 | 5.00 | Winter, geyser used |
| April | 210 | 1,260 | 6.00 | Fan and cooler start |
| May | 260 | 1,820 | 7.00 | AC in bedroom, guests |
| August | 190 | 1,045 | 5.50 | Monsoon |
| October | 150 | 750 | 5.00 | Festival month, lights |
These are made-up numbers. The cost per unit rises with usage, which is typical of tiered billing: May at 260 units costs ₹7 per unit, against ₹5 at 120. Check 1,820 divided by 260, which is 7, and 600 divided by 120, which is 5. The amount includes fixed charges and taxes, so cost per unit is an all-in figure, not the tariff rate.
Which formulas give you the summary?
- Total units for the year: =SUM($B$2:$B$13)
- Total paid: =SUM($C$2:$C$13)
- Average cost per unit for the year: =SUM($C$2:$C$13)/SUM($B$2:$B$13)
- Highest month by units: =INDEX($A$2:$A$13, MATCH(MAX($B$2:$B$13), $B$2:$B$13, 0))
- Difference between the peak and the lowest month: =MAX($B$2:$B$13)-MIN($B$2:$B$13)
The average cost per unit is the total paid divided by the total units, not the average of the twelve per-unit figures, because months with more units should count for more.
How do you add a chart?
Select the month column and the units column, then insert a column chart in Excel or Google Sheets. Add the amount as a line on a second axis if you wish. Colour the summer months differently, and the pattern will show clearly. If your sheet runs from April to March, keep the months in that order so that each financial year reads left to right.
What should you look for after twelve months?
- The peak month and its note, which tells you what drives your bill
- The lowest month, which is your baseline of fridge, fans and lights
- The gap between them, and whether a cheaper habit could shrink it
- Months where the cost per unit is unusually high, since this suggests a band boundary or a fixed charge change
Where do the payments come from?
Many people pay the bill through UPI or a bill-payment service. When you upload bank or card statements to SpendixAI, you can assign these payments to a Utilities category, which saves typing the amount column. The units and notes still come from the bill, so enter those in your sheet.
Next year
Copy the sheet, clear the numbers, and keep the old one for reference. When a month arrives, compare it with the same month last year first, and with last month second. Seasonal comparisons are fairer than month-to-month ones.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


