Education

A child's education history ledger from nursery to graduation

A year-by-year education history ledger for a child from nursery to graduation: school, fee total, extras and notes, ready for the next child or a loan form.

Editorial illustration for A child's education history ledger from nursery to graduation

A child's education history ledger is one row per year, with the school, the fee total, the extras and a notes column, kept from nursery to graduation. It takes a few minutes a year and gives you a ready answer when a second child enters school, when someone asks what an education has cost or when a lender's form asks for details. Here is a layout to copy.

What columns should the ledger have?

YearClass or courseSchool or collegeFee totalExtrasNotes
2018-19NurseryName of play school₹36,000₹4,000Annual day outfit and photos
2019-20LKGName of school₹52,000₹6,500Admission paid this year
2024-25Class 7Name of school₹78,000₹11,000Fee rose from last year
2029-30First year, degreeName of college₹1,10,000₹15,000Hostel not included

The figures above are made up, and the rows skip years to save space. In your own ledger, keep every year, even if it is only the fee and one word of note.

What counts as fees and what counts as extras?

Decide once and keep to it, because the value of the ledger is consistency. A simple rule is that fees are what the institution charges and extras are everything you pay for around it.

  • Fees: tuition, admission, annual or development charges, exam fees.
  • Extras: uniform, books, transport, activities, trips, tuition outside school, devices.
  • Notes: anything that explains a jump, such as a change of school or a new stage.

If you want more detail, add one column per extra type, but start simple. A ledger you keep for twenty years should be quick to fill.

Why keep the history?

There are three practical reasons. When the next child starts, you can see what the first year of schooling cost and when the large payments fall. When you plan for a degree, you can see how fees have moved across the years of your own family. And if a bank or a scholarship body asks for education details, you have a record you made at the time and not a guess.

Check what any lender or body actually asks for, since forms differ, and keep the original receipts and fee statements behind the ledger rather than relying on the ledger alone.

What if a year has an unusual event?

Write it in Notes and keep the numbers honest. A year with a change of school will carry an admission cost and perhaps overlapping fees. A year with a scholarship will show a lower fee total. A year when a course is repeated is still a year of cost. The ledger is a record of what happened, so avoid smoothing the entries to look tidy.

How do I fill it in each year?

  1. At the end of the school year, total the fee receipts and write the figure in the Fee total column.
  2. Total the extras from your records and write the number in Extras.
  3. Write a note on anything unusual: a new school, a bigger fee, a scholarship, a gap.
  4. Save a photo of the final fee receipt in a folder named for the child and the year.

Ten minutes in April or after the final instalment is enough. Waiting until graduation turns a ten-minute job into a month of searching.

Where does SpendixAI come in?

Receipts can be kept with their transactions in SpendixAI, and imported statements keep each payment with its account. You can build a yearly education view with a category per child and download a CSV for the ledger. The ledger itself is best kept as a simple sheet that you own, so it outlasts any app.

Starting from today

  1. Create the sheet with the six columns and one tab per child.
  2. Fill in this year's row now.
  3. Back-fill earlier years from old receipts when you find them, marking estimates as estimates.
  4. Set a yearly reminder after the last fee instalment.
SPENDIXAI JOURNAL

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

Explore your reports