A well-designed investigation findings matrix helps reviewers trace a preliminary assessment back to the specific issue, available source material and unresolved questions. It is most useful when the investigation covers several allegations or issues and a long narrative alone would make the reasoning difficult to follow.
It is important to distinguish a findings matrix from an evidence matrix. An evidence matrix organizes what the sources say about an issue. A findings matrix adds the reviewer’s evaluation of the information, its limitations and the current status of that issue—without treating unverified material as fact.
What columns belong in a findings matrix?
- Issue ID and review question: one precise, neutral question per row.
- Applicable policy or standard: a reference to the organization's actual policy, if relevant.
- Supporting source IDs: records or accounts relevant to the issue, with links to their approved storage locations.
- Contrary or conflicting source IDs: material that points in a different direction or limits an interpretation.
- Missing information: interviews, original documents or other checks still needed.
- Analysis: a dated explanation of what the available information does and does not establish.
- Issue status: open, under review, inconclusive or reviewed under a defined workflow.
- Reviewer and review date: who assessed the issue and when, subject to authorization.
Do not assume a single set of “supported,” “unsupported” or “substantiated” labels is appropriate for every matter. Actual findings categories and thresholds depend on governing policy, applicable law and the organization's decision-making standards.
Fictional walkthrough: the status of an inspection
Assume an internal reviewer must determine whether an equipment inspection was completed before a fictional incident. There is a staff recollection of October 12, a log copy dated October 13 and a work schedule showing the task was assigned for October 12.
| Issue | Current information | Status | Needed next |
|---|---|---|---|
|
ISS-001 Was an inspection completed before the incident? |
SRC-001: recollection of October 12. SRC-002: log copy dated October 13. SRC-003: work scheduled for October 12. |
Open; accounts and record timing differ. | Request original log and verify what “scheduled” versus “completed” means. |
|
ISS-002 Who authorized the work? |
A schedule lists an assigned role, but no signed approval is yet available. | Information incomplete. | Identify the appropriate authorization record through approved channels. |
Both entries remain open in this illustration. The matrix does not convert a scheduled task into a completed inspection or presume that either source is unreliable. A dated review note should identify the gaps and who is responsible for checking them.
Separate source records, evaluation and decisions
Source logs and timelines should retain the underlying evidence references. The findings matrix should reference them, not replace them. A subsequent reviewer needs to be able to see the original information and the steps that led to an assessment.
In some workflows, the investigator documents an assessment but a manager or another authorized decision-maker makes the final determination. Keep those roles separate where policy requires it. A conclusion is not stronger merely because the matrix has a green status cell.
A six-step quality review before closing an issue
- Confirm the issue question is neutral and does not assume the outcome.
- Check that all material supporting and conflicting records have stable source references.
- Explain significant limitations, such as incomplete records or uncertain dates.
- Identify unresolved actions and whether they could materially change the assessment.
- Document the review date, reviewer and the applicable organizational standard.
- Confirm the current status matches the information actually reviewed.
A findings matrix can improve communication, but it cannot substitute for mandated investigative procedures, chain-of-custody protocols or independent review where required.
Choose a CaseWorks resource for the workflow
Begin with the free investigation timeline to practice separating events, sources and verification labels. The $19 Source & Evidence Documentation Pack is suitable for organizing source and item references; it should not be represented as a legal evidence-processing system.
If you need an integrated structure for case intake, chronology, source records, interviews, actions and review, compare the $79 Case Management System and its genuine worksheet screenshots.
For a source-focused explanation, read the companion Evidence Matrix Guide. The two guides serve different purposes.
Frequently asked questions
Is a findings matrix a substitute for a final investigation report?
No. It can support report preparation by linking issues, sources, gaps and assessments, but the required report structure and approval process depend on your organization.
Should contradictory information be omitted once an issue is reviewed?
No. Material contradictions and relevant limitations should remain visible and traceable in accordance with applicable review procedures.
Can I store confidential evidence directly in a spreadsheet?
Only if the storage and access environment is approved for that information. A downloadable template does not itself provide secure evidence storage, access controls or retention enforcement.
General documentation guidance only; not legal advice or an official investigative findings standard.