YTD net revenue
—Jan 1, 2026 onward
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.
2026 overviewCalendar-year view
YTD net profit
—After all modeled costsYTD net margin
—Net profit / net revenueYTD NCAC
—Paid media / new customersYTD MER
—Net revenue / paid mediaTrailing 12mo CM2 LTV:CAC
—CM2 before acquisition spendTrend
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…
Subscriber counts are being estimated from Shopify selling-plan orders.
Connecting Meta and Google spend…
—
| Date | Orders | New cust. | Returning cust. | New subs | Active subs | Net revenue | Returning revenue | % rev. returning | COGS | Fulfillment | Processing + Stay AI | CM2 | Ad spend | CM3 | Overhead | Net profit | Net margin | MER | NCAC |
|---|
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 | CM2 | CM3 | Fixed costs | Net profit | Net margin | MER | NCAC |
|---|
Customer economics
Monthly acquisition cohorts
—
Customer group
Heatmap metric
Segment logic: subscribers are customers who have subscribed at any point—including customers who began with a one-time purchase. Non-subscribers are every other customer. CM2 LTV excludes paid media and fixed overhead; the outlined cell marks when it first covers blended CAC. 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 CM2 LTV | CAC | D180 CM2 LTV:CAC |
|---|
Customer economics
Actual all-customer CM2 LTV:CAC and payback
CM2 excludes paid media so CAC is counted once.
$
Quick slider $40–$120 · $5 steps
Payback—
Margin view
Customer group
Actual + projected: D30, D60, D90, and Y1 use actual Shopify and Stay AI cohorts. Y3 is a conservative projection from Y1 using the adjustable post-year-one revenue assumption. The outlined cell is the first month cumulative CM2 covers blended cohort CAC.
Planning model
Total business forecast
Existing customer renewals and repeat orders, plus future acquisition, in one forward P&L.
Forecast view
Next 12 months
Already in the business
Opening customer book
Future renewals and repeat orders from customers acquired before this forecast starts.
Current subscriber base—Stay AI active/paused at forecast start
Subscription run rate—Expected monthly net revenue
Existing repeat customers—Prior buyers eligible to reorder
12-month opening-book CM2—Before future acquisition + overhead
Existing customer book+New customer cohorts−Acquisition + overhead=Total business profit
Opening customers carry no new CAC—their acquisition cost was paid before the forecast starts.
$
Paid media + acquisition creator spend
%
Change applied each forecast month
$
Fixed operating costs after contribution
Months 1–12 new customers—
Months 1–12 net revenue—
Months 1–12 net profit—
Months 1–12 acquisition CAC ceiling—New cohorts only · opening book excluded
Projected total-business amountsExact monthly dollars · months 1–12
Total-business projection combines the opening customer book with future acquisition cohorts and keeps their contribution separate to prevent double-counting CAC.
Subscriber retention waterfall
Percent of each original subscriber cohort ordering in M0–M12
Subscriber CM2 LTV and payback
Cumulative CM2 per subscriber; red is below CAC and green is at or above CAC
Source of truth
Data & assumptions
Shopify supplies sales. Meta and Google supply ad spend. 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.
Saved by calendar month
COGS & overhead assumptions
Choose a month, switch between COGS and overhead, then save. Saved months remain unchanged until edited and resaved.
—Loading saved costs…
SKU COGS for this month
Shopify products and prices are shown beside the editable unit cost in effect for the selected month.
| Product / variant | SKU | Shopify price | P&L category | Unit COGS |
|---|
Overhead for this month
Fulfillment, processing, subscription fees, fixed operating costs, and creator fees.
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 1% of subscription revenue. The fixed $499 Stay AI fee remains in overhead.
CM2
Net revenue less COGS, fulfillment, shipping, processing, and the variable Stay AI fee; excludes paid media.
CM3
CM2 less paid media. Cohort CM3 deducts acquisition CAC once per customer.
Net profit
CM3 less allocated monthly fixed operating costs.
MER / NCAC
Revenue ÷ paid media; and paid media ÷ new customers.
Cohort LTV
Classic LTV:CAC uses cumulative CM2 divided by CAC. The optional CM3 view shows CM2 less CAC rather than dividing by CAC again.
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.
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.