Template library
TRUST ATLAS WORKSHEET

Change and incident populations

SOC 2 · Step 3 · Operate controls and retain evidence
Who prepares it
Engineering + operations
When to prepare it
Throughout the agreed Type 2 period

Spreadsheet columns

Use these column headings. Add one row for each item you record.

  1. Record ID
  2. Occurred at
  3. System and event
  4. State
  5. Evidence key
  6. Population filter

Gather first

  • Authoritative ticket, event or transaction system
  • Exact scope, time zone and date window
  • Auditor’s population and sampling request

How to prepare it

  1. Define what counts as one row and agree start and end cutoffs with the auditor. Export all in-scope activity, including failed or cancelled records when relevant.
  2. Save the query and export timestamp. Keep stable source IDs and reconcile totals to an independent report. Explain any legitimate exclusions.
  3. Give the full population to the auditor before sampling. Link selected items to underlying records as requested.

Review

The reviewer can reproduce the count and trace any selected item back to the original system.

Handoff

Transfer the export, query, reconciliation and any exclusions to the independent tester.

Keyboard shortcuts

⌘K or /
Search everything
?
This list
g h
Home
g l
Guide library
g f
Find my path
g t
Templates
g p
Playbooks
g w
My workspace
g d
Deadline calendar
g c
Regulatory changes