Skip Header

Federal Deposit
Insurance Corporation

Each depositor insured to at least $250,000 per insured bank

Loss Share Data Specifications Version 1.4.1

The FDIC defines the data reporting requirements for Loss Share Agreements via a set of detailed specifications that include file formatting instructions, Source validation criteria, RDVP validation criteria, reporting templates, and examples of reporting scenarios. These Loss Share Data Specifications have evolved over time. On September 22, 2014, the FDIC published the most recent version of the Loss Share Data Specifications. The dates of the last revisions to the documents are provided below.

Updates in Loss Share Data Specifications Version 1.4.1

The following list summarizes the updates to Loss Share Data Specifications:

Download Loss Share Data Specifications Version 1.4.1

FDIC Loss Share agreements include Single Family Residential or Non-Single Family portfolios. The documents below contain the instructions and reporting templates for each of these asset classes. The tables below contain links to the various documents that make up the data specifications:

Loss Share Data Specifications v1.4.1 for Single Family (SFR) Portfolios

File

Description

Instructions for SFR LS Specifications
(801 KB PDF File - PDF Help)

File describing detailed data requirements for the Loss Share Single Family Residential portfolios.

Example SFR Covered Loss Calculations(.xls)

File demonstrating how to calculate SFR covered losses.
All data, formulas and calculations are for illustrative purposes only.

SFR Certificate file(.pdf)

Aggregate Level file containing a summary of changes in the SFR portfolio, covered losses in the current period, and cumulative losses for all periods.

SFR Active Loans file(.xlsx)

Loan level file containing loans covered by Loss Share that are active at the end of the reporting period. Active loans should not also be found in the PIF, Loan Sale, or ORE files.

SFR Charge-Off Loss file(.xlsx)

Loan level file listing of second or greater lien mortgage loans charged-off during the reporting period.

SFR Foreclosure Loss file(.xlsx)

Loan level file listing assets with covered foreclosure and ORE sale loss events during the reporting period.

SFR Inactive Loans file(.xls)

Loan level file of inactive assets subject to recovery-sharing. The Inactive Loans file should include loans removed from Loss Share coverage (RFLS) during the period removed then no longer reported in subsequent submissions.

SFR Loan Sales file(.xls)

Loan level file listing loan sales completed during the reporting period. Please provide information on all loan sales completed during the reporting period and the covered loss amount for loan sales approved for Loss Share coverage and completed during the reporting period.

SFR ORE Listing file(.xls)

Asset level file containing a listing of Other Owned Real Estate covered by Loss Share.

SFR Paid in Full file(.xls)

Listing of paid in full loans covered by Loss Share within the reporting period. Do not report loans on the PIF file where a partial payment has been made.

SFR Recoveries and Expense file(.xls)

Asset level file containing details about recoveries and expenses on the assets covered by Loss Share.

SFR Related Loan file(.xls)

Loan level file of assets with related loans defined by the Purchase and Assumption Agreement. Submitted on a semi-annual basis.

SFR Restructure Loss file(.xls)

Loan level file listing assets with covered restructuring/modification loss events during the reporting period. This list applies only to loan modifications performed per HAMP or FDIC modification standards. Loans restructured under other approved programs may have additional data reporting requirements.

SFR Short Sale Loss file(.xls)

Loan level file listing assets with covered short sale loss events during the reporting period.

SFR FDIC Adjustment file(.xls)

File used to report activity from previous reporting periods requiring restatement.



Loss Share Data Specifications v1.4.1 for Non-Single Family (NSF) Portfolios

File

Description

Instructions for NSF LS Specifications
(886 KB PDF File - PDF Help)

File describing detailed data requirements for the Loss Share Non-Single Family Residential portfolios.

NSF Certificate file(.pdf)

Aggregate level file containing a summary of changes in the NSF portfolio, covered losses in the current period, and cumulative losses for all periods.

NSF Recovery Certificate file(.pdf)

Aggregate level file containing a summary of changes in the NSF portfolio during Recovery Quarters. Includes qualifying transactions booked against Recovery assets.

NSF Active Loans file(.xls)

Loan level file containing loans covered by Loss Share that are active at the end of the reporting period. Active loans should not also be found in the PIF, Asset Sales, or ORE Listing files.

NSF Inactive Loans file(.xls)

Loan level file of inactive assets subject to recovery-sharing. The Inactive Loans file should include loans removed from Loss Share coverage (RFLS) during the period removed then no longer reported in subsequent submissions.

NSF Asset Sales file(.xls)

Asset level file containing a listing of loans and ORE assets sold during the reporting period.

NSF Loss and Recoveries file(.xls)

Asset level file containing details on losses, recoveries, and expenses covered by Loss Share.

NSF ORE Listing file(.xls)

Asset level file containing a listing of Other Owned Real Estate covered by Loss Share.

NSF Paid in Full file(.xlsx)

Asset level file containing paid in full loans covered by Loss Share within the reporting period. Do not report loans on the PIF file where a partial payment has been made.

NSF Related Loan file(.xls)

Loan level file containing assets with "related loans" as defined by the Purchase and Assumption Agreement. Submitted on a semi-annual basis.

NSF FDIC Adjustment file(.xls)

File used to report activity from previous reporting periods requiring restatement.


RDVP Scorecard

The RSAM Data Validation Process (RDVP) is an automated data validation process which validates AI Certificate submissions based on parameters outlined in the Loss Share Data Specifications. AIs have the ability to generate their RDVP Scorecard in RTSP during their submission process which will now include asset-level detail available for review.

For easy identification of all validations, the file below contains all NSF and SFR RDVP and Source validations consolidated into one report (see link below).

FDIC Loss Share Training Video Series

Asset ID Assignment Methodology

The Shared-Loss agreement requires Acquiring Institutions (AIs) to comply with Loss Share data reporting standards described in the Loss Share Data Specifications. The specifications require AIs to submit asset level data for each covered asset. One of the required asset level data elements, the FDIC Asset ID, is a unique identifier assigned by the FDIC to each covered asset subject to loss sharing under the Shared-Loss Agreement and provided on Schedules 4.15. Asset ID Requests are to be submitted directly through RTSP.

Asset ID Request Training Video Series
(Part 1 of 2 - Bifurcations)


Asset ID Request Training Video Series
(Part 2 of 2 – Consolidations and Fully Charged Off at Closing)



RTSP 4.1 Certificate Submission

RTSP Iteration 4.1 introduces both new and updated functionality for AI personnel, specifically in the areas of Loss Share Certificate Processing. These videos are intended to serve as a quick reference for the submission upload process.

NSF Certificate Submission - Part 1

NSF Certificate Submission - Part 2

Data Key

Certificate submissions containing values other than the specified FDIC allowable values require Data Key mapping of the AI provided values to the FDIC allowable values. Data Key mapping is entered directly into RTSP. It is important the AI review all data files prior to submission and ensure that fields with allowable values are either populated with FDIC allowable values or mapped to Data Key values. Any unrecognized values will result in an error.

RTSP will be populated with AI allowable value mapping from the most recent submission for AIs who used the former Data Key template in their past submissions.

Allowable values of unknown or not applicable have been added to some of the FDIC data fields. Please be aware that the value unknown should be used sparingly and generally only at the initiation of Certificate reporting or during system conversions. RSAM Specialists may contact the AI where the value unknown is used excessively.

Questions?

Questions about Loss Share Data Reporting Requirements

If you have questions about your Institution's Loss Share data reporting requirements please see the Quick Reference Guide and FAQ document. You may also contact your RSAM Specialist.