Applying to ten universities costs far more than ten application fees. Each one can add transcripts, courier charges, score reports and sometimes a document check, so the true cost per university only shows up when you give each its own row. Build one sheet with a row per university, columns for each cost, a total per row, and a status column that tells you what is still pending.
Which columns should the table have?
Keep the columns the same for every university so that you can add them up and compare. Seven are enough: university, application fee, transcript, courier, score reports, total and status. If a university charges in dollars or pounds, add one more column for the foreign amount and one cell for the exchange rate you are using, and convert into rupees in the fee column. Dates matter too, so add a deadline column if you are applying to several rounds.
What does a filled table look like?
| University | Fee | Transcript | Courier | Score reports | Total | Status |
|---|---|---|---|---|---|---|
| University A | ₹6,500 | ₹1,200 | ₹2,800 | ₹1,800 | ₹12,300 | Submitted |
| University B | ₹7,500 | ₹1,200 | ₹0 | ₹1,800 | ₹10,500 | Docs pending |
| University C | ₹5,000 | ₹1,200 | ₹2,800 | ₹1,800 | ₹10,800 | Not started |
| All three | ₹19,000 | ₹3,600 | ₹5,600 | ₹5,400 | ₹33,600 | - |
These amounts are invented to show the layout. Row A is 6,500 + 1,200 + 2,800 + 1,800 = ₹12,300. Row B has no courier cost because everything is sent online, so it is 7,500 + 1,200 + 1,800 = ₹10,500. Row C is 5,000 + 1,200 + 2,800 + 1,800 = ₹10,800. The three together come to 12,300 + 10,500 + 10,800 = ₹33,600, and the columns add up to the same figure: 19,000 + 3,600 + 5,600 + 5,400.
Which spreadsheet formulas do you need?
These work in Excel and Google Sheets. Put the headers in row 1 and the first university in row 2, with the fee in column B through score reports in column E, the total in column F and the status in column G.
- Row total: =SUM(B2:E2) in cell F2, copied down the column.
- Grand total: =SUM(F2:F11) for ten universities.
- Cost of what is still unpaid or unsent: =SUMIFS($F$2:$F$11, $G$2:$G$11, "Not started").
- Number of applications submitted: =COUNTIF($G$2:$G$11, "Submitted").
- Foreign fee into rupees: =B2*$J$1, where J1 holds your rate. Change the rate in one cell and every row updates.
The status text must match exactly, so pick three or four words and use only those. A drop-down list in the status column keeps spellings the same.
What costs do people forget to add?
- A second score report sent to the same university, or extra reports beyond the free ones.
- Card charges or transfer charges for paying a foreign fee.
- Notarising, attesting or translating a document.
- Courier charges for sending a hard copy, and a tracked option if the deadline is close.
- A fee for rush processing, when a transcript is late.
How do you decide which universities to drop?
The table helps you decide with money in view, though cost is only one reason to drop a name. Sort by total, then add a column for how likely you think admission is and how much funding you could expect. If two rows look alike, a university that costs ₹5,000 more to apply to but is one you would not attend should go. Fees are small next to what the course will cost, so do not drop a good-fit university only because the application fee is high.
When a sheet stops being enough
A sheet is fine for the shortlist. Once you are paying fees by card, you may want those charges tied to real transactions. SpendixAI can import a card statement and let you review the rows, then you can create a category for application costs and see the total in a report. Keep the sheet for planning and the statement for what was actually charged.
Before you pay each application
- Confirm the fee and the deadline on the university's own page.
- Check whether a fee waiver exists, and read the conditions yourself.
- Order or send the transcript with the courier option you need.
- Send the score report from the testing body to that university.
- Save the payment receipt and update the status cell the same day.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


