Financial Statement Data
Contact one of our dedicated Customer Service
CSR Hours: Monday — Friday
8:30 a.m. to 5 p.m. Central Time
2017 Annual Record Layouts
2018 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 2016 but not 2017, or visa-versa, this might indicate the information was deleted (or added) in 2017.