Education

The year both children's big fees land together: a planning sheet

When one child changes to a senior class and another starts college, plot both fee calendars on one sheet to find the crunch months and bridge them.

Editorial illustration for The year both children's big fees land together: a planning sheet

When one child moves into a senior class and another starts college in the same year, plot both fee calendars on a single twelve-month sheet. The total may be manageable while two or three months are not. A running balance, with your monthly set-aside added and each fee subtracted, shows exactly which months are short and by how much.

What goes on the planning sheet?

Make a table with April to March down the left, because that is the financial year most families think in. Add columns for fees due, money you set aside, and the balance at the end of each month. List every fee with its month: school quarterly or term fees, an admission or class-change fee, college instalments, a hostel deposit, books, and uniform.

How does the arithmetic work in an example?

These figures are hypothetical. Say the school fee is ₹15,000 in April, July, October and January, which is 4 × 15,000 = ₹60,000. A senior-class admission fee of ₹25,000 falls in April. The college charges ₹90,000 in July and ₹90,000 in January, plus a ₹20,000 hostel deposit in July. The family starts with ₹30,000 saved and sets aside ₹20,000 each month.

Total fees: 60,000 + 25,000 + 180,000 + 20,000 = ₹2,85,000. Total money available: 30,000 + 12 × 20,000 = ₹2,70,000. The year ends ₹15,000 short, but the monthly pattern is what hurts.

MonthFees dueSet asideBalance at month end
April₹40,000₹20,000₹10,000
May₹0₹20,000₹30,000
June₹0₹20,000₹50,000
July₹1,25,000₹20,000-₹55,000
August₹0₹20,000-₹35,000
September₹0₹20,000-₹15,000
October₹15,000₹20,000-₹10,000
November₹0₹20,000₹10,000
December₹0₹20,000₹30,000
January₹1,05,000₹20,000-₹55,000
February₹0₹20,000-₹35,000
March₹0₹20,000-₹15,000

How do you build the running balance in a sheet?

Put the opening savings in E2, on a row labelled Opening. Then, with April in row 3, set-aside in column C, fees in column D and the balance in column E, the formula in E3 adds the set-aside and subtracts the fees:

  • =E2+C3-D3
  • Copy it down for each month
  • Add conditional formatting so any balance below zero turns red

Excel and Google Sheets both handle this the same way.

Which months are the crunch, and how do you bridge them?

In the example, July and January are the crunch months: the balance drops to −₹55,000 both times. Seeing that early gives you options that are cheaper than a last-minute scramble.

  • Raise the monthly set-aside, which only works if it starts early
  • Ask each institution whether fees can be paid in instalments or on a different date
  • Use savings already put aside for this purpose, such as a deposit that matures before July
  • Time optional purchases such as books to fall outside the crunch months
  • Talk to the family about help from other relatives, and agree the terms plainly

Do not borrow for fees without comparing the full cost. If you are unsure, ask a trusted adviser.

What if a fee date moves?

Fee dates shift: a college may announce a new instalment schedule, or a school may add a fee mid-year. Keep one column for the planned date and change it when the notice arrives. Re-check the running balance each time, since moving ₹90,000 from July to August changes which months turn red. Keep copies of the fee notices with the sheet, so you can see what changed and when, and so the family agrees on the numbers.

What to do once the sheet is built

  • Mark the crunch months in your calendar six weeks ahead
  • Update the sheet whenever a fee notice arrives
  • Add a monthly reminder to move the set-aside amount on the same day
  • Review the sheet at the start of each term
SPENDIXAI JOURNAL

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

Explore your reports