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.
| Month | Electricity | Mobile | Broadband | Gross | Cashback | Net |
|---|---|---|---|---|---|---|
| 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
- List each recurring bill and the amount you paid.
- Add any cashback credited since last month.
- Compute net as gross minus cashback.
- Note fees and failed payments.
- Look at the three-month total, not just one month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

