TREMOR's US bank credit-stress data is aggregated from FDIC Call Reports (the FDIC Statistics on Depository Institutions API, summed bank-by-bank to industry totals). This page documents how that FDIC-banks data is validated - a reconciliation against the FDIC's own Quarterly Banking Profile, plus internal rollup-consistency checks. For data sources and rate definitions, see the US bank/credit data methodology page. The companion credit-union and household-debt validations are on the NCUA and NY Fed pages.
Open the interactive US Bank Aggregates tool on TREMOR (FDIC Banks source) for the live validation tables.
FDIC reconciliation vs the Quarterly Banking Profile
Cross-validation of our FDIC-API aggregation (sum of individual bank records) against the FDIC's own pre-computed industry totals from the Quarterly Banking Profile (QBP). Same backend Call Report data, different aggregation path - any divergence points to a coverage or methodology gap.
Coverage: ~100 quarters (Q1 2001 onward), sourced from the FDIC QBP Time Series Spreadsheet. The comparison spans:
- Balances: Total Loans, Real Estate, Consumer, Credit Cards, Auto, Agriculture, Other, Lease financing.
- Delinquency: 30-89 DPD, 90+ DPD, Nonaccrual, and Net Charge-Offs across 7 segments.
- Rates: 30-89 DPD rate, Noncurrent rate, and Net Charge-Off rate (annualized).
Balances reconcile to the QBP industry totals; small delinquency-level differences are flagged as warnings where the FDIC's published aggregation differs marginally from the bank-by-bank sum. The live per-quarter reconciliation table (balances, delinquency, and rates side-by-side) is in the interactive tool.
Internal rollup-consistency checks
Pipeline math self-checks run across all ~100 quarters: for each parent category, the sum of its sub-categories should match the parent total. This confirms the aggregation is internally consistent before any comparison against external published numbers.
| Check | Identity | Status | Note |
|---|---|---|---|
| Total Loans rollup | LNLSGR = RE + C&I + Consumer + Ag + Other + Depository + Foreign Govt + Muni + Lease | PASS | Closes across all quarters |
| Real Estate sub-types | LNRE = Construction + CRE + Multifamily + Farmland + Residential | KNOWN GAP | ~0.8% - "other RE" not in these 5 sub-types |
| Consumer sub-types (post-2011) | LNCON = Credit Cards + Auto + Other Consumer | KNOWN GAP | ~5% - revolving credit plans not in CC/Auto/Other |
| Noncurrent identity | Noncurrent = 90+ DPD + Nonaccrual | PASS | Exact match across all ~100 quarters (0.0% gap) |
The two known gaps are structural FDIC reporting features (a residual "other RE" bucket, and revolving non-card consumer credit) - not data errors - and are consistent across all periods. The live per-quarter gap tables, plus latest-quarter and GFC-peak noncurrent-rate sanity checks, are in the interactive tool.
See it live
This page is the static, readable companion to the FDIC-banks validation in TREMOR's US Bank Aggregates tool (live QBP reconciliation + rollup-consistency tables). Open the interactive tool on TREMOR, or read the methodology page. TREMOR is part of tigzig.com - AI for analytics, databases and macro signals.