Track school fees with one ledger: a row per fee component per child per term, with the amount due, due date, amount paid and an automatic Paid, Pending or Overdue status. A small summary then adds each child's total and splits shared lines such as transport. It takes one tab and a few formulas.
How should I lay out the ledger?
Name the tab Fees and use rows 2 to 200:
- A Child (use "Both" for a shared line), B Component (tuition, transport, uniform, books, activities, exams), C Term.
- D Amount due, E Due date, F Amount paid, G Paid on, H Receipt number.
- I Status: =IF(F2>=D2,"Paid",IF(E2<TODAY(),"Overdue","Pending"))
Type receipt numbers from the school's own receipt; they help when a payment is questioned. If a child's fees are paid in instalments, add a row per instalment, not one row with a partial amount.
How do I handle two children with different schedules?
Different classes often mean different dates and amounts. A ledger handles this because each row carries its own due date. One child might pay in three terms, another in four quarters; each term simply gets its own rows. Say Term 1 looks like this, with all figures hypothetical:
| Child | Component | Amount due (₹) |
|---|---|---|
| Aarav | Tuition | 18,000 |
| Diya | Tuition | 14,000 |
| Both | Transport | 6,000 |
| Aarav | Books | 4,500 |
| Diya | Books | 3,200 |
| Diya | Uniform | 2,400 |
Term 1 adds up to 18,000 plus 14,000 plus 6,000 plus 4,500 plus 3,200 plus 2,400, which is ₹48,100.
How do I split the shared transport line?
Record transport once under "Both". In the summary, each child's total is their own rows plus half of the Both rows:
- Aarav: =SUMIFS($D$2:$D$200,$A$2:$A$200,"Aarav")+SUMIFS($D$2:$D$200,$A$2:$A$200,"Both")/2
- Diya: =SUMIFS($D$2:$D$200,$A$2:$A$200,"Diya")+SUMIFS($D$2:$D$200,$A$2:$A$200,"Both")/2
For Aarav that is 18,000 plus 4,500 plus half of 6,000, so ₹25,500. For Diya it is 14,000 plus 3,200 plus 2,400 plus 3,000, so ₹22,600. Together, 25,500 plus 22,600 is ₹48,100, matching the ledger. If the transport is split in another way, such as by distance, replace the divisor with a share cell.
Which other costs belong in the ledger?
Fees on the school's notice are only part of the year. Decide which of these you will also record in the same Fees tab, and use the same columns:
- One-time or annual charges such as admission, annual day or development fees.
- School trips and event contributions, usually due on a short notice.
- Stationery and project material bought mid-term.
- Tuition or coaching outside school, if you want one view of education costs.
Cash and cheque payments go in the same way as UPI: enter the amount, the date and the receipt number. For a cheque, add its number in the receipt column until it has cleared on your statement.
Which totals should I watch?
- Pending: =SUMIFS($D$2:$D$200,$I$2:$I$200,"Pending")
- Overdue: =SUMIFS($D$2:$D$200,$I$2:$I$200,"Overdue")
- Next due date: =MINIFS($E$2:$E$200,$I$2:$I$200,"<>Paid"), which needs Excel 2019, Excel 365 or Google Sheets.
- Paid so far this year: =SUM($F$2:$F$200)
Add a rule with Conditional Formatting that colours a row when it is not paid and the due date is within seven days: =AND($I2<>"Paid",$E2-TODAY()<=7). It acts as a gentle reminder without any app.
A start-of-year routine
- Create rows for every component and term as soon as the fee notice arrives, in April or whenever your school's year begins.
- Put a due date on every row.
- Mark each payment on the day it is made and file the receipt.
- Review the Overdue total every Sunday.
Fees paid from your bank or card will also appear in your statement. SpendixAI can import it, and you can attach the school receipt to the matching transaction, so the ledger and the bank record agree.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

