| Cycle | Quarter | Planned hours | Actual hours | Status | Exceptions | High findings | Owner | |
|---|---|---|---|---|---|---|---|---|
| Ref | Cycle | Rating | Owner | Ageing days | Action due | Revised due | Due status | |
|---|---|---|---|---|---|---|---|---|
Build the source file first: annual plan, RCM, monitoring rules and observation report.
An internal audit dashboard should show whether the approved plan is moving, which reviews have produced high-risk observations, whether management actions are overdue and which continuous monitoring exceptions still need reviewer conclusion.
The dashboard should not replace workpapers. It is a reporting layer over the annual plan, RCM, source population, evidence, observation register and ATR. A red tile without source data and reviewer conclusion creates heat, not assurance.
This generator creates an audit committee pack with cycle status, hours, exception counts, rating mix and observation ageing. The Excel version keeps those tabs editable so the internal audit team can support meeting papers without rebuilding the file each month.
R2R and P2P have been reported, ITGC is still in progress, and two high-risk observations need management visibility. The committee needs progress, overdue actions and what will be monitored next month.