Excel workbook previewGrant Closeout Checklist
3 free downloads per account. Just your email and a 6-digit code.
About this template
A grant closeout checklist guides the last months of a federal award, from the end of the period of performance to the day the agency closes the award. Section 200.344 of the Uniform Guidance, as revised in 2024, gives recipients 120 calendar days to submit all final reports and liquidate obligations, and subrecipients 90 days to report to the pass-through entity. Missed final reports can be recorded against the recipient in SAM.gov.
The checklist has 42 checks in ten groups: timeline, final costs and obligations, cash and drawdowns, indirect costs, final reports, property and supplies, subawards, program income and cost sharing, records and audit, and post-closeout. Each check carries its 2 CFR 200 section. A Closeout Dates sheet calculates every deadline from the end date and the final report date, and a summary shows progress per group.
Who it is for
The grants manager or controller facing the end of a federal award's period of performance who has to close it out cleanly and on time.
What is inside
- 42 closeout checks in 10 groups, each tied to its 2 CFR 200 section
- Status dropdown with green, amber and red colouring and a live completion percentage
- Summary sheet with items and percent done per group
- Closeout Dates sheet that calculates the 90 and 120 day deadlines, the one-year federal closeout target and the three-year retention end from the end date and the final report date
- Days remaining to each deadline by formula, with overdue dates in red
- Covers final financial and performance reports, liquidation, final drawdown and refunds, indirect rates, property, subrecipients, program income and records
- How to use sheet with the source sections
How to use it
Enter the end of the period of performance on the Closeout Dates sheet, then work through the checklist group by group.
Files
- XLSXgrant-closeout-checklist.xlsx14 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
How long do we have to close out a federal grant?
Under 2 CFR 200.344 as revised in 2024, a recipient must submit all financial, performance and other reports no later than 120 calendar days after the end of the period of performance and liquidate all obligations in the same 120 days. Subrecipients have 90 days, or an earlier date agreed with the pass-through entity.
What if our final indirect cost rate is not set at closeout?
Section 200.344(b) says a final financial report must still be submitted, and a revised final report follows when all indirect cost rates are final. Under 200.344(h) the agency may agree with the recipient to close the award using the current or most recently negotiated rate, but the recipient is not required to agree.
Does closeout end our responsibilities on the award?
No. Section 200.345 keeps the agency's right to disallow costs after a later audit, the duty to return funds from refunds or rate adjustments, audit requirements, property management rules and record retention. Records are generally kept for three years from submission of the final financial report.



