Keep one row per recharge in a small log with these columns: number (a nickname, not the full number), date, amount, plan validity, expiry date and who paid. Add a reminder a few days before each expiry. With four or five numbers in a family, this catches lapsed plans and shows what mobile really costs each month.
Why does recharge spending get lost?
Recharges come in ones and twos, through UPI apps, wallets, shop counters and sometimes cash. Different people in the family pay for different numbers, and plans have different validity, such as 28 days, 56 days or a full year. A month rarely holds exactly one recharge per number, so the total drifts and nobody can say how much the family spends.
What goes in the recharge log?
| Number (nickname) | Recharged on | Amount (₹) | Validity | Expires on | Paid by |
|---|---|---|---|---|---|
| Dad | 2 Nov | 299 | 28 days | 30 Nov | Dad, UPI |
| Mom | 9 Nov | 299 | 28 days | 7 Dec | Dad, UPI |
| Child 1 | 15 Nov | 199 | 28 days | 13 Dec | Self, UPI |
| Grandparent | 1 Oct | 1,799 | 365 days | 30 Sep next year | Cash |
The prices and dates are examples. Use your own plans and write down the expiry as it appears on the confirmation message. Expiry rules vary, so do not calculate it blindly.
How do I get a monthly total across numbers?
Put the amount in column C and the month of recharge in a helper column. Then total each month with =SUMIFS($C$2:$C$300, $G$2:$G$300, "Nov") where column G holds the month name. To total a single person's numbers, use another SUMIFS with the nickname column as a second condition.
Longer plans need one more step if you want fair monthly figures. A yearly plan of ₹1,799 costs about ₹150 a month, since 1,799 divided by 12 is 149.9. Record the full payment when it happens, but also note the monthly equivalent so one big month does not look like a spike.
How do I stop plans lapsing?
- Write the expiry date in a calendar entry titled with the nickname, set three days before expiry.
- If the number is for a child or an elder, send the reminder to whoever pays.
- After you recharge, update the log and move the calendar reminder.
- If a plan lapses anyway, note the date and any extra cost for the next recharge.
What about who paid?
In many families one person pays for everyone. If that matters, add a column for who benefited. Parents paying for children is a family cost, while an employer reimbursing a work number is a different story. For reimbursements, keep the proof of each recharge so the claim is clear. Do not mix them into your own spending total unless you want them there.
Where do my tools fit?
If you import UPI-linked bank statements into SpendixAI, recharges appear as separate transactions and a rule for the operator's name can file them under Mobile or Phone. Cash recharges can be added by hand. The expiry reminder is still best kept in your phone calendar.
What if the family shares one bigger plan?
Some families use a single plan with add-on connections. Then the log needs one extra field, the connection each charge covers, so you can still see what each person costs. Record the combined bill once and split it by connection in a second column. If the plan is paid after the month, as postpaid plans usually are, log the bill on the date you pay it and keep the bill month in a note so the totals match the usage period.
Monthly checklist
- Add each recharge to the log on the day you pay.
- Tick the expiry reminder as done.
- Compare the month's total with the previous month.
- Review the plans every few months in case a lower-priced option meets everyone's needs.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


