To compare subscriptions fairly, convert each to a monthly cost: divide a yearly price by 12, a quarterly one by 3, a half-yearly one by 6, and multiply a weekly price by 52 and divide by 12. Add the results and you have the true monthly total, which is nearly always bigger than the number you think you pay.
What are the conversion factors?
| Billing cycle | Formula to monthly | Why |
|---|---|---|
| Weekly | price × 52 ÷ 12 | 52 weeks in a year, spread over 12 months |
| Fortnightly | price × 26 ÷ 12 | 26 charges in a year |
| Monthly | price × 1 | Already monthly |
| Quarterly | price ÷ 3 | 3 months per charge |
| Half-yearly | price ÷ 6 | 6 months per charge |
| Yearly | price ÷ 12 | 12 months per charge |
Do not use 4 for weeks in a month. Four weeks make a 48-week year, which is why weekly plans cost more than they look.
A worked example with five subscriptions
These are made-up services and prices.
| Subscription | Billing | Price | Monthly cost | Yearly cost |
|---|---|---|---|---|
| News site | Weekly | ₹49 | ₹212.33 | ₹2,548 |
| Streaming bundle | Quarterly | ₹597 | ₹199.00 | ₹2,388 |
| Photo storage | Yearly | ₹1,499 | ₹124.92 | ₹1,499 |
| Music | Monthly | ₹299 | ₹299.00 | ₹3,588 |
| Fitness app | Half-yearly | ₹1,200 | ₹200.00 | ₹2,400 |
Check the working: 49 × 52 = 2,548, and 2,548 ÷ 12 = 212.33. Next, 597 ÷ 3 = 199 and 597 × 4 = 2,388. After that, 1,499 ÷ 12 = 124.92. Then 299 × 12 = 3,588, and 1,200 ÷ 6 = 200. The monthly costs add to 1,035.25, and the yearly costs add to 2,548 + 2,388 + 1,499 + 3,588 + 2,400 = ₹12,423, which equals 12 × 1,035.25.
So five subscriptions that feel like a handful of small bills come to a little over ₹1,000 a month.
Is a yearly plan always cheaper?
Only if you would use the service for the whole year. Say a service charges ₹199 monthly or ₹1,999 yearly. Twelve monthly payments are 199 × 12 = ₹2,388, so the yearly plan saves ₹389, and works out to ₹166.58 a month. But if you would cancel after five months, five monthly payments cost ₹995, which is less than ₹1,999. The saving is real only if you stay.
How do you do this in a sheet?
- Billing cycle in column B, price in column C.
- =IF(B2="Weekly", C2*52/12, IF(B2="Quarterly", C2/3, IF(B2="Half-yearly", C2/6, IF(B2="Yearly", C2/12, C2)))) in D2 for the monthly cost.
- =D2*12 in E2 for the yearly cost.
- =SUM($D$2:$D$50) under the list for the total.
The last argument of the nested IF returns the price unchanged, which covers Monthly. Spell the cycle names exactly the same every time.
Which price should you use?
Use the amount actually debited on your statement, not the headline price on a website. Displayed prices may or may not include GST or other charges, and a plan may have risen since you signed up. If your statement shows ₹354 for a plan advertised as ₹299, work with ₹354, because that is what leaves your account.
Does the same logic apply to apps you pay for yourself?
Yes. SpendixAI Pro, for example, is priced at ₹99 a month or ₹999 a year, and the yearly price saves ₹189 against twelve monthly payments, because 99 × 12 = 1,188 and 1,188 − 999 = 189. Works out to about ₹83 a month. That is the same sum worth doing for any plan, including this one.
Closing checklist
- List every plan with its billing cycle.
- Convert each with the factor table.
- Add the monthly total and multiply by 12.
- For each yearly plan, ask whether you will really stay the whole year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


