# Northline Workshops — October 2026 results (CAD, tax excluded)

**Status: PROVISIONAL.** One settled October refund (refunds.csv R06 / RF05, order N1011, Course) has no
amount. Per inputs/policy.md ("Empty values are unknown, never zero"; "Missing refund amounts mean the
resulting net revenue is provisional") nothing was subtracted for it, so every Course and Combined figure
marked † below is the *calculable* value and can only go down once RF05 is known. Workshop figures are not
affected by RF05.

## 1. Results

| Measure | Workshop | Course | Combined |
|---|---:|---:|---:|
| Paid order count | 5 | 4 | 9 |
| Gross sales | 1,920.00 | 900.00 | 2,820.00 |
| Applied refunds (settled in October) | 240.00 | 60.00 † | 300.00 † |
| Net revenue | 1,680.00 | 840.00 † | 2,520.00 † |
| Advertising 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 † |

† Provisional: excludes the unknown amount of RF05.

Formulas (inputs/policy.md): net revenue = paid gross − settled October refunds; contribution after
advertising = net revenue − ad spend; net revenue per paid order = net revenue ÷ paid order count.

- Workshop: 1,920.00 − 240.00 = 1,680.00; 1,680.00 − 300.00 = 1,380.00; 1,680.00 ÷ 5 = 336.00
- Course: 900.00 − 60.00 = 840.00; 840.00 − 150.00 = 690.00; 840.00 ÷ 4 = 210.00
- Combined: 2,820.00 − 300.00 = 2,520.00; 2,520.00 − 450.00 = 2,070.00; 2,520.00 ÷ 9 = 280.00

Paid orders — Workshop: N1001, N1003, N1005, N1010, N1012. Course: N1002, N1006, N1008, N1011.

### Range implied by the missing RF05 amount (a bound, not an estimate)

Policy says refunds cannot exceed paid gross. N1011's paid gross is 360.00 (sales.csv S13), so if RF05 is a
valid refund its amount lies between more than 0.00 and 360.00. No value has been assumed.

| Measure | Calculable (RF05 not subtracted) | If RF05 were the maximum 360.00 |
|---|---:|---:|
| Course net revenue | 840.00 | 480.00 |
| Course contribution after advertising | 690.00 | 330.00 |
| Course net revenue per paid order | 210.00 | 120.00 |
| Combined net revenue | 2,520.00 | 2,160.00 |
| Combined contribution after advertising | 2,070.00 | 1,710.00 |
| Combined net revenue per paid order | 280.00 | 240.00 |

## 2. Reconciliation of included and excluded records

| Source file | Raw rows | Included | Excluded | Raw stated amount | Included amount | Excluded stated amount | Blank amounts |
|---|---:|---:|---:|---:|---:|---:|---:|
| inputs/sales.csv (gross_cad) | 15 | 9 | 6 | 4,140.00 | 2,820.00 | 1,320.00 | 0 |
| inputs/refunds.csv (amount_cad) | 7 | 2 | 5 | 960.00 | 300.00 | 660.00 | 1 (R06) |
| inputs/ads.csv (spend_cad) | 7 | 5 | 2 | 630.00 | 450.00 | 180.00 | 0 |

Raw stated amount = included + excluded in every file. Every raw row ID appears exactly once, either as
`row_id` in a cleaned file or as a row in exceptions.csv (which carries the raw and normalized values).

### Sales — excluded rows (sales.csv)

| Row | Order | Category | Gross | Reason |
|---|---|---|---:|---|
| S04 | N1003 | exact_duplicate | 480.00 | Exact duplicate of S03 (same order ID and all fields); collapsed to one order. |
| S05 | N1004 | status_pending | 120.00 | Order status is 'pending', not paid. |
| S08 | N1007 | status_cancelled | 240.00 | Order status is 'cancelled', not paid. |
| S09 | N1008 | superseded_by_later_update | 120.00 | Conflicts with S10 for the same order ID; S10 has later updated_at (2026-10-16T09:00:00 vs 2026-10-15T12:00:00) and gross 180.00, so it is retained. |
| S11 | N1009 | outside_reporting_period | 240.00 | Order date 2026-09-30 is outside 2026-10-01 to 2026-10-31. |
| S15 | N1013 | outside_reporting_period | 120.00 | Order date 2026-11-01 is outside 2026-10-01 to 2026-10-31. |

### Refunds — excluded rows (refunds.csv)

| Row | Refund | Category | Amount | Reason |
|---|---|---|---:|---|
| R03 | RF02 | exact_duplicate | 60.00 | Exact duplicate of R02 (same refund ID and all fields); collapsed to one refund. |
| R04 | RF03 | refund_pending | 240.00 | Refund status is 'pending', not settled. |
| R05 | RF04 | no_valid_paid_order | 120.00 | Order N9999 does not appear in sales.csv, so the refund cannot be matched to a valid paid order or a product. |
| R06 | RF05 | missing_refund_amount | blank | Settled October refund against valid paid order N1011 (Course, gross 360.00) has an empty amount. Amount preserved as blank (unknown, not zero). |
| R07 | RF06 | settled_outside_reporting_period | 240.00 | Settlement date 2026-11-02 is outside October 2026. |

### Ads — excluded rows (ads.csv)

| Row | Ad | Category | Spend | Reason |
|---|---|---|---:|---|
| A04 | AD03 | exact_duplicate | 100.00 | Exact duplicate of A03 (same ad ID and all fields); collapsed to one ad. |
| A07 | AD06 | outside_reporting_period | 80.00 | Ad date 2026-11-01 is outside October 2026. |

### Included rows

| Sales row | Order | Date / product | Gross |
|---|---|---|---:|
| S01 | N1001 | 2026-10-02 Workshop | 240.00 |
| S02 | N1002 | 2026-10-03 Course | 120.00 |
| S03 | N1003 | 2026-10-05 Workshop | 480.00 |
| S06 | N1005 | 2026-10-10 Workshop | 240.00 |
| S07 | N1006 | 2026-10-11 Course | 240.00 |
| S10 | N1008 | 2026-10-15 Course | 180.00 |
| S12 | N1010 | 2026-10-20 Workshop | 720.00 |
| S13 | N1011 | 2026-10-22 Course | 360.00 |
| S14 | N1012 | 2026-10-31 Workshop | 240.00 |

| Refund row | Refund | Order / product / settled | Amount |
|---|---|---|---:|
| R01 | RF01 | N1003 Workshop 2026-10-09 | 240.00 |
| R02 | RF02 | N1006 Course 2026-10-14 | 60.00 |

| Ad row | Ad | Date / product / channel | Spend |
|---|---|---|---:|
| A01 | AD01 | 2026-10-03 Workshop Search | 150.00 |
| A02 | AD02 | 2026-10-04 Course Social | 90.00 |
| A03 | AD03 | 2026-10-10 Workshop Social | 100.00 |
| A05 | AD04 | 2026-10-17 Course Search | 60.00 |
| A06 | AD05 | 2026-10-28 Workshop Search | 50.00 |

Policy flags checked and not encountered: no unmapped products (all rows map to Workshop or Course), and no
applied refund exceeds its order's paid gross (RF01 240.00 vs N1003 480.00; RF02 60.00 vs N1006 240.00).

## 3. Recommendation

1. **Do not finalize October until RF05's amount is obtained** from the payment/refund system (refunds.csv
   R06). Each dollar of RF05 lowers Course and Combined net revenue and contribution one-for-one, by up to
   360.00.
2. **Do not move ad budget between products on this month's figures.** On the calculable numbers the two
   products are identical per ad dollar: net revenue ÷ ad spend is 5.60 for Workshop
   (1,680.00 ÷ 300.00) and 5.60 for Course (840.00 ÷ 150.00);
   contribution ÷ ad spend is 4.60 for both. RF05 can only lower the Course side.
   These ratios are my supplementary arithmetic, not policy-defined measures; they rest on 9 orders and
   on the policy's product-level attribution of spend, which does not show that the ads caused the orders.
3. **Look into Workshop refunds before scaling Workshop spend.** Besides the 240.00 applied in October
   (12.5% of Workshop gross), two more refunds against October Workshop orders are outside
   this month's result: RF06, 240.00 on N1012, settled 2026-11-02 (it will reduce November's net revenue),
   and RF03, 240.00 on N1005, still pending. If RF03 also settles, 720.00 of
   1,920.00 October Workshop gross (37.5%) will have been refunded.
4. **Trace refund RF04** (120.00, refunds.csv R05): its order N9999 is not in sales.csv. It is excluded as
   policy requires; if it turns out to belong to a valid paid October order missing from the export, October
   net revenue would be lower by that amount.
5. **Fix the exports at source**: one duplicated order row (S04), one duplicated refund row (R03), one
   duplicated ad row (A04) and one order with two conflicting gross values (N1008: S09 120.00 vs S10 180.00).

**This is contribution after advertising, not profit.** inputs/policy.md states that no COGS, payment fees,
salaries or overhead are supplied. The 2,070.00 (provisional) is what October sales left over after
refunds and advertising to cover those unsupplied costs; whether the business made a profit cannot be
determined from these inputs.

## 4. Assumptions and limitations

- The sales `date` column is used for the October test (policy does not name the column). No retained order
  would change status under `updated_at` instead.
- For exact duplicates the first row ID is retained (S03, R02, A03) and the later one excluded (S04, R03,
  A04); the choice does not affect any value. "Exact duplicate" means all raw fields other than row_id match.
- Cleaned files contain only records that enter the totals. Excluded and unresolved rows, including R06
  with its blank amount preserved, are in exceptions.csv with raw and normalized values.
- `order_product` in cleaned-refunds.csv is derived from the matched order in cleaned-sales.csv; refunds.csv
  has no product column. RF04 (N9999) therefore has no product and is not assigned to one.
- Ad channel is normalized to trimmed title case (Search, Social); product to Workshop/Course.
- Deduplication and latest-`updated_at` selection are applied before status and period tests.
- The RF05 range and the per-ad-dollar and refund-share figures are supplementary calculations.

## 5. Checks performed (by output/reconcile.py, all passed on this run)

- sales.csv: every raw row ID appears exactly once in the cleaned file or exceptions.csv (9 + 6 = 15)
- refunds.csv: every raw row ID appears exactly once in the cleaned file or exceptions.csv (2 + 5 = 7)
- ads.csv: every raw row ID appears exactly once in the cleaned file or exceptions.csv (5 + 2 = 7)
- Workshop + Course = Combined for gross
- Workshop + Course = Combined for ref
- Workshop + Course = Combined for ads
- Workshop + Course = Combined for net
- Workshop + Course = Combined for contrib
- Workshop + Course = Combined for order count
- sales.csv: raw stated amount 4140.00 = included 2820.00 + excluded 1320.00 (blank amounts: 0)
- refunds.csv: raw stated amount 960.00 = included 300.00 + excluded 660.00 (blank amounts: 1)
- ads.csv: raw stated amount 630.00 = included 450.00 + excluded 180.00 (blank amounts: 0)
- No applied refund exceeds its order's paid gross
- All cleaned dates fall in 2026-10-01..2026-10-31
- All cleaned order/refund/ad IDs are unique
