Applying to many competitive exams means many small payments: form fees, photos and documents, travel, sometimes a stay. Log each one against the exam it belongs to, with the date and the result, and you will see the true cost of a whole job-search cycle and which exams were worth the money.
What should the tracker look like?
Use one row per cost, not one row per exam. That way an exam that needs a form fee, a photocopy bill and a train ticket shows up as three lines that add up.
| Exam | Cost type | Amount | Date | Note |
|---|---|---|---|---|
| Exam A | Form fee | ₹500 | 12 March | Paid by UPI, screenshot saved |
| Exam A | Travel | ₹1,800 | 20 June | Train, both ways |
| Exam B | Form fee | ₹100 | 3 April | Paid online |
| Exam C | Form fee | ₹750 | 18 April | Admit card received |
| Exam C | Travel | ₹2,600 | 9 July | Train and cab |
Add a separate small table for results: exam, appeared or not, outcome. That is where the cost per attempt starts to mean something.
What cost types should you use?
- Form fee: the amount charged by the recruiting body.
- Documents: photographs, photocopies, attestation, scanning or any certificate you had to order.
- Travel: bus, train, cab or fuel to reach the exam centre.
- Stay and food: for an exam in another city.
- Preparation add-ons: a mock test or a paper bought only for this exam.
Some bodies offer fee concessions or refunds to certain applicants. If one applies to you, write the amount you actually paid, and add a line if a refund is promised so you can check it arrives.
How do you total the cycle?
Say you applied to six exams with form fees of ₹500, ₹100, ₹750, ₹800, ₹500 and ₹1,000. These are made-up amounts. Together they are ₹500 + ₹100 + ₹750 + ₹800 + ₹500 + ₹1,000 = ₹3,650. Two of them needed travel, costing ₹1,800 and ₹2,600, a total of ₹4,400. The cycle cost is ₹3,650 + ₹4,400 = ₹8,050.
If you actually appeared in four of the six, then the cost per exam you sat is ₹8,050 ÷ 4 = ₹2,012.50. That is a harder number than the form fees alone, and it helps you choose which forms to fill next time.
What formulas keep the sheet honest?
Put the exam name in column A, the cost type in column B, the amount in column C and the date in column D. Then these formulas work in Excel or Google Sheets.
- Total for one exam, whose name is typed in F2: =SUMIFS($C$2:$C$200,$A$2:$A$200,F2)
- Total of one cost type, for example travel: =SUMIFS($C$2:$C$200,$B$2:$B$200,"Travel")
- Grand total of the cycle: =SUM($C$2:$C$200)
- Cost per exam sat, with the count of exams sat typed in H1: =SUM($C$2:$C$200)/H1
Which exams are worth the fee?
The tracker cannot tell you which exams to take, but it can show patterns. If your travel costs are far larger than your form fees, maybe a nearer centre or a different city choice is possible. If many of your forms were never followed by an attempt, you may be applying too widely. Look at the results table before the next cycle and decide how many forms you can actually prepare for.
How can SpendixAI help?
If form fees go out through a card or bank account that you upload statements for, they appear as rows to review, and you can keep them in a custom category of your own, such as Exam forms. You can also add the cash spent on photocopies by hand. For a small list, a sheet is perfectly adequate.
An end-of-cycle review
- Total by cost type.
- Total by exam.
- Exams applied for versus exams sat.
- Fees where a refund is still due.
- Budget for the next cycle.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
