Aether Green Executive Dashboard

Shopify orders, Meta ads, GA4 traffic, QuickBooks - built
Bank
-
Chase card
-
Payroll tax
-
Net working capital
-
Compare to:
Net revenue
Orders
Washers sold (automatic)
AOV
Marketing summary (Meta)
Total spend
Attributed revenue
ROAS (attributed / blended)
CPC (Meta)
Site conversion (GA4)
Operational contribution
Per day this window
vs breakeven (period-adjusted)
Cumulative surplus / deficit
Gross profit
Ad spend

Daily net revenue

Top products by revenue (last 90 days)

ProductUnitsRevenue
Sorted: washers first, then combo accessories (filter bag spacers, rinse stations, paddles), then other.

Weekly operational contribution

Bars: contribution = gross profit − ad spend summed per period. Gross profit uses per-SKU COGS (Auto Washer v2 $500, Combo Set $687, Rinse Station $90, Filter Bag Set $97, Manual Washer $100, accessories per UNIT_COGS) and subtracts 3% + $0.29/order payment processing. Weekly buckets (Mon-Sun) up to 90 days; monthly for the 365-day view. Dashed line: breakeven using actual monthly QuickBooks opex for historical months and the $21k/month post-personnel-cut baseline for May 2026 onward. Partial periods render at lower opacity.

Cumulative profitability

Solid: cumulative actual contribution. Dashed: cumulative breakeven target using actual monthly opex (slope steepens in expensive months, flattens after April 15, 2026 cut). Gap above = surplus, below = deficit.

Current month burn rate

MTD fixed OPEX
-
MTD ad spend
-
Total MTD burn
-
Projected full-month
-

Monthly view: ad spend vs operational contribution (trailing 24 months; current month is partial)

Grouped bars per month: Meta ad spend (gold) and operational contribution (green if positive, red if negative). Dashed line: actual monthly fixed opex from QuickBooks (May 2025 - Apr 2026) and the $21k/month forward baseline for May 2026 onward. When the green bar clears the dashed line, the month was operationally profitable.

Monthly fixed operating cost (trailing 24 months)

Fixed operating overhead per month from QuickBooks P&L, excluding COGS, Officers' Salaries / Management Fee, Advertising & Marketing, and payment processing. Solid bars: actual posted opex. Hatched/lighter bars: forecast at the $21k/month forward baseline (post April 2026 personnel cuts). This is the cost base each month's gross profit must clear to be operationally profitable.

Chase business card balance

Chase card snapshot

Latest balance
Utilization
Available credit
of $28,000 limit
Interest paid (window)

Off-platform PayPal revenue

Recent custom orders

DateNoteGross

Meta ad spend & clicks

Top Meta campaigns

CampaignSpendClicks Purch.Attr. rev

GA4 sessions & transactions

Channel mix (sessions, last 90 days)

Cross-functional KPIs

MetricCurrentCompare Δ
Compare column reflects the toggle above (prior period or year over year). YoY shows "—" where prior data didn't exist (e.g. Meta ads only began running in January 2026).