@pipeworx/ffiec-call-reports

Connect: https://gateway.pipeworx.io/ffiec-call-reports/mcp · Install: one-click buttons

Tools: 5

Every US bank’s quarterly balance sheet, income statement, regulatory capital, loan, deposit and credit-quality detail, as filed on the FFIEC Call Report (Consolidated Reports of Condition and Income, forms 031/041/051) — 4,336 filers, line-item level.

Why this is not part of fdic, and not the same thing

Three packs touch US banks and they do different jobs:

The split is an id-space decision, not a preference. A bank carries an FDIC certificate number and a Federal Reserve IDRSSD, and they are different numbers for the same institution — JPMorgan Chase Bank is cert 628 and rssd 852218. The CDR keys on IDRSSD; fdic keys on cert. Interleaving them in one pack is how a caller passes the id one tool returned into another and silently gets a different bank.

So: both identifiers are accepted here, both are returned, and every response states which one it resolved on.

Tools

Auth

Keyless.

Units — the trap that breaks bank-vs-credit-union comparison

Call reports are filed in thousands of dollars. NCUA files in whole dollars. Comparing the two on raw numbers is wrong by 1000×, in the credit union’s favour.

Every amount here is normalised to whole USD, with the as-filed figure kept alongside:

{ "mdrm": "RCFD2170", "label": "TOTAL ASSETS",
  "value_usd": 4016571000000, "as_filed": 4016571000,
  "unit": "USD (normalised from the thousands banks file in)" }

Capital ratios arrive as percentages with a literal % and are passed through as unit: "percent" — never multiplied.

What is mirrored

The seven core schedules — RC (balance sheet), RI (income statement), RC-R I (regulatory capital), RC-N (past due and nonaccrual), RC-C I (loans by category), RC-E (deposits), RC-K (quarterly averages). Measured: 1.49M values per quarter of the 5.23M across all 46 schedules.

The full 3,843-code MDRM dictionary loads regardless, so any code is explainable even where no value is held — ffiec_coverage({code}) returns mirrored_values: false for those.

Non-numeric cells (17,100 a quarter) go to their own table rather than being dropped. CONF matters: it means the bank filed and withheld the value as confidential, which is a different answer from “not reported”.

Data source

• https://cdr.ffiec.gov/public/PWS/DownloadBulkData.aspx — FFIEC Central Data Repository bulk download.

Things the next person would otherwise rediscover

• There is no API. The CDR download is ASP.NET WebForms: the period dropdown is empty until a series is selected via an AJAX postback, so one quarter takes three requests (GET for __VIEWSTATE, POST to populate periods, POST to download). No login needed. www.ffiec.gov/npw/* returns 403 to scripted clients, so that is not an alternative.
• RCFD vs RCON is the consolidation basis, not two different metrics — RCFD includes foreign offices, RCON is domestic-only. A bank files one or the other for a given line, so a lookup must try both or it returns “not reported” for a bank that reported perfectly well.
• Line 2 of every schedule file is the human label, not data. Parsing from line 2 shifts every value by one row.
• Values are in thousands (see above).
• CONF is a value. Do not coerce it to null.
• The filing lag is ~60 days, so the current calendar quarter is normally not the newest available.

Tools

• ffiec_search_banks — Find US banks and savings institutions that file the FFIEC Call Report, by name, city or state. Returns the bank’s Federal Reserve IDRSSD, its FDIC certificate number, location, which call report form
• ffiec_call_report — Get a US bank’s filed call report for one quarter — the balance sheet, income statement, regulatory capital, loan and deposit detail as actually reported, with every line item labeled rather than left
• ffiec_line_item — Track one US bank call report line item over time — total assets, net income, deposits, equity, or any MDRM code. Answers “how have this bank’s deposits changed”, “net income trend for bank X”, “what
• ffiec_compare_banks — Compare or rank US banks on a call report figure — largest by assets, most deposits, highest net income — optionally within one state. Answers “largest banks in Ohio”, “compare JPMorgan and Bank of Am
• ffiec_coverage — Report what FFIEC call report data is available here — which quarters are loaded, how many banks and line items each holds, which schedules are covered, and the filing lag between a quarter ending and