Subscriptions billed weekly, fortnightly or by semester cannot be added up as they stand. Convert each to a monthly figure with one spreadsheet formula, and the total shows what you really pay.
Why are student subscriptions hard to add up?
Student plans come in awkward rhythms: a study app that bills weekly, a game pass every fortnight, a textbook platform each semester, plus a few ordinary monthly ones. Looking at each on its own, nothing seems large. Together they can take a real bite out of a part-time wage.
What does the formula look like?
Put the amount in column B and the billing rhythm in column C. Type this in D2 and fill it down:
=IF(C2="Weekly",B2*52/12,IF(C2="Fortnightly",B2*26/12,IF(C2="Half-yearly",B2/6,IF(C2="Yearly",B2/12,B2))))
It reads the word in column C and applies the matching conversion; anything else is treated as monthly. Then =SUM(D2:D20) gives your monthly total, and =SUM(D2:D20)*12 the yearly one. Spell the rhythm words exactly as in the formula.
A worked example
| Subscription | Amount | Rhythm | Monthly equivalent |
|---|---|---|---|
| Video | A$9.99 | Monthly | A$9.99 |
| Music | A$5.99 | Monthly | A$5.99 |
| Study app | A$4.00 | Weekly | A$17.33 |
| Game pass | A$5.00 | Fortnightly | A$10.83 |
| Cloud storage | A$1.49 | Monthly | A$1.49 |
| Textbook platform | A$60.00 | Half-yearly | A$10.00 |
Adding up: 9.99 + 5.99 + 17.33 + 10.83 + 1.49 + 10.00 = A$55.63 a month, or A$667.56 a year (55.63 x 12). The weekly study app, at A$4.00, is the biggest single line, which the weekly price did not suggest. Figures are invented.
Where do you find them all?
- Statements from every account, including a parent-linked one.
- Your phone's list of subscriptions.
- Student email, where platforms send receipts.
- Any payment app you top up, if it records repeats.
Which ones are worth keeping?
Mark each as used this week, used this month, or not used. Cancel the third group straight away. For the second, check whether a student rate or a shared plan exists; whether you qualify is for the provider to say.
Keeping it small
Review the sheet at the start of each semester and whenever your income changes. SpendixAI summarises uploaded statements in a dashboard, though it is built around India and INR, so for Australian-dollar accounts the sheet above is what to use.
What do you do about cheap-looking weekly charges?
Weekly charges are the sneakiest: A$4.00 feels like a coffee. Multiply by 52 and it is A$208.00 a year. Ask whether the thing it buys is worth A$208.00 over twelve months, not whether it is worth A$4.00 this week.
Do the same sum for the fortnightly game pass: A$5.00 x 26 = A$130.00. Seeing yearly figures beside the monthly ones makes the decision plainer. Cancel anything you would not buy as a single yearly purchase at that price, and keep what you would.
- Weekly charges: multiply by 52.
- Fortnightly charges: multiply by 26.
- Half-yearly charges: multiply by 2.
What if the formula returns the wrong number?
Check three things. First, that the rhythm word in column C matches the word inside the formula exactly, including capital letters and no trailing space. Second, that the amount in column B is a plain number, not text with extra words typed in. Third, that the range in the SUM covers every row you filled. A single misspelt rhythm word is the usual culprit, and it makes the line count as monthly. After fixing it, compare the new total with your first attempt; a large jump usually means a weekly or fortnightly line was being undercounted all along.
Checklist
- List every repeating charge.
- Add the rhythm word.
- Fill the formula down.
- Total, then multiply by twelve.
- Cancel the unused and diary the rest.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

