With two education loans in one family, the moratorium end dates, EMI dates and amounts will rarely match. Build one combined calendar with a label per child, one row per month, and a total column. That single sheet shows the months where one EMI runs alone and the months where both land in the same budget.
Why do two loans get confusing?
Each loan has its own bank, its own sanction letter, its own grace period and its own EMI date. Siblings also start at different times, so one loan may be in repayment while the other is still releasing money to a college. If both sit in one mental bucket called the education loan, you end up asking which EMI is this.
What goes in each loan's header?
Give every loan a short block of facts at the top of the calendar sheet, then keep it frozen in view.
- Child's name and course.
- Bank and loan account label (not the full account number).
- Study end date and grace end date.
- First EMI month, EMI amount and EMI debit date.
- Tenure in months and the last EMI month.
- Where the sanction letter and schedule are filed.
How do you build the combined calendar?
Make a sheet with one row for each month, running from today to the last EMI month of the later loan. Use these columns: A for the month (the first of each month as a date), B for Child A EMI, C for Child B EMI, D for the total.
- Type the first month in A2 and fill the dates down with a month step, using =EDATE(A2,1) in A3.
- Leave B and C at zero until each loan's first EMI month, then enter the EMI amount from that month to the last one.
- In D2 write =B2+C2 and fill down.
- In a side cell, find any month with =SUMIFS($D$2:$D$200,$A$2:$A$200,F1), where F1 holds the month you want to check.
- Colour the rows where both B and C are above zero, so overlap months stand out.
EDATE works in Excel and Google Sheets. Format column A as a month and year, and keep the debit date of each EMI in a separate note, because two loans rarely debit on the same day.
What does an example look like?
Say Child A's EMI is ₹9,500 and begins in December 2027. Child B's EMI is ₹7,200 and begins in December 2029. These are invented figures.
| Period | Child A EMI | Child B EMI | Monthly total |
|---|---|---|---|
| Dec 2027 to Nov 2029 | ₹9,500 | ₹0 | ₹9,500 |
| From Dec 2029 | ₹9,500 | ₹7,200 | ₹16,700 |
The first period has 24 months, so A alone costs 24 × 9,500 = ₹2,28,000. From December 2029 the family needs ₹16,700 every month, or 16,700 × 12 = ₹2,00,400 in a year. If the household's monthly take-home is, say, ₹70,000, the two EMIs together are about 24 per cent of it.
How do you keep the two loans apart in daily records?
Use a label per child on every repayment: Education EMI - Child A, Education EMI - Child B. Keep the fee receipts, statements and letters of each child in a separate folder. When a bank asks for an interest certificate or a balance letter, you will know which folder to open.
A short checklist
- Fill both headers from the sanction letters.
- Build the monthly calendar and mark the overlap start.
- Set a reminder for each study end and grace end date.
- Compare the EMI debits on your statement with the schedule every quarter.
- Update the sheet if either bank revises the schedule.
If your EMIs debit from one account, SpendixAI lets you create a custom category for each child's loan so that imported statement rows stay separate after you review them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


