To track all your subscriptions in one place, build a single list with one row per recurring payment and these columns: name, amount, billing cycle, next renewal date, how it is paid and how to cancel. Fill it from three sources: your card statements, your bank account debits and the autopay or mandate area of your UPI app. A few formulas then turn it into a monthly total.
Where do recurring payments hide?
- Credit and debit cards: a merchant charges the card on the same day each cycle.
- Bank account debits: direct debits and standing instructions that appear as regular entries.
- UPI autopay: you approved a mandate once and the merchant collects each cycle. Look for a section on autopay or mandates in your UPI app; the name and location vary by app.
- Phone app store: subscriptions bought through your Android or iPhone account are listed in its subscription settings.
- Wallets: some services bill a wallet balance, not a card.
Open each source and copy every recurring item. Do not worry about duplicates yet; you will merge them in the list.
How should the sheet be laid out?
| Name | Amount | Cycle | Next renewal | Paid via | Monthly cost |
|---|---|---|---|---|---|
| Video streaming | ₹499 | Quarterly | 15 Dec | Credit card | ₹166.33 |
| Cloud storage | ₹1,300 | Yearly | 2 Mar | UPI autopay | ₹108.33 |
| Gym | ₹1,500 | Monthly | 5th each month | Bank debit | ₹1,500 |
The figures are made up. The Monthly cost column is where the formulas do the work.
Which formulas turn it into a total?
Assume amounts sit in column B, the cycle text in column C, rows 2 to 60. To convert any row to a monthly amount, put this in F2 and copy it down:
- =IF(C2="Yearly", B2/12, IF(C2="Quarterly", B2/3, IF(C2="Half-yearly", B2/6, B2)))
- Total per month: =SUM($F$2:$F$60)
- Total per year: =SUM($F$2:$F$60)*12
- Yearly-only items: =SUMIF($C$2:$C$60, "Yearly", $B$2:$B$60)
For renewal dates, store real dates in column D, not text. Then =D2-TODAY() shows days left, and you can colour cells where it is under 7 using conditional formatting. These formulas work in both Excel and Google Sheets. Spelling must match exactly: "Yearly" and "yearly " with a trailing space count as different, so use a drop-down list for the cycle if you can.
What about payments with no fixed date?
Some payments, like a food-delivery membership, renew on the day of first signing up. Note that day when you first see the charge on a statement. Where you cannot find a renewal date, write the date of the last charge and add one cycle. Update the next date after each renewal, or add a reminder in your phone calendar that repeats.
When does a sheet stop being enough?
A sheet is a good start, but you have to type every row. If you want the repeating charges found for you, SpendixAI can import card and bank statements, each transaction keeping its own account, and you can filter and group by merchant to find monthly repeats. It does not connect to your bank or read SMS, so it only sees the statements you upload.
How do you keep the list current?
- Set a calendar reminder on the first of each month to review the list.
- Add any new recurring charge you spot on statements.
- Remove cancelled items, but keep the cancel date in a notes column.
- Check each row's next renewal date against the actual statement.
- Mark any item you did not use in the last month as review.
The aim is one honest list. Once it exists, the total each month becomes easy to see and easy to argue with.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

