Borrower Payment History Statement
Keep a clean repayment record for every borrower. Payments are applied to the oldest installment first, and the statement shows exactly which installments were paid on time, late or are still overdue.
QUICK ANSWERA borrower payment history shows each scheduled installment next to the payment that cleared it, the payment date and whether it was on time, late (and by how many days) or still unpaid. Payments are allocated to the oldest unpaid installment first. Days past due (DPD) is counted from the oldest unpaid installment’s due date.
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 Borrower Payment History Statement
- ✅ Oldest-first allocation
- ✅ Paid on time / late / overdue
- ✅ Current DPD
- ✅ Advance shown separately
- ✅ Multiple loans
- ✅ Print statement & WhatsApp
How to use the Borrower Payment History Statement
- STEP 1Create the loanBorrower, amount, rate, method, frequency, installments and first due date.
- STEP 2Record paymentsDate, amount, mode and receipt/UTR for each payment received.
- STEP 3Review statusEach installment shows its payment date and status; overdue rows are red.
- STEP 4Share the statementPrint it or send the summary to the borrower on WhatsApp.
Frequently asked questions
How is DPD calculated in the statement?
DPD is the number of days since the due date of the oldest installment that is not fully paid. A part payment does not reset DPD.
Can a borrower use this to check their own loan?
Yes. Enter your loan terms and payments from your passbook or app to see whether the lender’s overdue figure matches.
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.Loan Repayment Schedule Generator →Daily, weekly, fortnightly or monthly installment schedule, flat or reducing interest, with principal, interest and balance.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.