To find what share of your household income goes to education, add up a full year of education payments, divide by the household's income for the same year and multiply by 100. Do it twice, once with everything and once with only recurring costs, because one-off items like admission distort the picture. Use your own records, since any national figure says little about your family.
What do I need before I start?
- A twelve-month window, either April to March or the school year, used the same way each time.
- Every education payment: school or college fees, tuition, transport, books, uniforms, exam fees, activity fees and devices bought for study.
- Household income for the same twelve months, using the same definition each year, for example take-home pay of all earning members.
- A note on which payments were one-off and which recur.
Decide the definition of income once. If you use take-home pay in one year and gross pay in the next, the trend will lie to you.
How do I work it out?
Here is a made-up household. Monthly household income is ₹1,20,000, so the year is 1,20,000 × 12 = ₹14,40,000.
| Type | Item | Amount |
|---|---|---|
| Recurring | School fee instalments | ₹90,000 |
| Recurring | Transport | ₹24,000 |
| Recurring | Tuition | ₹36,000 |
| One-off | Admission and kit | ₹28,000 |
| One-off | Books and a study laptop bag | ₹14,000 |
Recurring total: 90,000 + 24,000 + 36,000 = ₹1,50,000. One-off total: 28,000 + 14,000 = ₹42,000. Everything: ₹1,92,000.
- All education: 1,92,000 ÷ 14,40,000 = 0.1333, or about 13.3 per cent of household income.
- Recurring only: 1,50,000 ÷ 14,40,000 = 0.1042, or about 10.4 per cent.
The gap between the two numbers is the one-off cost. Plan next year on the recurring share and add one-offs when you know them.
How do I do the sum in a sheet?
Put payments in rows with the type in column B (Recurring or One-off) and the amount in column C. To total recurring costs, use =SUMIF($B$2:$B$500, "Recurring", $C$2:$C$500). Put annual income in a cell, say E1, and compute the share with =SUM($C$2:$C$500)/E1. Format the result as a percentage. The arguments of SUMIF are the range to test, the criterion and then the range to add.
Should I include income that is not regular?
Bonuses, rent received and side income are part of what the household had, so decide whether to include them and say so on the sheet. A cautious method is to calculate the share twice, once on regular monthly income only and once on everything received. If the two shares are close, the choice hardly matters. If they differ a lot, the larger number shows how much the education budget leans on irregular money.
What does the trend tell me?
Repeat the calculation every year and keep the shares side by side. If the recurring share climbs each year, ask whether fees are rising faster than income or whether the number of children in school has changed. A rising share is not automatically a problem, but it is a reason to plan, for example by putting more into a fund for next year's term fees.
Where does SpendixAI help?
If your fees and tuition come through bank or card, SpendixAI imports the statements and lets you keep an Education category with sub-categories. Its report builder filters and groups transactions, and you can download the result as a CSV for your sheet. Cash tuition can be added by hand. You still need to review the categories and supply the income figure yourself.
A yearly review
- Gather twelve months of education payments.
- Mark each as recurring or one-off.
- Divide each total by the same year's household income.
- Write both shares down and compare with last year.
- Decide whether any recurring cost needs a plan or a conversation.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


