NOTE: Please note that the 2019 Annual record layouts are being reviewed for further changes and will be replaced as needed.
NOTE: Beginning with 2019 Quarterly filings, there will no longer be a Fraternal Statement Blank. Fraternal will now be filed on the Life Statement Blank.
2019 Annual Record Layouts
2020 Quarterly Record Layouts
There are two worksheets to review for the annual tables—one to identify changes in columns, and one to identify changes in the rows.
Using the auto filter capabilities in Excel, scroll to the last column of each worksheet, which is labeled "Difference"—in order to highlight the differences—and click on the down arrow in order to change the options to display only non-blank rows. This filter will only include results where changes have occurred between the two years. You might find it useful to also filter by the blank type you are working on.
These worksheet are sorted by blank type and then base table name. However you have the option to sort all data to your liking.
As you go through report specifications, you might find it helpful to click the down arrow on the base table name and then start typing the name of table that concerns you in the search box. If you get no results, then there were no changes to the table you are concerned with if you set the filter in the difference columns as described above.
Note, the search feature is not case sensitive.
If you find a row in the worksheet where data is present for 2018 but not 2019, or visa-versa, this might indicate the information was deleted (or added) in 2019.
Due to the current situation concerning the COVID-19 pandemic, NAIC staff are working remotely and are not shipping products or taking phone calls.
If you need help placing an order or need further information, please email one of our dedicated customer service representatives at:
Financial Statement Data
Automated Valuation Service (AVS)
CSR Hours: Monday — Friday
8:30 a.m. to 5 p.m. Central Time