VIP Intelligence Suite
The complete operational platform for casino VIP teams. Model deals before you commit. Run pre-settlement in real time. Track agent commissions to the penny. Manage clawback at the cage. All from one system — no spreadsheets.
Built by casino operations professionals across three phases: deal modelling and portfolio, pre-settlement and clawback, and the full agent/junket module with commission logic, settlement reports, and discount schedules.
Smart Deal Wizard
- 3-step wizard: Client → Objective → Approach (1–5 slider)
- Auto-generates House Favour and Player Favour deal cards
- Approach slider recalculates all values live — margin, rate, threshold, comp
- Full P&L per card: Theo / Commission / Comp / GDC + margin badge
- Risk flags, review cadence, and deal rationale on every card
- Save to portfolio with one click
Manual Deal Builder
- 7 deal types: Cashback · Rebate · DOL · ROL · Hybrid · JV · Agent/Junket
- DOL = Discount on Loss · ROL = Rebate on Loss — both first-class deal types
- Min Avg Bet + Min Hours/Day + Primary Game → turnover derived automatically
- Provisional tier auto-suggested from Front Money (Silver / Gold / Platinum / Diamond)
- Comp % uses tier-assigned rate — not a hardcoded default
- Property Deal Template selector — auto-populates agent commission structure
- Clawback model per deal: Full Repayment / Proportional / Trip-End
- Multi-scenario engine: Low / Expected / Optimistic
Game Speed Engine
- Single source of truth: lib/gameSpeed.ts — decisions/hr + house edge per game
- Baccarat 5% · Baccarat 0% · Roulette · Blackjack · UTH · Casino Poker · Slots
- Turnover = Min Avg Bet × Decisions/Hr × Min Hours/Day × Trip Days
- All house edges from canonical table — no hardcoded values anywhere
- Game speed overrides configurable per property in /settings
Provisional Tier Logic
- Auto-assigns provisional tier from Front Money on new player deals
- Provisional badge (clock icon) vs verified badge (shield icon)
- "Mark verified" removes provisional flag — host confirmed
- Tier thresholds fully configurable in /settings (org-scoped, Supabase-persisted)
- Auto-promote / demote: fires on session close when rolling ADT crosses boundary
- Notification surfaces to host: "Tier adjusted from Silver to Gold"
Pre-Settlement Calculator (4-Panel)
- Panel 1 — The Deal: read-only, loaded from saved deal record
- Panel 2 — Session Data: exactly 3 inputs (Drop, Avg Bet, Hours) — system derives everything
- Player Win/Loss derived from game speed model — positive = house win
- Panel 3 — Qualification & Settlement: all calculated, no inputs
- Qualification badge (Green / Amber / Red) visible at top before scrolling
- When Not Qualified: deal terms suppressed, discretionary-only Panel 4
- Comp budget uses tier-assigned comp %, headroom goes red when exceeded
- Panel 4 — Agent Recommendations: comp options, early cashout, clawback warning
Clawback Engine
- Three models: Full Repayment · Proportional · Trip-End (no clawback)
- Model A: upfront bonus fully repaid if player ends trip in profit
- Model B: proportional recovery — amount × original discount rate
- Model C: trip-end discount only — no clawback needed
- NN chip lifecycle: Issue / Convert / Redeem / Expire — live outstanding balance
- Clawback owed displayed in Panel 3; warning card in Panel 4
- Cage departure checklist: three checkboxes before player departs
- "Mark cage settled" logs to clawback_ledger and transitions deal to settled
Actual Result Tracking
- Pre-settlement and final entry per deal
- GGR · NGR (computed or override) · gaming tax snapshot
- Variance vs model: colour-coded, immediately visible
- Overdue settlement alerts across portfolio
- Full audit trail: who entered results and when
- Deal status lifecycle: Draft → Active → Pre-Settlement → Settled
Portfolio & Group Analytics
- Portfolio-wide P&L: expected vs actual across all deals
- Deal type distribution, margin analysis, concentration risk (HHI)
- Overdue result monitoring across your estate
- Multi-property group dashboard for chains (single login)
- Per-property variance scoring and underperformer identification
- Export-ready outputs via jsPDF
Agent / Junket Module
- Agent profiles: deal model (Commission / JV / Hybrid), cage deposit, airfare, quick pay
- Per-agent qualification matrix — min avg bet, min hands, min hours per game
- Player linkage with full audit trail (linked/unlinked by, timestamps)
- Walk-in players tracked separately with walk-in commission rate
- Qualification check fires in real time during pre-settlement
- Chargeback workflow: unqualified player → deduct from agent cage deposit
Two-Tier Discount Schedules
- Daily + Trip discount tables per agent (chip or cash)
- Unlimited tiers: Min Loss · Max Loss ("No limit") · Discount %
- Previous trip loss credit: 5% applied automatically to returning players
- Fully editable inline with add / remove / reset to defaults
- Persisted org-scoped to Supabase; loaded at runtime
Monthly Agent Settlement Report
- Generates full settlement for any calendar month on demand
- Line-item layout: gross result → expenses → discounts → net profit → commission → walk-in → chargebacks → TOTAL DUE
- Commission: MAX(Theo × theoPct, Actual × actualPct) — capped if applicable
- Cap applied indicator + override-available flag when cap override is allowed
- Approve & Lock: persists to agent_settlements, report becomes read-only
- APPROVED watermark on PDF when locked
- PDF and CSV export from settlement UI
Property Deal Templates
- 14 reference templates (A–N) covering resort, mass market, UHNW, Asia Pacific, Macau, European, Middle East, Latin America, and boutique segments
- Template library UI with card grid — clone, edit, delete (reference templates: clone only)
- Commission calc panel: Theo Path / Actual Path / Cap — three columns side-by-side
- Winning path highlighted; cap applied indicator; active discount tier highlighted
- Player Discount clearly separated from agent payout
- All values update live as actual loss is entered
- Save current values as new custom template
Everything is configurable — per property, per agent
Every key parameter in the system is admin-configurable and persisted org-scoped to Supabase. No hardcoded values. No hidden defaults.
- ·Decisions/hr per game
- ·House edge per game
- ·Effective immediately across all calculations
- ·Front Money → provisional tier brackets
- ·Comp % per tier
- ·Activation threshold override
- ·Qualification matrix per game
- ·Two-tier discount schedules (Daily + Trip)
- ·Walk-in threshold + commission rate
- ·Commission cap + override allowed
Built to production standard
- ·Next.js 14.2 (App Router) · TypeScript 5
- ·Supabase (Auth + Postgres + RLS)
- ·Tailwind CSS · Recharts · jsPDF
- ·Groq — Llama 3.3 70B AI engine
- ·Vercel deployment — auto-deploy on push
- ·All tables RLS-enabled, org-scoped
- ·vip_deals · vip_results · agent_profiles
- ·agent_player_links · agent_settlements
- ·clawback_ledger · nn_chip_lifecycle
- ·trip_discount_schedules · property_deal_templates
Bespoke Enterprise Deployment
VIP Intelligence Suite is deployed as a tailored enterprise solution. Pricing is scoped to your operation — number of properties, team size, agent volume, and deal complexity. Contact us for a consultation and a custom configuration scoped to your casino.
Contact Us for Pricing →