Features · Collections and arrears
Loan collections and arrears reports
Late loans are found by looking, not by luck. LoanTabs gives your team a worklist of overdue loans, a printable daily collection sheet, and the portfolio-at-risk, aging and provisioning reports that show how much of the book is in trouble.
30-day free trial, no credit card required.
What are loan collections and delinquency reports?
Loan collections and delinquency reports show which loans are overdue, by how many days and by how much, so a lender can follow up and measure risk. Common ones are a delinquency list, an aging report, portfolio at risk (PAR) and a provisioning schedule. LoanTabs includes all four as built-in reports.
LoanTabs provides collections reports. You can see exactly what is overdue and hand a collection sheet to an officer. For most money lenders and MFIs, knowing precisely who to visit today is what matters.
The collections and risk reports
All of these are among LoanTabs' 30 reports and export to CSV, Excel and PDF.
A daily collections routine with LoanTabs
- Step 1
Open the delinquency worklist
See every overdue loan in one list and decide who to contact first.
- Step 2
Print the daily collection sheet
Give each officer their section with borrower phone numbers and amounts due.
- Step 3
Record what was collected
Enter each repayment as it arrives and print the PDF receipt.
- Step 4
Review PAR and aging weekly
Watch the trend. Rising 30+ and 90+ day buckets are your early warning.
Which report answers which question
| Question | Report | Why it matters |
|---|---|---|
| Who do we chase today? | Delinquency worklist and daily collection sheet | Turns arrears into a task list |
| How much of the book is at risk? | Portfolio at risk (PAR) | A single risk figure for boards, funders and regulators |
| How old is the overdue money? | Aging report | Older arrears are harder to recover |
| How much should we set aside? | Provisions and loan classification | Keeps profit and the balance sheet honest |
| Are our officers collecting? | Collections performance | Shows who and where to coach |
| Are cohorts of loans behaving? | Vintage and roll-rate analysis | Shows whether new lending is better or worse than old |
How does the follow-up work in practice?
The reports tell you who is late and by how much, and your team does the follow-up and records the outcome. A loan officer starts the day with the delinquency worklist or the printable daily collection sheet, visits or calls the borrowers listed, and records each payment against the loan as it arrives.
If you want more depth on how these measures work, our guides explain portfolio at risk, days past due and aging and how to reduce loan defaults.
Loan collections reports: common questions
Does LoanTabs have collections software?
LoanTabs includes collections reports: a delinquency worklist, a daily collection sheet, collections performance, portfolio at risk, aging and provisions, so your team always knows who to follow up today.
How do I calculate portfolio at risk in LoanTabs?
The PAR report calculates it for you using thresholds set in your reporting policy, so you do not need to work it out by hand.
Can I print a list of borrowers to visit today?
Yes. The daily collection sheet is a printable PDF with a section for each officer and each borrower's phone number.
What aging buckets does LoanTabs use?
Current, 1-30, 31-60, 61-90, 91-180 and 181+ days past due.
Keep exploring
- Loan management softwareThe LoanTabs overview: what it does, who it is for and what it costs.
- Online loan management systemRun your loan book from any browser, with nothing to install.
- Loan software guideThe types of loan software, what each does and how to choose.
- Lending software and lending management systemsWhat a lending management system covers, end to end.
- Loan management software for small businessBuilt for money lenders: quick setup, small-team workflow, simple pricing.
- Online loan application softwareTake and process loan applications online, from intake to disbursement.
- Loan management solutionSoftware, setup, migration, training and support in one solution.
- Loan tracking softwareTrack balances, due dates and overdue loans, with an aging example.
- Loan repayment softwareRecord, allocate and receipt repayments, with a worked example.
- All 30 lending reportsPortfolio, collections, income and accounting reports.
See who is overdue in seconds
Start a 30-day free trial, import a sample of loans and open the delinquency worklist.
No credit card required