IT Operations, Risk and Audit · #98

Online Audit Evidence and Action Tracker

Collects open actions, delays and missing evidence in one table before an audit.

  • Data is processed in your browser and not sent to a server
  • Export: XLSX, CSV

Tool

Date YYYY-MM-DD or DD.MM.YYYY.

Empty = today.

What does this tool do?

Auditors verify that a closed finding is really closed through evidence; 'closed' items without evidence are raised again. Overdue actions must be explained in management review. The tool checks status, due date and evidence columns and gives a summary per owner.

How to use it

  1. CSV header: finding, due, status required; control, owner, evidence optional. Status: open/in progress/closed (TR/DE equivalents accepted).
  2. Enter the reference date (empty = today) and the number of days counted as upcoming.
  3. Press Run; download the list as XLSX.

Fields

Action list (CSV)
Date YYYY-MM-DD or DD.MM.YYYY.
Reference date
Empty = today.
Upcoming window (days)

Worked example

InputValue
Action list (CSV)
control,finding,owner,due,status,evidence
A.5.15,Access review not completed,Ayşe,2026-11-10,open,
A.8.13,Backup restore test,Mehmet,2026-11-30,in progress,
A.5.24,Incident response exercise,Ayşe,2026-10-15,closed,
A.8.8,Patch process document,Ali,2026-12-20,open,
A.5.9,Asset inventory updated,Ali,2026-09-01,closed,SharePoint/Evidence/A59.xlsx
Reference date2026-11-22
Upcoming window (days)14

Expected result: A.5.15 is 12 days overdue; A.8.13 is due in 8 days; A.5.24 was closed without evidence. 3 open, 2 closed items; Ayşe has 1 overdue action.

The exercise item closed without evidence needs the exercise report or attendee list. Naming evidence with the control number (e.g. A.5.24_exercise_report.pdf) in the audit folder shortens search time during the audit.

Second scenario

InputValue
Action list (CSV)
control;finding;owner;due;status;evidence
4.1;Kontext dokumentieren;QM;15.01.2027;offen;
Reference date2026-11-22
Upcoming window (days)30

Expected result: A German list ("offen", DD.MM.YYYY): the single open item is due in 54 days; not within the 30-day window.

Method and assumptions

Days left = due − reference. For open/in-progress items days left < 0 is overdue, ≤ window is upcoming. Closed items with an empty evidence column get a warning. Statuses recognised: open/açık/offen, in progress/devam/in Bearbeitung, closed/kapalı/erledigt.

Using the result and troubleshooting

Update the list in the weekly security meeting; link treatment plans with the IT Risk Matrix. Keep evidence in an access-controlled library (e.g. SharePoint) with version history.

Limits and common mistakes

  • Evidence links are not checked for accessibility or content; only whether the column is filled.

Frequently asked questions

What counts as evidence?

Dated records showing the control is applied: screenshots, system reports, signed minutes, ticket records or an updated document version. A statement that it was 'done' is not enough.

Related tools and service

  • IT Risk MatrixScores information security risks, places them on a heat map and flags missing ownership or treatment.
  • IT Change and Rollback PlanSchedules steps, reserves rollback time and produces the plan for the CAB as Markdown.

Related service: Audit Evidence and Document Management with SharePoint

Compliance online tools · See all online tools