Sample Label Profit Dashboard: Expenses, ROI, and Worked P&L

Why Sample Labels Need a Profit Dashboard

Gross sales screenshots lie. A pack can “do $4,000” and still lose money after marketplace fees, paid ads, collab splits, and the month of mixing you never priced. A dashboard answers three questions: Which SKUs fund the label? Which channels are worth ads? What is left after real costs?

You do not need ERP software. A disciplined workbook beats a vibes-based “we’ll make it up on the next pack.” All currency figures in the worked example are illustrative.

Spreadsheet Schema

Recommended sheets: SKU, Revenue, Expenses, Ads, P&L_Monthly, ROI_by_SKU.

Expense categories (controlled list)

collab_split | marketplace_fees | payment_fees | paid_ads | freelance_design | freelance_audio | sample_clearance | software_subs | web_hosting | email_tools | storage_backup | legal_accounting | education | misc_variable | misc_overhead

Core Formulas

• Net sales (line) net = gross - fees - refunds
• Collab COGS (if revenue share) collab_cost = net * collab_split_pct (or fixed fee from Expenses)
• Variable costs (SKU) variable = collab_cost + sku_ads + sku_freelance + sku_clearance + other_sku_expenses
• Contribution margin contribution = net_sales_sku - variable
• Contribution margin % cm_pct = contribution / net_sales_sku
• ROI on direct cash roi_pct = contribution / MAX(ads + out_of_pocket_direct, 0.01) — interpret carefully when ads≈0
• ROAS (ads) roas = attributed_net_sales / ad_spend (track attribution honestly)
• Operating profit (month) operating_profit = SUM(contribution_all_skus) - overhead_month
• Effective hourly (SKU) effective_hourly = contribution / hours_invested (log hours or estimate once per release)
• Blended fee rate fee_rate = fees / gross — watch channel drift

In spreadsheets, prefer SUMIFS from Revenue/Expenses into ROI_by_SKU rather than hand-copied totals. Example: net_sales = SUMIFS(Revenue[net], Revenue[sku_id], A2).

Worked P&L Example (Labeled Example Only)

Example label: “Northline Samples,” month of March (illustrative). Two packs live: SKU-A “Chrome Kits” (new), SKU-B “Dust Loops” (catalog). Currency: USD. Not real company results.

Reading the example: SKU-A looks bigger on gross but ads + collab crush contribution; SKU-B’s quiet catalog sales are high-margin. ROI-on-ads for A ≈ 819 / 900 ≈ 0.91 contribution per ad dollar if you naively divide — actually contribution already subtracted ads, so evaluate ROAS on net sales: attributed net ~2,670 / 900 ≈ 3.0 ROAS before collab. Decision: cut weak ad creatives on A, keep B’s light retargeting, and do not kill B just because gross is smaller.

Hours example: 40h on A → effective hourly on contribution 819/40 ≈ $20.5/h before overhead allocation. That number tells you whether the next collab pack is worth your calendar.

Channels, Fees, and Ad Sanity

• Ad rule of thumb If contribution after ads stays negative for two iterations of creative, pause and fix offer/page before more spend.
• Fee rule of thumb If blended fee_rate jumps, check channel mix and new platform pricing.
• Refund rule High refunds on one SKU → QA and preview quality issues (see technical QA guide).

Build the Dashboard in One Afternoon

1. List SKUs and splits
   Every live pack with collab % and release date.
2. Export 90 days of sales
   Each channel CSV into Revenue with consistent sku_id.
3. Enter expenses
   Bank/PayPal export tagged with categories; allocate pack-specific costs.
4. Wire SUMIFS
   ROI_by_SKU and P&L_Monthly pull automatically.
5. Mark one decision
   Kill, fix, or scale exactly one SKU/channel based on contribution — not gross.
6. Schedule monthly close
   Same calendar day: import, categorize, snapshot operating profit.

Common Mistakes

• Celebrating gross Fees, splits, and ads are real. Contribution is the grown-up number.
• Hiding owner labor at $0 forever At least track hours so you see effective hourly.
• Allocating all software to one pack Keep shared tools in overhead unless truly pack-specific.
• No refund column Net sales will be fantasy.
• ROAS without contribution High ROAS with 50% collab split can still be weak.
• Treating example P&Ls as benchmarks Your niche, list, and fees differ. Use the structure, not the sample dollars.

Monthly Close Ritual

On the first business week of each month, lock the prior month: import revenue, categorize expenses, refresh pivots, write three bullets (best SKU by contribution, worst ad waste, one process fix). Quarterly, re-price weak packs or move them to bundle strategy instead of more ad spend.

Connect money to operations with SKU analytics, technical QA, and multi-producer label systems so profit is not accidental.