Next due
20 OCTGSTR-3B · Summary return · Sep 2026tomorrow 21 OCTTax Audit Report · Form 3CA/3CB · AY 2026-27 · extended from 30 Sepin 2 days 30 OCTAOC-4 · Financial statements · FY 2025-26in 11 days 7 NOVTDS / TCS deposit · Deducted in Oct 2026in 19 days 11 NOVGSTR-1 · Outward supplies · Oct 2026in 23 days 15 NOVPF & ESI · Contributions · Oct 2026in 27 days 21 NOVITR filing · Audit cases · AY 2026-27 · extended from 31 Octin 33 days 29 NOVMGT-7 / 7A · Annual return · FY 2025-26in 41 days
All due dates
Template

Loan Amortisation Schedule

A month-by-month EMI schedule that splits every instalment into principal and interest and shows the reducing outstanding balance.

LOAN AMORTISATION SCHEDULE

Loan Amount: ₹[10,00,000]  |  Rate: [9.5% p.a.]  |  Tenure: [60 months]  |  EMI: ₹[20,998]

EMI No.Due DateOpening Balance (₹)EMI (₹)Interest (₹)Principal (₹)Closing Balance (₹)
1[05/05/2025][10,00,000][20,998][7,917][13,081][9,86,919]
2[05/06/2025][9,86,919][20,998][7,813][13,185][9,73,734]
3[05/07/2025][9,73,734][20,998][7,709][13,289][9,60,445]
…[…][…][20,998][…][…][…]
60[05/04/2030][20,834][20,998][164][20,834][0]

How to use: EMI = P × r × (1+r)^n ÷ [(1+r)^n − 1], where r is the monthly rate (annual ÷ 12 ÷ 100) and n is the number of months. Each month, interest = opening balance × r, principal = EMI − interest, and closing balance reduces by the principal. The final balance should reach ₹0. Use the interest column for the deductible-interest figure in your books.

Before you use it — fill in / check

  • Loan amount
  • Interest rate (p.a.)
  • Tenure (months)
  • EMI amount
  • Opening balance
  • Interest component
  • Principal component
  • Closing balance

How to use this template

  1. Read through and replace every [bracketed] or blank placeholder with your actual details.
  2. Delete any clause that doesn't apply and add anything specific to your situation.
  3. Click Print / Save as PDF to download, or Copy text to paste into your letterhead.
  4. Get it signed / stamped / notarised as required, and keep a copy for your records.

This is a general, editable template for convenience only — not legal advice. For anything material, have a professional review it. TaxClue isn't liable for how it's used.