A business interview can leave me with three versions of the same afternoon: the story an owner tells, the sequence I saw, and the dates in a notebook. None is automatically wrong. They answer different questions. The trouble starts when I merge them while writing and forget which detail came from where.
For small-business reporting, a plain digital ledger helps me keep those differences visible. It is not a scoring system for whether somebody sounds convincing. It is a way to leave a trail from a sentence in a draft back to something I can check.
Start with a claim, not a transcript
I give each useful claim its own row. Beside it, I record who said it, when we spoke, and where the supporting material lives. That material might be an interview time stamp, a photograph of a demonstration, or a dated notice supplied by the business.
A separate column says what kind of evidence I have. “The owner remembers moving in spring” is different from “the lease began in March.” Those may eventually fit together, but they should not become the same fact just because a spreadsheet puts them next to each other.
Keep an observation column
Suppose a bookbinder shows me a repair that takes several stages. I can describe the stage I watched. I cannot turn ten minutes at the bench into a confident statement about an entire week's output.
My observation column keeps that boundary close to the note. I write what happened in front of me, then list the follow-up needed to understand the wider process. A demonstration can suggest a question without settling it.
Make uncertainty searchable
A long notes document hides unfinished work remarkably well. A ledger lets me filter for it. I use a small set of labels: checked, needs another source, awaiting clarification, and omit for now.
The labels describe my reporting work, not the character of the interviewee. If I cannot establish a date before publication, leaving it out may be the cleanest choice. A blank in a reporting ledger is often more useful than a guess that looks complete.
Link records without spreading private files
The spreadsheet does not need to contain every recording or document. A short reference to a sensibly named file is enough. I keep sensitive material in a restricted folder and share only what an editor actually needs to review.
Simple software can also flag an empty evidence field or list unresolved rows before a deadline. That is a useful kind of automation: it reminds me to ask a question instead of offering an answer of its own.
Keep the ledger after publication
For a newsletter edition, I save the version used at publication and note later corrections separately. Quietly overwriting the old row makes the history harder to follow.
The result is not a more complicated interview. It is a calmer editing session. When a sentence sounds too certain, I can find its source, adjust its wording, and return to the business with a precise question rather than asking somebody to tell the whole story again.


Top comments (0)