Bank of England Loan Level Data Reporting Template for Auto Loan Portfolios

The Bank of England (BoE) introduced a mandatory loanlevel data (LLD) reporting framework for all authorised lenders in the United Kingdom. The aim is to give regulators a granular view of credit risk across the banking system, improve macroprudential surveillance, and ultimately enhance financial stability.

Why Auto Loans Matter

Auto loans represent one of the largest and fastestgrowing segments of consumer credit. Their distinct characteristics shortterm maturities, vehiclecollateral, high turnover of borrowers create a risk profile that differs markedly from mortgages or credit cards. Consequently, lenders must capture and report specific data fields that reflect the unique dynamics of autoloan portfolios.

Key Objectives of the Template

• Standardisation: Ensure all institutions use a common set of definitions, codes and formats.
• Transparency: Provide the BoE with sufficient detail to monitor concentrations, credit quality and emerging trends.
• Comparability: Enable crossinstitutional analysis of riskadjusted performance.
• Timeliness: Align reporting deadlines with existing regulatory calendars (monthly, quarterly).

Structure of the Reporting Template

The template is divided into six main sections. Each section contains mandatory fields, optional fields (where applicable), and a set of validation rules.

Data Formatting Rules

1. Date formats: ISO 8601 (YYYYMMDD).
2. Numeric fields: Two decimal places, period as decimal separator.
3. Categorical codes: Use the BoEapproved lookup tables (e.g., EMP for employed, SELF for selfemployed).
4. Missing data: Use NA for optional fields; mandatory fields must never be left blank.

Reporting Frequency & Deadlines

The BoE requires monthly submission of the entire autoloan portfolio as of the last business day of the month. The file must be uploaded to the regulatory portal by the 10th business day of the following month. Quarterly supplemental reports may be required for stresstesting purposes.

Technical Submission Guidelines

Reports must be submitted in the following formats:

• CSV (UTF8 encoded): Preferred for large datasets, allows easy validation using standard tools.
• XML (XSD compliant): Alternative for institutions that already generate XML outputs.

Both formats must conform to the XSD schema published on the BoE website. Validation errors will be returned automatically; institutions have 48hours to correct and resubmit.

Key Risk Indicators (KRIs) Derived From the Template

While the template itself is a reporting tool, it also underpins several KRIs that banks monitor internally:

• Portfolio Weighted Average Credit Score.
• 30day, 60day, 90day delinquency rates.
• Loss Given Default (LGD) by vehicle type.
• Repossession to recovery ratio.
• Average loantovalue (LTV) at origination.

Common Challenges and Best Practices

Data Quality

Autoloan data often originates from multiple legacy systems (dealership management systems, core banking, credit bureaus). Consolidation can lead to mismatched identifiers. A recommended approach is to maintain a master datahub that assigns a single Loan ID used across all downstream feeds.

Timely Reconciliation

Because the reporting window is narrow, any mismatch between the loan ledger and the LLD file can cause submission rejections. Implement automated reconciliation scripts that compare total balances, count of active loans, and aggregate LTV before file generation.

Regulatory Change Management

The BoE periodically updates the schema (e.g., adding new vehicletype codes). Allocate resources for a changeimpact analysis each quarter, and maintain versioncontrolled XSD files in a secure repository.

Data Security & Privacy

Autoloan data contains personally identifiable information (PII). Ensure encryption intransit (TLS 1.2+), store files on encrypted drives, and limit access to needtoknow personnel. Document the datahandling process to satisfy both BoE and GDPR requirements.

Sample CSV Layout (excerpt)

LoanID,ExternalRef,OrigDate,BorrowerAge,BorrowerEmpStatus,CreditScore,IncomeBand,VehicleMake,VehicleModel,VehicleYear,VIN,NewUsedFlag,VehicleValue,LoanAmount,TermMonths,Rate,APR,RepaymentFreq,OutstandingBal,CurrentInst,DelinqStatus,WriteOffFlag,ReposDate,RecoveryAmt,NetLoss,CollateralNPVA123456,EXT987654,2023-02-15,34,EMP,720,30k-40k,Toyota,Camry,2022,1HGCM82633A004352,N,25000,15000,60,4.5,5.2,Monthly,14500,250,0,0,,,B234567,EXT654321,2022-11-03,28,SELF,660,25k-35k,Ford,Focus,2021,2FTRX18W1XCA12345,Y,18000,12000,48,6.2,7.0,Monthly,11600,250,31-60,0,2023-08-01,8000,4000,8500

Next Steps for Institutions

1. Gap Analysis: Compare current internal reporting fields against the BoE template.
2. Data Mapping: Document sourcetotarget mappings and identify transformation rules.
3. System Build: Develop an extractiontransformload (ETL) pipeline that produces the required CSV/XML file.
4. Testing: Run the file through the BoE validation service; resolve any schema errors.
5. Governance: Establish a reporting governance committee responsible for oversight, signoff and continuous improvement.

For the most uptodate schema definitions, validation tools and implementation guidance, please refer to the Bank of Englands official website: bankofengland.co.uk.