EMI Collection and Loan Receipts
The schedule is built once from principal, rate, tenure and frequency. Every receipt after that is recorded against an instalment, by the person who took it, on the day it was taken. Balances move without a second entry.
The demand for the day
Each due date produces a list showing borrower, instalment, amount and whether the account is already behind. Weekly schedules work the same way. That suits lenders to groups that meet on a fixed weekday.
What a receipt carries
What the borrower gets, and what the office gets
- Reminders by SMS or email, before the due date and after it
- A receipt raised from the same entry, not written out again
- A statement showing instalments paid, short paid and still pending
- Group loans where member dues and the SHG total come from one set of entries
- Collections exported as entries your accountant brings into Tally
How an EMI schedule is shaped
An EMI is a fixed instalment that repays interest and principal together over the tenure. Early instalments carry more interest, and later ones more principal. Lenders choose between a reducing balance and a flat rate, and the choice changes what the borrower pays over the tenure. The rate type and the day-count rule should be fixed in the loan product before the first loan is booked. Your lender type may also require certain disclosures about the rate, so ask your compliance adviser.
Handling awkward payments
Most collection arguments are about unusual cases, not routine ones.
Before the first collection day
Test with a handful of real loans from your book. Compare the schedule to what your old sheet says, instalment by instalment. A difference of a few rupees points to a rounding or day-count rule that you should settle at once.
A collection day, from list to ledger
Collection is the daily heartbeat of a lender. The demand is known in advance. The receipts arrive from several people in several ways.
Decisions to make before the first collection day
The first collection day is easier when a few decisions are made beforehand. They concern who may take money, how receipts are numbered and what counts as late. Each decision becomes a rule that every staff member follows. Rules come first.
Agree the evidence before signing off this part.
Use a representative scenario to decide what this part of the system must show and where review is still needed.
What a receipt carries
Can the same receipt be allocated without counting the money twice?
Take an unallocated amount in “What a receipt carries” and apply it to the intended balance. Review the remaining amount and the original receipt reference together.
Background reading: ERPNext: payment allocation
Applied to the instalment
Does the schedule match the agreed terms and actual release of funds?
For “Applied to the instalment”, use a sample already checked by your finance team. Compare due dates and the principal and interest split before relying on the resulting balance.
Background reading: Frappe Lending: repayment schedules
Frequently asked questions
Can we collect weekly instead of monthly?
Yes. Frequency belongs to the loan product, so weekly, fortnightly and monthly schedules can run side by side in one book. Weekly dates follow the centre meeting.
What if a borrower pays three EMIs together?
The receipt is applied across those instalments and the schedule updates. A borrower who clears arrears in one visit stops showing as overdue the same day.
Does it post entries into Tally by itself?
No. Tally remains your accountant’s book for final accounts and GST. Collections, disbursements and interest come out as entries the accountant brings in, and that link is scoped when the module is set up.
Can we use a flat rate and a reducing balance on different products?
Your loan product defines the schedule. Name each rate type you lend on during scoping so each product is built to match.
Can a collector change a receipt?
Only if you give that right. Entry rights and edit rights are separate, and corrections normally pass through the office with both figures logged.
How do we see who is behind?
Each due date produces a list showing whether the account is already behind, and overdue buckets follow the schedule.
Can group loans be collected through one receipt?
Group loans keep member dues and the group total from one set of entries. How a centre receipt is split among members is agreed in scoping.
How this feature fits the system.
Loan Management System: the parts that work with this feature, the trades that use it and the ways to put it in place.
Enquiries and leads
Each loan enquiry is logged with its source and a follow-up date, and reports show which enquiries turned into applications.
Lead ManagementSanction approvals
Approval levels are set by loan amount or product, disbursement waits for the required sign-off, and the log records who approved and when.
Workflow and ApprovalsCollection app for field agents
Field collectors record instalment receipts against the borrower from a phone browser, and due and received amounts appear together with collector name and date.
Receipts ManagementTell us what you need.
Tell us what your team does today, where work gets stuck and what you want to change.
What happens after you share your requirements
- We review your brief and the systems you already use.
- We clarify the workflow, missing information and the work to consider first.
- The proposed scope sets out the deliverables, responsibilities and dependencies.
- Review the scope and commercial terms before deciding whether to proceed.
Start with your requirements
Describe your current process, the people involved and the change you need. Start with the details you know; we can clarify the rest together.
Share your requirements