Lead Ageing Report for Lenders: Buckets, SLAs, Layout
Last reviewed: November 2026
A lead ageing report for lenders is a view of every open loan enquiry showing how long it has waited in its current stage, grouped into age buckets with clear limits. It answers one question each morning: which borrowers have we kept waiting too long, and where?
This guide is for heads of sales operations and chief business officers at banks, non-banking financial companies (NBFCs) and fintech lenders. It works through the questions teams ask when building one, from stage buckets and illustrative service level agreement (SLA) thresholds to layout and red-bucket actions, plus how Digiqt's CRM 2.0 helps officers clear the oldest leads first.
At a Glance
- Age leads by stage, not just since creation. A ten-day-old lead stuck in credit needs different action from one never called.
- Use stage-specific thresholds. One bucket rule for all stages hides the urgent cases.
- Put value next to age. Leads at risk in ₹ get attention that counts do not.
- Close dead leads deliberately. Old nurture leads are a data-protection question too.
What Is a Lead Ageing Report for Lenders?
A lead ageing report for lenders lists open leads by stage and age bucket, with a summary matrix for managers and a drill-down list for officers. It answers how long open leads have waited in each stage.
Lenders often confuse it with two neighbours. Loan lead leakage analysis asks which leads were lost and why, while lead scoring for lenders asks which leads are most likely to convert; ageing is the early warning, and leakage is what happens when nobody acts on it.
How Much Pipeline Sits Idle Without a Lead Ageing Report?
Pipeline sits idle in surprising amounts when a lender has no lead ageing report showing stage age. Take an illustrative lender with 1,200 open leads across 10 branches, an average ticket of ₹4 lakh and historical conversion of 12% for fresh leads and 4% for red leads.
If 360 of those leads (30%) sit in red buckets, they would have produced 43 loans if worked while fresh, but only 14 now. That is 29 loans and ₹1.16 crore of disbursement lost: the price of not looking.
Which Lead Ageing Buckets Should Lenders Use for Each Stage?
Lenders should use five stage-specific ageing bands, each with a green, amber and red threshold. These illustrative SLA thresholds are a starting point; set yours from your own stage-time history.
| Stage | Green | Amber | Red |
|---|---|---|---|
| New, not yet contacted | Under 4 working hours | 4–24 hours | Over 24 hours |
| Contacted, documents pending | 0–3 working days | 4–7 days | Over 7 days |
| Logged in, under credit review | 0–3 working days | 4–7 days | Over 7 days |
| Sanctioned, not disbursed | 0–5 working days | 6–10 days | Over 10 days |
| Nurture (not ready to borrow yet) | 0–30 days | 31–60 days | Over 60 days: re-engage or close |
Age in stage (working days) = report date − stage entry date − holidays and weekly offs in between
Red bucket share = red leads in stage ÷ open leads in stage × 100
Exclude days a lead was paused at the borrower's written request, and log the pause reason. Login-stage ageing belongs partly to credit, so share it with credit underwriting queue management.
How Do You Set Your Own Lead Ageing Thresholds?
You set your own lead ageing thresholds from the stage times of leads that actually converted, using four steps.
- Export six months of disbursed loans with the entry and exit date of every stage.
- Calculate working days spent in each stage for each loan.
- Set amber at the 80th percentile and red at the 95th percentile of those days.
- Recheck every quarter, and after any change in credit policy or product.
For example, if 80% of disbursed loans cleared documents pending within 4 working days and 95% within 7, amber starts on day 5 and red on day 8. Thresholds built this way reflect how your borrowers and teams really behave, so officers accept them.
Do RBI or Data Rules Limit How Long Loan Leads Can Wait?
Two rules touch lead ageing directly, one at the application stage and one for old nurture leads.
- Paragraph 12, Reserve Bank of India (RBI) (NBFC – Responsible Business Conduct) Directions, 2025: an NBFC "shall devise a system of giving acknowledgement for receipt of all loan applications"; preferably, the acknowledgement indicates the time frame for disposal. Measure login-stage ageing against that promised time frame.
- Section 8(7)(a), Digital Personal Data Protection (DPDP) Act, 2023: erase personal data when consent is withdrawn or "as soon as it is reasonable to assume that the specified purpose is no longer being served", unless law requires retention. Old nurture leads need a close-and-erase rule.
Under the Ministry of Electronics and Information Technology (MeitY) commencement notification of 13 November 2025, section 8 is scheduled to take effect 18 months later, in May 2027.
What Goes in the Ageing Summary Matrix for Managers?
The ageing summary matrix for managers shows counts by stage and bucket for each branch, with value at risk in the last column. Build it with one row per stage for every branch and these seven columns:
- Branch code
- Stage
- Green count
- Amber count
- Red count
- Red share (%)
- Value at risk (₹ lakh) = red leads × ticket × conversion
Which Columns Belong in the Lead Ageing Drill-Down List?
The lead ageing drill-down list needs twelve columns so an officer can act without opening another screen.
- Lead ID and source (branch walk-in, digital, partner, call)
- Borrower name and product
- Assigned officer and branch
- Current stage
- Stage entry date
- Age in stage (working days) and bucket
- Total lead age since creation
- Expected ticket size
- Last contact date and outcome
- Next action and due date
- Pause flag and reason
- Lead score, if you use one
Clean duplicates first using loan application deduplication, or one borrower will appear as three aged leads.
What Should Each Red Ageing Bucket Trigger?
Each red ageing bucket should trigger one named action and owner, so the report drives work rather than discussion. This illustrative action matrix covers all five stages.
- New, not contacted over 24 hours: reassign to another officer the same day (branch manager).
- Documents pending over 7 days: resend the document checklist and call at the best time (assigned officer).
- Under credit over 7 days: escalate with the file number to credit (head of sales operations).
- Sanctioned, not disbursed over 10 days: clear conditions and track the physical file (branch operations).
- Nurture over 60 days: re-engage with a reason, or close and erase (sales operations).
Physical files stuck between desks show up in loan file movement tracking. Feed the weekly ageing review into the management information system (MIS) pack through NBFC MIS reporting, so the chief business officer sees ageing trend alongside disbursement.
Are your documents-pending leads quietly turning red?
See How CRM 2.0 Turns Aged Leads Into Tasks
See AI-created tasks and WhatsApp follow-ups target the oldest enquiries, or ask us about your pipeline stages.
How Does CRM 2.0 Help Clear Aged Loan Leads?
CRM 2.0 helps clear aged loan leads by making the next action easy and timely for the officer who owns the lead. CRM 2.0 is Digiqt's artificial intelligence (AI)-powered customer relationship management system, and Digiqt can build the stage-wise ageing report around it.
| Task | Spreadsheet Routine | With CRM 2.0 |
|---|---|---|
| Find stuck leads | Weekly spreadsheet export | Ageing view built by Digiqt on stage entry dates |
| Decide next step | Officer memory | AI task creation from the last call or chat |
| Reach the borrower | Repeated calls at random times | Best time to connect suggestions |
| Chase documents | Manual texts | Smart WhatsApp messaging |
| Know what was said | Notes typed later | AI call summaries and AI chat summaries |
| Learn why leads stall | Anecdotes | Objections tracked and categorised |
Document chasing pairs well with WhatsApp lead nurturing for lenders. Officer workload matters too, so check lead allocation to sales officers when one person holds most red leads.
What Does a Worked Lead Ageing Example Show for One Branch?
A worked lead ageing example shows how one branch's report points to a single stage problem. This illustrative branch has 120 open leads and a ₹5 lakh average ticket.
| Stage | Open | Red | Red Share | Conversion Lost per Red Lead | Value at Risk |
|---|---|---|---|---|---|
| New, not contacted | 30 | 6 | 20% | 8 points | ₹2.4 lakh |
| Documents pending | 40 | 18 | 45% | 10 points | ₹9 lakh |
| Under credit | 25 | 4 | 16% | 15 points | ₹3 lakh |
| Sanctioned, not disbursed | 10 | 3 | 30% | 30 points | ₹4.5 lakh |
| Nurture | 15 | 9 | 60% | – | Close or re-engage |
Value at risk = red leads × ₹5 lakh × conversion points lost. Documents pending carries the most value, so the fix is a document chase routine, not more leads.
Want the oldest loan enquiries worked first every morning?
Book a CRM 2.0 Demo for Lead Ageing Views
See ageing buckets built on your own stages, or visit Digiqt to connect with our CRM team.
Sources
- RBI: Non-Banking Financial Companies – Responsible Business Conduct Directions, 2025
- MeitY: The Digital Personal Data Protection Act, 2023 (No. 22 of 2023)
- AZB & Partners: DPDP Act Phased Rollout and Key Compliance Milestones (14 November 2025)
- TeamLease RegTech: MeitY Notification on Commencement of the DPDP Act, 2023



