NCCS adds five financial variables to all BMF files. These NCCS financial variables are similar to the financial variables in BMF from the IRS, but NCCS financial data is compiled from 5 separate Core files for each BMF file year and then supplemented with BMF data, so the information is more accurate than the financial data found in BMF files. Unlike BMF financial variables, NCCS financial variables are also defined consistently for all types of filers.
All of the NCCS variable names in BMF begin with 'c' and and are listed in BMF data dictionaries under "NCCS Financial Info."
Variable: cFiler (replaces FILER)
Description: Filed 990 return within 24 months of BMF file date? (Y/N)
Type: Character
Length: 1
Variable: cTaxPer (replaces TAXPER)
Description: Ending date for tax period of NCCS financial data in yyyymm format.
Type: Character
Length: 6
Variable: cTotRev (replaces INCOME & F990REV, which is defined as Gross Rev for PCs and Total Rev for PFs within the same 501c3 file. The IRS added Total Rev for PCs to the BMF file in a new variable called F990REV. The new cTotRev contains Total Revenue, regardless of org type, the form filed, or the tax year.)
Description: Total Revenue from most recent Form 990 (incl. 990EZ or 990PF)
Type: Numeric
Precision: 0
Variable: cAssets (replaces ASSETS)
Description: Total assets (end of year) from most recent Form 990 (incl. 990EZ or 990PF)
Type: Numeric
Precision: 0
Variable: cFinSrc (identifies file source of data)
Description: Source of financial data added by NCCS (primarily the most recent Form 990 filing as of BMF date from NCCS Core files)
Type: Character
Length: 10
BMF-based TableWizard reports are based on these NCCS 'c' variables instead of financial variables provided on BMF files (as of October 12, 2006) and all DataWeb users are strongly advised to use NCCS 'c' financial variables instead of the BMF financial variables for several reasons:
- The definition of INCOME in BMF as a measure of Gross Revenue is calculated differently depending on type of filer (Form 990, 990-EZ, or 990-PF):
BMF description of INCOME AMOUNT
Income Amount is a computer generated amount from the most recent Form 990 series return filed by the organization. Income Amount is computer generated using PART I, Total Revenue Line 12 and adding "back in" the expense items, i.e. Line 6b (Rental Expenses) shown on the Form 990 return. On Form 990EZ it is generated using PART I, Line 9 and adding "back in" the expense items, i.e. Line 5b (Cost or Other Basis Expenses). ** Income Amount for Form 990-PF is generated using Part I, Line 10b (Cost of Goods) and adding Part I, Line 12, Col. (A) (Total Revenue Col. A) and Part IV, Line 1, Col. (G) (Cost or Other Basis). This field is dollars only.
** NOTE - The definition of INCOME for 990PF is not easily reconciled to INCOME amounts in BMF.
- BMF does not contain Total Revenue for Form 990-PF filers. Do not use INCOME as a proxy for 990-PF Total Revenue!:
BMF description of FORM 990 REVENUE AMOUNT
Amount from Form 990, part 1, line 12, or part 1, line 9, of Form 990EZ.
- ** On the other hand, BMF does define ASSETS the same way for all types of filers:
BMF description of ASSET AMOUNT
Asset Amount is an amount from the most recent Form 990 series return filed by the organization. Asset Amount is the Total Assets End of Year - PART IV Balance Sheet Line 59 Col. (B) shown on the Form 990. This field is also from PART II, Line 25, Col. (B) EOY on Form 990EZ and PART II, Line 16, Col. (b) on Form 990PF. This field is dollars only.