-
Step 1: Identify the original deliverable and its sources
Record the source files, deliverables, claims, calculations, charts, recommendations, date, and scope. For example, connect create_mavenfuzzyfactory_vApril2022.sql and preparing_workbench_vApril2022.sql to the reports that used them.
Success looks like: Every output has a named, accessible source and a defined coverage period.
Common mistake to avoid: Do not audit a conclusion without recording which source data and transformations produced it.
-
Step 2: Recompute every material number
Recalculate totals, percentages, growth rates, ratios, denominators, and derived values independently. A total of $1,284,500 across 412 rows reconciled to the deliverable, but the correct Q4-to-Q1 increase was 12.0%, not 18%, because the original calculation used a subtotal that excluded Facilities.
Success looks like: Your independent result matches the deliverable or produces a documented discrepancy.
Common mistake to avoid: Never accept a plausible result without testing the denominator and period used.
-
Step 3: Verify source traceability
For every important claim, document the source file, row, field, cell, transformation, and location in the final output. The trace should allow another reviewer to reproduce the result without relying on the original AI agent.
Success looks like: A reviewer can answer where the claim came from, how it was transformed, and where it appears.
Common mistake to avoid: A general source citation is not enough when a precise row, field, or cell is available.
-
Step 4: Separate supported claims from unsupported inference
Classify statements as directly observed, correctly derived, reasonable but unproven, unsupported, or dependent on missing data. For example, software spending of $298,000 may be supported, while a claim that it grew 30% quarter over quarter fails if no prior-quarter figure exists.
Success looks like: Facts, calculations, caveats, and hypotheses are visibly distinguished.
Common mistake to avoid: Do not present correlation or a likely explanation as proven causation.
-
Step 5: Test data quality before interpretation
Check missing values, duplicates, invalid values, IDs, joins, negative prices, missing session IDs, missing product IDs, and agreement between line-item sums and order totals. Separate legitimate unattributed records from broken or incomplete records.
Success looks like: You can explain which records are missing or unusual and whether they affect the conclusion.
Common mistake to avoid: Do not interpret a trend until you know whether the underlying dataset is complete enough for that interpretation.
-
Step 6: Validate the deliverable structure and functionality
Inspect the actual artifact, not just the text describing it. In the RTL dashboard example, the setting was enabled, but the primary index appeared in Column B and charts stopped at row 6 even though the table continued to Africa at row 7.
Success looks like: The output satisfies its requested format, layout, chart range, labels, links, and interactive requirements.
Common mistake to avoid: Do not treat a polished appearance as evidence that the artifact is compliant.
-
Step 7: Assign explicit verdicts
Use Pass for correct and supported work, Partial for a correct result with a methodological caveat, Fail for incorrect, unsupported, or noncompliant work, and Warn for a potential issue requiring reviewer attention.
Success looks like: Every material check has one verdict and supporting evidence.
Common mistake to avoid: Do not hide a failed requirement inside an otherwise positive overall summary.
-
Step 8: Produce a concise evidence-backed conclusion
State what passed, what failed, what is partial, what must be corrected, which evidence supports each conclusion, and what limitations remain. A strong verdict might say that source-backed totals reconcile, but the growth rate must be restated as 12.0% and the unsupported software trend claim removed or qualified.
Success looks like: The reader knows exactly whether the work can be published and what remains unresolved.
Common mistake to avoid: Do not issue a vague “mostly accurate” conclusion when specific corrections are available.