First page of the Internal Control Deficiency LogExcel workbook preview

GAO Green Book

Internal Control Deficiency Log

Internal control deficiency log in Excel: type, magnitude, likelihood and nature, live significance score, corrective action, overdue flags and summaries.

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 deficiency log is the single record of every control issue an organization has found, from the day it is identified to the day the corrective action is proven. Auditors and audit committees ask for it to see whether findings are evaluated consistently and closed on time, and whether the same principle keeps failing. Grantors and oversight bodies use it to follow up on audit findings.

The log follows principle 17 of the 2025 GAO Green Book (GAO-25-107721). It records the deficiency type (design, implementation or operation), rates the three significance factors the Green Book names, and captures the corrective action documentation it lists: root cause, planned actions, milestones, completion dates, an indicator of progress and the responsible official. Formula sheets summarize it by component, type and principle.

Who it is for

The controller or internal auditor who must show the auditor or audit committee every open control deficiency, its significance and the status of its corrective action.

What is inside

  • 23 columns covering detection, evaluation, corrective action and closure
  • 11 worked sample rows for an invented town plus 20 blank formatted rows
  • Score and significance formulas from magnitude, likelihood and nature, with possible fraud always High
  • Days open, overdue flag and a report-to rule calculated for every row
  • Dropdowns for source, component, type, ratings and status, with principle limited to 1 to 17
  • Summary sheet with 10 measures plus counts by component and by deficiency type
  • By Principle sheet with open and open High counts for all 17 Green Book principles
  • Red highlighting for overdue target dates and High significance

How to use it

Clear the eleven Town of Maple Fork rows, then log your open audit findings and monitoring issues first.

Files

  • XLSXinternal-control-deficiency-log.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 the difference between a design and an operating deficiency?

A design deficiency exists when a needed control is missing, or when an existing control would not meet its objective even if it operated as designed. An operating deficiency exists when a properly designed control does not operate as designed, or the person performing it lacks the authority or competence. The Green Book also names implementation deficiencies.

How do you decide how significant a control deficiency is?

The Green Book asks management to consider the magnitude of impact, the likelihood of occurrence and the nature of the deficiency, including whether it arises from possible fraud or misconduct. The log turns the first two into a score and treats possible fraud as High. The bands are a house rule you can change.

When can an audit finding be closed?

Under the Green Book the remediation process is complete only after action that corrects the deficiency, produces an improvement, or demonstrates that the finding does not warrant management action. The log has a status for each of these outcomes and keeps a date closed so days open stop counting.