In short: Compliance and regulatory reports — IRS Form 990 schedules, state charity filings, and board reports — should come from one audited source, so each figure is traceable rather than re-assembled by hand every cycle. Pick one record of truth for every grant number, keep the evidence behind it, and generate each required format as a view of that same data. Do that once and the board packet, the IRS schedule, and the state filing all reconcile because they were never separate numbers to begin with.
Most grantmakers feel this at filing time. You pull the same grant totals into a board deck in the spring, into the Form 990 in the fall, and into the state charity registration on whatever cadence your state sets. Each pull uses a different template, and when someone asks "where did this figure come from," the honest answer is a spreadsheet that has since changed. The numbers usually agree, but you cannot prove it quickly, and re-keying them each cycle is where errors slip in.
Start by writing down the full set. For most grantmaking organizations that includes the IRS Form 990 and its relevant schedules (commonly Schedule I for grants paid, and Schedule H if you are a hospital organization), any state charitable registration and financial filing, and the internal board or committee reports your governance calendar requires. For each one, note the recipient, the cadence, and the figures it demands. This list is the spine of everything that follows — you cannot build one source until you know every report drawing from it.
Now line up the figures. Schedule I wants grants and other assistance paid to organizations and individuals; your board report wants totals by program; your state filing wants revenue and expense summaries. Many of these are the same underlying number shown three ways. Map each required field back to a single source of record instead of a per-report spreadsheet. Sopact keeps that source as the Grantee Thread — one grantee record held under a persistent Contact ID — so a board report, an IRS schedule, and a state filing become output views of the same traced data rather than three hand-built documents.
Traceability is the point of this whole exercise. Every figure in a compliance report should link back to the grantee record it came from: the award amount to the signed agreement, the amount paid to the disbursement, the outcome to the grantee's own submission. When each number carries its source, an auditor's question takes seconds instead of a scramble through old files. Because Sopact cites each figure back to the grantee record under its Contact ID, "prove where this came from" stops being a fire drill and becomes a click.
With one audited source and evidence attached, each report is a format applied to that data, not a fresh build. The Form 990 Schedule I layout, the board summary, and the state financial report all read from the same grantee records. Change a grant's status once and every downstream report reflects it. This is the difference between maintaining one source and maintaining a stack of documents that quietly drift apart.
Finally, file on each recipient's schedule. Board reports follow your governance calendar; the Form 990 follows the IRS filing deadline for your fiscal year; state filings follow rules that vary by state, so confirm each jurisdiction's registration and financial-reporting requirements rather than assuming one deadline covers all. Review each report against its source before it goes out. When the source is audited and traceable, review is a check, not a reconstruction.
Use these prompts against your own grant data to move through the steps. Swap the bracketed placeholders for your fiscal year, programs, and report types.
List every compliance and regulatory report [MY ORGANIZATION] owes for fiscal year [YEAR]. For each one, give the recipient (IRS, [STATE] Attorney General, board), the required figures, and the filing cadence. Flag any figure that currently lives only in a spreadsheet.
For each figure required on IRS Form 990 Schedule I for [YEAR], map it to a single source in my grantee records: grantee name, award amount, amount paid, and purpose. Show the grantee record each figure traces back to, and flag any figure with no linked source.
Generate a [BOARD REPORT / STATE FINANCIAL FILING] for [PROGRAM or PORTFOLIO], [YEAR], using only the audited grantee records. For every total, cite the grantee records it was built from so I can verify each number before filing.
GRADE: green | Every figure traces to a grantee record | you can click any number and see its source; amber | numbers match but the source is not linked | you trust the total but cannot show where it came from; red | reports re-keyed by hand each cycle | the board number and the IRS number no longer reconcile.
Build the source once, not the report. The pull that hurts is rebuilding the same numbers in a new template each cycle. If you invest in one audited grantee record instead, every report after the first is close to free. Sopact holds that record as the Grantee Thread so each new filing reads from it rather than restarting.
Attach evidence at the moment of the transaction. Do not wait until filing season to hunt for the agreement or the disbursement record. Link the document to the grantee record when the grant is awarded and paid, so the audit trail is already complete when the report is due.
Confirm state rules per jurisdiction. State Attorney General and charity-regulator requirements vary by state, and multi-state grantmakers owe more than one filing. Do not assume a single registration or deadline covers everything — check each state where you operate or solicit.
Reconcile the board number and the IRS number before either ships. If your board report and your Form 990 draw from the same source, they reconcile automatically. If they do not, treat any gap as a signal that two versions of the truth exist, and fix the source rather than patching the report.
Schedule I of the IRS Form 990 reports grants and other assistance that an organization paid to organizations, governments, and individuals in the United States during the tax year. For grantmakers it is usually the schedule where your outgoing grants are itemized, which is why the amounts on it should trace directly to your grantee records rather than a separate list.
Schedule H is the Form 990 schedule for hospital organizations, used to report community benefit and related activities. If your organization is not a hospital, it likely does not apply, but health-system grantmakers often owe both Schedule H and grant-related reporting in the same cycle, which is a strong reason to keep one audited source behind all of them.
Most states require charities to complete an annual charitable registration and file financial information, but the specific forms, thresholds, and deadlines vary by state. A grantmaker operating or soliciting in several states typically owes several filings on different cadences, so confirm each state's rules directly rather than generalizing from one.
A board report is an internal document your governance calendar requires, framed to help trustees make decisions — usually totals by program and progress against strategy. A regulatory report, such as the Form 990 or a state filing, is an external submission in a prescribed format for a regulator. The figures often overlap, so both should read from the same audited source; only the framing and layout differ.
Sopact keeps one audited source — the Grantee Thread, one grantee record under a persistent Contact ID — and treats every compliance report as a view of that data. Because each figure is cited back to the grantee record it came from, a board report, an IRS schedule, and a state filing reconcile with one another and each number can be traced on demand. See grant compliance, foundation board reporting, and grant management software for how the source is built, and how to read a 990 for compliance and dashboards and SROI compliance reports for the reporting side. For funder-facing outcome reporting, see impact reporting software.
ChatGPT, Claude, and Gemini are fine for a quick test — but not for an answer you'll put in front of a funder or board. When it has to hold up, run it in Sopact Sense.
Try it in Grant Intelligence →
