First page of the GAO Green Book Internal Control Assessment Template (17 Principles)Excel workbook preview

GAO Green Book

GAO Green Book Internal Control Assessment Template (17 Principles)

Green Book internal control assessment in Excel: all 17 principles by component, 51 attributes, live principle and component conclusions, documentation check.

Excel workbook · 22 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 Green Book internal control assessment records whether each of the five components and 17 principles of the GAO Standards for Internal Control in the Federal Government is designed, implemented and operating effectively. Federal agencies use it to support their annual internal control statement. State and local governments, nonprofits and other recipients of federal awards use it to show the auditor or a grantor that the controls the Uniform Guidance expects are in place and evaluated.

The workbook follows the 2025 revision of the Green Book (GAO-25-107721), which replaced the 2014 edition from fiscal year 2026. The main sheet holds the 17 principles with their requirement wording, three ratings each and a formula that gives the summary determination. Separate sheets rate the 51 attributes, the eight minimum documentation requirements, and the conclusion for each component and for the system as a whole.

Who it is for

The finance director or internal auditor of a government, nonprofit or grantee who must show the auditor or oversight body a documented internal control assessment.

What is inside

  • 17 principles grouped by the 5 components, with the requirement wording from GAO-25-107721 appendix I
  • Design, implementation and operation rated per principle, with a summary determination formula
  • Consistency check that flags ratings the Green Book does not allow
  • 51 attributes rated on their own sheet, rolled up as a percentage per principle
  • 8 minimum documentation requirements with paragraph references and a coverage percentage
  • Component Summary that concludes per component and for the whole system
  • Worked example for an invented town with 3 principles not effective, plus a 365-day next review date

How to use it

Start on Principle Assessment and replace the Town of Maple Fork ratings with your own for each of the 17 principles.

Files

  • XLSXgao-green-book-internal-control-assessment-template.xlsx22 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

What are the 17 principles of the GAO Green Book?

They are the requirements that support the five components. Principles 1 to 5 cover the control environment, 6 to 9 risk assessment, 10 to 12 control activities, 13 to 15 information and communication, and 16 and 17 monitoring. The 2025 revision renamed principle 8 to cover fraud, improper payments and information security, and principle 11 to cover general controls over information technology.

Which Green Book edition applies now?

GAO issued the 2025 revision, GAO-25-107721, in May 2025. It supersedes the September 2014 edition and is effective beginning with fiscal year 2026, with early implementation permitted. Check gao.gov for any later update before you rely on a version for a specific reporting period.

When is an internal control system effective under the Green Book?

Only when each of the five components is effectively designed, implemented and operating, and the components operate together in an integrated manner. A component cannot be effective if one of its principles is not. The workbook applies that rule with formulas, but the ratings themselves remain management's judgment.