Federal Audit Clearinghouse filing
The federal awards section, the major-program test, and the fac.gov submission checklist, from the same ledger your schedule already reconciled.
Every award in the exact column order the federal awards workbook expects: agency prefix and Assistance Listing Number extension, cluster, loan flag, pass-through identity, and the major-program call, built from the same ledger and register your schedule already uses.
The current Type A threshold applied to your own total federal expenditures, and the percentage-of-coverage rule checked against it, so you know before you file whether the auditor has to add another program to the major list.
The filing deadline computed from your fiscal year end and your auditor's report date, with days remaining, plus the nine-step submission checklist in fac.gov's own order.
- 01
Get your ledger
Your accounting system's export.
- 02
Match your columns
Which column is which.
- 03
Name what's in your file
What each code in your ledger really is.
- 04
Fix what's flagged
What your auditor asks first.
The Data Collection Form is due to the Federal Audit Clearinghouse no later than the earlier of 30 calendar days after the organization receives the auditor's report, or nine months after the end of the audit period. The organization's own certifying official, not the outside audit firm, has to submit it.
A federal program is a preliminary Type A program once its own expenditures exceed a sliding-scale dollar threshold set by total federal expenditures, $1,000,000 for organizations at or under $34 million. The final major-program list, including any additional program selected to meet the coverage requirement, belongs to the auditor.
Major programs, in the aggregate, have to cover at least 40 percent of total federal expenditures, or 20 percent for an auditee that meets the low-risk criteria in 2 CFR 200.520.
Riverbend Community Partners expended $1,817,160 across 6 federal programs for the fiscal year ending December 31, 2025. $53,510 across 3 transactions is not yet coded to an award, so the federal awards section does not reconcile to the ledger. No program individually reaches the $1,000,000 Type A threshold, so the auditor has to select a Type B program as major to reach the 40% coverage 2 CFR 200.518(f) requires. The Data Collection Form is due September 24, 2026.
| Prefix | Extension | Program name | Amount expended | Major program |
|---|---|---|---|---|
| 93 | 600 | Head Start | $734,800 | No |
| 14 | 267 | Continuum of Care Program | $443,900 | No |
| 16 | 575 | Crime Victim Assistance | $214,200 | No |
| 10 | 558 | Child and Adult Care Food Program | $169,050 | No |
| 14 | 231 | Emergency Solutions Grant | $127,200 | No |
| Assistance to Firefighters Grant | $74,500 | No | ||
| Total | $1,763,650 |
Re-keyed by hand into fac.gov's workbook from the finished schedule, one row at a time, under a hard deadline.
Built automatically in fac.gov's own column order from the same ledger and register your schedule already uses.
Worked out separately, often after the schedule is already final.
Computed automatically against the current Type A threshold and the coverage rule. Riverbend's demo shows zero programs reaching the threshold, so the auditor has to add one to meet coverage.
Found only when fac.gov's own validation rejects the submission.
Flagged before you file. Riverbend's demo flags one award missing its Assistance Listing Number and one pass-through award missing its identifying number.
Tracked on a spreadsheet or not at all, until 30 days after the auditor's report is suddenly close.
Computed from your fiscal year end and your auditor's report date, with days remaining shown every time you open it.
The organization's own certifying official, usually the CFO or controller, not the outside CPA firm that performed the audit. 2 CFR 200.512 names the submitter directly.
No. This engine reads the same ledger and award register your schedule already uses and builds the separate federal awards section fac.gov's workbook requires, plus the major-program test, the deadline, and the submission checklist.
Leap computes the nine-months-after-fiscal-year-end deadline as soon as your fiscal year end is on file, and adds the 30-day-after-report deadline once your auditor's report date is entered, using whichever bound is earlier.