Shopping

Electricity and recharge bills with UPI cashback: net cost by month

Track gross bill, UPI cashback and net cost for electricity, mobile and broadband over three months to see if the offers changed what you really paid.

Editorial illustration for Electricity and recharge bills with UPI cashback: net cost by month

To see whether UPI cashback on bill payments changes your real cost, track three numbers for each recurring bill each month: the gross amount you paid, the cashback received, and the net, which is gross minus cashback. In the made-up example below, three bills over three months cost ₹8,897 and returned ₹120, which is a net of ₹8,777. Useful to know, but not life-changing.

What columns should the sheet have?

  • Month and bill name (electricity, mobile recharge, broadband).
  • Gross: the amount that left your account.
  • Cashback: the amount credited later, entered in the month you actually received it.
  • Net: gross minus cashback, as a formula.
  • A notes column for fees, late charges or a cashback that did not arrive.

If you pay through an app that adds a convenience fee, record that fee as part of the gross, since it is part of what you paid. Check your statement to see whether such a charge exists.

A made-up three-month sheet

Say your electricity bill varies, a mobile recharge is a steady ₹299 and broadband is ₹800 a month. Here is the January to March gross, cashback and net.

MonthElectricityMobileBroadbandGrossCashbackNet
Jan₹1,840₹299₹800₹2,939₹35₹2,904
Feb₹1,610₹299₹800₹2,709₹20₹2,689
Mar₹2,150₹299₹800₹3,249₹65₹3,184
Total₹5,600₹897₹2,400₹8,897₹120₹8,777

In Excel or Google Sheets, with gross in E2 and cashback in F2, the net in G2 is =E2-F2, and the total row can be =SUM(G2:G4). The cashback total of ₹120 is about ₹1.35 for every ₹100 of bills here, and the electricity bill alone swung by ₹540 between February and March, which is far larger than any cashback.

Electricity is the line to watch. Because it moves with usage, compare it with the same month a year earlier if you have that record, and note festival months or visiting guests that pushed it up. Then a high bill is not mistaken for a cashback problem.

Did the offers change your real cost?

This is the question the sheet answers. Look at the cashback column next to the month-to-month swing in the gross column. In this example, cashback moved the net by ₹20 to ₹65 a month, while the electricity bill moved it by hundreds. The offers helped slightly, but your usage drove the cost. That is a sensible thing to know before you plan a month around an offer.

When is it worth switching how you pay?

Only if the net is lower after counting everything. If one payment route gives ₹10 back but adds a fee of ₹10, nothing changed. If cashback arrives weeks later, enter it in the month it arrives and add a note naming the bill it belongs to. If a payment fails and is retried, make sure you have not recorded the bill twice.

Late charges deserve a note too. If a bill is paid after its due date and a late fee appears, add it to the gross. One late fee can outweigh several months of cashback, and the sheet will show that plainly.

How does this look in a tracker app?

The gross amounts arrive with your bank statement, categorised under bills. Cashback credits come either as small lines in a statement or as wallet rewards you add by hand. In SpendixAI you can import the statement, review the rows, add the credits manually and then use a report to compare a month's Utilities total with and without the cashback line.

A monthly check in five minutes

  1. List each recurring bill and the amount you paid.
  2. Add any cashback credited since last month.
  3. Compute net as gross minus cashback.
  4. Note fees and failed payments.
  5. Look at the three-month total, not just one month.
SPENDIXAI JOURNAL

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

Explore your reports