Commercial Bank Data
Beginning with the September 30, 2017 data file, select variables were removed due to variable logic being no longer supported going forward. The removed variables are listed below.
Report of Condition and Income data are available for all banks regulated by the Federal Reserve System, Federal Deposit Insurance Corporation, and the Comptroller of the Currency. All financial data are on an individual bank basis. Data on this site are available from 1976 to 2010 in zipped SAS XPORT format datasets. You can download the free System Viewer from the SAS site to view these files if you are not a SAS user.
Availability of Commercial Bank Data
Beginning with the March 31, 2011, Report of Condition, future releases of quarterly commercial bank data will only be available from the FFIEC Central Data Repository's Public Data Distribution site (PDD). Data on the PDD site are available in two formats for downloading, tab delimited and eXtensible Business Reporting Language (XBRL); and includes historical data through March 31, 2001. This will help ensure timely access to data as it is submitted or revised. An example SAS program to read the tab delimited bulk files into a SAS dataset is provided in the Data Files section below to help ease the transition to the PDD.
The historical datasets will remain available on chicagofed.org, and historical datasets that are within the two year window of the most recent as-of date will continue to be refreshed. The PDD releases data for commercial banks that file the FFIEC 031 and FFIEC 041 only, and does not include additional structural information. Due to this restriction, other report of condition and income data included in the chicagofed.org datasets, specifically the FR 2886b and FFIEC 002 data, will be provided going forward, along with structure information for filers of all four reports. However, due to the lack of continuity with future datasets, the Data Extraction System for Call Report data tool will be decommissioned.
The complete files below contain all the financial variables reported on the Report of Condition and Income and selected structure data. These files are large (15MB zipped) and are best suited for a network (file server) environment.
The structure and non-CDR datasets below contain structure and geographical variables for all call report filers, and financial data for FR 2886b and FFIEC 002 filers.
The example SAS program below provides one possible way of importing the tab delimited bulk files available on the CDR's PDD site into a SAS dataset. The PDD tab delimited bulk files are structured so that each schedule of the call report is available as a separate text file containing all respondents. The data are also available in XRBL format with individual files for each respondent.
Example SAS Program (Updated 06/21/2012)
Banking Research Datasets
CRSP-FRB Link is intended to distribute data that is useful for conducting and replicating academic research involving commercial banks.
Contains a brief definition of the variables on the files and their reporting frequency.
Forming Consistent Time Series
Notes on forming consistent time series.
Sample Call Report Forms
Only the complete files contain all variables.
Consolidated Reports of Condition and Income for a Bank with Domestic and Foreign Offices
Consolidated Reports of Condition and Income for a Bank with Domestic Offices Only (replaces FFIEC 032, FFIEC 033, FFIEC 034)
Consolidated Report of Condition and Income for Edge and Agreement Corporations
Report of Assets and Liabilities of U.S. Branches and Agencies of Foreign Banks
Notes on changes in reporting Regulatory Capital data from 1990 to 1994 and 1994 to current.
Structure and Geographical Variables
List of structure and geographical variables on both files (Complete and Subset). Detailed description for decoding can be found in the Dictionary file.