Task 1 complete. All deliverables are in `output/`.

## Results (October 2026, CAD — provisional)

| Metric | Workshop | Course | Combined |
|---|---:|---:|---:|
| Paid orders | 5 | 4 | 9 |
| Gross sales | 1,920.00 | 900.00 | 2,820.00 |
| Applied refunds | 240.00 | 60.00 | 300.00 |
| Net revenue | 1,680.00 | 840.00 | 2,520.00 |
| Ad spend | 300.00 | 150.00 | 450.00 |
| Contribution after ads | 1,380.00 | 690.00 | 2,070.00 |
| Net revenue / paid order | 336.00 | 210.00 | 280.00 |

Provisional because settled refund RF05 (refunds.csv R06) has a missing amount — preserved as unknown, never zero, per policy.

## Handoff

**Output files**
- `output/cleaned-sales.csv` — 9 paid October orders (source row IDs preserved; S03;S04 collapsed, S10 kept over S09 per latest `updated_at`)
- `output/cleaned-refunds.csv` — 2 applied refunds (RF01, RF02; product inherited from linked order)
- `output/cleaned-ads.csv` — 5 October ads (AD03 duplicate collapsed, channels normalized)
- `output/exceptions.csv` — 13 entries covering all duplicates, the superseded conflict, and every exclusion/flag (pending, cancelled, out-of-period, orphan order N9999, missing refund amount)
- `output/summary.md` — full reconciliation, method, assumptions, recommendation (resolve RF05/RF04 first; cautious Workshop budget tilt; contribution ≠ profit since COGS, fees, salaries, overhead are not supplied)
- `output/reconcile.py` — reproducible script (stdlib only), identical to the executed version

**Checks actually performed**
- Ran the script; assertion passed: all 29 raw row IDs accounted for exactly once across cleaned provenance + exclusions (15 sales, 7 refunds, 7 ads)
- Hand-calculated totals independently — matched script output
- Verified both applied refunds ≤ their order's paid gross (240≤480; 60≤240)
- Read back all four output CSVs line by line; fixed two issues found during checks (row-ID accounting logic for collapsed duplicates; duplicate-detail wording)
- Raw inputs untouched (only read; sizes listed post-run)

**Remaining limitations**
- Net revenue/contribution provisional until RF05's amount is recovered (combined floor 2,040.00 if RF05=360.00 cap and RF04=120.00 proves valid)
- RF04's order N9999 is absent from sales data — needs source-system follow-up, not resolvable from inputs
- No causal ad-attribution or cost data; refund product attribution assumed from linked order (documented in summary.md)
- Only Task 1 inputs were supplied; no site/ exists for a Task 3

**Estimated human finish time:** ~20–30 minutes (review exception dispositions, confirm RF05/RF04 externally, sign off) — an estimate, not a measured result.