Excel workbook previewGAO Yellow Book and Single Audit
Schedule of Expenditures of Federal Awards (SEFA) Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
The schedule of expenditures of Federal awards (SEFA) is the auditee's list of every Federal program it spent money on in the year. 2 CFR 200.510(b) makes the auditee responsible for preparing it, and the auditor reports on whether it is fairly stated in relation to the financial statements. Pass-through entities and Federal agencies read it to see which awards were covered. This template is for the person who prepares it.
The listing carries every element that 2 CFR 200.510(b)(1) to (6) asks for: programs by Federal agency with Assistance Listing numbers, cluster names and totals, pass-through entity names and identifying numbers, amounts passed to subrecipients, loan balances and the de minimis rate election in the notes. Formulas compute program totals and preview the Type A threshold from the table in 2 CFR 200.518(b)(1). Program titles were checked against the Federal Program Inventory at fpi.omb.gov.
Who it is for
The controller or grants accountant who must hand the auditor a complete schedule of expenditures of Federal awards for the single audit.
What is inside
- Award listing with 15 columns: agency, cluster, Assistance Listing number, pass-through entity and number, award ID, R&D flag, expenditures and subrecipient amounts
- 10 worked rows for an invented youth nonprofit (USD 1,747,200 total) plus 20 formatted blank rows
- Live formulas for program key, program total, Type A or Type B label and a completeness check on every row
- Totals sheet by Federal agency and by cluster with a grand total and subrecipient total
- Thresholds sheet: single audit test and the Type A threshold from the 2 CFR 200.518 table, all formulas
- Notes sheet with six draft notes, including the de minimis indirect cost rate election and non-cash assistance
- Reconciliation sheet from Federal revenue in the financial statements to the schedule total
How to use it
Replace the worked rows on the Award listing sheet with your own awards, one row per award, then read the Thresholds and Totals sheets.
Files
- XLSXschedule-of-expenditures-of-federal-awards-template.xlsx18 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What columns does a SEFA need?
2 CFR 200.510(b) requires programs listed by Federal agency with the Assistance Listing number, the cluster name and cluster total for clustered programs, the pass-through entity name and identifying number for subawards received, the total expended for each program, and the amount provided to subrecipients. Loan balances and significant accounting policies go in the notes.
Does the SEFA show expenditures or receipts?
Expenditures. Section 200.502 bases Federal awards expended on when the activity related to the award occurs, such as expense transactions, disbursements to subrecipients, use of loan proceeds, receipt of property or use of food commodities. Non-cash assistance received as part of an award is valued at fair market value or the agency's assessed value and included.
Who decides which programs are major programs?
The auditor does, using the risk-based approach in 2 CFR 200.518. The Thresholds sheet only previews the Type A threshold from the regulation's table so the finance team can see which programs are likely to be tested. The auditor's determination and documentation prevail.




