GameRun · Finance Operations Playbook

Finance Dept.
Reconciliation & Reporting

Operating procedures · v1.0

How money moves
through GameRun.

A complete reference for the daily, weekly, and monthly rituals that keep payments reconciled, partners paid, and the books reviewable — from a Stripe charge to a partner’s commission statement.

Operational stages
across the lifecycle

Live reconciliation
sheets maintained

Stripe transactions
processed each day

Distinct cadences
from daily to event-led

§ 01 · Data architecture

Where the numbers flow.

Payments enter at Stripe, branch through reconciliation, and fan out into partner-, sport-, and time-based views. The diagram below traces every dependency in the system.

Money source

Metadata source

Reconciliation sheet

Exception flow

§ 02 · The nine stages

Every step, in order.

Tap any stage to expand its full operating definition: data fields, who sees it, dependencies, and where the output lands next. Filter by cadence to focus on a specific rhythm.

01/09

Stripe collects the day’s payments

Approximately four to five customer transactions flow into Stripe across a typical business day — the upstream signal for every downstream sheet in this playbook.

Daily Expand+

What gets captured

Charge ID — Stripe transaction reference
Amount & currency charged to the customer
Stripe fees deducted at source
Customer email & name for identification
Product / price ID tying the charge to a SKU
Timestamp for the reconciliation window

Stakeholders

Stripe (system of record)

Finance team (reads daily)

Customer (initiator)

Flow

Output of Customer checkout

Feeds into Main Stripe Reconciliation Sheet → Mercury payouts (eventually)

02/09

Main Stripe reconciliation sheet

Stripe data is exported and posted into the master reconciliation sheet — transaction details, fees, customer information — serving as the single source of truth for every downstream sheet.

Daily Expand+

Columns maintained

Transaction date & Stripe charge ID
Gross amount charged
Stripe processing fees
Net amount due to GameRun
Customer name, email, geography
Product / report type purchased
Status — succeeded, refunded, disputed

Stakeholders

Finance team (owner)

Founders (occasional review)

Flow

Sourced from Stripe export

Feeds into Mercury Payout Sheet · GRIQ Shared Sheet

03/09

Mercury payout sheet

When Stripe transfers funds into the Mercury operating account, the payout sheet records the calculated payout amount, deductions, and reconciliation against expected net.

Per payout Expand+

Columns maintained

Payout date & Stripe payout ID
Expected payout (sum of net transactions in window)
Actual payout received in Mercury
Variance if any, with reason code
Mercury reference number
Reconciled by & date

Stakeholders

Finance team (owner)

Mercury (banking partner)

Stripe (payout source)

Flow

Sourced from Stripe payouts + Mercury statements

Reconciled against Main Stripe Reconciliation Sheet

04/09

GameRun IQ — confidential sheet

Transaction data from the main Stripe sheet feeds directly into the GRIQ Confidential sheet — enriched with sport classification, commission calculations, and Dub attribution. The internal master view that all downstream sheets derive from.

Daily Expand+

Columns maintained

Payment details — amount, net, date
Customer details — name, contact, geography
Sport — reconciled from internal dashboard
Product / report type purchased
Monthly payment aggregates by sport & product
Partner commissions calculated per transaction
Dub link data — click and conversion attribution
Internal margin after fees and commissions

Stakeholders

Finance team (owner)

Founders & leadership only

Flow

Sourced from Main Stripe sheet + Internal Dashboard (sports) + Dub

Feeds into GRIQ Shared · Partner sheets · Contract tracker · Monthly summary

Operational note The sport column cannot be derived from the Stripe export alone — it must be exported separately from the internal dashboard and reconciled row-by-row against the customer or product ID before any downstream sheet is updated.

05/09

GameRun IQ — shared sheet

A curated, advisor-facing view derived from GRIQ Confidential. Commission figures, margins, and internal attribution data are stripped out — advisors see transaction activity, sport breakdown, and subscription status only.

Daily Expand+

Columns surfaced

Payment details — amount, net, date
Customer details — name, contact, geography
Sport — inherited from GRIQ Confidential
Product / report type purchased
Subscription status — active or cancelled
Acquisition channel where available

Stakeholders

Finance team (owner)

Advisors (read access)

Flow

Sourced from GRIQ Confidential (filtered subset)

Consumed by Advisors for oversight & reporting

06/09

Per-partner commission sheets

A dedicated sheet for each partner, shared only with that partner, categorised by sport. Lists every attributable transaction in the bi-weekly window and the resulting commission owed.

Bi-weekly Expand+

Columns per partner sheet

Transaction date & reference
Customer name (de-identified where required)
Sport — categorisation drives commission tier
Gross transaction value
Commission rate (per partner contract)
Commission owed for the period
Payout status — pending / paid

Stakeholders

Finance team (owner)

The specific partner only

Flow

Sourced from GRIQ Confidential (filtered to partner)

Feeds into Partner Contract Tracker (payment status)

Confidentiality Each partner sees only their own sheet. Cross-partner visibility is never granted. Sport-wise categorisation within each sheet must match the GRIQ Confidential source row-for-row to avoid disputes.

07/09

Refunds & disputes sheet

Every refund issued and every dispute raised is logged in a dedicated sheet at the moment it occurs. Captures the original transaction, the reason, the outcome, and any commission claw-backs that follow.

Event-driven Expand+

Columns maintained

Original transaction ID & date
Event type — refund or dispute
Customer & product involved
Amount affected
Reason — customer-stated or bank-coded
Outcome — won / lost / refunded in full / partial
Commission claw-back if applicable
Resolution date

Stakeholders

Finance team (owner)

Customer success (reason context)

Founders (visibility)

Flow

Triggered by Stripe refund or dispute event

Feeds into Main Stripe sheet (status update) · Monthly Revenue Summary

Note on source list Items #7 and #9 in the original process list both described this sheet; they have been consolidated into a single stage here.

08/09

Partner contract tracker

A weekly-maintained ledger of every active partnership: the contract terms, the commission rate, the payment status, and the next payout window.

Weekly Expand+

Columns maintained

Partner name & primary contact
Sport(s) covered
Contract effective date & term
Commission structure — rate, caps, tiers
Status — active / paused / churned
Last payment — date & amount
Next payout window
Notes — renegotiations, escalations

Stakeholders

Finance team (owner)

Partnerships / BD team

Founders (review)

Flow

Sourced from Contract documents + partner sheets (payment status)

Feeds into Leadership review · Renewal planning

09/09

Monthly revenue summary

The top-of-funnel report. Aggregates all retail signed customers, all retail cancellations, and the resulting net revenue position by month. Maintained regularly throughout the month, then closed at month-end.

Monthly Expand+

Rows tracked

Retail clients signed — count & revenue
Retail clients cancelled — count & lost revenue
Net new revenue for the month
Refunds & disputes impact — from R&D sheet
Partner commission outflow — aggregate
Net retained revenue
Breakdown by sport

Stakeholders

Finance team (owner)

Founders & leadership

Advisors (selected views)

Flow

Sourced from GRIQ Confidential + Refunds & Disputes + Mercury payouts

Feeds into Investor updates · Board materials

§ 03 · Operating rhythm

The cadence at a glance.

Five distinct rhythms keep the finance function in sync — from the daily Stripe pull to the bi-weekly partner reconciliation and the monthly close.

Daily

04 stages

Stripe payment intake (~5/day)
Main Stripe reconciliation
GRIQ Confidential update
GRIQ Shared sheet update

Weekly

01 stage

Partner contract tracker review
Active partnership status check

Bi-weekly

01 stage

Partner commission calculation
Per-partner sheet refresh
Partner payouts dispatched

Monthly

01 stage

Monthly revenue summary
Retail signed / cancelled totals

Event

02 triggers

Mercury payout from Stripe
Refund or dispute raised

§ 04 · Sheet inventory

The seven artefacts.

The complete set of sheets the finance team maintains, with their visibility classification and update rhythm. Use this as a quick-reference index.

Sheet

Cadence

Audience

Visibility

Main Stripe Reconciliation

Daily

Finance, Founders

Internal

Mercury Payout

Per payout

Finance

Internal

GameRun IQ — Shared

Daily

Partners & Advisors

Restricted

GameRun IQ — Confidential

Daily

Leadership only

Confidential

Per-Partner Commission Sheets

Bi-weekly

One sheet per partner

Restricted

Refunds & Disputes

Event-driven

Finance, Founders

Internal

Partner Contract Tracker

Weekly

Finance, BD, Leadership

Internal

Monthly Revenue Summary

Monthly

Leadership, select Advisors

Confidential

How money movesthrough GameRun.

Where the numbers flow.

Every step, in order.

The cadence at a glance.

The seven artefacts.

How money movesthrough GameRun.

Where the numbers flow.

Every step, in order.

The cadence at a glance.

The seven artefacts.

How money moves
through GameRun.

How money moves
through GameRun.