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
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
- CSV header:
finding, due, statusrequired;control, owner, evidenceoptional. Status: open/in progress/closed (TR/DE equivalents accepted). - Enter the reference date (empty = today) and the number of days counted as upcoming.
- 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
| Input | Value |
|---|---|
| Action list (CSV) | |
| Reference date | 2026-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
| Input | Value |
|---|---|
| Action list (CSV) | |
| Reference date | 2026-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