Loan Repayment Schedule Generator
Generate a proper installment schedule for any loan, from a 100-day daily finance loan to a 36-month EMI loan, with due dates, principal and interest split and balance. Print it on your letterhead or send it to the borrower.
QUICK ANSWERA repayment schedule lists every installment with its due date, amount, principal, interest and outstanding balance. For a flat-rate loan, installment = (principal + principal × rate × years) ÷ number of installments. For reducing balance, installment = P × r × (1+r)^n ÷ ((1+r)^n − 1), where r is the rate per period. Daily loans usually skip Sundays.
Loading tool…
Want this synced, automatic and collecting payments?
- Same workflow in a free FastFee account, on every device and for your whole team
- Automatic WhatsApp reminders before and after due dates
- Payment links, UPI and AutoPay with auto receipts and live “paid” status
What you get free in the Loan Repayment Schedule Generator
- ✅ Flat or reducing balance
- ✅ Daily, weekly, fortnightly, monthly
- ✅ Skip Sundays for daily loans
- ✅ Principal / interest split
- ✅ Round installments to ₹10/₹100
- ✅ Print, PDF, Excel, WhatsApp
How to use the Loan Repayment Schedule Generator
- STEP 1Enter loan termsBorrower, amount, interest rate, flat or reducing, frequency, number of installments and first due date.
- STEP 2Review the scheduleEvery installment with due date, principal, interest and balance.
- STEP 3AdjustRound installments, skip Sundays for daily loans, add processing fee.
- STEP 4Print or sharePrint on your letterhead, download Excel or send to the borrower on WhatsApp.
Frequently asked questions
What is the difference between flat and reducing repayment schedules?
With flat interest, interest is charged on the original loan for the whole tenure, so interest per installment stays the same. With reducing balance, interest is charged only on the outstanding balance, so the interest part falls every installment.
How is a daily loan schedule made?
Choose Daily, enter the number of installments (for example 100) and the first date. Sundays are skipped by default, so each installment falls on a working day.
Is this tool free? Do I need to sign up?
Yes, it is completely free with no login and no limit on entries. Signing up for FastFee is optional. The free plan keeps your records synced across devices; automatic WhatsApp reminders, UPI AutoPay and team logins are on FastFee Premium.
Where is my data stored?
Only in your browser on this device (local storage). Nothing is uploaded to FastFee. Clearing browser data deletes it, so export a CSV or PDF backup regularly.
Need the full software?
More free loan, nbfc & microfinance tools
Daily Loan Demand Sheet Maker →Who must pay today, with arrears and total demand, grouped by agent or area, with a collected column and print.Borrower Payment History Statement →Record payments against a loan; see each installment paid on time, late, part-paid or overdue, with DPD and a printable statement.Loan Overdue Days (DPD) Calculator →DPD for a whole list of loans, SMA-0/1/2 and NPA buckets, PAR 30 and gross NPA % of portfolio.Flat vs Reducing Interest Comparator →Compare flat and reducing-balance EMIs side by side and see what a flat rate really costs as an annual (APR) rate.Gold Loan Interest Calculator →Eligible loan from gold weight and karat, monthly interest, bullet or EMI repayment and interest for 3–24 months.Loan Foreclosure Amount Estimator →Foreclosure amount after N EMIs: principal outstanding, broken-period interest, foreclosure charge + GST and interest saved.Loan Collection Agent Target Tracker →Agent-wise target vs collected, pace vs days elapsed, amount needed per day, projected month-end and incentive.Microfinance Centre Meeting Register →Centre members, meeting attendance (P/A/L), installment collected, minutes and an 8-meeting register.NACH / AutoPay Failure Tracker →Track every bounced NACH or UPI AutoPay EMI: reason, bounce charge, follow-up, re-presentation and recovery.Two-Wheeler Loan Installment Register →Bike / scooter loan register with vehicle number, monthly installments, payments, overdue and DPD per loan.Weekly Loan Collection Planner →Week view of installments due each day by area or agent, then the day’s collection sheet with arrears.
Other free business tool categories
🎓 School Certificates, Exams & Admissions →Report cards, admit cards, ID cards, TC, bonafide, timetable, online tests and a coaching admission website, all from one student list.🏫 School Staff Tools →Free staff salary sheet with payslips and a staff attendance register for schools, coaching and colleges.🧾 Billing & Invoicing →GST invoices, quotations, purchase orders, delivery challans, receipts and job cards, all free and unlimited.🏪 Shop Billing & POS →Browser POS with exact-amount UPI QR, small-shop billing with stock, daily sales closing and expense P&L.🏦 Lending & Field Collection →MFI group collection sheet, daily cash collection register for agents and a shop installment (kist) tracker.📒 Udhaar, Receivables & Collections →Digital khata, outstanding tracker, payment reminders, promise-to-pay, credit limits, dealer ageing and customer statements.🔁 Subscriptions & Memberships →Recurring billing, gym and studio memberships, PG rent, AMC and insurance renewals, retainers and packages.🥛 Daily Delivery Billing →Milk, newspaper, water can and tiffin monthly bills from daily quantities, plus laundry orders.📅 Projects, Bookings & Installments →Milestone billing, installment plans, booking advances, event and property payment schedules.💳 UPI Payments & Collection →UPI QR with amount, payment pages, coupons, booking advances, bulk payment requests, group collections and UTR reconciliation.🏦 Vendor, Refund & Cash Flow →Vendor payables, PO payments, invoice and payment approvals, refunds, security deposits, commissions, renewals and a cash flow calendar.🎒 School Fee & Admin →Fee demand, fee structure, concessions, attendance %, promotion, exam seating, PTM slots and holiday calendar for schools and coaching.🚚 Distributor & Shop Credit →Party-wise outstanding, credit aging, salesman targets, cheque due dates, advances, part payments and monthly recovery reports.🏘️ Local Recurring Business →Monthly collection registers for cable TV, internet, parking, dance and music classes, hostel mess, PG electricity, laundry and home tuition.👪 Personal & Family Money →Bill and trip splitters, udhaar and payment reminders, budgets, savings goals, shagun card, PDF scanner, image compressor and passport photos.🧮 Fee & finance calculators →GST, EMI, late fee, rent receipt and more.