Step 1: Identify the source documents
What to do: Record every file used to create the output, such as vendor_invoices_q1.csv, q4_spend_summary.xlsx, source SQL files, gapminder.csv, or global street-view metadata. Record the deliverables separately, including reports, workbooks, guides, and dashboards.
What success looks like: Every conclusion can be associated with one or more named source files and one specific deliverable.
Common mistake to avoid: Do not verify only the narrative while ignoring the workbook, chart, PDF, or dashboard that contains the final result.
Step 2: Recompute every material figure
What to do: Recalculate reported totals, averages, rates, rankings, and changes directly from the source. For example, summing vendor_invoices_q1.csv produced a Q1 total of $1,284,500.00 across 412 rows.
What success looks like: The recomputed result agrees with the deliverable or is explicitly marked as a failure or partial result.
Common mistake to avoid: Do not treat precision in the displayed number as evidence that the calculation is correct.
Step 3: Verify the denominator and comparison period
What to do: Check that the numerator and denominator use matching definitions and complete periods. In the spend example, Q1 was $1,284,500 and Q4 was $1,147,000, so the correct increase was 12.0%, not 18%; the incorrect result used a Q4 subtotal that excluded Facilities.
What success looks like: The comparison can be reproduced from clearly defined, like-for-like values.
Common mistake to avoid: Do not compare a complete period with a subtotal, partial period, or differently classified category.
Step 4: Trace the claim to the exact source location
What to do: Record the source file, row or field, calculation, deliverable location, and evidence reference. A vendor ranking can be documented as Acme Logistics at $312,000, with Logistics category spend reconciled to $512,000.
What success looks like: Another reviewer can follow the evidence trail without asking the original analyst to explain hidden steps.
Common mistake to avoid: Do not cite only a file name when the claim depends on a specific row, field, cell, or marked passage.
Step 5: Check whether the source supports the inference
What to do: Distinguish an observable figure from a broader interpretation. Software spend of $298,000 was present, including $84,000 in annual prepayments, but the claim that Software grew approximately 30% quarter over quarter failed because no prior-quarter Software figure existed.
What success looks like: Conclusions do not extend beyond what the source can establish.
Common mistake to avoid: Do not convert a plausible explanation into a verified causal conclusion when the source contains only a correlation or incomplete coverage.
Step 6: Classify the evidence status
What to do: Label each result as reported, calculated, implied, partial, unsupported, or failed. Use Pass when the output agrees with a reproducible source calculation, Partial when methodology needs qualification, Fail when the claim is contradicted or incorrectly calculated, and Unsupported when the source cannot establish it.
What success looks like: Reviewers can tell immediately which statements are directly evidenced and which require correction or qualification.
Common mistake to avoid: Do not replace explicit verdicts with vague confidence language that hides the reason for uncertainty.
Step 7: Check the final file and document limitations
What to do: Inspect charts, layout properties, ranges, formatting, missing records, and source coverage. In the RTL dashboard audit, the worksheet property and aggregations passed, while column reversal and chart range failed because the chart omitted the final row.
What success looks like: The final deliverable is both numerically correct and structurally usable, with missing data and limitations clearly documented.
Common mistake to avoid: Do not assume a correct calculation means the finished file is correct in every respect.