How to Calculate True Profit on Shopify
By ProfitIQ · Updated · 4 min read
What Shopify’s reports leave out
Shopify’s analytics are built around sales: orders, revenue, customers. It can show a margin where you have entered a cost per item, but most of what separates sales from profit lives outside the store.
- Cost of goods you have not entered, or entered once and never updated when your supplier’s price changed.
- Shipping you actually paid. The amount a customer was charged for shipping is not the amount the courier or label cost you.
- Payment and transaction fees, which differ by gateway, country and plan, and are charged even on orders you later refund.
- Ad spend on Meta, Google and TikTok, which sits in other dashboards entirely.
- Returns and lost goods: a refund gives the customer their money back but does not give you back the courier charge or the stock you cannot resell.
- Currency conversion, if you sell or advertise in more than one currency.
The formula
Work in two layers. First the order, where every cost belongs to a specific sale. Then the period, where ad spend and overheads belong to the month rather than to any one order.
net profit = revenue − cost of goods − shipping you paid − payment and platform fees − discount given − amount refunded
true net profit = profit on all earned orders − ad spend − operating expenses
Leave tax out
Sales tax, VAT and GST are collected for the tax authority. They are not your revenue, so strip them out before you start and never subtract them again afterwards.
Step 1: get the cost of goods right
Use what each unit really cost to land in your warehouse, not the supplier’s invoice price: product, freight, customs duty, insurance and packaging. If you buy the same product at different prices, use a blended weighted-average cost. The landed cost guide walks through both with numbers.
Step 2: use the shipping you paid
Take the courier’s or carrier’s actual charge for each parcel: from the label, the carrier invoice, or the courier’s own tracking data. Surcharges and weight adjustments are real costs. Charging a customer $4 for shipping that cost you $6 is a $2 loss on every order.
Step 3: take the fees the platform really charged
Payment processor fees usually combine a percentage and a fixed amount per transaction, and may be higher for international cards or other currencies. Read them from your payout reports rather than assuming a rate.
Step 4: treat ad spend as a period cost
Ad spend cannot be divided fairly between orders: customers see an ad, return later and buy through another channel. Subtract it for the period and judge campaigns by profit after ads and break-even ROAS. See break-even ROAS explained.
Step 5: count what returns cost
A refund reduces profit by the amount refunded, and a returned parcel usually leaves you paying the courier both ways. If the goods go back on the shelf you recover their cost; if they are damaged you do not. What a return really costs breaks down each part.
A worked example
One Shopify order
- Item price, before discount
- $64.00
- Discount code
- − $4.00
- Cost of goods (landed)
- − $24.50
- Shipping label paid
- − $5.20
- Payment fee
- − $1.85
- Net profit on the order
- $28.45
Illustrative figures. That is 47% of the $60 the customer paid, before ad spend and overheads, which then come off the month’s total.
Doing it in a spreadsheet, or not
A spreadsheet can do all of this for one store at low volume. It gets hard when costs change, when you sell on more than one channel, or when returns and ad spend arrive late. Spreadsheet or profit software says honestly where the line is.
Let the numbers calculate themselves
ProfitIQ connects to Shopify read-only, applies your costs and your courier charges, and shows net profit for every order. The free plan covers 50 orders a month.
Frequently asked questions
What is the difference between gross profit and net profit?
Gross profit is revenue minus the cost of goods only. Net profit also subtracts shipping, fees, discounts, refunds, ad spend and operating expenses. Gross profit tells you whether a product is worth selling; net profit tells you whether the business is making money.
Does Shopify show my profit margin?
Shopify can show a margin for products where you have entered a cost per item. It cannot know your courier charges, your ad spend or the cost of returns beyond the refund itself, so the margin it shows is higher than your true one.
How do I work out profit per order in Shopify?
Start with the order’s revenue excluding tax, then subtract the cost of goods, the shipping you paid, payment fees, any discount and any refund. ProfitIQ does this automatically for every order it syncs from Shopify.
Should ad spend be subtracted from each order?
No. Ad spend belongs to a period and cannot be divided fairly between orders. Subtract it from the month’s profit, and judge each campaign by its profit after ads.