A college cost planner needs two blocks: one-time costs such as the admission fee, deposit, books, laptop and hostel setup, and recurring costs such as tuition, hostel and mess for each semester. Add a due date, a paid-by column and a status, and you can see the total for year one and what each source must cover.
How do I lay out the sheet?
| Column | Heading | Example entry |
|---|---|---|
| A | Item | Caution deposit |
| B | Type | One-time or Per semester |
| C | Amount (₹) | 10,000 |
| D | Due date | 15-07-2027 |
| E | Paid by | Parents, Loan or Scholarship |
| F | Status | Pending or Paid |
| G | Refundable? | Yes or No |
Take the amounts and dates from the college's official fee document, not from a conversation or a message, and attach a copy in a folder you can reach quickly.
Totals by type come from =SUMIFS($C$2:$C$30, $B$2:$B$30, "One-time") and the same with "Per semester", multiplied by the number of semesters you are planning. Keep a Notes cell for how each fee is paid, for instance online with a receipt or by demand draft, and keep every receipt with the item it belongs to.
What does a worked example look like?
All the figures here are invented. The one-time block is admission fee ₹45,000, caution deposit ₹10,000, books ₹8,000, laptop ₹55,000 and hostel setup (bedding, lock, bucket, extension cord) ₹6,000. That adds up to ₹1,24,000.
The per-semester block is tuition ₹60,000, hostel ₹30,000, mess at ₹4,500 for five months which is ₹22,500, and two trips home at ₹1,800, which is ₹3,600. One semester comes to ₹1,16,100, and two come to ₹2,32,200. The first-year total is ₹1,24,000 plus ₹2,32,200, which is ₹3,56,200.
Who pays for what?
Total each source with SUMIFS: =SUMIFS($C$2:$C$30, $E$2:$E$30, "Loan"). Suppose a loan covers tuition (₹1,20,000 over two semesters), a scholarship gives ₹30,000 per semester (₹60,000), and parents cover the rest. That is ₹3,56,200 minus ₹1,20,000 minus ₹60,000, so ₹1,76,200 from the family. Check how loan money is paid out, since it often goes straight to the college on a schedule, and so may not arrive when you need to pay hostel or laptop bills.
Which dates need a warning?
In column H add =IF(AND(F2<>"Paid", D2-TODAY()<=14, D2>=TODAY()), "Due soon", IF(AND(F2<>"Paid", D2<TODAY()), "Overdue", "")). This flags anything unpaid and due within two weeks, and anything unpaid whose date has passed. Add conditional formatting on column H so it stands out.
Sort the sheet by due date once a month. Payments tend to bunch up around admission and the start of each semester, and the sorted view shows a cash crunch in a particular month before it arrives. If one month is heavy, ask the college whether instalments are possible, or move a purchase such as the laptop to a month with room.
What do people usually forget?
- Exam, library and lab fees listed separately from tuition.
- Uniform, ID card, stationery and printing.
- Travel for the first move and holiday trips.
- Mobile data, a laptop bag, a backup drive and basic repair costs.
- Pocket money, which is easier to plan as a monthly amount than as lump sums.
- Health insurance or a medical fund for the student.
Next steps
- Copy every item in the official fee schedule into the sheet.
- Ask the college which payments are refundable and when.
- Mark the due dates in your calendar two weeks early.
- Review the sheet at the end of each semester and carry real figures into the next one.
Once the year begins, record actual payments as they happen. If they come through a bank account you already import into SpendixAI, you can add the fee receipts next to each transaction and compare the plan against what was paid.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


