# Change log — review of the initial submission

The original submission is preserved unchanged in `output/original-submission-v1/`.

## Corrections and improvements
1. **exceptions.csv:** added two columns, `category` (`excluded_by_policy` / `flagged_unresolved`) and `needs_follow_up` (yes/no). This separates the 2 items that need action (R05/RF04 and R06/RF05) from the 11 routine policy exclusions. Rows, reasons and raw values are unchanged.
2. **summary.md:** corrected a mislabelled assumption. The RF04 bullet was headed "Refund on an out-of-period order"; it now reads "Refund on an unknown order", which matches the evidence (N9999 is not in sales.csv).
3. **summary.md:** added a "How to read the output files" section. It explains the `included`/`applied` flags, notes that cleaned files keep every source row, and states that `raw_value` holds the source amount as written.
4. **summary.md:** the recommendation now notes that Workshop's higher per-order figure comes largely from one 720.00 order (N1010).
5. **summary.md:** added a "Verification performed" section describing only checks that were actually run.
6. **New file `verify.py`:** recomputes all totals independently from the cleaned CSVs. My first handoff said I had worked the totals out by hand. I did that in my reasoning, not with a tool, so it left no record. verify.py replaces that claim with a check that can be rerun.
7. **Handoff wording corrected:** my first handoff said the raw input files were unchanged without having checked them. The scripts only open inputs for reading, and the workspace write tool cannot edit original inputs. In this review I recorded SHA-256 prefixes of the inputs, but there is no earlier baseline to compare them with.

## Confirmed without change
- **All figures match:** every number in the results table and the RF05 range was recomputed by verify.py and matched. The figures are unchanged:
  - net revenue 2,520.00
  - contribution 2,070.00
  - net revenue per paid order 280.00
- **Policy applied correctly:**
  - DD/MM dates: 03/10/2026, 11/10/2026 and 14/10/2026 were all read as October.
  - Latest record kept for conflicting orders: N1008 keeps the 180.00 row, S10.
  - Exact duplicates collapsed: S04, R03 and A04.
  - Pending items excluded: S05 and R04.
  - Period boundaries: S14 (2026-10-31) included; S11, S15, R07 and A07 excluded.
  - The missing RF05 amount was not treated as zero.
