Nonprofit Program Data Collection Template
Three documents and three sheets that design one collection backwards from every funder's indicator definitions, so a single set of fields answers every report.
Free download · No account needed
Every nonprofit data collection template runs forwards. Start at the logic model, list your indicators, build a form per programme, then add another spreadsheet when a new funder arrives. Even the most rigorous version of that, a per-indicator reference sheet, specifies one indicator at a time and never asks what any two of them have in common. So the collection grows with the reporting obligation instead of with the facts sitting underneath it, and fragmentation is the predictable result rather than a failure of discipline.
This pack runs the other way. It takes each executed agreement, quotes the indicator definitions, splits them into the clauses that each have to be true, and names the facts those clauses require. In the worked example six awards ask Cedar Line Community Health for 22 indicators. Those definitions contain 58 separate testable clauses, and the clauses name 18 facts. Eight are already clean, so the whole distance between what six funders were promised and what the organisation can produce is ten fields.
Then every gap gets two properties nothing else computes. How many indicators it blocks, which puts a household key at the top at four, all four on one state contract, derivable from an address already on every intake form. And whether this cohort's value still exists, because two of the ten are gone: nobody records in June why somebody stopped attending in November. The indicators you committed to sit upstream of this and the impact report sits downstream.
What is in the pack
Funder Indicator Crosswalk, run backwards
From each agreement's own wording to the facts that have to exist before the figure is possible, with the clause count on every definition.
Unified Data Structure
The union of those facts, one row each, so a fact three funders need is one field rather than three that will eventually disagree.
The grain rule, applied per field
Each field set to the finest grain any single funder asked for, because aggregation runs one way and the coarse question destroys the fine answer.
Gaps ranked by what they unblock
Not by how hard they look. The largest blocker in the worked example is also the cheapest thing on the list, and nobody guesses that.
A recoverability column no other template has
Already held and needs joining, still obtainable by asking, or gone because the occasion passed. Only the third one changes what you do today.
Data Quality Check as queries
Each check returns rows and runs on its occasion, so intake problems surface at intake rather than in the week the report is due.
How it works
- 1
Send the agreements, not a summary of them
Executed awards with their reporting guidance and any portal template. A paraphrase drifts toward the fact you already collect, which is exactly the fact the gap analysis needs to ignore.
- 2
Decompose every indicator into clauses
Each definition split into the separate things that have to be true, then the facts those clauses name. Do all of them before drawing a field, because the saving is in the union.
- 3
Set the grain and take the union
One field per fact, at the finest grain anybody asked for, with the occasion it is captured on. Funder wordings that map onto an existing field become mappings rather than new fields.
- 4
Rank the gaps, then tier the fixes
By indicators unblocked, then split by what has to be true before the work can start. The figures you have already filed tell you which gaps were being papered over by hand.
Frequently asked questions
How is this different from a logic model?
A logic model decides which indicators should exist at all, working forwards from the programme. This works backwards from agreements already signed and decides what has to be captured, on which occasion, for those indicators to be answerable. Different direction, different artifact, and you want both.
Which gap do we close first?
The one blocking the most indicators, which is rarely the one that feels urgent. In the worked example a household key blocks four indicators, all four on one state contract, and it derives from an address already on every intake form. The gap that feels most pressing blocks two and needs an outside party.
What if a follow-up window has already closed?
Say so, in writing, before the funder finds it. Name the indicator, the reason it is unavailable for this period, and the change that makes the next cohort's version available. An estimate presented as a measured value is worse than the blank it replaces, and it turns a data gap into a finding.
Should we collect detailed race and ethnicity if no funder asks?
Yes, because the aggregation only runs one way. The revised federal standard requires collection beyond the minimum categories as a default, with the detail aggregating up into them, on one combined self-reported question. A form asking five categories can never produce the detail.
Can a spreadsheet do this, or do we need a database?
A spreadsheet is fine, and the pack ships three. What matters is that one fact has one field at one grain with its occasion named. The gift and grant records you already reconcile prove the point: the tool was never the problem, the second field holding the same fact was.
How long do we have to keep the underlying records?
Federal award records must be retained three years from submission of the final financial report, longer while litigation, a claim or an audit finding is open, and that covers the records rather than only the reports. So corrections get recorded as new dated rows, never as edits in place.
Does collecting more detail create a privacy problem?
It creates a duty you already have. A recipient must take reasonable measures to safeguard protected personally identifiable information and anything the agency designates sensitive. That covers the paper forms in the drawer and every per-funder export, which the audit preparation will ask about.
Find out how few facts you actually need
Send the executed agreements and your current intake forms. The first thing back is the clause count, the union of the facts, and which gaps are already gone.
Design my collection