TRUST ATLAS WORKSHEET
Sampling populations
SOC 1 · Step 3 · Collect records and support testing- Who prepares it
- Control owners + independent CPA
- When to prepare it
- During the Type 2 period and fieldwork
Spreadsheet columns
Use these column headings. Add one row for each item you record.
- Record ID
- Occurred at
- System and event
- State
- Evidence key
- 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
- 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.
- Save the query and export timestamp. Keep stable source IDs and reconcile totals to an independent report. Explain any legitimate exclusions.
- 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.