ReturnPro Dashboard
The ReturnPro dashboard at returnpro.optimal.miami is a Next.js financial reporting tool that visualizes budget data, KPIs, and income statements for the ReturnPro operation. It reads from the ReturnPro Supabase instance and provides monthly and annual views with program-level drill-down. The Sales section adds a Pallets For Sale tool at /sales/pallets.
Data Sources
All financial dashboard data comes from the ReturnPro Supabase instance (vvutttwunexshxkmygik.supabase.co):
| Table | Purpose |
|---|---|
stg_financials_raw | Staged NetSuite GL data, including R1 volumes (uploaded via optimal finance upload and optimal finance upload-r1). |
confirmed_income_statements | Confirmed income statement rows (uploaded via optimal finance upload-confirmed). |
dim_account | Chart of accounts with account codes, names, and sign_multiplier. |
dim_program_id | Program dimension (cost centers, business units). |
dim_master_program | Master program dimension (parent grouping for programs). |
dim_client | Client dimension. |
fpa_baseline_units | FP&A baseline units for budget projections. (Renamed from fpa_wes_imports in migration 20260330300000.) |
The Pallets For Sale tool reads its rules and snapshots from a separate Sales (Lovable legacy) Supabase instance (tgysafeenbcosudycymw.supabase.co) — see Pallets For Sale.
Pages
- KPIs — Gross Margin formula, Solution7 canonical formula, sign-multiplier convention.
- NetSuite Template Flow — Six-step monthly close from
generate-templatethroughaudit/diagnose. - Pallets For Sale — Sales tool at
/sales/pallets. Dual-Supabase auth, Rust/WASM streaming XLSX parser. - CLI Commands — ReturnPro-specific CLI commands grouped by workflow.