Build a SEFA Support Binder

The SEFA is not just another audit schedule. It drives Single Audit planning. If the SEFA is incomplete or poorly supported, the audit starts on weak ground.

2 CFR 200.510 requires the auditee to prepare a Schedule of Expenditures of Federal Awards for the period covered by the financial statements. The schedule includes federal award expenditures. It also includes details that help federal agencies and pass-through entities understand the awards.

A support binder makes the SEFA easier to test. It also helps leadership see where federal award records are thin before audit fieldwork begins.

Step 1: build the award universe

Start with every federal award active during the fiscal year. Include direct federal awards and pass-through awards.

Use more than one source. Pull from the ledger, grant tracker, bank deposits, prior year SEFA, award files, and pass-through notices. A grant can be missed if one list is stale.

For each award, capture the award name, federal agency, pass-through entity, Assistance Listing number, award number, period of performance, and total award amount.

If the award came through another organization, save the pass-through notice. That notice should name the federal source and Assistance Listing when required.

Step 2: define what counts as expenditure

SEFA expenditures are not always the same as cash received. Under 2 CFR 200.502, federal awards expended are measured by the activity that applies to the award type.

For most grant spending, start with expenses charged to the award during the fiscal year. Then review special cases. Loans, donated property, food commodities, insurance, and endowment funds can have different treatment.

If your nonprofit only has standard reimbursement grants, this step may be short. Still document the basis. Auditors need to see how the team decided what belongs on the schedule.

Step 3: reconcile to the ledger

Pull general ledger detail by award for the fiscal year. Tie each award total to the SEFA worksheet.

Explain differences. Common differences include accruals, refunds, cost transfers, indirect cost entries, and corrections posted after the first draft.

Do not let the SEFA become a separate spreadsheet that no longer agrees with the books. The binder should show the path from the financial statements to award-level totals.

If you also prepare SF-425 reports, compare the SEFA totals to report totals. They may differ because periods and bases can differ. If they differ, write a short note.

Step 4: identify subrecipient amounts

If your organization passed federal funds to subrecipients, identify the amount provided to subrecipients for each federal program.

This is often missed because subrecipient payments may look like vendor payments in the accounting system. Review subaward agreements and payment detail.

Keep the subrecipient list in the binder. Include subrecipient name, subaward number, payment total, and the federal program.

If you need a separate process, use the subrecipient risk review workflow to organize monitoring records.

Step 5: attach award and report support

Each award section should include the award agreement, amendments, budget, closeout notices if any, reporting history, and key correspondence.

Add the ledger export and reconciliation. If the award had cost transfers, include the approval and journal entry support.

The goal is not to print every invoice. The goal is to make the audit sample easy to trace once selected.

Step 6: run a completeness review

Before the binder goes to auditors, ask someone outside the first draft to review it.

Use this check:

• Does the award list match the ledger?
• Are pass-through awards marked clearly?
• Are Assistance Listing numbers present?
• Are subrecipient amounts shown?
• Do totals reconcile to the financial statements?
• Are unusual items explained?

Save the review notes. A short review memo can prevent long audit questions.

What to do with uncertain items

Some awards are hard to classify. A contract may include federal funds but arrive through a city or state agency. A payment may look like fee-for-service revenue but still carry federal award terms. A refund may reduce current year spending even though the original cost was in a prior year.

Do not force these items into the SEFA without a note. Create an uncertain items tab in the binder. List the item, amount, source document, question, and decision. Save the award terms or pass-through notice that supports the decision.

This is especially useful when federal funds are passed through several layers. The finance team may see only the payer. Grants staff may hold the notice that names the federal program.

Keep the binder audit ready

Name files so auditors can follow them. Use award name, fiscal year, and support type. A folder called “misc” will slow everyone down.

If the auditor selects a sample, the team should be able to pull the agreement, ledger detail, report history, and payment support without searching email. That is the point of the binder. It turns the SEFA from a year-end spreadsheet into a supported schedule.

How GrantPipe helps

GrantPipe can keep award records, report history, closeout status, and support files connected during the year. That makes the SEFA binder less like a scramble and more like a final pull from records the team already kept.