A school fees expense tracker is a ledger with one line per payment: date, child, what the payment was for, amount, how you paid and where the receipt is. Add a quarterly check against the school's own record, and you can answer any question about fees in a minute. The structure below works in a notebook, a spreadsheet or an app.
How should I design the columns?
| Column | Example entry | Why it matters |
|---|---|---|
| Date paid | 07 Jul | Matches the bank statement |
| Child | Aarav | Needed if you have more than one child |
| Fee type | Term 2 tuition | Lets you total by purpose |
| Amount (₹) | 22,000 | The money out |
| Mode | UPI | Helps you find it later |
| Receipt | Photo saved, number noted | Proof when asked |
Which categories and sub-categories work?
Use one parent category, School, with sub-categories underneath: Tuition, Transport, Books and uniform, Activities and exams, Admission and annual charges. Keep the same names every year, so you can compare years without translating. If you have two children, add the name in a note or use the child column instead of doubling your categories.
A worked example for two children
Say a family pays these in one term.
- Elder child tuition: ₹22,000.
- Younger child tuition: ₹15,500.
- Transport for both: ₹4,800.
- Annual activity fee for the elder child: ₹3,200.
Total for the term: 22,000 + 15,500 + 4,800 + 3,200 = ₹45,500. Without the child column, you could only say ₹45,500 went to school. With it, you can say the elder child's lines cost 22,000 + 3,200 = ₹25,200 and the younger child's cost ₹15,500, with ₹4,800 shared between them.
What is the quarterly check?
- Ask the school for a fee statement or look at its parent portal, if it has one.
- Total what you recorded as paid for each child.
- Compare the two figures. If they differ, look for a payment that was made but not credited, or recorded under the wrong child.
- Raise any mismatch in writing with the receipt, while the date is fresh.
Does fee data matter for tax time?
Some people need fee receipts when they file returns, but rules and limits change, so confirm the current position with your CA or the official source rather than relying on a blog. What a tracker can do is make sure the receipts and totals are ready when you are asked.
How do I get past statements in?
If your fee payments went through a bank or card, upload the statement to SpendixAI as PDF, CSV or Excel, pick the account first and review the rows before saving. Then tag the school rows once with a rule so future payments to the same name are categorised automatically. Cash payments can be added by hand.
Cash payments and part payments
Some fees are paid in cash or in two parts. Enter each part as its own line with its own date, and add a note such as balance due ₹5,000 on the first part. When the second part is paid, the two lines together equal the circular's figure, and the quarterly check becomes a quick sum instead of a puzzle. For cash, ask for a written receipt every time and photograph it the same day.
- One line per payment, never one line for several.
- A note for any balance left, with the date it is due.
- The receipt number in the entry, even if the paper is lost later.
A last check
- Does every payment have a receipt?
- Do the child totals match the school's record?
- Are sub-category names the same as last year?
- Is the next due date in your calendar?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


