Independent thinking. Informed defence.

CISO Times

Intelligence for the people behind the defence.

The CISO Decision Brief

Control Assurance Dashboard

Reports tested coverage, pass rates, open deficiencies and assurance readiness per framework.

Available soon

Format
Excel
Size
111 KB
Length
13 sheets
Version
1.2
Updated

What's inside

What changed

  1. 1.2

    The restore-testing note names P23's Restore Testing Methodology.

  2. 1.1

    The restore-testing note names P22's RR-14.

  3. 1.0

    Published.

Changes across this pack

Preview

The workbook's sheets as you will receive them, with its example rows and the values its formulas calculate. Highlighted [[text]] is for you to replace; rows marked EXAMPLE are for you to delete. Wide sheets scroll sideways. The cover, document control and changelog sheets are in the file.

Instructions

How to use this workbook

StepWhat to do
1What this dashboard is. The quarterly report of the control testing programme, kept by the control assurance lead and read by the assurance sponsor. It holds a copy of the key fields of the Control Inventory & Ownership Register, the workpapers (Control Test Workpaper Template), the Control Deficiency & Remediation Tracker and the Annual Control Testing Plan, and works out every measure from them.
2On the Summary sheet, enter the As-at date (the quarter's last day) and the date the plan year starts. Type both; never a formula that changes them. Every overdue flag and every measure is worked out at the As-at date.
3On the Controls sheet, copy each control from the Control Inventory & Ownership Register: its ID, name, source rule and document, owner, whether it is key, and its risk rating as at the As-at date. The test cycle, last result, next test due, overdue flag and next planned test calculate.
4On the Tests sheet, add one row per workpaper: the control, its risk rating when tested, the dates, the design conclusion, the population, the exceptions, the tester and the reviewer, and the date the reviewer signed. The sample size (CA-05) and the conclusion (CA-07) calculate. If either differs from the workpaper, find out why before you report.
5On the Deficiencies sheet, copy each deficiency from the Control Deficiency & Remediation Tracker. Severity (CA-12), the date the plan must be agreed by and the due date (CA-13) calculate from the date the reviewer confirmed it. Below it, list each exception recorded on a test concluded Effective.
6On the Plan Progress sheet, copy each test the Annual Control Testing Plan sets, with its month. When the workpaper is signed, enter the date. The sheet shows what is due by the As-at date and what was final in time: signed by the reviewer within the review days after the end of its month (CA-11).
7Read the By NIS2 Point sheet. It counts, for each point of NIS2 Article 21(2), the controls whose source document cites that point, and how many of them are tested and effective. It does not say any point is met. Fill its second block from the Unified Control Framework Mapping Workbook if you report by the requirements you rely on your controls for.
8On the Summary sheet, read the six headline measures and write the commentary: what changed since last quarter and what you ask the sponsor to decide. Keep each quarter's copy of the workbook, with the workpapers it reports, as the record.
9To start your own dashboard, delete the contents of the first column and of every yellow cell on the Controls, Tests, Deficiencies and Plan Progress sheets, and the exceptions noted. The formulas stay.

Legend

Yellow cells are inputs. Everything else is calculated or fixed — do not overwrite formulas.

EXAMPLERows marked EXAMPLE in the first column show how a completed row looks. Delete them before approval.

Limitations: This document helps you test whether your security controls work. It is not legal advice, and a test result is not a statement that you comply with NIS2, DORA, the GDPR or any standard. Where a law, a certification or a contract asks for an audit or an independent review, confirm with counsel, your certification body or the other party what it must include.

What this dashboard is not (CA-18, CA-19) is set out at the foot of the Summary sheet. It does not say which control meets which requirement: that is your own record in the Unified Control Framework Mapping Workbook (CA-17).

EXAMPLE: a wholesale distributor with about 900 staff, three warehouses and an online ordering service that takes 60% of its orders, an important entity under NIS2 in its Member State. Its Quality and Compliance Manager, who owns and performs no control, leads the programme from 1 Sep 2026. The pilot round TR-2026-P, 21 Sep 2026 to 25 Sep 2026, tested seven controls over 1 Mar 2026 to 31 Aug 2026; the Internal Audit Manager reviewed the workpapers on 28 Sep 2026. The Chief Operating Officer approved the first annual plan on 30 Sep 2026. The dashboard is as at 30 Sep 2026.

Tailoring — small organisation: the six measures are the minimum. Where one person leads and tests, a colleague from another function or internal audit reviews their workpapers (CA-10, CA-11).

Tailoring — financial entity under DORA: test results can feed the yearly review of the ICT risk management framework and the internal audit. The dashboard is neither of them.

This workbook is your own record. Keep it with the workpapers it reports.

Summary

Control assurance: quarterly dashboard

For the assurance sponsor, each quarter. Yellow cells are yours; everything else calculates from the Controls, Tests, Deficiencies and Plan Progress sheets. Every figure is a count, and every status is in words; the colour only repeats it.

Report settings

SettingValueNote
As-at date (the quarter's last day)30 Sep 2026Every flag and measure is worked out at this date.
Plan year starts1 Oct 2026The first day of the Annual Control Testing Plan's year.
Quarter reportedQ3 2026Your words.
Plan approved by the sponsor on30 Sep 2026Before the plan year starts (CA-16).

Headline measures (CA-19: counts, never a share)

MeasureResult at the As-at dateTargetNamedWhat it meansThe decision it supportsLead's commentary
CAM-01 Controls tested within their cycle5 of 30All, by the end of each control's first cycleSee the Controls sheetHow many controls have a test recent enough to rely on. A control outside its cycle may still work: there is simply no current evidence that it does.Whether testing keeps pace with the plan, and which controls to test next.[[What changed since last quarter, and what you ask the sponsor to decide]]
CAM-02 Tested controls effective4 of 5All1 not effective: see CAM-04Of the controls tested within their cycle, how many worked throughout their testing period. An exception recorded on an Effective test is named on the Deficiencies sheet.Which failed controls need a fix and a retest, and which results an audit or a customer review can be shown.[[What changed since last quarter, and what you ask the sponsor to decide]]
CAM-03 Key controls never tested19 of 24None after the first plan yearCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25, CT-27, CT-28, CT-29, CT-30Key controls with no operating test concluded. Until each is tested, nobody knows whether it works.Whether the plan reaches them in time, and whether to bring a test forward where an audit or review relies on the control (CA-16).[[What changed since last quarter, and what you ask the sponsor to decide]]
CAM-04 Open deficiencies by severityHigh 2, Medium 0, Low 0No High open past its due dateDF-01 (CT-13, High); DF-02 (CT-02, High)Deficiencies not yet closed by a passed retest. High means a key control failed with no compensating control tested effective, or a risk outside appetite is left without its control.Whether each open deficiency has an owner, an agreed plan and the resources to meet its due date.[[What changed since last quarter, and what you ask the sponsor to decide]]
CAM-05 Deficiencies past their due dateNoneNoneNoneOpen deficiencies whose due date has passed with no approved deferral.For each one: escalate, fund the fix, or defer it as a P02 exception with the remaining risk accepted (CA-13). The assurance sponsor decides on any High one.[[What changed since last quarter, and what you ask the sponsor to decide]]
CAM-06 Planned tests deliveredThe plan starts on 1 Oct 2026All; any slip recorded with its new dateNone lateTests whose workpaper the reviewer signed by the end of the planned month plus the review days (CA-11), out of the tests the plan set for the year to date.Whether testing capacity is enough, and whether to approve a change to the plan, which is then recorded (CA-16).[[What changed since last quarter, and what you ask the sponsor to decide]]

Each figure is a count of named controls, tests or deficiencies. Add none of them together, and never show one as a percentage (CA-19).

Behind the headline

CountAt the As-at dateWhere to look
Controls in the inventory30Controls
of which key controls24Controls
Controls with a concluded operating test5Controls
of which Not effective at their last test1Controls; Deficiencies
Latest test found the design deficient1Tests; Deficiencies
Latest test: Not tested, as the control had not yet run1Tests
Workpapers awaiting the reviewer's signature0Tests
Exceptions recorded on tests concluded Effective1Deficiencies, foot of the sheet
Controls overdue for an operating test0Controls
Next due date of an open deficiency27 Dec 2026Deficiencies

The year's plan by quarter (CAM-06)

Plan quarterFromToTests plannedDue by the As-at dateFinal in time
Q11 Oct 20261 Dec 2026800
Q21 Jan 20271 Mar 20271000
Q31 Apr 20271 Jun 2027900
Q41 Jul 20271 Sep 2027600
The year3300

Design checks count as planned tests. A Lower-risk control whose operating test waits for the second year of its cycle still has its design checked this year (CA-02); the Controls sheet shows its operation as "Next plan year (Lower: 24-month cycle)".

What this dashboard is not

Control testing is not an internal audit, a certification audit, a P19 maturity assessment or a statement of compliance, and is never presented as one. Its results can feed each of them. (CA-18)

Results are reported as counts, such as "21 of 30 controls tested", with every deficiency named. There is no overall assurance score, no weighting, and no figure presented as a share of compliance with any framework. (CA-19)

It does not say which control meets which requirement. The By NIS2 Point sheet counts the controls whose source documents cite each point of NIS2 Article 21(2); that is the documents' own citation, not a statement that the point is met.

A control tested Effective worked on the occurrences sampled, over its testing period. It says nothing about periods not tested, or about risks no control in the inventory addresses.

Settings the formulas read (from the methodology)

Risk rating (CA-15)Test cycle, monthsWhen it applies
Higher6A key control on which a risk outside appetite, or an obligation the organisation has recorded as not met, rests; or a control that failed its last test.
Standard12Any other key control.
Lower24A control that is not key. Its design is still checked every 12 months (CA-02).
Population from (CA-05)Population toSample, Standard or LowerSample, HigherTypical control
12AllAllAn annual control, or a quarterly one tested over six months
31223A quarterly or monthly control
1352510A weekly control, or events a few times a month
532502030A daily control, or events most working days
251and above2540A control that runs many times a day
Severity (CA-12)Days to fix (CA-13)
High90
Medium180
Low365
Working days to agree a remediation plan (CA-13)10
Working days after the last test step for the reviewer to sign (CA-11)10

These are the Control Testing Methodology's values. Where you change one there, change it here; public holidays are yours to add to the working-day count.

Controls

One row per control, from the Control Inventory & Ownership Register. Yellow columns are yours; white columns calculate at the As-at date on the Summary sheet.

RowControl IDControlSource ruleSource documentNIS2 Article 21(2) points its source document citesControl ownerKey controlRisk ratingControl started on, if after the plan year beganTest cycle, months (calc)Latest test result (calc)Last concluded operating test: period end (calc)Its conclusion (calc)Tested within its cycle (calc)Next operating test due (calc)Due date counted from (calc)Overdue at the As-at date (calc)Next planned operating test (calc)Next planned design check (calc)Key control never tested (calc)Key controls never tested, so far (working)
EXAMPLECT-01Board report from checked figuresP03 BR-08P03-A05NoneHead of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Dec 2026With its operating test (CA-02)YesCT-01
EXAMPLECT-02Policy reviews on timeP04 PF-06P04-A02(a)Head of Information SecurityYesHigher6Design deficientNoAfter the design is fixed (CA-01)Not due1 Jul 20271 Jan 2027YesCT-01, CT-02
EXAMPLECT-03Joiners acknowledge policiesP04 PF-09P04-A02(a)HR DirectorYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Oct 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03
EXAMPLECT-04Quarterly risk reviewP05 RM-09P05-A02(a)Head of Information SecurityYesStandard12Effective31 Aug 2026EffectiveYes31 Aug 2027End of the last tested periodNot due1 Jul 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03
EXAMPLECT-05Exceptions approved and renewed in timeP02 EX-05, EX-06, EX-10P02-A02(a), (i)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Oct 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05
EXAMPLECT-06Monthly exception register reviewP02 EX-11P02-A02(a), (i)Head of Information SecurityNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not due1 Dec 2026With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05
EXAMPLECT-07Tier 1 suppliers reassessed in timeP06 TP-09P06-A02(d)Information Security ManagerYesHigher6Never testedNo1 Apr 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Nov 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07
EXAMPLECT-08Metric inputs checked before reportingP11 MR-05, MR-06P11-A02(f)Head of Information SecurityNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not due1 Feb 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07
EXAMPLECT-09NIS2 readiness self-assessedP12 NR-08P12-A04NoneHead of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Feb 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09
EXAMPLECT-10Board members trainedP12 NR-05P12-A06NoneBoard secretaryYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 May 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10
EXAMPLECT-11Information register reviewedP15 CL-03, CL-12P15-A02(i)Head of Information SecurityNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not due1 Jun 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10
EXAMPLECT-12Disposal certificates collectedP15 CL-11P15-A02(i)Head of ITNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not dueNext plan year (Lower: 24-month cycle)1 Apr 2027NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10
EXAMPLECT-13Urgent vulnerabilities fixed in timeP01 VM-08P01-A02(e)Head of ITYesHigher6Not effective31 Aug 2026Not effectiveYes28 Feb 2027End of the last tested periodNot due1 Feb 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10
EXAMPLECT-14Vendor releases reviewedP17 PM-03P17-A02(e)Head of ITNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not dueNext plan year (Lower: 24-month cycle)1 Aug 2027NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10
EXAMPLECT-15Missed patch deadlines deferredP17 PM-14P17-A02(e)Head of ITYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jan 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15
EXAMPLECT-16Leavers' access removedP13 JML-09P13-A02(i)Head of ITYesStandard12Effective31 Aug 2026EffectiveYes31 Aug 2027End of the last tested periodNot due1 Mar 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15
EXAMPLECT-17Movers' old access removedP13 JML-08P13-A02(i)Head of ITYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Nov 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17
EXAMPLECT-18Monthly account reconciliationP13 JML-15P13-A02(i)Head of ITYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Dec 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18
EXAMPLECT-19User access reviewsP07 AR-02, AR-07P07-A02(i)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Mar 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19
EXAMPLECT-20Privileged access reviewedP14 PA-16P14-A02(i), (j)Head of ITYesStandard12Not testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jan 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20
EXAMPLECT-21Break-glass accounts tested and every use reviewedP14 PA-12P14-A02(i), (j)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Apr 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21
EXAMPLECT-22Security induction completedP16 AW-05P16-A02(g)Information Security ManagerYesStandard12Effective31 Aug 2026EffectiveYes31 Aug 2027End of the last tested periodNot due1 Mar 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21
EXAMPLECT-23Annual security course completedP16 AW-04P16-A02(g)Information Security ManagerYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jul 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23
EXAMPLECT-24Post-incident review heldP09 IM-11P09-A02(b)Information Security ManagerYesStandard12Effective31 Aug 2026EffectiveYes31 Aug 2027End of the last tested periodNot due1 Mar 2027With its operating test (CA-02)NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23
EXAMPLECT-25Incident response exercisedP10 EX-02P10-A02(f)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jun 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25
EXAMPLECT-26After-action report approvedP10 EX-09P10-A12(f)Chief Operating OfficerNoLower24Never testedNo1 Oct 2028Start of the first plan year, or the control's start if later (CA-15)Not dueNext plan year (Lower: 24-month cycle)1 Sep 2027NoCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25
EXAMPLECT-27Notification readiness checkedP18 RN-17P18-A08NoneHead of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 May 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25, CT-27
EXAMPLECT-28Maturity assessed each yearP19 MA-17P19-A03(f)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Oct 2026With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25, CT-27, CT-28
EXAMPLECT-29Supplier High findings escalatedP06 TP-08P06-A02(d)Information Security ManagerYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jun 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25, CT-27, CT-28, CT-29
EXAMPLECT-30Triggered risk reassessmentP05 RM-10P05-A02(a)Head of Information SecurityYesStandard12Never testedNo1 Oct 2027Start of the first plan year, or the control's start if later (CA-15)Not due1 Jun 2027With its operating test (CA-02)YesCT-01, CT-02, CT-03, CT-05, CT-07, CT-09, CT-10, CT-15, CT-17, CT-18, CT-19, CT-20, CT-21, CT-23, CT-25, CT-27, CT-28, CT-29, CT-30

Tests

One row per workpaper (Control Test Workpaper Template). The sample size and the conclusion calculate by CA-05 and CA-07; a conclusion is final only when the reviewer signs (CA-11).

RowWorkpaperControl IDRisk rating when testedTested onTesting period fromTesting period toDesignPopulationSample size (calc, CA-05)Exceptions in the sampleExceptions among the added occurrencesAutomated controlOperating conclusion (calc, CA-07)TesterReviewerReviewer signed onIndependence check (calc, CA-10, CA-11)Concluded and final (calc)Result reported (calc)Population sourceWhat the tester foundConcluded key (working)Latest key (working)
EXAMPLEWP-2026-01CT-16Standard21 Sep 20261 Mar 202631 Aug 2026Adequate38510NoEffectiveQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKYesEffectiveHR system leavers report, 1 Mar to 31 Aug 2026L-2026-031's ERP account stayed enabled for 19 days after the last working day. The May reconciliation (CT-18) found and disabled it. One exception, so five more leavers were tested (CA-07): none failed. Effective, with the exception recorded and CT-18 noted as having caught it (CA-08).CT-16|46265CT-16|46286
EXAMPLEWP-2026-02CT-13Standard22 Sep 20261 Mar 202631 Aug 2026Adequate3452NoNot effectiveQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKYesNot effectiveRemediation tracker export of Priority 1 and 2 findings due 1 Mar to 31 Aug 2026VUL-2026-0301 and VUL-2026-0318 were fixed after their June deadlines, with no deferral requested (P17 PM-14). Two exceptions: Not effective. P19's assessment found the same misses (MP-18).CT-13|46265CT-13|46287
EXAMPLEWP-2026-03CT-22Standard23 Sep 20261 Mar 202631 Aug 2026Adequate61200NoEffectiveQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKYesEffectiveHR system joiners report, 1 Mar to 31 Aug 2026, with the learning system's completion datesAll 20 sampled joiners completed the induction within 10 working days of their start date.CT-22|46265CT-22|46288
EXAMPLEWP-2026-04CT-04Standard23 Sep 20261 Mar 202631 Aug 2026Adequate2450NoEffectiveQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKYesEffectiveRisk register review history: 12 risks, March and June quartersEach of the five sampled reviews was made in its quarter by the owner the register names, with a decision recorded.CT-04|46265CT-04|46288
EXAMPLEWP-2026-05CT-24Standard24 Sep 20261 Mar 202631 Aug 2026Adequate110NoEffectiveQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKYesEffectiveIncident log: Severity 1 and 2 incidents closed 1 Mar to 31 Aug 2026INC-2026-014, closed on 21 Aug 2026, had its review on 27 Aug 2026, four working days later, with an owner and due date for each action; R-04 was reassessed on 20 Aug 2026 (P05).CT-24|46265CT-24|46289
EXAMPLEWP-2026-06CT-20Standard24 Sep 20261 Mar 202631 Aug 2026Adequate000NoNot testedQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKNoNot testedPrivileged access review recordsDesign walked through on the Privileged Access Standard approved on 18 Sep 2026. Not tested: no review has yet fallen due; the first is due by 21 Dec 2026.CT-20|46289
EXAMPLEWP-2026-07CT-02Higher25 Sep 20261 Mar 202631 Aug 2026DeficientNoNot testedQuality and Compliance ManagerInternal Audit Manager28 Sep 2026OKNoDesign deficientPolicy documents and their approval recordsDesign deficient: with no register of review dates, nothing shows when a review falls due, and there is no cryptography policy to review (CA-01). Operation not tested until the design is fixed.CT-02|46290

Deficiencies

One row per deficiency, from the Control Deficiency & Remediation Tracker. Severity, the plan date and the due date calculate (CA-12, CA-13). A deficiency closes only on a passed retest (CA-14).

RowDeficiency IDControl IDFrom workpaperDesign or operatingKey control (calc)Compensating control tested effectiveLeaves a risk outside appetite or a recorded unmet obligation without its controlOnly the record falls short of the evidence standardSeverity (calc, CA-12)Control ownerConfirmed by the reviewer onPlan agreed by (calc, CA-13)Due (calc, CA-13)StatusFixed onOpen (calc)Past its due date (calc)Days to due date (calc)FindingRemediationLinked work, due by the deficiency's dateRelated later workRetest fromOpen deficiencies, so far (working)Past due, so far (working)
EXAMPLEDF-01CT-13WP-2026-02OperatingYesNoNoNoHighHead of IT28 Sep 202612 Oct 202627 Dec 2026OpenYesNo88Two of five sampled Priority 1 and 2 findings were fixed after their deadlines with no deferral.Bring the ordering platform's patching back within deadline, and defer every miss as an exception before its deadlineP05 TA-03P19 MF-112 Nov 2026DF-01 (CT-13, High)
EXAMPLEDF-02CT-02WP-2026-07DesignYesNoYesNoHighHead of Information Security28 Sep 202612 Oct 202627 Dec 2026OpenYesNo88No register records when each policy is due for review, and there is no cryptography policy.Keep a policy register with an approval and review date for every policy, and have the board approve the cryptography policyP12 GAP-01; P19 MF-01None1 Feb 2027DF-01 (CT-13, High); DF-02 (CT-02, High)

Exceptions recorded on tests concluded Effective (CA-07, CA-08)

A sampled occurrence that fails an attribute is an exception, even if another control later caught and corrected it. The other control counts when the deficiency is rated (CA-12), not when this control is concluded. This differs from P19's MA-05 on purpose: P19 rates a whole practice with its checks, P20 one control. Each one is named here, though it is not a deficiency.

RowWorkpaperControl IDOccurrenceWhat happened
EXAMPLEWP-2026-01CT-16L-2026-031ERP account disabled 19 days after the last working day, by the May reconciliation (CT-18)

Plan Progress

One row per test the Annual Control Testing Plan sets, by the month its fieldwork runs. Enter the date each workpaper is signed. A test is delivered when the reviewer signs it by the end of its month plus the review days (CA-11, CAM-06).

RowControl IDControl (calc)Planned monthTestTesterNoteWorkpaper final onPlan quarter (calc)Due by the As-at date (calc)Final by: month end plus review days (calc, CA-11)Final in time (calc)Status (calc)
EXAMPLECT-03Joiners acknowledge policies1 Oct 2026OperatingInformation Security ManagerQ1No13 Nov 2026Not due yet
EXAMPLECT-05Exceptions approved and renewed in time1 Oct 2026OperatingQuality and Compliance ManagerQ1No13 Nov 2026Not due yet
EXAMPLECT-28Maturity assessed each year1 Oct 2026OperatingQuality and Compliance ManagerQ1No13 Nov 2026Not due yet
EXAMPLECT-07Tier 1 suppliers reassessed in time1 Nov 2026OperatingQuality and Compliance ManagerHigher: first of twoQ1No14 Dec 2026Not due yet
EXAMPLECT-17Movers' old access removed1 Nov 2026OperatingQuality and Compliance ManagerQ1No14 Dec 2026Not due yet
EXAMPLECT-01Board report from checked figures1 Dec 2026OperatingQuality and Compliance ManagerQ1No14 Jan 2027Not due yet
EXAMPLECT-18Monthly account reconciliation1 Dec 2026OperatingQuality and Compliance ManagerQ1No14 Jan 2027Not due yet
EXAMPLECT-06Monthly exception register review1 Dec 2026OperatingQuality and Compliance ManagerQ1No14 Jan 2027Not due yet
EXAMPLECT-02Policy reviews on time1 Jan 2027DesignQuality and Compliance ManagerDF-02: design re-checked once the register existsQ2No12 Feb 2027Not due yet
EXAMPLECT-20Privileged access reviewed1 Jan 2027OperatingQuality and Compliance ManagerFirst review due by 21 Dec 2026Q2No12 Feb 2027Not due yet
EXAMPLECT-15Missed patch deadlines deferred1 Jan 2027OperatingQuality and Compliance ManagerQ2No12 Feb 2027Not due yet
EXAMPLECT-13Urgent vulnerabilities fixed in time1 Feb 2027RetestQuality and Compliance ManagerDF-01 retest; Higher: first of twoQ2No12 Mar 2027Not due yet
EXAMPLECT-08Metric inputs checked before reporting1 Feb 2027OperatingQuality and Compliance ManagerQ2No12 Mar 2027Not due yet
EXAMPLECT-09NIS2 readiness self-assessed1 Feb 2027OperatingQuality and Compliance ManagerQ2No12 Mar 2027Not due yet
EXAMPLECT-16Leavers' access removed1 Mar 2027OperatingQuality and Compliance ManagerBefore the customer reviewQ2No14 Apr 2027Not due yet
EXAMPLECT-22Security induction completed1 Mar 2027OperatingQuality and Compliance ManagerBefore the customer reviewQ2No14 Apr 2027Not due yet
EXAMPLECT-19User access reviews1 Mar 2027OperatingQuality and Compliance ManagerBefore the customer reviewQ2No14 Apr 2027Not due yet
EXAMPLECT-24Post-incident review held1 Mar 2027OperatingQuality and Compliance ManagerBefore the customer reviewQ2No14 Apr 2027Not due yet
EXAMPLECT-21Break-glass accounts tested and every use reviewed1 Apr 2027OperatingQuality and Compliance ManagerQ3No14 May 2027Not due yet
EXAMPLECT-12Disposal certificates collected1 Apr 2027DesignQuality and Compliance ManagerLower: design checked each year (CA-02); operation tested next yearQ3No14 May 2027Not due yet
EXAMPLECT-07Tier 1 suppliers reassessed in time1 May 2027OperatingQuality and Compliance ManagerHigher: second of twoQ3No14 Jun 2027Not due yet
EXAMPLECT-10Board members trained1 May 2027OperatingInformation Security ManagerQ3No14 Jun 2027Not due yet
EXAMPLECT-27Notification readiness checked1 May 2027OperatingQuality and Compliance ManagerQ3No14 Jun 2027Not due yet
EXAMPLECT-25Incident response exercised1 Jun 2027OperatingQuality and Compliance ManagerQ3No14 Jul 2027Not due yet
EXAMPLECT-29Supplier High findings escalated1 Jun 2027OperatingQuality and Compliance ManagerQ3No14 Jul 2027Not due yet
EXAMPLECT-30Triggered risk reassessment1 Jun 2027OperatingQuality and Compliance ManagerQ3No14 Jul 2027Not due yet
EXAMPLECT-11Information register reviewed1 Jun 2027OperatingQuality and Compliance ManagerQ3No14 Jul 2027Not due yet
EXAMPLECT-02Policy reviews on time1 Jul 2027RetestQuality and Compliance ManagerDF-02 operating retest; HigherQ4No13 Aug 2027Not due yet
EXAMPLECT-04Quarterly risk review1 Jul 2027OperatingQuality and Compliance ManagerQ4No13 Aug 2027Not due yet
EXAMPLECT-23Annual security course completed1 Jul 2027OperatingQuality and Compliance ManagerQ4No13 Aug 2027Not due yet
EXAMPLECT-13Urgent vulnerabilities fixed in time1 Aug 2027OperatingQuality and Compliance ManagerHigher: second of twoQ4No14 Sep 2027Not due yet
EXAMPLECT-14Vendor releases reviewed1 Aug 2027DesignQuality and Compliance ManagerLower: design checked each year (CA-02); operation tested next yearQ4No14 Sep 2027Not due yet
EXAMPLECT-26After-action report approved1 Sep 2027DesignQuality and Compliance ManagerLower: design checked each year (CA-02); operation tested next yearQ4No14 Oct 2027Not due yet

By NIS2 Point

By NIS2 Article 21(2) point: controls whose source documents cite it

For each point of Article 21(2), the controls on the Controls sheet whose source document cites that point in its own framework references, and how many of them are tested within their cycle and Effective. This is the documents' citation, counted. It is not a statement that any point is met, and a point with no control here is not, on that ground, a gap.

PointMeasureNIS2's wordsControls whose source documents cite this pointOf those, tested within their cycleOf those, Effective at their last testWritten asNote
(a)Risk analysis and security policies“policies on risk analysis and information system security”6111 of 6 tested; 1 of 1 effective
(b)Incident handling“incident handling”1111 of 1 tested; 1 of 1 effective
(c)Business continuity and crisis management“business continuity, such as backup management and disaster recovery, and crisis management”000No control's source document cites itRestore testing is not in the control set. Add your own control to the inventory if you rely on one, quoting the Cyber Resilience & Recovery pack's RR-14 or a rule of the Backup & Restore Assurance pack.
(d)Supply chain security“supply chain security, including security-related aspects concerning the relationships between each entity and its direct suppliers or service providers”2000 of 2 tested; 0 of 0 effective
(e)Security in acquisition, development and maintenance“security in network and information systems acquisition, development and maintenance, including vulnerability handling and disclosure”3101 of 3 tested; 0 of 1 effective
(f)Assessing effectiveness“policies and procedures to assess the effectiveness of cybersecurity risk-management measures”4000 of 4 tested; 0 of 0 effective
(g)Cyber hygiene and training“basic cyber hygiene practices and cybersecurity training”2111 of 2 tested; 1 of 1 effective
(h)Cryptography and encryption“policies and procedures regarding the use of cryptography and, where appropriate, encryption”000No control's source document cites it
(i)People, access and assets“human resources security, access control policies and asset management”10111 of 10 tested; 1 of 1 effective
(j)Multi-factor authentication and secured communications“the use of multi-factor authentication or continuous authentication solutions, secured voice, video and text communications and secured emergency communication systems within the entity, where appropriate”2000 of 2 tested; 0 of 0 effective
A control counts under every point its source document cites, so the rows do not add up to the number of controls. Which requirement you rely on a control for is your own record in the Unified Control Framework Mapping Workbook, not this sheet's.

By the requirements you rely on your controls for

Yours to fill, from the Unified Control Framework Mapping Workbook: one row per requirement you report on, the controls you rely on for it, and how many of those are tested within their cycle and Effective, from the Controls sheet. Count them; do not turn them into a share (CA-19).

Requirement setRequirement, in its own wordsControls you rely on for itHow manyOf those, testedOf those, EffectiveWritten asNote
[[e.g. a requirement set]][[the requirement, as the workbook lists it]][[the control IDs]]

Lists

YesNoDesignConclusionDeficiencyKindDeficiencyStatePlannedTest
YesAdequateDesignOpenOperating
NoDeficientOperatingPlan agreedDesign
Fixed, awaiting retestRetest

Closed

Deferred as an exception

Definitions

Definitions

TermMeaning in this workbook
CAM-01 Controls tested within their cycleControls whose last operating test, concluded Effective or Not effective, covered a period ending within their test cycle, out of the controls in the inventory. Target: All, by the end of each control's first cycle.
CAM-02 Tested controls effectiveControls whose last operating test concluded Effective, out of the controls tested. Target: All.
CAM-03 Key controls never testedKey controls with no operating test concluded, by name. Target: None after the first plan year.
CAM-04 Open deficiencies by severityDeficiencies not yet closed by a passed retest, counted High, Medium and Low. Target: No High open past its due date.
CAM-05 Deficiencies past their due dateDeficiencies not yet fixed when their due date passed, with no approved deferral, by name. A deficiency fixed by its due date and waiting for its retest is open (CAM-04) but not past due. Target: None.
CAM-06 Planned tests deliveredTests final, with the reviewer's signature, by the end of the month the plan set plus the review time (CA-11), out of the tests the plan set for the year to date. Target: All; any slip recorded with its new date.
ControlSomething done routinely to keep a risk in check, written as who does what, how often, and the record it leaves (CA-01).
Key controlA control whose failure, on its own, would let a risk on the register happen or go unnoticed, or that the organisation names as its evidence for an obligation. Key controls are never rated Lower risk.
Control ownerThe manager accountable for a control running and leaving its record. Agrees test dates, provides access to records and fixes deficiencies.
TesterThe person who tests a control. Owns and performs none of the controls they test (CA-10).
Design testA check that the control, as written and as set up, would prevent or detect the risk if it ran: a walkthrough of one occurrence from start to record (CA-02).
Operating testA check, on a sample chosen by the tester, that the control ran as designed throughout the testing period (CA-04 to CA-07).
PopulationEvery occurrence of the control in the testing period, taken by the tester from the system of record, with a check that the list is complete (CA-04).
SampleThe occurrences the tester chooses from the population, spread across the testing period. The owner never chooses them (CA-04, CA-05).
Testing periodThe months the operating test covers: since the control was last tested, and never longer than its test cycle (CA-06).
ExceptionA sampled occurrence that fails any attribute (CA-07, CA-08).
DeficiencyA design that would not keep the risk in check, or an operating test concluded Not effective. Rated High, Medium or Low (CA-12).
Compensating controlAnother control that keeps the same risk in check when this one fails. It counts only once it has been tested and found effective (CA-12).
RetestAn operating test of a fixed control, made after it has run enough times to sample, by someone other than its owner. A deficiency closes only on a retest that passes (CA-14).
WorkpaperThe record of one test: population and its source, sample, attributes, results, exceptions, conclusion, tester and reviewer (CA-11).
Risk ratingEach control is rated Higher, Standard or Lower risk, and tested at least every 6, 12 or 24 months respectively. A control never tested is due within one cycle of the start of the first plan year, or of the day it started if that is later; one whose design was found deficient, within one cycle of the day its design is found adequate. A key control is never Lower, and a control that failed its last test is Higher until a retest passes. When each rating applies is in the settings on the Summary sheet.
SeverityEvery design deficiency and every Not effective result is a deficiency. High: a key control failed and no compensating control was tested effective, or the failure leaves a risk outside appetite or a recorded unmet obligation without its control. Medium: a key control failed but a compensating control was tested effective, or a control that is not key failed. Low: the control ran, but its record falls short of the evidence standard.
EffectiveNo exception in the sample; or one exception in a manual control whose population is at least twice the sample, with none among the occurrences added (CA-07).
Not effectiveAny other result with an exception (CA-07). It is a deficiency (CA-12).
Not testedThe control had not run in the testing period, or its design was found deficient, so its operation was not tested (CA-01, CA-06).
Design deficientThe design check found the control could not keep its risk in check as written or set up. Its operation is not tested until the design is fixed (CA-01).
Never testedNo workpaper on the Tests sheet for the control.
Awaiting reviewThe test is not final until the reviewer signs (CA-11), so it is not reported as a conclusion.
Tested within its cycleThe control's last concluded operating test covered a period ending no more than its test cycle before the As-at date.
Next operating test dueThe end of the last tested period plus the test cycle (CA-15). For a control never tested, one cycle from the start of the first plan year, or from the day the control started if that is later; for one whose design was found deficient, one cycle from the day its design is found adequate (CA-15). Until then it has no operating due date (CA-01).
OverdueThe next operating test was due before the As-at date.
Next planned operating test, next planned design checkThe first operating test or retest, and the first design check, that the plan sets from the As-at date's month. A design check runs with every operating test (CA-02); a Lower-risk control whose operation waits for the next plan year has its own design check row.
NIS2 points its source document citesThe points of NIS2 Article 21(2) that the control's source document cites in its own framework references. It says what the document helps with; it does not say the control meets the point.
As-at dateThe date every flag and measure is worked out at: the quarter's last day.
Assurance sponsorThe member of management who approves the test plan, receives the dashboard, and decides when a High deficiency is overdue.
Control assurance leadThe person who runs control testing: keeps the inventory and the plan, assigns testers, reviews workpapers, and rates deficiencies. Owns and performs no control in scope.
(calc), (working)A column or cell the workbook calculates. Do not type or paste over it. Working columns hold running lists other cells read.
CA-nn, CT-nn, CAM-nnThe rules, controls and headline measures of the Control Testing Methodology. WP-nnnn-nn are workpapers; DF-nn deficiencies.
EXAMPLEA worked example: a wholesale distributor with about 900 staff, three warehouses and an online ordering service that takes 60% of its orders, as at 30 Sep 2026, after its pilot round TR-2026-P. Delete before use.

Framework References

Framework references

These references indicate relevance only and do not reproduce the text of any standard.

FrameworkReferenceSupported by
ISO/IEC 27001:2022Clause 9.1 — Monitoring, measurement, analysis and evaluationThe dashboard as a whole: what is tested, when, and the results evaluated and reported to management each quarter
NIST CSF 2.0GV.OV-03 — “Organizational cybersecurity risk management performance is evaluated and reviewed for adjustments needed”Summary sheet: test results put before management each quarter, with the decision each measure supports
NIS2 — Directive (EU) 2022/2555Article 20(1) — management bodies approve the cybersecurity risk-management measures, oversee their implementation and can be held liable for infringementsSummary sheet: what the management body sees each quarter to oversee the measures it approved. The dashboard informs that oversight; it does not discharge it
NIS2 — Directive (EU) 2022/2555Article 21(2)(f) — “policies and procedures to assess the effectiveness of cybersecurity risk-management measures”The dashboard as a whole: the results of testing whether controls work, reported to management on a set cycle. Part of assessing effectiveness, not the whole of it
NIS2 — Implementing Regulation (EU) 2024/2690Article 1 — lays down the technical and methodological requirements of the Article 21(2) measures, and further specifies when an incident is significant, for DNS service providers, TLD name registries, cloud computing, data centre and content delivery network providers, managed service and managed security service providers, providers of online marketplaces, online search engines and social networking services platforms, and trust service providersApplies to the providers its Article 1 names. For them, the Annex points below; for others, a useful guide only
NIS2 — Implementing Regulation (EU) 2024/2690Annex, point 2.2.1 — regularly review compliance with the network and information system security policies, topic-specific policies, rules and standards; “The management bodies shall be informed of the status of network and information security on the basis of the compliance reviews by means of regular reporting.”Summary sheet: regular reporting to management on whether the controls the policies set are working. For the providers Article 1 names, the results can feed the compliance reviews; the dashboard is not that review
NIS2 — Implementing Regulation (EU) 2024/2690Annex, point 2.2.2 — an effective compliance reporting system, appropriate to the entity’s structures, operating environments and threat landscapes, “capable to provide to the management bodies an informed view of the current state of the relevant entities’ management of risks”Summary, Deficiencies and Plan Progress sheets: a current view for management of which controls are tested, which work and what is being fixed (providers Article 1 names)
DORA — Regulation (EU) 2022/2554Article 5(2) — the management body defines, approves, oversees and is responsible for the ICT risk management framework, bears ultimate responsibility for ICT risk and sets the risk toleranceSummary sheet, for financial entities: information the management body can use to oversee the ICT risk management framework it is responsible for
DORA — Delegated Regulation (EU) 2024/1774Article 27(2) — the report on the review of the ICT risk management framework (DORA Article 6(5)) contains, among other things, an executive-level summary of the ICT risk profile, threat landscape, “the assessed effectiveness of its controls” and security posture; the date of the management body’s approval; the reason for the review; the function responsible; the findings, with an assessment of the severity of weaknesses, deficiencies and gaps; the measures to address them, with expected dates, responsible functions and resource impact; the criteria for accepting residual risk where gaps are not remedied; planned developments; and the state of corrective measures from past reviewsDeficiencies sheet and CAM-02 to CAM-05, for financial entities: the tested effectiveness of controls and the severity of each deficiency, which can feed the review report. The dashboard is not that report

Editions referenced: ISO/IEC 27001:2022 incl. Amd 1:2024; NIST CSF 2.0; Directive (EU) 2022/2555 (NIS2) and Implementing Regulation (EU) 2024/2690; Regulation (EU) 2022/2554 (DORA) and Delegated Regulation (EU) 2024/1774; Regulation (EU) 2016/679 (GDPR)

ISO/IEC 27001 references name the clause or control this document relates to. They do not say that meeting it meets any other framework's requirement.

These references show where this document supports an external framework. They indicate relevance only and do not reproduce the text of any standard.

Prepared by Zero One Cybersecurity · Published by CISO Times

CISO Times Resource Licence — Internal Use