First page of the Internal Control Self-Assessment QuestionnaireExcel workbook preview

GAO Green Book

Internal Control Self-Assessment Questionnaire

Internal control self assessment questionnaire in Excel: 51 questions on the 17 Green Book principles, scored live with principle and component ratings.

Excel workbook · 19 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

An internal control self-assessment questionnaire lets managers rate their own internal control against a recognized framework before an auditor, grantor or board does it for them. It turns a long standard into specific questions that a finance director, a department head or a program manager can answer with evidence, and it shows where the gaps are and who will fix them by when.

This workbook asks 51 questions, three for each of the 17 principles in the 2025 revision of the GAO Green Book, the free federal internal control standard, and cites the GAO paragraph behind each one. Answers score automatically. A Summary sheet rates every principle against thresholds you can change, then rates each component using the Green Book rule that a component cannot be effective when one of its principles is not. A worked example for an invented town shows the scoring at work.

Who it is for

The finance director or grants manager who was asked by the board, the auditor or a grantor to show how the organization assessed its own internal control this year.

What is inside

  • 51 questions, 3 for each of the 17 principles of the 2025 GAO Green Book, each with its paragraph reference
  • Answer dropdown (Yes, Partly, No, N/A) with color coding and a live score per question
  • Worked example answers, evidence notes and actions for the invented Town of Maple Fork
  • Action owner, target date and status per question, with overdue target dates highlighted in red
  • Summary sheet: score, No count and rating for each of the 17 principles
  • Component ratings that follow the Green Book rule that one ineffective principle makes its component ineffective
  • Adjustable rating thresholds in yellow input cells, plus open and overdue action counts
  • 16 blank formatted rows for your own questions and a How to use sheet

How to use it

Clear the Town of Maple Fork answers in column E, then answer each question with the person who owns that area.

Files

  • XLSXinternal-control-self-assessment-questionnaire.xlsx19 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 is an internal control self assessment?

It is a review in which the people who run a process or an organization evaluate their own controls against a set of criteria, record evidence for each answer and plan corrective actions. The 2025 Green Book lists self-assessments as one form of separate evaluation that management can use to monitor the internal control system (paragraph 16.06).

How are the principle and component ratings calculated?

Each Yes scores 2, Partly 1 and No 0, and N/A is left out. A principle's score is its points divided by the points available, compared with the two thresholds on the Summary sheet. A component is rated Not effective as soon as one of its principles is, which follows the Green Book rule in paragraph OV3.10.

Does a high score mean our internal control is effective?

No. The score is a screening aid that shows where to look. The Green Book asks management to judge each principle on design, implementation and operating effectiveness, consider deficiencies individually and together, and decide whether the five components work together. The questionnaire supports that judgment with evidence and actions but does not replace it.