A test series tracker is a table with one row per series: what you paid, the date it expires, how many tests there are and how many you have taken. The last two columns tell you whether the fee was worth it, and the expiry column stops a lapsed series from silently costing you again.
What should the tracker contain?
| Column | What to enter |
|---|---|
| Series name | The name as shown on the receipt |
| Fee paid | Amount in rupees, after any discount |
| Paid on | Date of payment |
| Valid till | Expiry date shown at purchase |
| Tests in series | Total number promised |
| Tests taken | Update each week |
| Auto-renew | Yes or no, and how it renews |
Add a notes column for details such as a coupon used or a refund promised. If you bought through a coaching institute, note whether the series was bundled with another fee.
How do you find the cost per test taken?
Divide the fee by the number of tests you have actually taken. The result tells you what each test has cost so far. Say you paid ₹2,400 for a series of 30 tests and have taken 9 so far.
- Cost per test taken so far: ₹2,400 ÷ 9 = ₹266.67.
- If you finish all 30: ₹2,400 ÷ 30 = ₹80.
- Tests left: 30 − 9 = 21.
The figure falls as you use the series. If three months later you have taken only 12 tests, the cost per test is ₹200, and you know that the series is underused. In a spreadsheet, with the fee in column B and the tests taken in column F, the formula is =IF(F2=0,"",B2/F2). It leaves the cell blank until you have taken at least one test.
How do you stop lapsed subscriptions from being forgotten?
Add a status column that reads the expiry date. If the valid-till date is in column D, then =IF(D2<TODAY(),"Lapsed","Active") shows the status at a glance. Sort by it once a month. If a series has lapsed and you have tests left, decide whether to renew, to switch or to let it go.
What should you ask before buying a new series?
- How many full-length tests are promised, and how many are only topic tests?
- How long is the validity, and is there a way to extend it?
- Is there a refund policy, and what is written about it at checkout?
- Will you realistically have time to take every test in the validity period?
- Does a free sample test show the quality of the questions and the analysis?
How often should you review the tracker?
Once a month, on a fixed date, is enough. Total the fees paid in the month, look at what is lapsing and update the tests taken. At the end of the preparation cycle, add up all series fees. That number, along with exam form fees and books, is your real preparation cost, and it can feed into how you plan the next attempt.
Where does SpendixAI help?
When a sheet stops being enough, SpendixAI can bring your statement rows in, so subscription debits that you forgot to log still show up. A custom category such as Exam prep lets you total fees for the year, and you can attach the receipt to each payment.
A last point on honesty with yourself: a series you paid for and never opened is a cost, not an asset. Mark it clearly in the tracker, with the amount, and let it inform what you buy next. Many aspirants find that two series used properly are worth more than five bought in a rush, and the cost-per-test column is what makes that visible.
A monthly tracker routine
- Update tests taken for each series.
- Check the lapsed or active status.
- Look for recurring debits in your statement.
- Decide: renew, switch or drop.
- Write the total spent on test series so far.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

