Schedule of Expenditures of Federal Awards (SEFA) Worksheet

This worksheet captures the core data needed for a Schedule of Expenditures of Federal Awards: award program name, Assistance Listing number, pass-through entity and identifier, direct or indirect status, award period, and federal expenditures. It also includes reconciliation fields and a certification section so the final record is ready for review. Use it as the working file before you assemble the formal SEFA for audit or filing support.

It is usually prepared by accounting, grants management, or finance staff who can pull award activity from the general ledger and supporting grant records. A reviewer such as a controller, grant accountant, or finance director should verify the totals and sign the certification. If your organization uses a separate grants administrator, they can populate award details while accounting confirms the expenditure amounts.

Most organizations update it at least monthly during the fiscal year and then finalize it at year-end. Monthly updates make it easier to catch coding errors, missing pass-through identifiers, and awards that cross reporting periods. If your grant volume is low, you can update it quarterly, but do not wait until audit season to reconstruct the full file.

Direct awards are received directly from the federal agency, while indirect awards flow through a pass-through entity such as a state or local government, university, or nonprofit. The template separates these because the pass-through entity name and identifier are often required for indirect awards. Marking this correctly helps avoid incomplete SEFA reporting and reduces follow-up questions during the audit.

Common issues include leaving the Assistance Listing number blank, mixing award periods with the fiscal year being reported, and entering net amounts instead of federal expenditures. Another frequent problem is failing to reconcile the worksheet to the general ledger before certification. This template is designed to surface those gaps early with explicit reconciliation and notes fields.

The worksheet supports Single Audit preparation by organizing award data in a format that is easier to review, reconcile, and certify. It also encourages an audit trail by separating line items, notes, and certification. While it does not replace your accounting records, it helps you document the basis for the SEFA and the controls used to prepare it.

Yes. You can add internal grant codes, fund numbers, department fields, or project IDs if they help you reconcile to the general ledger. Keep the core fields intact so the worksheet still captures the federal award details needed for reporting. If you add extra fields, make sure they are clearly labeled as optional or internal-use only.

This template works well alongside your general ledger, grant management system, and document storage for award agreements and pass-through notices. If your workflow supports it, link the worksheet to source reports or exported transaction detail so reviewers can trace each amount. That makes review faster and strengthens the audit trail without adding unnecessary PII.

Do not use it as a substitute for the official SEFA schedule if your organization already has a finalized reporting format required by your auditor or governing body. It is also not the right tool for non-federal grant tracking unless those funds need to be separated for internal purposes. Use it as a working worksheet for federal award expenditure compilation and reconciliation.