Getting started

School fees expense tracker: categories, receipts and checks

Set up a school fees expense tracker with categories per child, receipt habits and a quarterly check so every rupee paid to school can be accounted for.

Editorial illustration for School fees expense tracker: categories, receipts and checks

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?

ColumnExample entryWhy it matters
Date paid07 JulMatches the bank statement
ChildAaravNeeded if you have more than one child
Fee typeTerm 2 tuitionLets you total by purpose
Amount (₹)22,000The money out
ModeUPIHelps you find it later
ReceiptPhoto saved, number notedProof 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?

  1. Ask the school for a fee statement or look at its parent portal, if it has one.
  2. Total what you recorded as paid for each child.
  3. Compare the two figures. If they differ, look for a payment that was made but not credited, or recorded under the wrong child.
  4. 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?
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports