For a child's first year of college away from home, a parents' tracker needs only six lines: fees by instalment, hostel and mess, the refundable advance, books and supplies, travel home, and the monthly allowance. Give every line a due date and a status, and keep the refundable advance separate from real spending. The figures below are invented to show the layout, so replace them with the numbers in your college's own schedule.
What are the six lines to track?
| Line | What it covers | When it falls due |
|---|---|---|
| Tuition and fees | Instalments as per the college schedule | On the dates in the fee notice |
| Hostel | Room rent, and the refundable advance or deposit | At joining, then as notified |
| Mess or food | Monthly mess bill, or meals outside | Monthly |
| Books and supplies | Textbooks, lab items, a laptop or calculator if needed | Start of each term |
| Travel home | Train, bus or flight tickets for each trip | Before holidays |
| Allowance | Money for daily expenses, sent monthly | Same date every month |
Take the fee instalments and hostel dates from the college's own notice, not from memory or from other parents. Colleges change schedules and add charges, so keep a photo of the notice in the same folder as the tracker.
A worked year with made-up figures
Suppose tuition is paid in two instalments of ₹60,000, which is 2 x 60,000 = ₹1,20,000. Hostel rent is ₹40,000 for the year, and a refundable hostel advance is ₹15,000. Mess is ₹3,500 for 10 months, which is 3,500 x 10 = ₹35,000. Books cost ₹12,000. Four trips home at ₹3,000 each come to 4 x 3,000 = ₹12,000. An allowance of ₹6,000 for 10 months is ₹60,000.
Add the lot: 1,20,000 + 40,000 + 15,000 + 35,000 + 12,000 + 12,000 + 60,000 = ₹2,94,000. Without the refundable advance, the real cost is 2,94,000 - 15,000 = ₹2,79,000. Keeping the advance apart matters because you hope to get it back at the end.
How do you handle the refundable advance?
Record it on the day you pay, but mark it as an advance to be returned, not as spending. When the hostel returns it, record the money coming back. Ask the hostel in writing what conditions apply to the refund and when it is processed, since rules vary. If deductions are made, record only the deducted amount as a real cost.
What about the monthly allowance?
Pick one date, such as the first of the month, and send the same amount each time, so your child can plan. If the allowance goes up in exam months or festival months, note why. If you notice that the allowance does not last the month, talk it over with your child before changing it, and ask what the extra money was needed for.
- Agree a monthly figure and a payment date.
- Decide what the allowance covers: food outside the mess, local travel, phone recharge.
- Decide what you will pay directly: fees, books, travel home.
- Revisit the amount after the first term, with your child's own spending history.
Where do the records live?
A sheet with the six lines and a due-date column is enough. If you pay from several accounts or cards, SpendixAI can take the statements from each one, with the account picked before upload, and you can create categories such as Tuition, Hostel, Books and Allowance. Cash and bank payments to the hostel can be added by hand, and the Report builder can show the year's totals by category.
Before the first term begins
- Get the fee, hostel and mess schedules in writing and photograph them.
- Fill the due dates into your phone calendar.
- Decide the allowance and pay date.
- Plan the travel-home dates early, because tickets around holidays can sell out or cost more.
- Keep a separate line for the refundable advance.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


