To match education loan disbursements to fees, keep a ledger with one row per disbursement and one row per fee demand: date, amount, who was paid, fee head and receipt number. Then compare the totals for each semester. Any difference is a mismatch to explain, either a part you paid yourself or an amount that did not reach the college.
What should the ledger contain?
- Date the lender disbursed money
- Amount disbursed and who received it (college or your account)
- Fee head being paid (tuition, hostel, exam, lab, other)
- Fee demanded by the college for that head
- Receipt number and date from the college
- Difference between the demand and what came from the loan
What does a two-semester example look like?
Take invented figures. Semester 1: tuition ₹1,20,000, hostel ₹40,000 and exam fee ₹5,000, a demand of ₹1,65,000. The loan disburses ₹1,60,000. Semester 2: tuition ₹1,25,000, hostel ₹42,000 and lab ₹5,000, a demand of ₹1,72,000, and the loan disburses ₹1,70,000.
| Semester | Fee demand (₹) | Disbursed (₹) | Receipts total (₹) | Paid by you (₹) | Check |
|---|---|---|---|---|---|
| 1 | 1,65,000 | 1,60,000 | 1,65,000 | 5,000 | Matches |
| 2 | 1,72,000 | 1,70,000 | 1,70,000 | 0 | Receipts 2,000 short |
In Semester 1, the receipts equal the demand, and the ₹5,000 gap between demand and disbursement was met by you. All good, provided you recorded it. In Semester 2, receipts total ₹1,70,000 but the demand was ₹1,72,000, so either ₹2,000 is still due at the college, or a receipt is missing. Ask the college accounts office for a statement of your fee account.
What mismatches can you expect?
- Demand higher than the disbursement: you pay the balance. Record it and keep the receipt.
- Disbursement higher than the demand: ask the lender or college where the extra went. Do not assume it will adjust itself.
- A receipt dated before the disbursement: the college may have been paid by you first. Note it as a reimbursement.
- A fee head you did not expect: ask for the college's fee circular for that semester.
Also ask the lender whether any charge is deducted from a disbursement before it reaches the college. If so, record it as its own line.
How do you compare the totals?
At the end of each semester, add up the disbursed amounts and the receipts for that semester. In a sheet, with the semester in column A and amounts in column D, =SUMIF($A$2:$A$50,1,$D$2:$D$50) gives semester 1's total, and the same with 2 for the next. Then compare the receipts with the fee demand, and with disbursed plus paid by you. All three should agree. If they do not, the row to find is the one that explains the difference.
Where does SpendixAI help?
If you pay any fees from your own account, uploading that statement into SpendixAI lets you review the payments and attach the college receipt to the right transaction. The loan's disbursement ledger still lives in your sheet.
What should you do about a missing or late disbursement?
If a fee deadline is near and the disbursement has not arrived, ask your lender for the status and the expected date, in writing. Tell the college accounts office too, and ask whether a short extension or a letter acknowledging the loan is possible. Record each call and reply in a notes column with the date and name. If you pay a fee from your own account to avoid a late charge, mark it as paid by you, and note that it may be reimbursed when the loan money arrives.
End-of-semester checklist
- Fee demand for the semester saved
- Every disbursement from the lender entered
- Every receipt matched to a fee head
- Totals compared and any gap explained in writing
- Lender statement checked against your disbursement list
Useful ideas start with a clearer picture of your own spending.
Explore your reports

