Variable pages · IRS 990 Master Concordance

F9_09_EXP_FEE_SVC_LOB_PROG

Fees for services - lobbying - program service expenses

Description
Fees for Services - Lobbying - Program Service Expenses
Table
F9-P09-T00-EXPENSES (one)
Part
Part IX - Statement of Functional Expenses
Location
F990-PC-PART-09-LINE-11D-COL-B
Type
numeric
Scope
PC – 990 only
Database
F990
Forms
PC
2 / 3
xpaths observed / mapped
136k
filings with a value
2009–2024
tax years observed
0 + 1 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues parse as numbers100.0% of values are numeric
▲ warnNo sudden change in the median between adjacent yearslargest change 12.8x (IRS990/FeesForServicesLobbying/ProgramServices, 990, TY2010)
✓ passPooled xpaths are on the same scale (same return type)largest ratio of medians between xpaths: 1.0x
ⓘ infoSign convention0.0% of values are negative (fine for net amounts)

Flags

FlagSeverityXpathDetailReview
SCALE_BREAK▲ warnIRS990/FeesForServicesLobbying/ProgramServices990 medians differ 26x across xpaths (ProgramServices vs ProgramServicesAmt)✓ accepted
noteSame form line: the pre-2013 xpath (TY2009-12) and its post-2013 successor never overlap in a year. The check compares medians of per-year/schema-version q50 with zeros dropped, so zero-heavy eras and the small, larger-org TY2009-10 e-file population drive the ratio (old-xpath medians fall 2009->2012 toward the new-era level; yearly medians within one xpath swing as much). Same quantity. Evidence (990): IRS990/FeesForServicesLobbyingGrp/ProgramServicesAmt [Line 11d Column (B)] TY13-24 n=121,791 yearly medians 0 to 26,662; IRS990/FeesForServicesLobbying/ProgramServices [Line 11d Column (B)] TY9-12 n= 14,019 yearly medians 0 to 26,995

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990/FeesForServicesLobbying/ProgramServicesPC2009–201214,0192.5%
x2IRS990/FeesForServicesLobbyingGrp/ProgramServicesAmtPC2013–2024121,7915.53%
x3IRS990/Form990PartIX/FeesForServicesLobbying/ProgramServicesPCnot observed0

% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.

Coverage by tax year

Filings’09’10’11’12’13’14’15’16’17’18’19’20’21’22’23’24
x11.5k3.9k4.2k4.5k
x25.0k5.6k5.8k6.1k6.4k7.0k8.1k13k15k16k18k15k
Fill rate: % of all filings of the return type (largest xpath)
9905332332223344556

Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.

Values

ReturnFilings% numeric% zero% negativeP25MedianP75P99
990135,810100.0%61.8%0.0%01,00029,825554,138

Percentiles are the median over tax years of each year's percentile.

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2The Family YMCA0XML
2012990x1MARIMED FOUNDATION FOR ISLAND HEALTH CA…0XML