Gravity Finance OS
Standalone close workspace for publisher economics, source reconciliation, contract terms, credits, and audit-ready finance operations.
Nov-Apr discovery scope
Classified from discovery rules
Needs grant-class waterfall
Stripe-backed operating view
Stripe
Operational advertiser billing/payment objects
QuickBooks sandbox
Sandbox accounting, customers, vendors, and chart of accounts
Google Drive
Publisher agreement folder inventory and text extraction
Plaid sandbox
Bank transaction integration development lane
Rho CSV
Manual cash transaction CSV fallback import
Finance Supabase
Dedicated Finance OS raw records, entity review, audit events, exceptions, and close state
Gravity prod database
Canonical entities, credits, billing state, and event-level spend joins
Redshift
Historical event-level spend verification
| Primitive | Purpose | Included now |
|---|---|---|
| Source sync runs | Track read-only ingestion attempts, cursors, row counts, freshness, and failures | Yes |
| Raw source records | Immutable payload/hash store for Stripe, QBO, Gravity, Drive, Rho/Plaid | SQL blueprint |
| Finance entities | Canonical finance identity layer independent of source naming | SQL blueprint |
| Alias approvals | Human-reviewed mapping from Rho/Drive/XLSX/QBO/Stripe/Gravity | SQL blueprint |
| Audit events | Record every future override, approval, calculation rerun, and close lock | SQL blueprint |
Every source record gets a run ID, hash, cursor, and source trace before it can affect finance outputs.
Aliases, overrides, contract approvals, and close locks are explicit finance events, never silent mutations.
Stripe, QBO, Rho/Plaid, credits, and Gravity spend each have clearly separated source-authority roles.