A loan tape is a loan-level data file — typically a spreadsheet or CSV — that summarizes every loan in a portfolio with standardized fields: balance, rate, term, origination date, borrower characteristics, delinquency status, and collateral type. Loan tapes are the primary data artifact exchanged in secondary market whole-loan sales, CLO collateral management, and due diligence for portfolio acquisitions.
A loan tape is the data layer that makes whole-loan markets function. When a bank, credit union, or non-bank lender wants to sell a portfolio of loans — to another institution, a CLO warehouse facility, or an asset manager — the buyer's first request is the loan tape. The tape allows the buyer to underwrite the portfolio at the loan level: analyze concentration risk, prepayment exposure, credit quality distribution, geographic diversification, and weighted-average coupon (WAC) / weighted-average maturity (WAM). Standard loan tape fields for commercial loans typically include: loan ID, origination date, maturity date, original balance, current balance, scheduled payment amount, interest rate, rate type (fixed/floating), DSCR at origination, LTV at origination, NAICS code, borrower state, collateral type, payment status (current, 30+, 60+, 90+, REO), and modification history. For consumer loan tapes (personal loans, auto, mortgages), fields add FICO score, DTI, and credit bureau pull date. Loan tapes are also used by servicers and CLO managers for ongoing portfolio monitoring, by regulators (the Federal Reserve and FDIC conduct periodic loan-level data collection), and by fintech lenders who sell whole-loan flows to institutional buyers as part of their originate-to-sell model. The standardization of loan tape fields has been driven by industry bodies and agency disclosure requirements — Fannie Mae and Freddie Mac publish standardized MBS collateral data that effectively define loan tape standards for conforming mortgage markets.
Secondary market buyers (banks, credit funds, BDCs, CLO managers) use loan tapes to underwrite portfolio acquisitions. Regulators (Federal Reserve, FDIC, OCC) collect loan-level data for stress testing and supervisory purposes. Servicers use tapes for ongoing portfolio monitoring. Fintech lenders and marketplace lenders use them to sell loan flows to institutional capital partners.
A clean tape has complete, consistent fields with no missing data, standardized formats (dates as YYYY-MM-DD, rates as decimals), and accurate current balances reconciled to the servicer's records. A dirty tape has inconsistent field definitions, missing obligor data, gaps in payment history, or discrepancies between loan-level balances and portfolio totals. Dirty tapes require significant normalization work and reduce buyer confidence — often widening the bid-ask spread.
Securitization requires detailed loan-level disclosure so investors can assess collateral quality. Fannie Mae and Freddie Mac publish standardized MBS loan-level data files (a form of loan tape) for every pool they issue. CLO managers file collateral reports with trustees that are functionally loan tapes for each CLO deal. The quality and granularity of loan tape data directly affects investor demand and pricing in structured credit markets.