Margin Breakdown that shows true profit per SKU
Profit AnalysisSee real margin at SKU level. Full cost stack: COGS, fees, shipping. Find quick wins to fix or drop losers.
Your first run is free - no card required.
Profit Analysis Data
Live sync
Auto‑Generated
2 min ago
Coming Q2 2026
📍 Waterfall calculation engine complete, multi-currency support in testing
What's Inside the Excel
Get a ready-to-use file with everything you need
📊
SKU waterfall
Revenue → COGS → fees → shipping → net profit per product
🔍
Fee breakdown
Payment, platform, transaction fees separated by type
💰
Shipping subsidy
Actual carrier cost vs. what customers paid
📋
Quick wins list
Raise prices, drop losers, renegotiate shipping
Available for These Platforms
Platform-specific implementations of this decision kit with unique insights for each
What You'll Get
Real outcomes for your business
⚡
Quick wins ready: Find 5-10 fixes worth $1,000-$3,000/month - raise prices, drop losers
💎
True margin exposed: SKU-level breakdown with fees, shipping, COGS - no hidden costs
🎯
No more vanity: Replace revenue dashboards with honest profit metrics
Is this for me?
✓
Your top-selling SKUs might be losing money after all fees
✓
You offer free shipping but don't know the true cost
✓
You want to see every cost layer - COGS, fees, shipping - per product
How We Calculate True Margin Waterfall
From revenue to net profit, layer by layer
📊
Net Margin %
Definition: (Revenue - COGS - Payment Fees - Shipping Cost - Platform Fees) ÷ Revenue × 100
Source: Order revenue + itemized cost stack
Granularity: Per-SKU, per-category, per-platform
📊
Fee Share of Revenue
Definition: (Total Fees) ÷ Revenue × 100
Source: Payment gateway fees + platform commissions
Granularity: By platform, by product category
📊
Shipping Cost Ratio
Definition: (Actual Shipping Cost - Customer Paid Shipping) ÷ Revenue × 100
Source: Carrier costs vs. shipping charged to customer
Granularity: Per-order, aggregated by zone/carrier
Key Features
Unlock powerful insights with these automated features.
SKU-Level Margin Waterfall
See every cost layer for each product: revenue → COGS → payment fees → shipping → net profit.
Category & Platform Comparison
Compare margin performance across product categories and sales channels to optimize your mix.
Fee Breakdown by Type
Split fees into payment processing, platform commissions, and transaction fees - see where money leaks.
Quick Wins List
Auto-generated action list: raise prices, drop losers, renegotiate shipping, fix fee tiers.
Why Manual Reporting Doesn't Work
Hours spent downloading CSVs, cleaning data, and formatting spreadsheets. Every week, every month, every platform.
The Pain Points
- Manual exports that eat up your time
- Inconsistent formatting between platforms
- Errors from manual copy-pasting
- Data that's outdated the moment you get it
Our Solution
- Fully automated report generation
- Expertly formatted Excel & Google Sheets reports
- Fresh data delivered on your schedule
- Pre-built Report Recipes by e-commerce experts
How It Works
3 simple steps to your first report
1. Connect your store
OAuth2 - no passwords
2. Pick dates
Select your date range
3. Download Excel
Ready in ~30 seconds
Prerequisites
- ✓ At least one e-commerce or marketplace platform
- ✓ Minimum data: 3 months of order history with itemized costs
- ✓ Optimal: 12+ months to detect cost shifts over time
- ℹ️ COGS data strongly recommended; without it, gross margin only; shipping costs pulled from carrier integrations when available
Frequently Asked Questions
What if I don't track COGS?
Upload a CSV mapping SKU to cost, or we can use category average margins. Missing COGS means we can only show gross margin, but still better than nothing.
Do you account for free shipping offers?
Yes - we calculate shipping subsidy (actual carrier cost minus what customer paid, often $0). Shows the true cost of 'free shipping' promos.
How do you handle payment processing fees?
We calculate fees based on your plan tier and payment gateway. Different rates for Stripe, PayPal, platform-native payments, etc.
Can I see margins across multiple sales channels?
Yes - if you sell on multiple platforms, we consolidate margin analysis and show which channels have better economics.
Why Choose Spreadsheet Broccoli?
Start automating your e-commerce reporting today and save hours every week.
🚀
Expert-Built Templates
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
⚡
Lightning Fast Setup
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
📊
Excel & Sheets Native
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
🎯
Playbooks, not just reports
Our report recipes are designed to provide actionable insights and recommendations for your business.
Ready to Reconcile Your Payouts?
Start using Margin Breakdown (Fees - Shipping - COGS) today and turn your data into decisions
No card • Keep the file forever • Cancel anytime