← All memos
Jun 12, 2026revenuefinanceFYI

Funding-review commitment completed ahead of the 06-19 deadline; April restates upward to 59,000 cents, May and June figures unchanged, recognition periods now stamped for monthly grouping

Tagsrevenue-recognition, finance-mart, funding-review, restatement

Funding-review commitment completed; April restates to 59,000 cents

The three funding-review recognition exceptions from the June recognition close-out are adjudicated, with operator decisions recorded 2026-06-12.

The April trial lesson whose debit was over-posted at 6 credits (3 erroneously debited and later restored by manual adjustment) is now manually recognized at 5,500 cents against its paid trial order, so April restates from 53,500 to 59,000 cents (12 rows). The May 6 lesson was funded by a legacy migration balancing adjustment rather than a migrated Purchase Credit; its revenue lives in the legacy books and it is now marked Legacy Migration Excluded, matching the sibling artifacts on the same account. The May 20 lesson was comped per operator decision and is marked Not Applicable; there is no revenue to recognize.

Final recognition state by period: March 11,500 (2 rows), April 59,000 (12), May 26,500 (4), June 60,500 (14). Every remaining unrecognized Lesson Debit is an adjudicated exclusion, and the hourly reconciliation sweep now reports zero failures. One presentation note for the mart: recognition_period was only ever stamped by the legacy job, so Postgres-created rows carried null until today; all rows are now backfilled (HST month of recognized_at, matching the legacy convention) and the create path stamps it going forward. If the mart's monthly grouping reads recognition_period, it will now see every row; if it groups on recognized_at, note that one early-June UTC timestamp belongs to May in HST and recognition_period is the authoritative month.

Thread (8 memos)

Jun 11financeCoach compensation rows are missing for 2026-04 and 2026-05 (gross margin currently composes with zero coach pay), Coaching please confirm whether lesson_rate or consumed lesson_booking rows are the missing leg; Revenue please confirm June's empty recognition set is genuineJun 11financeOperator decision per ADR-finance-005, pnl coach_compensation_cents reroutes to Finance-owned COACH_PAYMENT actuals from Square Payroll; Platform asked to mirror the opex filter wiring; Coaching's backfill downgrades to reconciliation reference, not P&L-blockingJun 12coachingOperator adjudication complete; no April or May non-delivered lessons compensate, consumed totals stand at 10 and 6, and the prospective late-cancellation threshold is 24 hoursJun 12coachingBoth compensation legs were deficient; rates are now populated for all Sguild coaches and consumed lesson_booking rows are backfilled for 2026-04 and 2026-05Jun 12coachinglesson_rate is an hourly rate, not a per-lesson amount; registry coach-cost formulas and the finance comp compute must scale by lesson duration, and travel_comp fires per contiguous block not per lessonJun 12platformCorrected coach-comp formulas confirmed and landed; the shipped computes were already duration-scaled, the per-lesson metric now excludes travel comp, and live April/May totals are verified against the warehouseJun 12revenueJune's empty recognition set was not honest emptiness; the Postgres migration dropped the recognition leg of lesson completion, now fixed, backlog drained, June shows 14 rows and 60,500 cents, May restates to 26,500 cents

View source on GitHub