Financial Institution Reports & Historical Data References

Holding Company Data

Notice of Change in Data Availability

Effective June 15, 2021, users will no longer be able to access quarterly datasets for those data inside the active revision and retention window (five years plus current) through the Federal Reserve Bank of Chicago (FRBC). However, effective August 1, 2021, the data can be found by visiting the Financial Data Download page on the National Information Center (NIC) website.

Data from 1986 to current are available as quarterly datasets in compressed zip files. To receive updates when new data is available, click on the link to the subscription form, in the sidebar to the right, and select "Financial Holding Company Data" from the list of subscriptions.

Financial data are available for:

• FR Y-9C—All domestic holding companies on a consolidated basis;
• FR Y-9LP—All large domestic holding companies on an unconsolidated parent only basis; and
• FR Y-9SP—All small domestic holding companies on an unconsolidated parent basis, including balance sheet and income information for all three categories.

Note: FR Y-9C and FR Y-9LP data are collected quarterly; FR Y-9SP is collected semiannually.

Data Files

Historical quarterly datasets

Financial Institution Reports

Financial Institution Reports gathers data that aids the Federal Reserve in carrying out its responsibilities for the conduct of monetary policy, the supervision and regulation of the banking industry, and the protection of consumers' rights.

Data

Reports and data series collected and produced by the Chicago Fed's financial reporting group.

• Annual Report of Holding Companies - FR Y-6
• Commercial Bank Data
• Holding Company Data

Reporting Guidance

FAQs, links to relevant information and interactive worksheets to aid in preparation of reports.

• Call Report - Regulatory Reporting Guidance
• FR 2644 Reporting Guidance
• FR 2900 Reporting Guidance
• How to Submit Your Report in Reporting Central

Report Forms & Instructions

Current and historical report forms and instructions.

• Federal Reserve System Reporting Forms

Top Banks and Holding Companies

Notice of Change in Report Availability

As of March 1, 2024, updates will no longer be made to the Top Banks and Holding Companies report provided by the Federal Reserve Bank of Chicago. However, the data used in this visualization can be found by visiting the National Information Center's public website (NPW) and the FFIEC's Central Data Repository Public Data Distribution site. Further, a listing of large holding companies, by as-of date, is also available on NPW.

The Top Banks and HCs report indicates the total consolidated assets and number of financial institutions by District, as well as the rank order of the Seventh District’s largest top tier BHCs, SLHCs, banks, and state member banks by asset size in comparison to the largest top tier BHCs, SLHCs, banks, state member banks nationally. The four segments of the report graphically display these indicators for each type of institution. The Federal Reserve Bank of Chicago generates this report semi-annually (after financial data for the June 30th and December 31st reporting periods are considered final) using data from the Consolidated Reports of Condition and Income for Banks (FFIEC 031/ 041), the Consolidated Financial Statements for Bank Holding Companies (FR Y-9C), and the Parent Company Only Financial Statements for Small Bank Holding Companies (FR Y-SP).

Prior Releases

• Tableau Public, 2020-2022
• December 31, 2019
• June 30, 2019
• December 31, 2018
• June 30, 2018
• December 31, 2017
• June 30, 2017
• December 31, 2016
• June 30, 2016
• December 31, 2015
• June 30, 2015
• December 31, 2014
• June 30, 2014
• December 31, 2013
• June 30, 2013
• December 31, 2012
• June 30, 2012
• December 31, 2011
• June 30, 2011
• December 31, 2010
• June 30, 2010

Mergers and Acquisitions

Beginning after the September 09, 2015 merger datasets, future releases of mergers and acquisitions data will only be available from the National Information Center (NIC) bulk data download page.

The merger files contain information that can be used to identify all bank and bank holding company (BHC) acquisitions and mergers that have occurred since 1976. The file also includes information on the top holding companies of both the non-surviving and surviving entities. These data can be merged with the BHC or call report financial datasets by using either SURV_ID or NON_ID in the merger file and RSSD9001 (FRS ID/ID_RSSD) in the financial datasets, while paying close attention to the MERGE_DT and the as-of date of the financial data (RSSD9999).

The datasets are available as zipped SAS XPort files (*.XPT) for backwards compatibility and portability, and as XML files. The XML file is provided without a schema as no metadata is included. The XML file can be imported into Microsoft Excel, Office 2003 and later, by opening the file after downloading or by importing as a refreshable web query. Excel will create a schema during imports and once saved any future updates can be retrieved by refreshing the data connection.

• SAS XPort Datasets
• Bank Merger Data (SAS)
• BHC Merger Data (SAS)
• Live XML Files
• Bank Merger Data (XML)
• BHC Merger Data (XML)
• Variable Information
• Bank Merger Data Record Format
• BHC Merger Data Record Format

Seventh District Loan Loss Experience

This data is no longer being updated. For past data, please see below.

This data is a resource for de novo banks needing "loan loss experience" for tax purposes. Seventh District insured commercial bank "Consolidated Reports of Condition and Income" data are available for each quarter from March 1991 to December 2008.

Loan loss data

Documentation/Dictionary

A brief definition of each of the call report items in each of the categories.

Total Loans (Gross)

RCFD2122 TOTAL LOANS AND LEASES, NET OF UNEARNED INCOME.

The net total of "Total Loans and Leases, Gross (1400)" less "Unearned Income on Loans (2123)".

PLUS

RCFD2123 UNEARNED INCOME ON LOANS. Includes unearned income only to the extent that it is included in various loan items.

MINUS

RCFD2165 LEASE FINANCING RECEIVABLES (NET OF UNEARNED INCOME). Includes all outstanding receivable balances relating to direction and leveraged financing leases on property acquired by the bank for leasing purposes. These balances include the estimated residual value of leased property and is net of unearned income and any allowance for losses on leases.

Chargeoffs

RIAD4635 CHARGE-OFFS ON ALLOWANCE FOR LOAN AND LEASE LOSSES

(The amount of gross charge-offs on loans and leases during the calendar year-to-date)

MINUS

RIAD4266 CHARGE-OFFS ON LEASE FINANCING RECEIVABLES

(Includes all leases charged-off during the current calendar year-to-date)

Recoveries

RIAD4605 RECOVERIES ON ALLOWANCE FOR LOAN AND LEASE LOSSES

(Includes recoveries of amounts previously charged-off against allowance for loan and lease losses during the calendar year-to-date)

MINUS

RIAD4267 RECOVERIES ON LEASE FINANCING RECEIVABLES

(Includes all leases recovered during the calendar year-to-date)

Allowance for Loan and Lease Losses

RCFD3123 ALLOWANCE FOR LOAN AND LEASE LOSSES

Allowance for Loan and Lease Losses - Beginning Balance (3124)

PLUS

Recoveries in Allowance for Loan and Lease Losses (4605)

PLUS

Provision for Allowance for Loan and Lease Losses (4230)

PLUS

Adjustments (4815)

MINUS

Charge-Offs in Allowance for Loan and Lease Losses (4635)

Fed Funds Sold

RCONB987

From 20020331 to 99991231 FEDERAL FUNDS SOLD IN DOMESTIC OFFICES

PLUS

RCFDB989 From 20020331 to 99991231

SECURITIES PURCHASED UNDER AGREEMENTS TO RESELL

RCFD1350 From 19651231 to 20011231

FEDERAL FUNDS SOLD AND SECURITIES PURCHASED UNDER AGREEMENTS TO RESELL IN DOMESTIC OFFICES OF THE BANK AND OF ITS EDGE AND AGREEMENT SUBSIDIARIES, AND IN IBFS.

Includes both federal funds sold, and all securities purchased under agreements to resell. Reported as federal funds sold are all transactions involving the disposal of immediately available funds for one business day only or under continuing contract.