How to Calculate True Profit on Shopify (COGS + Ads + Fees)
True profit on Shopify is your total revenue minus COGS, platform fees (typically 2.9% + $0.30 per transaction), payment processing fees, shipping costs, returns/refunds, and advertising spend. Most Shopify sellers only track gross revenue, missing 15–30% of hidden costs that silently erode their margins.
If your Shopify dashboard says you made $10,000 last month, your actual take-home after all deductions might be closer to $5,500–$7,000. The gap is not a rounding error — it is the accumulation of dozens of costs that Shopify never surfaces in its default analytics. This guide walks you through every hidden cost category, teaches you the formulas that matter, and shows you how tools like ProfitIQ can automate the entire calculation in real time.
What costs does Shopify not show you?
Shopify’s built-in reports are designed around gross revenue and gross profit — the number before the painful deductions. Here is what gets left out of every default Shopify report:
- Payment processing fees— Shopify Payments charges 2.9% + $0.30 per online transaction (higher for international cards). If you use a third-party gateway, Shopify adds an additional 0.5%–2.0% transaction fee on top of whatever your gateway charges.
- App subscription costs — The average Shopify store runs 6–12 paid apps costing $50–$500/month collectively. Review apps, upsell tools, email marketing platforms, and analytics plugins all chip away at margin.
- Shopify plan fees — Your monthly plan ($39–$399 or Shopify Plus at $2,300+) is a fixed operating cost that most sellers forget to factor into per-order profitability.
- Theme and development costs — Premium themes ($180–$380), custom Liquid development, and design work are sunk costs that should be amortized across your order volume.
- Shipping label costs and carrier surcharges — Even if you use Shopify Shipping, dimensional weight adjustments, fuel surcharges, and residential delivery fees often exceed your estimated rates.
- Returns and refund processing — Shopify refunds the customer but does not refund your payment processing fee. A $100 refund still costs you ~$3.20 in irrecoverable fees.
- Currency conversion fees — Selling internationally? Shopify Payments adds a 1.5% currency conversion fee on top of the exchange rate spread.
When you add all of these together, the “hidden” cost layer typically represents 8–15% of gross revenue — before you even account for COGS or advertising. This is why sellers who only look at the Shopify dashboard believe they are profitable when they are actually losing money on certain products or channels.
How do you calculate COGS for each product?
Cost of Goods Sold (COGS) is the single largest expense for most e-commerce businesses, yet it is also the most frequently miscalculated. The mistake most sellers make is using the supplier invoice price as their COGS. The real number is the landed cost — the total cost to get that product into your warehouse, packaged, and ready to ship.
Landed Cost Formula:
Landed Cost = Product Cost + Freight/Shipping to Warehouse + Customs Duties + Insurance + Packaging Materials + Labeling/Prep Labor
Let’s say you source a phone case from Alibaba for $1.20/unit. But by the time it reaches your warehouse:
- Product cost: $1.20
- Sea freight (per unit): $0.35
- Customs duty (8%): $0.10
- Freight insurance: $0.03
- Poly bag + branded insert: $0.18
- Prep labor (per unit): $0.08
- True landed cost: $1.94 — 62% higher than the invoice price
If you are pricing based on the $1.20 invoice cost and targeting a 3× markup ($3.60 selling price), your real margin on a $3.60 sale is $1.66 — not $2.40. That is a 31% margin overestimation. Multiply this error across thousands of orders and you can see why so many Shopify stores are “growing revenue” while their bank account says otherwise.
In ProfitIQ, you enter the full landed cost per SKU once, and every order automatically deducts the correct COGS — including variant-level cost differences (e.g., the XL version costs $0.15 more in fabric).
What is the difference between gross profit and true net profit?
These two numbers tell very different stories about your business health. Most Shopify sellers only see gross profit — and it gives them a dangerously optimistic picture.
Gross Profit:
Gross Profit = Revenue − COGS
Example: $10,000 revenue − $3,500 COGS = $6,500 gross profit (65% margin)
True Net Profit:
Net Profit = Revenue − COGS − Platform Fees − Payment Processing − Shipping − Returns − Ad Spend − Software/Apps
Example: $10,000 − $3,500 − $350 − $320 − $800 − $400 − $2,200 − $280 = $2,150 net profit (21.5% margin)
The seller in this example thinksthey have a 65% margin. The reality is 21.5%. That 43.5-point gap is where businesses silently bleed cash. It is also the gap that makes the difference between a store that can reinvest and scale, and one that runs out of working capital despite “record sales.”
The most dangerous scenario is when true net profit is negative on specific products but positive on others — and you cannot see which is which because your tracking is done at the store level, not the SKU level. ProfitIQ breaks this down to the individual order and product level so you can kill unprofitable SKUs before they drain your cash.
How does ad spend affect your real profit margin?
Advertising is typically the second-largest cost after COGS, and it is the most volatile. A product that is profitable at a $5 CPA becomes a cash incinerator at $12 CPA — and CPAs can shift that dramatically within a single week on Meta Ads or Google Ads.
The standard metric sellers use is ROAS (Return on Ad Spend):
ROAS = Revenue from Ads ÷ Ad Spend
A 4× ROAS means you generated $4 in revenue for every $1 spent on ads. But here is the critical insight: ROAS does not tell you if you are profitable. If your true margin (after COGS + fees + shipping) is only 30%, then you need a minimum ROAS of 3.33× just to break even on ad-driven sales.
Here is how to calculate your break-even ROAS:
Break-Even ROAS = 1 ÷ (True Margin % after all costs except ads)
If your pre-ad margin is 30% → Break-even ROAS = 1 ÷ 0.30 = 3.33×
If your pre-ad margin is 50% → Break-even ROAS = 1 ÷ 0.50 = 2.00×
The problem gets worse with multi-channel attribution. A customer might click a Meta ad, then a Google retargeting ad, then buy via an organic search. Both Meta and Google claim credit for the sale, and if you add their reported revenue together, you double-count revenue and massively overstate your ROAS.
Platforms like TikTok Ads are even more opaque — their attribution windows and view-through conversions can inflate reported performance by 30–80%. The only reliable source of truth is your actual order data matched against actual ad spend — which is exactly what ProfitIQ’s ad integration does automatically across Meta, Google, and TikTok ad accounts.
How to automate profit tracking instead of using spreadsheets
Most sellers start with a Google Sheet or Excel workbook. It works for the first 50 orders. Then it becomes a second job. Here is the typical progression:
- Month 1–3: You manually enter each order, COGS, and shipping cost. Takes 30 minutes/day. Feels manageable.
- Month 4–6:You build formulas for auto-calculation. One broken VLOOKUP silently miscalculates 200 orders. You don’t notice for 6 weeks.
- Month 7–12:You hire a VA to update the sheet. They miss ad spend changes, forget to update COGS when your supplier raises prices, and use last month’s shipping rates.
- Month 12+: The spreadsheet is 15 MB, takes 45 seconds to load, and nobody trusts the numbers anymore.
Automated profit tracking tools like ProfitIQ solve this by connecting directly to your Shopify store (or WooCommerce, or Daraz) and pulling every order, fee, and transaction in real time. You set your COGS per product once, connect your ad accounts, and the system calculates true net profit for every single order automatically — no formulas, no VAs, no stale data.
The key advantages of automated tracking over spreadsheets:
- ✓ Real-time accuracy — Fees and costs update as they happen, not when you remember to enter them
- ✓ Per-order granularity — See profit on every single order, not just monthly totals
- ✓ SKU-level P&L — Know exactly which products make money and which ones burn it
- ✓ Ad spend attribution — Automatically allocate ad costs to the orders they generated
- ✓ Zero formula risk — No broken VLOOKUP, no stale references, no human data entry errors
- ✓ Multi-store consolidation — One dashboard for all your stores and channels
If you are spending more than 2 hours per week on manual profit tracking, you are spending more on the tracking itself than the tool would cost. Check out our full comparison of ProfitIQ vs Excel tracking for a detailed breakdown.
Frequently Asked Questions
▶How does ProfitIQ calculate profit?
ProfitIQ calculates true net profit by automatically deducting COGS, platform fees, payment processing fees, shipping costs, returns/refunds, and advertising spend from your gross revenue — in real time, for every single order. It connects directly to your store and ad accounts so there is zero manual data entry.
▶What costs does Shopify not show you?
Shopify does not deduct payment processing fees (2.9% + $0.30 per transaction), third-party app subscriptions, transaction fees on non-Shopify Payments gateways, packaging costs, shipping carrier surcharges, or ad spend from your reported revenue figures. These hidden costs typically account for 8–15% of gross revenue.
▶What is the difference between gross profit and true profit?
Gross profit is revenue minus COGS only. True profit (net profit) subtracts all operating costs including platform fees, payment processing, shipping, returns, ad spend, and software subscriptions. The gap between the two is typically 15–30% for e-commerce sellers — meaning your real margin is significantly lower than what gross profit suggests.
▶Can I track profit from multiple stores in one dashboard?
Yes. ProfitIQ supports multi-store profit tracking across Shopify, WooCommerce, and Daraz from a single unified dashboard, with per-store and per-product margin breakdowns. You can view consolidated P&L or drill down into individual store performance.
Stop guessing. Start tracking true profit.
ProfitIQ connects to your Shopify store in under 2 minutes and shows you real-time, per-order net profit — no spreadsheets, no formulas, no guesswork.
Start Your Free Trial →