Getting started

Mobile recharge expense tracker: a simple sheet that tells you when to pay

Build a mobile recharge expense tracker in Excel or Google Sheets with next-due dates, days-left alerts and cashback columns, then see when an app is easier.

Editorial illustration for Mobile recharge expense tracker: a simple sheet that tells you when to pay

A mobile recharge expense tracker needs only a few columns: the date you recharged, the plan's validity in days, the amount paid, and a formula that adds the validity to the date to show the next due date. With a days-left column beside it, the sheet tells you when to pay as well as what you paid. Below is the set-up, with formulas that work in both Excel and Google Sheets.

What columns should the sheet have?

ColumnHeadingExample
ARecharge date3 March
BNumber labelOwn SIM
CAmount paid₹299
DCashback or discount₹10
EValidity in days28
FNext due dateFormula
GDays leftFormula

Format column A and F as dates. Use a label in column B rather than the full phone number, so the sheet can be shared with family without exposing numbers.

Which formulas do I need?

  • Next due date in F2: =A2+E2
  • Days left in G2: =F2-TODAY()
  • Net cost in H2: =C2-D2
  • Total net spend for a label, such as Own SIM, in a summary cell: =SUMIFS($H$2:$H$300,$B$2:$B$300,"Own SIM")
  • Recharges counted for that label: =COUNTIFS($B$2:$B$300,"Own SIM")

Check the logic with one row. If you recharge on 3 March with a 28-day plan, =A2+E2 gives 31 March, because 3 plus 28 is 31 and March has 31 days. Fill the formulas down for every new row, and keep one row per recharge. For a colour warning, select column G and add conditional formatting for values less than 4, so the cell changes colour when a plan is close to ending.

How should I treat cashback and wallet offers?

Record the amount you paid as the expense and the cashback as a separate figure in column D, then use the net cost in H. A ₹299 recharge with ₹10 cashback shows ₹289 net. If the cashback arrives later as a wallet balance and not a bank credit, note that in a comment, because it will not appear on your bank statement. Without this column, your sheet and your statement will never quite agree.

How do I check the sheet against my statements?

Once a month, pick one label and total the amounts in the sheet. Then search your bank or card statement for recharge payments in the same month and add those. Say the sheet shows ₹299 and ₹349 for the month, ₹648, while the statement shows ₹299, ₹349 and ₹199. The ₹199 recharge is missing from the sheet, probably a data pack bought in a hurry. Add it, and the two agree at ₹847.

When is a sheet no longer enough?

A sheet is fine for a few numbers. It strains when payments come through UPI apps, cards and wallets and you retype each one. SpendixAI can take the bank and card statements you upload, put recharge rows into a Mobile category and show the monthly total beside your other spending. It does not read SMS, so recharges paid from a wallet still need to appear in a statement or be added by hand.

What if a number is used for work?

Freelancers and shopkeepers often put a second SIM or a data plan on the business. Give it its own label, such as Work SIM, so the total can be reported on its own. Ask your CA whether and how it matters for your records; this page covers only the habit of keeping it separate and the receipts for it.

Monthly routine

  1. Add each recharge to the sheet on the day you pay.
  2. On the first of the month, check days left for every label.
  3. Reconcile the month's total with the statement.
  4. Note price changes in a comment so you can compare year on year.
SPENDIXAI JOURNAL

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

Explore your reports