FFIEC Call Report
FFIEC_CALL_REPORTfree10 data-quality rules for the FFIEC Consolidated Reports of Condition and Income (Call Report, FFIEC 031/041/051) filed by banks. Covers required schedules, the balance-sheet identity (Schedule RC: Total assets = Total liabilities and equity capital), income-statement consistency, MDRM item validity, RSSD identification, quarter-end period, and non-negative balances. Use it to clear validity edits before submitting to the agencies.
Checks included (10)
Balance Sheet Balances (RC 12 = RC 29)
Schedule RC item 12 "Total assets" must equal item 29 "Total liabilities and equity capital" — the fundamental accounting identity.
Net Income Reconciles (Schedule RI)
Schedule RI net income must equal total interest and noninterest income less expenses, provisions, and taxes (within rounding).
Total Equity Reconciles to Components
Total equity capital must equal the sum of its components (common stock, surplus, retained earnings, AOCI) within rounding.
RSSD Identifier Present(rssd_id)
Every report must carry the filing institution's RSSD ID to identify the reporter.
Required Schedules Present
The core schedules (RC balance sheet and RI income statement) must be present for the reporting period.
MDRM Item Codes Are Valid
Each reported line item must reference a valid MDRM (Micro Data Reference Manual) item code for the reporting form and period.
Reporter Is a Known Institution
The filing RSSD ID must exist in the FFIEC institution registry (NIC).
Reported Asset Balances Non-Negative(total_assets)
Asset and balance line items reported in thousands should not be negative unless the item explicitly permits it.
Report Date Is a Quarter-End(report_month_day)
Call Reports are as-of quarter-end dates (Mar 31, Jun 30, Sep 30, Dec 31).
One Value per Schedule Item(item_key)
Each (report, schedule, MDRM item) combination must be reported once.