Education

A yearly education cost summary for each child from your records

Turn twelve months of tagged payments into a one-page education cost summary for each child: fees, transport, books, activities and the unexpected extras.

Editorial illustration for A yearly education cost summary for each child from your records

A yearly education cost summary for each child is a one-page table that groups twelve months of payments into fees, transport, books, activities and unexpected extras, with a total. You get it by tagging each payment to a child and a category as you go, then adding up at year end. Here is how to build it from your own records.

What goes on the page?

Pick the year that matches how you think, either April to March or the school year, and use the same one every year. For each child, use the same five lines.

  • Fees: tuition, admission, annual charges and exam fees.
  • Transport: bus or van fees, or the cost of getting there.
  • Books and stationery: textbooks, notebooks, uniform items if you keep them here.
  • Activities: sports, music, clubs, trips.
  • Unexpected: project materials, a replaced laptop, a late fee. This line is where surprises show.

Keeping the same lines every year allows year-to-year comparison, which is where the real insights lie.

What does a finished summary look like?

Here is a made-up example for one child for one year.

LineHow it was builtTotal
FeesInstalments through the year₹84,000
Transport₹2,000 a month × 12₹24,000
Books and stationeryStart of term and one top-up₹12,500
ActivitiesSwimming and a school trip₹9,000
UnexpectedProject materials and a replacement bag₹6,500
TotalSum of the five lines₹1,36,000

Check the arithmetic: 84,000 + 24,000 + 12,500 + 9,000 + 6,500 = ₹1,36,000. The unexpected line is under five per cent of the year, so it is small, but you now know its size, and next year you can set it aside.

How do I tag payments so I can add them up?

Decide the tag when you record the payment, not twelve months later. In a sheet, add a Child column and a Line column. A cheque to the school office is Child A, Fees. A bookshop payment is Child B, Books. If one payment covers two children, split it before recording.

To total a child's line in Excel or Google Sheets, with children in column A, lines in column B and amounts in column C, use =SUMIFS($C$2:$C$500, $A$2:$A$500, "Child A", $B$2:$B$500, "Fees") and change the two criteria for each cell of the summary. The argument order is sum range first, then each range and criterion pair.

What can I learn from the summary?

Once the page exists, compare it with last year's. If fees rose by a few thousand rupees, that is expected. If activities doubled, ask whether the child still wants all of them. If the unexpected line is large two years running, it is no longer unexpected and deserves its own planned line. The summary also gives you a ready number when someone asks what a child's schooling costs you, so you answer from records, not memory.

How do I handle shared and one-off costs?

Split shared costs by a rule you decide and keep to, for example equal shares for a family activity. Mark one-off costs such as admission or a laptop so they do not make next year's recurring cost look inflated. A second total, recurring only, is more useful for planning.

When does a sheet stop being enough?

A sheet is fine while you record by hand. If you pay through bank or card, SpendixAI can take the statements, and you create categories and sub-categories such as Education then each child's name. The report builder can filter and group by them, and you can download a CSV. You still review the categories yourself.

Making the summary useful

  1. Build the one-page table for each child at year end.
  2. Add last year's column beside this year's.
  3. Write one sentence on what surprised you.
  4. Decide which two lines to plan better next year.
SPENDIXAI JOURNAL

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

Explore your reports