NAIC Statutory Reporting
NAICfree10 data-quality rules for insurer statutory financial statements filed with the NAIC (Annual/Quarterly Statement). Covers required pages, the balance-sheet identity (assets = liabilities + capital and surplus), NAIC company-code validity, non-negative reserves, premium reconciliation, investment-schedule consistency, reporting period, and duplicate suppression. Use it to clear cross-checks before filing.
Checks included (10)
Balance Sheet Balances
Total assets must equal total liabilities plus capital and surplus on the statutory balance sheet.
Net Premium Reconciles
Net premiums written must equal direct plus assumed less ceded premiums (within rounding).
Capital and Surplus Reconciles to Components
Capital and surplus must equal the sum of common/preferred capital, gross paid-in surplus, and unassigned funds (within rounding).
Schedule D Total Ties to Balance Sheet
Total invested assets from Schedule D must tie to the invested-assets line on the balance sheet (within rounding).
NAIC Company Code Present(naic_company_code)
Each statement must carry the filer's NAIC company code.
Required Statement Pages Present
Core pages (Assets, Liabilities/Surplus, Summary of Operations) must be present for the filing.
NAIC Company Code Is Registered
The NAIC company code must exist in the NAIC company registry.
Reserves Are Non-Negative(total_reserves)
Reported loss/policy reserves should not be negative.
Reporting Period Is Valid(period_end_month_day)
Statutory statements are filed for quarter-end or year-end periods.
One Statement per Company per Period(company_period_key)
A company should file a single statement per reporting period.