How we calculate funder giving metrics

Data sources

Private foundations file IRS Form 990-PF every year. Public charities that make grants — community foundations, supporting organizations and others — file Form 990 and list their grants on Schedule I. The IRS publishes the electronically filed returns (e-files) as machine-readable XML. From each return we read:

• The itemized grant list ("Grants and contributions paid during the year" on the 990-PF, Schedule I on the 990): each recipient's name, city, state, status, purpose and amount.
• Financial totals: total grants paid and, on the 990-PF, the distributable amount and qualifying distributions. Each profile names the form its figures come from.

We keep up to five filing years per foundation. A "year" is the tax year of the return, which for many foundations is a fiscal year rather than a calendar year; we label it by the calendar year it ends in. Paper filings and returns the IRS has not yet released are not included, so the latest year shown can lag the current year by one to two years.

As of October 2026 the data covers returns the IRS released through its 2026 batches: most funders' latest year is a fiscal year ending in 2024 or 2025, and some early filers already have one ending in 2026. Fiscal years ending in 2024 are the most recent nearly complete year, because returns are due four and a half months after year-end and extensions run six months more.

First-time grantees ("open to new grantees")

For the latest year on file we list every organization the foundation paid. A grantee is first-time if its name does not appear in any earlier year we hold for that foundation (for example 2020–2023 when the latest year is 2024). The share is first-time grantees divided by all distinct grantees that year; several grants to the same organization count once.

We only publish the figure when:

• the latest year has at least 10 distinct organizational grantees;
• there are at least 2 earlier years to compare against;
• each earlier year's list has at least 25% as many grantees as the latest year's. A short or truncated earlier list ("see attached") would make returning grantees look new, so we say nothing instead;
• no more than 50% of the latest year's grants went to individuals. Scholarship and hardship funds give to different people every year by design; "openness" does not describe them.

Grants to individuals are always left out of the grantee count. We treat a row as a grant to a person when the filer marks the recipient's status as individual ("I", "IND", "Individual"), when the name reads "College ITF Student" (in trust for), or when the status is blank or "N/A", the purpose is person-shaped (scholarship, tuition, hardship, funeral, rent, utility or heating help), and the name has no organization word in it.

Because our history window is at most five years, "first-time" means "not funded in the years we can see". An organization funded in 2015 and again in 2024 counts as new.

The state rankings ("Most open to new grantees in …") are stricter still: a foundation is ranked only with at least 20 itemized grants in each of its last three years and at least 20 distinct grantees in the latest, so a small funder with a handful of new names cannot top the list. Its latest itemized year must be within the last 2 years, and its first grants must average at least $1K, so micro-grant programs (where every recipient is "new") are left out. Ties are broken by the larger number of grantees.

First vs. repeat grant size

For each grantee in the latest year we add up everything the foundation paid it that year, then average (and take the median of) those totals separately for first-time and returning grantees. A first-time average well below the repeat average usually means the foundation starts new relationships with smaller "trial" grants.

Repeat rate

The share of the latest year's grantees that the foundation also paid in the immediately preceding year. It is published under the same minimums as the first-time share, applied to that one preceding year. A high repeat rate means most of the budget renews existing grantees.

Giving trend

We compare total grants paid in the latest year with the total three years earlier, using the return's own total-grants line when both years have it and the sum of the itemized list otherwise. Growth of 20% or more is growing, a drop of 20% or more is shrinking, and anything in between is stable. Figures are not adjusted for inflation. One large multi-year pledge paid in a single year can swing the comparison. When a foundation changes its fiscal year-end, two returns end in the same calendar year and we combine them into that year (for example, 18 months of giving). We label that year and skip the trend, and any year-over-year change, when either year being compared is one of them. We do not annualize.

Payout vs. the 5% rule

This applies to private foundations (Form 990-PF filers) only. Private foundations must distribute roughly 5% of the average value of their investment assets each year. The 990-PF states that required minimum as the distributable amount, and reports what the foundation actually spent on charitable purposes as qualifying distributions (grants plus reasonable administrative and direct charitable costs). We show qualifying distributions divided by the distributable amount for the latest year that has both.

• Older e-files often report qualifying distributions as 0. We treat 0 as missing rather than "paid nothing" and fall back to the next most recent year.
• Below 100% in one year is not a violation: a foundation has until the end of the following year to meet the minimum, and can apply excess distributions carried over from the five prior years.
• Ratios above 10× (usually a spend-down year) are shown as "well above" rather than as a number.

Name matching and its limits

990-PF grant lists carry no recipient EIN, so we match grantees across years by name — for Form 990 filers too, so every funder is measured the same way. Before matching we normalize each name: drop a trailing " - 2018 - GENERAL SUPPORT"-style suffix and any "DBA …" alias, lowercase it, turn "&" into "and", remove punctuation, and drop a leading or trailing "The" and trailing corporate words (Inc, Inc., Incorporated, Corp, LLC, Ltd…). Placeholder recipients like "Various" or "See attached" are ignored.

Two spellings of one name also count as a match. That covers a name cut off mid-word on the return ("Illinois State University Foundatio"), words shortened from one year to the next ("Big Brother Big Sis of Central IL"), common abbreviations ("SF" for San Francisco, "Ctr" for Center), and a generic word added or dropped ("Pikes Peak or Bust Rodeo [Foundation]"). An added place does not count: "First Presbyterian Church" and "First Presbyterian Church of Normal" stay separate grantees. When a funder has fewer than 25 grantees in its latest year, its profile says the figure is a small sample.

What this can get wrong:

• Overstating newness. A grantee that changed its name, was spelled differently, or was listed under a parent ("University Foundation" one year, "University" the next) looks new. This is the main source of error, so treat the first-time share as an upper bound.
• Understating newness. Two different organizations with the same normalized name (two "Boys & Girls Club" chapters listed without a city) look like one returning grantee.
• Filing gaps. A foundation that skipped or paper-filed a year has that year missing from its history.

Update cadence

Profile figures are computed from the grant lists whenever a profile page is regenerated, which happens within a few days of a new return being loaded. The state rankings ("Most open to new grantees in …") are recomputed in a batch after each 990 data load, so they can briefly trail the profile pages.

Spotted a figure that looks wrong? Email hello@grantable.co with the funder's name and we will check it against the filing.

The downloadable GrantGraph Open files are a dated snapshot, refreshed after each 990 data load (usually monthly), so a citation of a file points at a fixed version.

Known limitations

• Coverage. E-filed returns only. A foundation that filed on paper, or whose latest return the IRS has not released, shows an older year or is missing.
• As filed. Figures are what the foundation reported. We do not audit returns; a typo on the return is a typo on the profile. Amended returns replace the original when the IRS releases them.
• Itemized grants. "Grants paid" and grant counts come from the itemized grant list. A return that reports a total without listing the grants shows the total, labelled as such, and no count.
• Not inflation-adjusted. Dollar figures and trends are nominal.
• In-kind giving and pass-throughs. Donated goods (for example medicine from corporate patient-assistance foundations) are reported as grants, and a transfer from one related foundation to another is counted by both.
• Home state. A funder's state is the address on its return, often a bank trustee's office, and not where it gives.
• Grantee names. Matching by name across years can overstate or understate newness; see name matching.

Licence and open data

The figures Grantable derives from public IRS filings — names, EINs, locations, filing years, grant totals and counts, assets, payout ratios and the grantee metrics described on this page — are open data under the Creative Commons Attribution 4.0 International licence (CC BY 4.0). That covers the funder profiles' filing figures, the GrantGraph Open CSV downloads and the tables and charts in our reports, such as the State of Foundation Giving 2026. You may copy, share and adapt them for any purpose, including commercially, with credit to Grantable and a link, for example: Source: Grantable GrantGraph Open (https://grantable.co/grantgraph/data), licensed CC BY 4.0.

Not covered: the AI-written summaries on profiles ("Research compiled by Grantable AI"), news items, logos and text quoted from funders' own websites. Those remain the property of their owners. The IRS filings themselves are public records.

How to cite

Every indexed funder profile has a "Cite this profile" box near the bottom with a citation you can copy and a BibTeX entry. The format is:

Grantable. (2026). Example Family Foundation funder profile. GrantGraph. Retrieved October 4, 2026, from https://grantable.co/funders/example-family-foundation-morg_…

To cite the whole dataset or a report, use the citation at the bottom of the GrantGraph Open page or the report. Questions or corrections: hello@grantable.co.