GOSPORTS

A multi-state youth sports events company with tournaments across three regional markets ran its finances on hand-built spreadsheets: expenses double-counted between reports, reconciliation rows leaking into totals, 1099 tracking drifting from payroll reality — no way to trust a number without manually rebuilding it. A prior-year workbook carried a six-figure near-miss from a single reconciliation row read as an expense.

A facts-enter-once architecture: markdown data contracts as the authoring layer and a 36-table Postgres schema where the accounting laws are structural constraints — derived layers are views only, reconciliation rows are excluded from sums by construction, no PII can exist in the roster table. The operating workflow is three buttons — Game Plan, Weekly Sweep, Weekend Close — with a numbered exception queue for every judgment call and a vendor dictionary that learns from each ruling. CI re-proves the pipeline on every commit: smoke tests, seed tie-out, migration parity, schema-page gates. The original Excel deliverables still render — from the database, at zero cell diffs against the delivered workbooks.

Every receipt target ties to the cent on every change: annual expense and revenue grands, a per-weekend wages gate at Δ0 across all 24 weekends, and a balance check with no plug figures. Accountant outputs (1099 master list, itemized paycheck log) and the banking package (debt schedule, financial statement) generate on demand from live data. Decisions from the board land as schema migrations with full verification, not tribal knowledge.