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

Reporting period: 2026-10-01 to 2026-10-31 inclusive, per `inputs/policy.md`
("Northline Workshops accounting note — October 2026"). Sources: `inputs/sales.csv`,
`inputs/refunds.csv`, `inputs/ads.csv`. All amounts CAD.

> **Provisional:** refund RF05 (`refunds.csv` R06, settled 2026-10-25 against paid
> Course order N1011) has a missing amount. Per policy, missing refund amounts make
> net revenue provisional even though a calculable total is given. Course and
> combined net revenue / contribution below are upper bounds within the calculable
> data; Workshop figures are unaffected by RF05.

## Results

| Metric | Workshop | Course | Combined |
|---|---:|---:|---:|
| Paid order count | 5 | 4 | 9 |
| Gross sales | 1,920.00 | 900.00 | 2,820.00 |
| Applied refunds (settled in Oct) | 240.00 | 60.00 | 300.00 |
| Net revenue (provisional for Course/Combined) | 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 |

Definitions per policy: revenue = paid order gross less settled refunds whose
settlement date falls in October (every refund here relates to an October order);
pending refunds are not subtracted; contribution after advertising = net revenue −
ad spend. **This is not net profit** — no COGS, payment fees, salaries or overhead
are supplied.

### Included records (row IDs)

- **Sales (9 paid October orders):** S01 (N1001, 240.00), S02 (N1002, 120.00),
  S03 (N1003, 480.00), S06 (N1005, 240.00), S07 (N1006, 240.00),
  S10 (N1008, 180.00 — latest `updated_at`), S12 (N1010, 720.00),
  S13 (N1011, 360.00), S14 (N1012, 240.00).
- **Refunds applied (2):** R01 (RF01 → N1003, Workshop, 240.00, settled 2026-10-09);
  R02 (RF02 → N1006, Course, 60.00, settled 14/10/2026 = 2026-10-14).
  Refunds are attributed to the product of their paid order. Neither exceeds its
  order's paid gross (240 ≤ 480; 60 ≤ 240), so no refund-cap flags were raised.
- **Ads (5):** A01 (AD01, Workshop, search, 150.00), A02 (AD02, Course, social,
  90.00), A03 (AD03, Workshop, social, 100.00), A05 (AD04, Course, search, 60.00),
  A06 (AD05, Workshop, search, 50.00). Per policy, October ads are attributable to
  the product named in each row.

## Reconciliation of raw rows (every row accounted for)

| Source file | Raw rows | Included | Excluded | Balance |
|---|---:|---:|---:|---|
| inputs/sales.csv | 15 | 9 | 6 | 15 = 9 + 6 ✓ |
| inputs/refunds.csv | 7 | 2 | 5 | 7 = 2 + 5 ✓ |
| inputs/ads.csv | 7 | 5 | 2 | 7 = 5 + 2 ✓ |
| **Total** | **29** | **16** | **13** | ✓ |

Exclusions (full detail and preserved original values in `output/exceptions.csv`):

| Row | Record | Reason |
|---|---|---|
| sales S04 | N1003 | Exact duplicate of S03; collapsed (policy: exact duplicates collapse). |
| sales S05 | N1004 | Status `pending`, not paid (120.00 not counted). |
| sales S08 | N1007 | Status `cancelled`, not paid (240.00 not counted). |
| sales S09 | N1008 | Conflicting row superseded by S10 (updated_at 2026-10-16T09:00 > 2026-10-15T12:00); gross 120.00 replaced by 180.00, not counted twice. |
| sales S11 | N1009 | Order date 2026-09-30, before period. |
| sales S15 | N1013 | Order date 2026-11-01, after period. |
| refunds R03 | RF02 | Exact duplicate of R02; collapsed. |
| refunds R04 | RF03 | Status `pending` (240.00 on N1005); policy says do not subtract pending refunds. |
| refunds R05 | RF04 | Settled 120.00 references order N9999, which does not exist among valid paid October orders; flagged and excluded from calculable total. |
| refunds R06 | RF05 | Settled in October against paid order N1011 but amount missing; flagged, excluded from calculable total, left blank (unknown ≠ zero). Makes net revenue provisional. |
| refunds R07 | RF06 | Settlement date 2026-11-02, outside October (240.00 on N1012 not applied this period). |
| ads A04 | AD03 | Exact duplicate of A03 (same ad_id/date/product/channel/spend); collapsed. |
| ads A07 | AD06 | Ad date 2026-11-01, outside October (80.00 not counted). |

## Cleaning rules applied

- Dates normalized to YYYY-MM-DD: ISO kept; slash dates parsed as **DD/MM/YYYY**
  (S02 `03/10/2026` → 2026-10-03; S07 `11/10/2026` → 2026-10-11; R02 `14/10/2026`
  → 2026-10-14); named-month date S03/S04 `Oct 05 2026` → 2026-10-05. All per policy.
- Money normalized to two decimals; `CAD 240.00`, `$120.00`, `$50.00` prefixes
  stripped. Missing amounts left blank, never treated as zero (R06).
- Product/channel names trimmed and case-folded (` Workshop ` → Workshop,
  `course` → Course, ` Search `/`SOCIAL` → search/social). No unmapped products
  occurred.
- Uniqueness by order_id / refund_id / ad_id per policy. Exact duplicates collapsed
  (S04, R03, A04 — A04 differs from A03 only in row_id, which is a file artifact,
  not ad data). Conflicting sales rows resolved by latest `updated_at` (S09 → S10).
- Cleaned files retain source `row_id`s; `cleaned-refunds.csv` adds a `product`
  column derived from the linked paid order for attribution.

## Assumptions / limitations

1. RF05's amount is unknown; Course/Combined net revenue and contribution are
   provisional and could fall by up to N1011's gross (360.00) if fully refunded —
   the policy caps refunds at paid gross. No amount was guessed.
2. RF04 (120.00, order N9999) is excluded because no valid paid order exists in the
   supplied data; if N9999 is a real order missing from `sales.csv`, October refunds
   would be understated. Needs a data fix, not an accounting guess.
3. Refund product attribution uses the linked order's product (policy ties every
   refund to an October order but does not name a product column on refunds).
4. A03/A04 treated as an exact duplicate despite differing row_id, since ad_id and
   all data fields match and policy makes ad_id unique.
5. Only the supplied files were used; no COGS, fees, salaries or overhead exist in
   the inputs, so profit cannot be computed.

## Recommendation

Workshop generated 1,380.00 contribution on 300.00 ad spend; Course 690.00 on
150.00. Efficiency is currently identical — both return 4.60 of contribution per
ad dollar (1,380/300 and 690/150) and 5.60 of net revenue per ad dollar — so
October's nine orders do not justify shifting budget between products on
efficiency grounds alone. Practical next steps, in order:

1. **Fix the data before deciding anything:** obtain RF05's amount (R06) and
   resolve the orphan refund RF04 → N9999 (R05). Until then Course/Combined net
   revenue is provisional.
2. **Watch known November drags on October orders:** pending RF03 (240.00 on
   Workshop order N1005) and November-settled RF06 (240.00 on N1012) are excluded
   from October per policy, but if RF03 settles it will reduce future-period
   contribution; Workshop's October cohort carries up to 480.00 of known
   pending/later refund exposure.
3. **Scale cautiously:** Workshop earns more per order (336.00 vs 210.00 net), so
   incremental Workshop volume adds more absolute contribution per order at
   current spend efficiency — but with only 5 vs 4 orders, one refund or one large
   order (N1010, 720.00) swings the averages; gather another month before
   reallocating spend.

**Contribution ≠ profit:** the 2,070.00 combined figure deducts only settled
October refunds and October ad spend from paid gross. Instructor time, materials,
platform/payment fees, salaries and overhead are not supplied (policy explicitly
forbids calling this net profit). The business could still be unprofitable at
this contribution level; treat it as an upper bound available to cover those
unsupplied costs.

## Checks performed

- Script `work/reconcile.py` (Python stdlib) produced all CSVs; asserted:
  raw = included + excluded per file (15/7/7); uniqueness of order_id, refund_id,
  ad_id in cleaned files; each applied refund ≤ its order's paid gross;
  per-product and combined arithmetic (gross − refunds = net; net − ads =
  contribution; product sums = combined). All assertions passed.
- Cleaned CSV contents re-read and verified against the tables above.
- Manual spot-check of totals: Workshop gross 240+480+240+720+240 = 1,920;
  Course gross 120+240+180+360 = 900; ads 150+100+50 = 300 and 90+60 = 150.
