First page of the Internal Control Monitoring CalendarExcel workbook preview

GAO Green Book

Internal Control Monitoring Calendar

Internal control monitoring plan in Excel: a fiscal-year calendar of ongoing monitoring and separate evaluations with live status, overdue flags and a month view.

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

An internal control monitoring calendar plans when management checks that its controls are present and working: the ongoing monitoring built into daily work, the separate evaluations done at set times, the review of service organizations and the follow-up of audit findings. Audit committees and auditors ask for it to see that monitoring is planned, done on time and documented, and that problems found lead to corrective action.

The workbook schedules monitoring activities across a fiscal year and calculates their status live against today's date. A Year View sheet counts planned, completed and overdue activities for each of twelve months from the start date you enter, and breaks the plan down by component and activity type. It is built on principles 16 and 17 of the 2025 GAO Green Book, the free federal internal control standard, including the requirement to document monitoring results.

Who it is for

The controller or compliance officer who was asked by the audit committee or the auditor for the plan that shows when internal control is monitored and whether the results were documented.

What is inside

  • Monitoring calendar with 12 worked activities for the invented Riverbend Youth Trust and 20 blank rows
  • Dropdowns for activity type, Green Book component, frequency, result and results documented
  • Live status per activity (Done, Overdue, Due soon, Scheduled) and days to the planned date
  • Overdue planned dates highlighted in red, status cells color coded
  • Year View sheet: 12 fiscal months from a fiscal year start you enter, with planned, completed and overdue counts
  • Completion and results-documented percentages, plus breakdowns by component and by activity type
  • Built on Green Book principles 16 and 17, with a How to use sheet

How to use it

Enter your fiscal year start on the Year View sheet, then replace the Riverbend Youth Trust activities with your own.

Files

  • XLSXinternal-control-monitoring-calendar.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

What is the difference between ongoing monitoring and separate evaluations?

Ongoing monitoring is built into normal operations and runs continually, such as supervisory reviews, reconciliations and data analytics. Separate evaluations are done at a point in time, such as a self-assessment, an internal review or an external audit, and their scope and frequency depend on risk. The 2025 Green Book describes both in paragraphs 16.04 to 16.06.

Do monitoring results have to be documented?

Under the 2025 Green Book, yes. Paragraph 16.09 is a minimum documentation requirement: management evaluates and documents the results of ongoing monitoring and separate evaluations to identify internal control issues. The calendar has a results-documented column and the Year View sheet shows the share of completed activities whose results were documented.

How often should internal control be monitored?

The Green Book does not set a fixed frequency. Ongoing monitoring runs continually, and the scope and frequency of separate evaluations depend on the assessed risks, the results of ongoing monitoring, new risks or deficiencies and the rate of change in the organization. It may be increased when a program is new or substantially changed (paragraph 16.06).