Latest day revenue
——
Private finance workspace
Daily numbers, one operating view.
Enter the shared team password to open the P&L, cohort reporting, and LTV:CAC model.
AES-256 encrypted settings · Shopify-connected reporting
/
Finance OS
Private
Updated —
Finance dashboard
Daily numbers. Clear decisions.
Shopify P&L, cohorts, and LTV:CAC.
Latest month net profit
——YTD net revenue
—Loaded reporting periodsYTD net profit
—After fixed costsTrailing 90d NCAC
—Paid media / new customersYTD MER
—Net revenue / paid mediaD180 contribution LTV:CAC
—Editable planning assumptionsTrend
Monthly revenue and net profit
Operating pulse
Daily net profit
Refresh status
Data sources
Model discipline
What “net profit” means here
Net revenue less product COGS, fulfillment, payment processing, Stay AI, paid acquisition, and allocated fixed operating costs. Taxes and working-capital timing remain outside this operating view.
Daily operating statement
Daily P&L
Newest day first. Shopify is the source of truth for revenue, orders, customers, and products.
Shopify: Connecting to live order data…
—
| Date | Orders | New cust. | Boxes | Net revenue | COGS | Fulfillment | Processing + Stay AI | Ad spend | Contribution | Net profit | Net margin | MER | NCAC | Source |
|---|
Management view
Monthly P&L
Shopify daily actuals roll up automatically with the costs entered in this dashboard.
| Month | Orders | New cust. | Net revenue | COGS | Fulfillment + fees | Ad spend | Gross profit | Contribution | Fixed costs | Net profit | Net margin | MER | NCAC |
|---|
Customer economics
Monthly acquisition cohorts
—
Customer group
Heatmap metric
Segment logic: subscribers have a Shopify selling plan or subscription tag; non-subscribers have neither; one-time only is the non-subscriber subset with one lifetime order. The current month is still developing.
Cohort retention
Percent of the original cohort ordering in each month
| Cohort | Customers | D30 revenue LTV | D60 revenue LTV | D90 revenue LTV | D180 revenue LTV | D180 contribution LTV | CAC | D180 LTV:CAC |
|---|
Acquisition guardrails
LTV:CAC at 30, 60, 90, and 180 days
Contribution LTV uses editable planning assumptions; trailing CAC uses Shopify customers and entered channel spend.
Trailing 90d NCAC—
Payback—
Acquisition & mix
Editable blue fields
AOV by customer type
First order and repeat order
Monthly repeat-order curves
Percent of the original cohort ordering in each month, M1 through M12
Source of truth
Data & assumptions
Shopify supplies sales. This page defines how each SKU and operating cost flows into P&L.
Connecting to Shopify…
Shopify is the sole source for revenue, orders, and customers.
Product economics
SKU → COGS mapping
Catalog price is reference only. Daily revenue uses the amount actually paid on each Shopify order.
| Product / variant | SKU | Shopify price | P&L category | Unit COGS | Status |
|---|
What every number means
Net revenue
Shopify current order total less tax, after discounts, edits, and refunds. Shipping revenue remains included.
COGS
Net line-item quantity × editable unit COGS above. Refunded quantities reduce COGS.
Fulfillment
Orders × shipping per order, plus pick-and-pack per order.
Processing + Stay AI
Payment percentage + per-order fee, plus the optional subscription-order fee.
Contribution profit
Net revenue less COGS, fulfillment, processing, Stay AI, and paid media.
Net profit
Contribution profit less allocated monthly fixed operating costs.
MER / NCAC
Revenue ÷ paid media; and paid media ÷ new customers.
Cohort LTV
Cumulative revenue or contribution from customers grouped by first-order month.
Ad spend CSV
Accepts Meta Daily Spend, Google Billed Cost, or a combined Date + channel file. Re-uploading a weekly or monthly export replaces overlapping dates for that channel without erasing the others.
Stay AI CSV optional
Add customer status data for subscription cohorts and/or dated platform fees.
Add non-Shopify costs for a day
Operating cost assumptions
Security boundary
This matches the existing finance tool’s client-side encrypted gate. It protects the model from casual access and encrypts saved browser data, but it is not a substitute for employee SSO or server-side authorization.