What Is a Loan Tape? How NBFCs Track Portfolio Data for Risk and Investor Reporting

When a venture debt firm, an asset management company, or a development finance institution considers investing in or co-lending with an NBFC, one of the first documents they request is the loan tape. When a rating agency assesses an NBFC’s credit quality, they use the loan tape. When an NBFC’s risk team reviews portfolio concentration, they work from the loan tape.

A loan tape is a structured, loan-level dataset that contains the key attributes of every loan in an NBFC’s active portfolio or of a specific pool being sold, securitised, or pledged. It is the raw material of portfolio analysis: the document that enables everyone who looks at a loan portfolio to see it clearly, consistently, and in detail.

This guide explains what a loan tape contains, who uses it and for what purpose, what the standard data fields are, and what data quality standards matter most.

What a Loan Tape Is and Why It Matters

The loan tape is the one document that reduces an entire loan portfolio to an analysable dataset. Rather than reviewing individual credit files (impractical at scale) or relying only on aggregated summary statistics (too coarse for risk analysis), the loan tape provides loan-level granularity in a standardised tabular format.

With a well-structured loan tape, an analyst can:

• Calculate the distribution of borrower credit scores across the portfolio.
• Assess geographic concentration in specific states or districts.
• Calculate weighted average LTV for the secured portion of the portfolio.
• Identify the proportion of the portfolio in SMA-0, SMA-1, SMA-2, and NPA.
• Calculate weighted average tenor and remaining tenor.
• Build vintage curves by aggregating loans originated in the same period.
• Identify sector concentration in MSME portfolios.

None of this analysis is possible from aggregate reporting. All of it is immediately available from a well-built loan tape.

Who Uses Loan Tapes and For What Purpose

• Internal risk teams: for portfolio monitoring, concentration analysis, vintage analysis, and FOIR distribution tracking across the active portfolio.
• Investors and co-lenders: for due diligence before committing capital. An investor evaluating an NBFC’s NCD issuance or direct assignment transaction uses the loan tape to understand the quality of the underlying loans.
• Rating agencies: CRISIL, ICRA, CARE, and India Ratings use loan tapes to analyse the portfolio quality of rated NBFC instruments, securitisation transactions, covered bonds, or direct NBFC ratings.
• Development Finance Institutions (DFIs): IFC, ADB, and BII use loan tapes in their due diligence for green or impact lending, verifying that loans in the portfolio meet specified criteria (LTV limits, income documentation standards, borrower segment eligibility).
• Securitisation trustees and servicers: for pools securitised or assigned, the loan tape is the master record of which loans are in the pool and their current status.
• RBI examiners: During supervisory examination, RBI teams use loan-level data to verify credit quality, classification accuracy, and provisioning adequacy.

Standard Loan Tape Fields for an NBFC Portfolio

Standard loan tape fields typically include the following categories:

Loan Identification

• Unique loan ID (anonymised for external sharing, no borrower PAN or name in the externally shared tape)
• Loan product type (personal loan, LAP, vehicle loan, MSME working capital, gold loan, etc.)
• Origination date
• Disbursement date
• Origination channel (digital, branch, DSA, co-lending)

Borrower Profile

• State and district of the borrower
• Borrower segment (salaried, self-employed, MSME, agricultural)
• CIBIL score at origination (or bureau score from whichever bureau was used)
• FOIR at origination
• Verified monthly income at origination

Loan Terms

• Original loan amount
• Interest rate (fixed or floating)
• Tenure (original months)
• EMI amount
• Current outstanding principal
• Months on book
• Remaining tenure

Collateral (for secured loans)

• Security type (property, gold, vehicle, FD)
• Original collateral value
• LTV at origination
• Collateral location (state, district)

Credit Quality Fields in a Loan Tape

Credit quality fields in the loan tape are the most closely analysed by risk teams and investors:

• Current DPD (Days Past Due): the number of days the most recent payment is overdue. 0 = current; 1–30 = SMA-0; 31–60 = SMA-1; 61–90 = SMA-2; 91+ = NPA.
• Account status: Standard, SMA-0, SMA-1, SMA-2, NPA, Restructured, Settled, Written Off.
• Worst DPD in the last 12 months: the highest DPD reached in the past year. An account currently at DPD 0 that reached DPD 30 once in the past year is a different risk profile from one that has been consistently at DPD 0.
• NACH bounce history: number of NACH returns in the past 3, 6, and 12 months. An account with 3 NACH returns in 12 months is under stress even if currently DPD 0.
• Provision amount: the provision set aside against this specific loan account relevant for investors assessing net exposure.
• Restructured indicator: whether the loan terms have been modified from the original structure. Restructured loans are a specific credit quality category that requires separate analysis.

Loan Tape Data Quality: Common Gaps and How They Affect Analysis

Loan tape data quality is a persistent challenge for many NBFCs, particularly those that have grown quickly, changed LMS systems, or have legacy portfolios from before robust data capture was in place:

• Missing origination CIBIL score: if the CIBIL score at origination was not captured in the LMS, it cannot be added retrospectively. Investors and rating agencies use origination score distribution as a key underwriting quality indicator; missing scores reduce the tape’s analytical value for this dimension.
• Inconsistent product classification: if the same product has been classified differently in different periods (some personal loans classified as consumer loans, some as retail loans), segmentation analysis produces misleading results.
• Outdated collateral valuations: LAP pools with collateral values from 3–5 years ago do not accurately represent current LTV, particularly relevant in markets where property values have changed significantly.
• Incomplete DPD history: some LMS systems only store the current DPD, not the DPD history. Without historical DPD, the loan tape cannot support worst-DPD analysis or vintage curve construction.
• Missing geographic data: loans without state or district data cannot be analysed for geographic concentration, a key risk management metric.

Loan Tape in Securitisation and Portfolio Sale Transactions

Loan tape in securitisation is the foundational document for any pool transaction. When an NBFC securitises a pool of loans or assigns them to a bank in a direct assignment transaction, the loan tape defines the pool:

• The pool tape lists every loan in the securitised pool with all standard loan tape fields.
• Investors and the rating agency use the pool tape to assess pool quality (score distribution, LTV distribution, vintage composition, DPD history).
• The trustee uses the pool tape as the master record against which monthly pool performance is tracked.
• Pool selection criteria (minimum CIBIL score, maximum LTV, minimum months on book) are verified against the pool tape.

Clean, complete, consistent loan tape data is a transaction quality indicator in securitisation markets. NBFCs with well-structured, gap-free loan tapes command better pricing in securitisation transactions because buyers can trust the data they are analysing.

Key Takeaways

• A loan tape is a loan-level structured dataset containing key attributes of every loan in an NBFC portfolio: origination data, borrower profile, loan terms, collateral, and credit quality fields. It is the foundational document for portfolio analysis.
• Users: internal risk teams (concentration and vintage analysis), investors and co-lenders (due diligence), rating agencies (quality assessment), DFIs (impact criteria verification), and securitisation trustees (pool management).
• Standard fields: loan identification, borrower profile (state, segment, CIBIL score, FOIR, income), loan terms (amount, rate, tenure, outstanding), collateral (type, value, LTV), and credit quality (current DPD, status, worst DPD, NACH bounces, provision).
• Data quality gaps, missing origination scores, inconsistent classification, outdated collateral values, and incomplete DPD history reduce the analytical value of the tape and the NBFC’s credibility in investor and rating transactions.

Frequently Asked Questions

Conclusion

The loan tape is the operational reality of a loan portfolio reduced to data. It tells the truth about the portfolio, not the portfolio’s good years or its average performance, but the actual distribution of risk across every loan, at this moment, with this DPD pattern, at these LTV levels.

Build the habit of keeping a clean, complete, consistently structured loan tape from the beginning. The NBFC that has three years of gap-free loan tape data when it approaches investors for scale capital is in a fundamentally different position from one that must reconstruct the data from legacy systems at the point of need. Data quality is built over time, and once the data is gone, it cannot be rebuilt.

Analyze smarter. Lend better with Fineye.