Expense categories

How to track shop electricity month by month

How to track shop electricity each month: what to record from the bill, how to compare units and cost, and a worked month with simple numbers.

Editorial illustration for How to track shop electricity month by month

To track shop electricity, record three numbers from every bill: the amount, the units consumed and the period it covers. The amount tells you what you paid, the units tell you how much you used, and dividing one by the other shows the effective cost per unit. If the bill jumps, the units will tell you whether you used more or whether the cost per unit rose.

What should you write down from each bill?

  • Billing period and due date.
  • Units consumed (the difference between the current and previous meter reading).
  • Total amount payable, and the amount you actually paid.
  • Date and mode of payment: UPI, net banking, card or cash at a collection counter.
  • Any extra: a late payment charge, a deposit adjustment or a meter fault note.

Some bills come every month and some every two months, depending on where you are, so look at your own bill rather than assuming. If yours is bimonthly, record it for the period it covers and split the amount across both months when you look at monthly totals.

What does a worked month look like?

Say last month's bill was ₹4,000 for 400 units. That is 4,000 ÷ 400 = ₹10 per unit as an effective figure. This month, the bill is ₹4,700 for 450 units, or about ₹10.44 per unit. The units went up by 50, which is 12.5 per cent, while the amount went up by ₹700 (17.5 per cent). The amount rose faster than the units, which suggests a fixed charge or a higher rate on the extra units. The effective rate includes fixed charges and any taxes on the bill, so it is a rough guide, not the tariff. Check your bill for the breakdown.

MonthUnitsBillEffective per unit
Previous400₹4,000₹10.00
Current450₹4,700₹10.44
Change+50+₹700+₹0.44

How do you spot a change that needs attention?

Compare the bill with the same month last year, not just last month, because shops that run fans, coolers or air conditioners use more in summer. A bill that is higher than last year's same month with similar business hours deserves a look. Things to check: new equipment, a freezer or display lights left on overnight, a faulty meter reading, or a mistake in the units billed.

Is the shop on its own meter?

If the shop shares a connection with a home above or behind it, the bill mixes two things. Try to get a separate meter, or at minimum agree a fixed share and note it, so the shop's cost is not overstated or understated. Do not move personal costs into the shop, or shop costs into the home, to make the numbers look tidier. How electricity is treated in your accounts, including any GST on it, is a question for your CA.

What does a sensible monthly review involve?

  1. Enter the bill on the day you pay it, with units and period in the note.
  2. Compare units with last month and with the same month last year.
  3. Calculate the effective per-unit figure and watch the trend.
  4. Check electricity as a share of sales.
  5. Note anything unusual, such as new machines or longer opening hours.

SpendixAI is a tracker for one personal workspace, so it fits a small shop owner who wants to see electricity next to rent, stock purchases and other costs. If the bill is paid through a bank or card statement you import, a rule on the electricity board's name will categorise it, and the Report builder can total it by month.

Before the due date

Mark the due date somewhere you will see it. A late payment charge is a cost that tells you nothing, so keep it as its own line, and you will see how much late payments cost over a year.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports