Template · Resource
Investigation Timeline Template and Checklist
A reusable timeline template and pre-publication checklist for documenting events, sources, and uncertainty in any investigation.
By Second Trace editorial · Published August 30, 2026 · Updated August 30, 2026 · 5 min read
In short
A ready-to-copy timeline template — date, certainty, event, source, and notes — plus a pre-publication checklist that makes sure every entry is sourced, typed, and gap-marked before you share it.
Download
Download the timeline template (CSV) · Download the pre-publication checklist
The template
Copy these five columns into a spreadsheet or your workspace. One row per event.
| Date | Certainty | Event | Source & location | Account / notes |
|---|---|---|---|---|
| 1998-06-14 | Exact | Report filed | Police report, p. 3 | Initial report of the incident |
| circa June 1998 | Approximate | Vehicle seen near site | Witness interview, 1998-06-20 | Witness unsure of exact day |
| 1998-06-13 / 1998-06-15 | Disputed | Date of last contact | Family account vs. records | Two accounts conflict — keep both |
How to fill each column
- Date — the date, range, or "unknown" the source supports.
- Certainty — exact, approximate, disputed, range, or unknown.
- Event — a neutral, specific description of what happened.
- Source & location — the source and where in it the entry comes from (page, timestamp).
- Account / notes — the claim in context, conflicts, and anything a future reader needs.
Pre-publication checklist
Run through this before you share or publish the timeline:
- Every entry has a date or is explicitly marked unknown.
- Every entry has a certainty state, and no approximate or disputed date is written as exact.
- Every entry cites its source and location within the source.
- Conflicting accounts are kept side by side, not merged.
- Gaps are marked, not smoothed over.
- Allegations, testimony, and inference are labeled and not written as confirmed fact.
- No entry implies guilt or ranks anyone as a suspect.
- Private information is redacted.
- The timeline is consistent with the presumption of innocence.
- You can reconstruct every entry from its source, months or years from now.
Adapting the template
Add columns as your work requires — a "status" column, a "verified by" column, or a "linked items" column. The core discipline is the five base columns; the rest is scaffolding. What matters is that every event stays dated, sourced, and honestly labeled about how certain it is.
Sources & further reading
- National Institute of Justice (NIJ) — cold-case research and review practices that inform a disciplined timeline.
Frequently asked questions
Should I use exact dates or ranges?
Use whatever the source supports. If a source gives an exact date, use it; if it only supports a range or an approximation, record that. The certainty column exists precisely so you never have to choose between accuracy and completeness.
How detailed should the notes column be?
Detailed enough to explain the entry without reproducing the whole source — what the account claims, any conflicts, and anything a future reader would need. When in doubt, err on the side of recording more and redacting later.
Can I use this for non-criminal research?
Yes. The template is a general documentation tool for any dated, sourced sequence of events — historical research, journalism, genealogy, or project reconstruction.
Put this into practice
Second Trace is a workspace for organizing case information with full provenance. These capabilities map directly to the method above:
Related resources
Timelines
Cold-case timeline →A step-by-step method for building an accurate cold-case timeline — separating exact, approximate, and disputed dates, and keeping every entry tied to its source.
Evidence
Organizing evidence →A practical framework for organizing evidence in large, long-running investigations — provenance, chain of custody, and how to keep thousands of items findable.
Method
Facts, allegations & theories →A working taxonomy for sorting confirmed facts, allegations, testimony, inference, and theory in a case record — and why the distinction must survive export.