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


 Home > Industry Analysis >Failed Banks> Failed Banks > Loss Share Data Specifications Past Releases

Release Notes for Past Releases

Past Release: Loss Share Data Specification Version 1.3.2

Important Notice: On September 26, 2011, FDIC published Loss Share Data Specifications version 1.3.3. All institutions must adopt version 1.3.3 starting with the September 30, 2011 reporting period end date. Content provided on this page is for reference purposes only.

The FDIC defines the data reporting requirements for Loss Share Agreements via a set of detailed specifications that include instructions, validation criteria, reporting templates, and examples of reporting scenarios. These Loss Share Data Specifications have evolved over time. On March 31, 2011 the FDIC published version 1.3.2 of the Loss Share Data Specifications.

Implementation Timeline for Loss Share Data Specifications Version 1.3.2

All Loss Share acquiring institutions must adopt the Loss Share Data Specifications Version 1.3.2 by the June 30, 2011 reporting period end date.

Changes in Loss Share Data Specification Version 1.3.2

Loss Share Data Specifications Version 1.3.2 was a minor release as defined in the Change Management Plan. The following list summarizes the changes made by the FDIC in the Loss Share Data Specifications Version 1.3.2:

  • Added instructions to describe the process for requesting FDIC Asset ID(s) after the Final Workbook Adjustment Process.
  • Added instructions to describe the process for reporting FDIC Adjustment(s) related to prior period submissions.
  • Enhanced field descriptions and data validation criteria.

Download Loss Share Data Specifications Version 1.3.2

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 for Single Family (SFR) Portfolios

File

Description

Instructions for SFR LS Specifications
(664 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.

SFR Certificate file (.xls)

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 (.xls)

Loan level file containing loans covered by Loss Share.

SFR Charge-Off Loss file (.xls)

Loan level file listing items for the listing of second lien mortgage loans charged-off during the reporting period

SFR Foreclosure Loss file (.xls)

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

SFR Inactive Loans file (.xls)

Listing of all inactive assets that are still subject to recovery-sharing. For example, include loans that were fully charged off at time of closing (during the first 3 years of the agreement).

SFR Loan Sale 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)

Loan 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.

SFR Recoveries and Expenses file (.xls)

Loan level file containing details about recoveries and expenses on the loans covered by Loss Share.

SFR Related Loans file (.xls)

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

SFR Restructuring 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, FDIC modification standards, or other modification programs approved by the FDIC. 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


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

File

Description

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

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

NSF Certificate file (.xls)

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 Active Loans file (.xls)

Loan Level file containing loans covered by Loss Share.

NSF Inactive Loans file (.xls)

Loan Level file listing of all inactive assets that are still subject to recovery-sharing. For example, include loans that were fully charged off at time of closing (during the first 3 years of the agreement).

NSF Loan Sale file (.xls)

Loan Level file containing a listing of loans sold during the reporting period.

NSF Loss and Recoveries file (.xls)

Loan Level file containing details about losses, recoveries, and expenses covered by Loss Share.

NSF ORE file (.xls)

Loan Level file containing a listing of Other Owned Real Estate covered by Loss Share.

NSF Paid in Full file (.xls)

Loan Level file containing Paid In Full loans covered by Loss Share within the reporting period.

NSF Related Loans file (.xls)

Loan Level file containing assets with "related loans" as defined by the Purchase and Assumption Agreement.

FDIC 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 Schedule 4.15. Since FDIC Asset IDs serve the important purpose of tracking covered assets throughout the life of the Loss Share agreement, FDIC will reject any loss claim certificate submission with blank or invalid FDIC Asset IDs.

FDIC Adjustments

FDIC adjustments relate to activity reported in previous reporting periods that requires restatement. Such adjustments may result from onsite compliance reviews, FDIC review of processed certificate submissions, or AI review of processed certificate submissions.

Clarifications

Additional clarifications to the Loss Share Data Specifications Version 1.3.2 files can be viewed in the following document:

Meeting materials:

Questions?

General Questions

If you have general questions about FDIC Loss Share please read:

Questions About Loss Share Data Reporting Requirements

If you have questions about your Institution's Loss Share data reporting requirements: