Getting started

Recording your electricity bill in an expense tracker, step by step

How to record an electricity bill in an expense tracker: bill month versus payment date, shared flats, late fees and prepaid recharges, with an example.

Editorial illustration for Recording your electricity bill in an expense tracker, step by step

Record your electricity bill in an expense tracker as one entry on the day the money leaves your account, in a Utilities category, with the bill month written in the note. That small habit keeps your cash picture right and still lets you compare June's bill with last June's, even if you pay a week late.

What is the difference between the bill date and the payment date?

A bill generated on 3 June for May usage might be paid on 20 June. Your bank statement shows 20 June. If you log by bill date, your tracker will disagree with the statement and your monthly totals will drift. Log by payment date, then put the usage month in the note field, for example Usage May 2026. When you want a seasonal comparison you can filter on that note.

How do I set it up?

  1. Create a category called Electricity, or a sub-category under Utilities.
  2. Add the same merchant name every time, such as the power distribution company's name as it appears on your statement.
  3. Record the amount actually debited, including any convenience fee for paying through a wallet or card.
  4. Add the units from the bill in the note, so you can calculate rupees per unit later.
  5. Attach a screenshot or PDF of the bill if your tracker supports receipts.

If a rule can match that merchant name, create it once so every future payment lands in Electricity without effort.

What about a prepaid meter or a recharge?

With a prepaid meter you top up when you wish, so payments are irregular. Record each recharge as it happens, and keep a separate monthly view that adds them up. Say you recharge ₹1,500 on the 4th, ₹1,000 on the 17th and ₹800 on the 29th. Your month shows ₹3,300, and that is the figure to compare with your plan, even though no single bill existed.

A worked example with made-up numbers

Date paidUsage monthUnitsAmount paidRupees per unit
20 AprMar210₹1,680₹8.00
19 MayApr300₹2,550₹8.50
22 JunMay420₹3,990₹9.50

Rupees per unit is amount divided by units: 1,680 divided by 210 is ₹8.00, and 3,990 divided by 420 is ₹9.50. The rate rising as usage rises is a sign of tiered charges or fixed fees in the bill; read the bill's own charge lines instead of guessing which. In a sheet, with amount in D2 and units in C2, =D2/C2 does the calculation.

How do I handle shared flats?

If three flatmates share one bill and you pay it, record the full payment, then record what each person pays you back as a reimbursement against the same category. Your net electricity cost is then your share. For example, a ₹3,000 bill split three ways leaves you with ₹1,000 net once two friends send ₹1,000 each. Some trackers have no split feature, so use a negative or credit entry for the repayments and note who paid.

Where can an app help?

SpendixAI can import your bank or card statement, apply your own category rules and keep the bill's receipt with the transaction. You add the usage note and units by hand. It does not connect to your bank or read SMS, and bills paid in cash need manual entry.

How do I check that the year adds up?

At year end, total the twelve payments. In a sheet, if payments sit in column D, =SUM($D$2:$D$13) gives the total, and =AVERAGE($D$2:$D$13) gives the monthly average. Say the total is ₹28,800; divided by 12 that is ₹2,400. If your tracker's electricity category shows a different total, a payment was filed under another category or paid through a different account. Search the amounts to find it.

A monthly routine

  • Log the bill on payment day.
  • Write usage month and units in the note.
  • Check that the category total matches your statement for the month.
  • Compare rupees per unit against the same month last year.
  • Set a reminder three days before the due date, so late fees do not arise.
SPENDIXAI JOURNAL

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

Explore your reports