Back to Cookbook

True Profit Calculator

Know your real margin per SKU after every hidden fee

Marketplace fees, shipping, returns, and ad spend hide real margin fast. This recipe pulls transaction data from your channels and calculates actual profit per SKU after the costs people usually forget.

House RecipeWork5 min setup

INGREDIENTS

✈️Telegram💬Slack

PROMPT

Calculate true per-SKU profitability across all my sales channels. Pull transaction data from [Shopify/Amazon/WooCommerce/eBay]. For each product, calculate: revenue minus (COGS + marketplace fees + payment processing fees + shipping costs + FBA fees + advertising cost per unit + return costs). My COGS data is in [spreadsheet/provide per-SKU]. Pull ad spend from [Amazon Ads/Google Ads/Meta Ads]. Output: a ranked profitability report showing true net margin per SKU and per channel. Flag any products with negative margins. Show margin trends over the last [3/6/12] months. Export as CSV and send a monthly summary to [email/Telegram/Slack].

How It Works

Your Claw pulls financial data from every platform you sell on —

marketplace fees, payment processing fees, shipping costs, advertising

spend, return costs, and fulfillment fees. It combines this with your COGS

data to calculate true net profit per SKU, per channel, and overall.

What You Get

  • Per-SKU profitability after marketplace, payment, fulfillment, shipping, return, and ad costs
  • Channel-by-channel comparisons
  • Margin trend over time
  • Loss-leader detection
  • Monthly P&L-style summaries across channels
  • Exportable reports for finance review

Setup Steps

  1. Connect your sales channels
  2. Provide your COGS data
  3. Connect ad platforms if you want ad spend folded in
  4. Review the cost mapping so fees land in the right buckets
  5. Verify the first report against a period you already know well

Tips

  • The quality of your COGS data determines whether this is interesting or actionable
  • Include return shipping and write-offs if you want the true picture
  • Ad spend allocation by SKU is imperfect, so document the attribution method
  • Your top-line best seller is often not your best-margin product
  • Review this monthly, not once, because fees and mix drift over time
Tags:#ecommerce#analytics#profitability#accounting#reporting