Schedule of Expenditures of Federal Awards (SEFA) Worksheet

This worksheet is used to compile the information needed to prepare a Schedule of Expenditures of Federal Awards for Single Audit reporting. It brings together the federal program name, Assistance Listing number, award identifiers, pass-through details, and expenditure amounts in one place. It is especially useful when awards are spread across departments or source systems. The worksheet also creates a review trail so reconciliation questions can be resolved before audit fieldwork.

It is usually prepared by grants accounting, finance, or a compliance lead who can access both award records and expenditure support. Program managers may supply award details, but the preparer should verify amounts against the general ledger and source documents. A reviewer with audit or controller oversight should confirm the final entries. If your organization uses multiple grant owners, assign one owner for consolidation to avoid duplicate or missed awards.

Most organizations update it throughout the fiscal year and then finalize it at year-end for audit preparation. If you manage many awards, monthly or quarterly updates help catch coding errors, unspent balances, and missing pass-through identifiers early. The worksheet can also be refreshed after major drawdowns, closeout activity, or award amendments. Waiting until the audit deadline usually creates reconciliation gaps and weak source-document references.

Use ledger reports, grant subledgers, reimbursement requests, drawdown records, award notices, and any pass-through correspondence that identifies the award. The source document reference field should point to the exact report or file used for each line. Keep the support consistent with the expenditure basis you selected so the numbers can be traced without guesswork. If a line is based on estimates or timing differences, note that in reconciliation notes.

Yes, it is designed to support SEFA preparation for Single Audit workpapers. It helps you identify federal awards, classify expenditures, and document variances before the auditor reviews the schedule. It does not replace your accounting records or the final SEFA, but it gives you a structured working file. The audit trail and review notes fields are useful for showing how amounts were derived and approved.

Enter the pass-through entity name, the pass-through identifier, and any contact details that help confirm the award source. This is important when the funding did not come directly from a federal agency and the award needs to be traced through another entity. If the pass-through information is missing, use the review notes to flag it for follow-up rather than leaving the line incomplete. Conditional logic can be used to show these fields only when the award type is pass-through.

Common mistakes include using the wrong Assistance Listing number, mixing up cash received with expenditures, and leaving the expenditure basis unclear. Another frequent issue is failing to reconcile the worksheet to the general ledger or not documenting why a variance exists. Some teams also omit source document references, which makes review and audit support harder. Mark required fields clearly and keep optional notes separate from the core data fields.

Yes, it can be adapted to include grant IDs, cost centers, fund codes, project numbers, or ERP export references. If your organization tracks awards in multiple systems, add a field for system source or report name so the worksheet stays traceable. Keep the form focused on the minimum necessary data needed for SEFA preparation and review. Avoid adding fields that do not affect classification, reconciliation, or audit support.

An ad hoc spreadsheet often lacks consistent field labels, validation, and review notes, which makes year-end reconciliation slower. This worksheet gives you a repeatable structure for each award line, including identification, amounts, and audit trail details. It also makes it easier to assign ownership and spot missing information before finalizing the SEFA. The result is less back-and-forth during audit preparation and a clearer path from source documents to the final schedule.