I've produced the October 2026 results, but they're **provisional**. Refund RF05 (refunds.csv row R06, order N1011, Course) is marked settled on 25 October but has no amount. Under the policy a blank amount is unknown, not zero, so I left it out of the totals and flagged it. **October 2026 results (CAD, tax excluded):** | Metric | Workshop | Course | Combined | |---|---:|---:|---:| | Paid orders | 5 | 4 | 9 | | Gross sales | 1,920.00 | 900.00 | 2,820.00 | | Refunds applied | 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 advertising | 1,380.00 | 690.00 | 2,070.00 | | Net revenue per paid order | 336.00 | 210.00 | 280.00 | - **Effect of the missing refund:** order N1011 is 360.00, and a refund can't exceed the order, so RF05 is between 0 and 360.00. Combined net revenue would then be 2,160.00–2,520.00 and contribution 1,710.00–2,070.00. Course net revenue would be 480.00–840.00. This is a range, not an estimate. - **Rows reconcile:** - Sales: 15 rows = 9 included + 6 excluded. - Refunds: 7 rows = 2 applied + 5 excluded. - Ads: 7 rows = 5 included + 2 excluded. Every excluded row is listed with its reason in `exceptions.csv`. The exclusions are duplicates, pending or cancelled records, an older version of order N1008, dates outside October, refund RF04 for an unknown order (N9999), and RF05. - **Recommendation:** before closing October, get the RF05 amount and check RF04 (120.00 against order N9999, which isn't in the sales file). Both products more than cover their ad spend. Nine orders in one month isn't enough to justify moving budget between them, so look again after November. - **This is not profit:** the 2,070.00 is net revenue minus ad spend only. It excludes product costs, payment fees, salaries and overhead, which weren't supplied, so it shouldn't be reported as net profit. **Checks done:** - I ran `reconcile.py` and its built-in checks that the row counts add up and that contribution = gross − refunds − ads; they passed. - I worked out all totals by hand separately, and they matched. - I read through all four CSVs the script produced. - I didn't use the browser tool, because Task 3 (the website) isn't in this assignment's prompt. **Assumptions:** slash dates are read as day/month/year, as the policy says. Each refund counts against the product of its order. October is decided by each sale's `date` field, not its `updated_at` time. **Limitations:** with no outside records, I couldn't find the RF05 amount or identify order N9999. The raw input files are unchanged. **Estimated human time to finish:** about 15–25 minutes to get RF05 and RF04 from the payment processor, update the summary and review it. This is a guess, not a measurement. Files are in `output/`: - `summary.md` - `cleaned-sales.csv` - `cleaned-refunds.csv` - `cleaned-ads.csv` - `exceptions.csv` - `reconcile.py`