Skip to content

DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-nccs

education-data-source-nccs

Verified

NCCS — Form 990 data for private nonprofit colleges (Portal: IPEDS-matched, 1993-2016). Revenue, expenses, assets, endowment, governance beyond IPEDS. Use when IRS financial depth needed. Portal ends 2016; public institutions excluded (no Form 990).

FileKindSize
SKILL.mdskill md21.2 KB
references/education-relevance.mdmarkdown30.4 KB
references/form-990.mdmarkdown18.3 KB
references/nonprofit-data.mdmarkdown25.2 KB
references/ntee-codes.mdmarkdown16.1 KB
references/variable-definitions.mdmarkdown40.0 KB

references/form-990.md

View on GitHub
# IRS Form 990 Structure and Data Elements

Form 990 is the annual information return that tax-exempt organizations file with the IRS. This reference covers the form's structure and the data elements available for research.

> **Variable naming context:** Older NCCS documentation used legacy NCCS Core names (e.g., `CONT`, `TOTREV`, `COMPENS`), which no current NCCS file uses as column names. This file gives the Efile names. In the Portal dataset the same items have lowercase descriptive names (e.g., `contributions_total`, `revenue_total`, `compensation_officers`); see SKILL.md Portal Variable Name Mapping, and `variable-definitions.md` for the full legacy-to-current mapping. Governance and schedule detail variables (Part VI, VII, Schedule D/J) are available only in the full NCCS Efile database, not in the Portal mirror dataset.

## Contents

- [Form 990 Overview](#form-990-overview)
- [Form Types](#form-types)
- [Form 990 Parts](#form-990-parts)
- [Schedules](#schedules)
- [Key Financial Sections](#key-financial-sections)
- [Governance and Compensation](#governance-and-compensation)
- [Data Quality Considerations](#data-quality-considerations)

---

## Form 990 Overview

Form 990, "Return of Organization Exempt From Income Tax," is required annually from most tax-exempt organizations. It provides comprehensive information about:

- **Mission and activities**: What the organization does
- **Finances**: Revenue, expenses, assets, liabilities
- **Governance**: Board composition, policies, conflicts of interest
- **Compensation**: Executive pay, board compensation
- **Related parties**: Transactions with insiders

### Filing Requirements

| Organization Type | Gross Receipts | Assets | Required Form |
|-------------------|----------------|--------|---------------|
| Most 501(c) | normally ≤ $50,000 | N/A | 990-N (e-Postcard) |
| Most 501(c) | < $200,000 | < $500,000 | 990-EZ |
| Most 501(c) | ≥ $200,000 **or** | ≥ $500,000 | 990 (full form) |
| Private foundations | Any | Any | 990-PF |

### 2008 Form Redesign

The Form 990 was substantially redesigned in 2008, affecting data comparability:

| Pre-2008 | Post-2008 |
|----------|-----------|
| 9 pages (2007) | 11 pages (2008); 12 pages from at least 2016 |
| Basic governance questions | Detailed governance section |
| Limited compensation detail | Extensive compensation reporting |
| Functional columns (B)-(D) required for 501(c)(3)/(4) (unchanged) | Same requirement, now Part IX |

**Important**: When analyzing pre-2008 vs. post-2008 data, be aware of definitional and structural changes.

---

## Form Types

### Form 990 (Full Form)

- **Filers**: Larger organizations (gross receipts ≥ $200K or assets ≥ $500K)
- **Length**: 12 pages (2025 form) + applicable schedules
- **Detail level**: Comprehensive financial and governance information
- **In NCCS**: Core PC files, Efile database

### Form 990-EZ

- **Filers**: Smaller organizations (gross receipts < $200K AND assets < $500K)
- **Length**: 4 pages
- **Detail level**: Abbreviated financials, basic governance
- **In NCCS**: Core PZ files (combined with 990), Efile database

### Form 990-PF

- **Filers**: Private foundations (including non-operating foundations)
- **Length**: 13 pages
- **Detail level**: Grant recipients, investment details, minimum distribution
- **In NCCS**: Core PF files, Efile database

### Form 990-N (e-Postcard)

- **Filers**: Very small organizations (gross receipts normally ≤ $50K)
- **Content**: Name, EIN, address, principal officer, tax year only
- **In NCCS**: Separate ePostcard database (no financial data)

---

## Form 990 Parts

### Part I: Summary

High-level organizational overview and key financial totals.

| Line | Description | Efile name (current year) | Legacy NCCS Core name |
|------|-------------|---------------------------|-----------------------|
| 1 | Mission/activities description | Text field | — |
| 8 | Contributions and grants | `F9_01_REV_CONTR_TOT_CY` | `CONT` |
| 9 | Program service revenue | `F9_01_REV_PROG_TOT_CY` | `PROGREV` |
| 10 | Investment income | `F9_01_REV_INVEST_TOT_CY` | `INVINC` |
| 12 | Total revenue | `F9_01_REV_TOT_CY` | `TOTREV` |
| 18 | Total expenses | `F9_01_EXP_TOT_CY` | `EXPS` |
| 19 | Revenue less expenses | `F9_01_EXP_REV_LESS_EXP_CY` | `NETINC` |
| 20 | Total assets (EOY) | `F9_01_NAFB_ASSET_TOT_EOY` | `TOTASS` |
| 21 | Total liabilities (EOY) | `F9_01_NAFB_LIAB_TOT_EOY` | `TOTLIAB` |
| 22 | Net assets (EOY) | `F9_01_NAFB_TOT_EOY` | `NETASS` |

Efile names are matched by the Form 990 line the Efile data dictionary gives. The Classic HRMN Core dictionary has the Part VIII-X equivalents for the full-990 (PC) files instead (`F9_08_REV_TOT_TOT`, `F9_09_EXP_TOT_TOT`, `F9_10_ASSET_TOT_EOY`, `F9_10_LIAB_TOT_EOY`, `F9_10_NAFB_TOT_EOY`); harmonized Core names are in `variable-definitions.md`.

### Part II: Signature Block

Officer signature and preparer information.

### Part III: Statement of Program Service Accomplishments

Narrative descriptions of the three largest program services with associated expenses.

| Line | Description |
|------|-------------|
| 1 | Mission statement |
| 4a-4d | Program descriptions and expenses |

### Part IV: Checklist of Required Schedules

Yes/No questions determining which schedules must be attached (38 numbered lines, many with sub-questions).

### Part V: Statements Regarding Other IRS Filings

Questions about other tax filings (W-2s, 1099s, etc.) and tax compliance.

### Part VI: Governance, Management, and Disclosure

Detailed questions about organizational governance.

| Section | Topics |
|---------|--------|
| A | Governing body and management |
| B | Policies (conflict of interest, whistleblower, document retention) |
| C | Disclosure (990 availability, financial statements) |

Key questions:
- Number of voting members of governing body
- Number of independent voting members
- Family/business relationships among officers
- Delegation of management to outside firms
- Policy documentation

### Part VII: Compensation of Officers, Directors, Trustees, Key Employees

Most important section for governance research.

| Section | Content |
|---------|---------|
| A | List of officers, directors, trustees, key employees, highest compensated employees |
| B | Independent contractors receiving > $100,000 |

**Reported for each person**:
- Name and title
- Hours per week (and related organizations)
- Reportable compensation from organization
- Reportable compensation from related organizations
- Estimated other compensation (benefits, deferred)

### Part VIII: Statement of Revenue

Detailed breakdown of all revenue sources.

| Line | Category |
|------|----------|
| 1a-1h | Contributions (federated campaigns, membership dues, fundraising events, related organizations, government grants, all other; 1h total) |
| 2a-2g | Program service revenue |
| 3 | Investment income (dividends, interest, similar) |
| 4 | Income from investment of tax-exempt bond proceeds |
| 5 | Royalties |
| 6a-6d | Rents |
| 7a-7d | Gain/loss from sales of assets (securities, other) |
| 8a-8c | Fundraising events |
| 9a-9c | Gaming |
| 10a-10c | Sales of inventory |
| 11a-11e | Other revenue |
| 12 | Total revenue |

### Part IX: Statement of Functional Expenses

Expenses broken down by function (program, management, fundraising).

| Line | Expense Category |
|------|------------------|
| 1 | Grants to domestic organizations |
| 2 | Grants to domestic individuals |
| 3 | Grants to foreign organizations/individuals |
| 4 | Benefits to members |
| 5 | Compensation (current officers, directors, etc.) |
| 6 | Compensation (disqualified persons) |
| 7 | Other salaries and wages |
| 8 | Pension plan accruals |
| 9 | Other employee benefits |
| 10 | Payroll taxes |
| 11a-g | Professional fees |
| 12 | Advertising and promotion |
| 13 | Office expenses |
| 14 | Information technology |
| 15 | Royalties |
| 16 | Occupancy |
| 17 | Travel |
| 18 | Travel/entertainment payments for public officials |
| 19 | Conferences and meetings |
| 20 | Interest |
| 21 | Payments to affiliates |
| 22 | Depreciation |
| 23 | Insurance |
| 24a-e | Other expenses |
| 25 | Total functional expenses |

**Columns**: 
- (A) Total
- (B) Program services
- (C) Management and general
- (D) Fundraising

### Part X: Balance Sheet

Assets, liabilities, and net assets at beginning and end of year.

**Assets**:
| Line | Category |
|------|----------|
| 1 | Cash (non-interest bearing) |
| 2 | Savings and temporary cash investments |
| 3 | Pledges and grants receivable |
| 4 | Accounts receivable |
| 5 | Loans to current/former officers, etc. |
| 6 | Loans to other employees |
| 7 | Notes and loans receivable |
| 8 | Inventories |
| 9 | Prepaid expenses |
| 10a-c | Land, buildings, equipment (gross, depreciation, net) |
| 11 | Investments (publicly traded securities) |
| 12 | Investments (other securities) |
| 13 | Investments (program-related) |
| 14 | Intangible assets |
| 15 | Other assets |
| 16 | Total assets |

**Liabilities**:
| Line | Category |
|------|----------|
| 17 | Accounts payable and accrued expenses |
| 18 | Grants payable |
| 19 | Deferred revenue |
| 20 | Tax-exempt bond liabilities |
| 21 | Escrow/custodial account liability |
| 22 | Loans from officers, directors, etc. |
| 23 | Secured mortgages and notes payable |
| 24 | Unsecured notes and loans payable |
| 25 | Other liabilities |
| 26 | Total liabilities |

> Line numbers below are for the 2019+ form, the first to use the "without/with donor restrictions" net-asset classes (IRS Form 990 for 2018 and 2019, https://www.irs.gov/pub/irs-prior/f990--2018.pdf and f990--2019.pdf, fetched 2026-10-30). The 2017 and 2018 forms used 27 Unrestricted, 28 Temporarily restricted, 29 Permanently restricted, 30-32 capital stock / paid-in / retained earnings, 33 Total net assets, 34 Total liabilities and net assets; that this layout holds back to the 2008 redesign is inference (the 2008-2016 forms were not checked). Forms before the 2008 redesign have a different balance sheet: on the 2007 form it is Part IV, with total net assets on line 73 (https://www.irs.gov/pub/irs-prior/f990--2007.pdf, fetched 2026-10-30). Portal years (1993-2016) span both layouts; see § 2008 Form Redesign.

**Net Assets**:
| Line | Category |
|------|----------|
| 27 | Without donor restrictions |
| 28 | With donor restrictions |
| 29 | Capital stock or trust principal |
| 30 | Paid-in or capital surplus |
| 31 | Retained earnings |
| 32 | Total net assets |
| 33 | Total liabilities and net assets |

### Part XI: Reconciliation of Net Assets

Links Part VIII revenue and Part IX expenses to the change in net assets.

### Part XII: Financial Statements and Reporting

Information about accounting method and audit status.

---

## Schedules

Organizations attach schedules based on their activities. Key schedules for education research:

### Schedule A: Public Charity Status and Public Support

Required for 501(c)(3) public charities.

| Part | Content |
|------|---------|
| I | Reason for public charity status |
| II | Support schedule (170(b)(1)(A)(vi)) |
| III | Support schedule (509(a)(2)) |
| IV-VI | Supporting organization details |

### Schedule D: Supplemental Financial Statements

**Part V: Endowment Funds** - Critical for higher education research

| Line | Description |
|------|-------------|
| 1a | Beginning of year balance |
| 1b | Contributions |
| 1c | Net investment earnings |
| 1d | Grants or scholarships |
| 1e | Other expenditures for facilities and programs |
| 1f | Administrative expenses |
| 1g | End of year balance |
| 2a-2c | % of year-end balance held as board-designated/quasi-, permanent, and term endowment |
| 3a-3b | Endowment funds held by unrelated/related organizations |
| 4 | Intended uses (described in Part XIII) |

Part V reports five columns: current year through four years back.

Other Parts:
- Part I: Donor advised funds
- Part II: Conservation easements
- Part III: Art and collections
- Part IV: Escrow and custodial accounts
- Part VI: Land, buildings, equipment details
- Part VII: Investments (other securities)
- Part VIII: Investments (program related)
- Part IX: Other assets
- Part X: Other liabilities
- Part XI: Reconciliation of revenue
- Part XII: Reconciliation of expenses

### Schedule J: Compensation Information

Detailed compensation for officers, directors, key employees.

| Part | Content |
|------|---------|
| I | Questions about compensation practices |
| II | Officers/directors/employees receiving >$150K from organization and related |

**For each person**:
- Base compensation
- Bonus and incentive compensation
- Other reportable compensation
- Retirement and deferred compensation
- Nontaxable benefits
- Total compensation

### Schedule R: Related Organizations and Unrelated Partnerships

Information about related entities (common for university systems).

| Part | Content |
|------|---------|
| I | Disregarded entities |
| II | Related tax-exempt organizations |
| III | Related organizations taxable as a partnership |
| IV | Related organizations taxable as a corporation or trust |
| V | Transactions with related organizations |
| VI | Unrelated organizations taxable as a partnership |

---

## Key Financial Sections

### Revenue Categories (Part VIII)

```
Total Revenue
├── Contributions, Gifts, Grants
│   ├── Federated campaigns
│   ├── Membership dues
│   ├── Related organizations
│   ├── Government grants
│   └── Other contributions
├── Program Service Revenue
│   ├── Tuition and fees
│   ├── Auxiliary enterprises
│   └── Other program revenue
├── Investment Income (lines 3-4)
│   ├── Dividends, interest, similar (line 3)
│   └── Tax-exempt bond proceeds investment (line 4)
├── Royalties (line 5)
├── Rents (line 6)
├── Net Gain/Loss from Sales (line 7)
│   ├── Securities
│   └── Other assets
└── Other Revenue
    ├── Fundraising events, gaming, inventory sales (lines 8-10)
    └── Miscellaneous (line 11)
```

### Expense Categories (Part IX)

```
Total Expenses
├── Grants and Allocations
├── Compensation
│   ├── Officers/directors/trustees
│   ├── Other employees
│   ├── Pension/retirement
│   ├── Other benefits
│   └── Payroll taxes
├── Professional Fees
│   ├── Accounting
│   ├── Legal
│   ├── Investment management
│   └── Other professional
├── Operations
│   ├── Occupancy
│   ├── Supplies
│   ├── Travel
│   ├── Conferences
│   └── Interest
├── Depreciation
└── Other Expenses
```

### Functional Expense Allocation

For 501(c)(3) and (c)(4) organizations, expenses must be allocated to:

| Function | Description |
|----------|-------------|
| **Program services** | Direct mission-related activities |
| **Management and general** | Administration, oversight, finance |
| **Fundraising** | Donor cultivation, solicitation |

This allocation is important for calculating efficiency ratios.

---

## Governance and Compensation

### Key Governance Variables

| Item | Description |
|------|-------------|
| Voting members | Size of governing body |
| Independent members | Members without financial relationship |
| Family relationships | Officers/directors related to each other |
| Business relationships | Officers/directors with business ties |
| Conflict of interest policy | Written policy exists |
| Whistleblower policy | Written policy exists |
| Document retention policy | Written policy exists |
| CEO/director review | Governing body reviews CEO compensation |
| Form 990 review | Governing body reviews Form 990 |

### Compensation Data

**Who is reported**:
- Current officers, directors, trustees
- Key employees (>$150K compensation with organizational responsibility)
- Five highest compensated employees (>$100K reportable)
- Former officers/employees receiving >$100K
- Former directors/trustees receiving >$10K in that capacity
- Independent contractors receiving >$100K

**What is reported**:
- Base compensation
- Bonus/incentive
- Other reportable (expense accounts, etc.)
- Retirement/deferred compensation
- Nontaxable benefits (health insurance, housing, etc.)
- Total

---

## Data Quality Considerations

### Common Issues

| Issue | Description | Mitigation |
|-------|-------------|------------|
| **Missing data** | Not all fields required | Check for valid values vs. blanks |
| **Reporting variations** | Organizations interpret questions differently | Use consistent definitions |
| **Fiscal year differences** | Organizations have different year-ends | Account for timing in comparisons |
| **Amended returns** | Some organizations file corrections | Use most recent filing |
| **Consolidation** | University systems may file consolidated | Check related organizations |
| **Rounding** | Small amounts may be rounded | Be cautious with small values |

### Missing Data Codes

In the Education Data Portal (not NCCS source files): -1 Missing, -2 Not applicable, -3 Suppressed (generic Portal labels; rare in NCCS columns).
| Code | Meaning |
|------|---------|
| -1 | Missing |
| -2 | Not applicable |
| -3 | Suppressed |
| `null` | Not reported (blank in CSV, null in parquet) |

> **Portal note:** In the Portal dataset, most missing data appears as `null` rather than negative codes. The `-1`/`-2`/`-3` codes exist but are rare (only a few financial columns). Always check for both `null` and negative codes when cleaning.

### Recommended Error Checks

1. **Revenue check**: Total revenue ≈ sum of components
2. **Expense check**: Total expenses ≈ sum of components
3. **Balance sheet**: Assets = Liabilities + Net Assets
4. **Reconciliation**: Beginning net assets + (Revenue - Expenses) ≈ Ending net assets
5. **Compensation**: Individual totals ≈ sum of components
6. **Functional expense**: Total ≈ Program + Management + Fundraising

### Form 990 vs. Audited Financial Statements

| Aspect | Form 990 | Audited Financials |
|--------|----------|-------------------|
| **Basis** | Modified cash or accrual | GAAP accrual |
| **Fiscal year** | Tax year (may differ) | Organization's fiscal year |
| **Consolidation** | Varies | Full consolidation |
| **Revenue detail** | Specific categories | May differ |
| **Expense detail** | Functional allocation | Natural classification |
| **Notes** | Limited | Extensive |

**For colleges**: Audited financial statements (GAAP) may show different totals than Form 990 due to these differences. IPEDS data also follows education-specific accounting.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 198kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 194kUpdated Claude CodeCodexVerifiedInstall