First page of the Single Audit Preparation Checklist (2 CFR 200 Subpart F)Excel workbook preview

GAO Yellow Book and Single Audit

Single Audit Preparation Checklist (2 CFR 200 Subpart F)

Single audit checklist in Excel: 52 preparation steps tied to 2 CFR 200 Subpart F, GAGAS and the FAC, plus a due date calculator for the reporting package.

Excel workbook · 15 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A single audit is required when a nonprofit, state, local government, Indian Tribe or college expends USD 1,000,000 or more in Federal awards in a fiscal year that began on or after October 1, 2024. The organisation prepares the financial statements, the schedule of expenditures, the summary schedule of prior audit findings and the corrective action plan, and it files the reporting package with the Federal Audit Clearinghouse. This checklist is for the finance lead who has to have all of that ready on time.

The workbook lists 52 checkable steps in eight groups, from the threshold test and auditor procurement to the FAC certification order and record retention. Every step cites its open source: 2 CFR 200 Subpart F on ecfr.gov, the GAO Government Auditing Standards 2024 revision, or the FAC submission guide on fac.gov. A Key dates sheet computes the filing deadline from the fiscal year end and the date the auditor's report is received, and rolls a weekend or listed holiday to the next business day.

Who it is for

The finance director of a nonprofit or local government whose Federal spending crossed the single audit threshold and who must get ready before the auditor arrives.

What is inside

  • 52 checklist items in 8 groups, each tied to a 2 CFR 200 section, a GAGAS paragraph or an FAC guide step
  • Status dropdown with colour coding and a live completion percentage
  • Summary sheet with done versus total per group, built on COUNTIFS
  • Key dates sheet: threshold test, FAC due date with weekend roll and holiday list, retention and management decision dates
  • Threshold switch between USD 750,000 and USD 1,000,000 based on the fiscal year start date
  • Worked example for a calendar 2026 fiscal year with a due date that falls on a Sunday
  • Evidence and owner columns, freeze panes, filters and print fit

How to use it

Enter your fiscal year dates on the Key dates sheet, then work down the checklist and record evidence for each item.

Files

  • XLSXsingle-audit-preparation-checklist.xlsx15 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

When is a single audit required?

Under 2 CFR 200.501, a non-Federal entity that expends USD 1,000,000 or more in Federal awards during its fiscal year must have a single audit or, if it qualifies, a program-specific audit. The FAC applies the USD 1,000,000 threshold to fiscal years beginning on or after October 1, 2024 and USD 750,000 to earlier years. The workbook switches the threshold on the fiscal year start date.

When is the single audit due?

2 CFR 200.512(a) sets the deadline at 30 calendar days after the auditee receives the auditor's report or nine months after the end of the audit period, whichever is earlier. When the due date falls on a Saturday, Sunday or Federal holiday, the package is due the next business day. The Key dates sheet computes both dates and applies the roll.

What goes into the reporting package?

Section 200.512(c) lists four parts: the financial statements and the schedule of expenditures of Federal awards, the summary schedule of prior audit findings, the auditor's reports, and the corrective action plan. The FAC also asks for the SF-SAC workbooks and a single merged, text searchable PDF without personally identifiable information.