Etsy profit per order: what the fees really cost you

The number on an Etsy order is not the number you keep. Etsy profit per order is the sale price plus shipping you charged, minus every fee Etsy takes, minus what the item cost you to make, pack and ship. Most sellers can name their revenue to the dollar and can only guess at the last part. This guide gives a formula you can run in a spreadsheet tonight, and lists the places where profit quietly leaks.

A note on numbers: Etsy changes its fee schedule from time to time, so the rates below are the structure and typical shape, not a promise. Check Etsy’s current fee page before you hard-code any percentage.

The formula

For one order:

Profit = item price + shipping charged to buyer − Etsy fees − shipping label cost − cost of goods − packaging − refunds or discounts

Every term is a real cash movement. The trick is to build each term from a file you already have, instead of from memory.

Where each number comes from

Item price and shipping charged. Download the Orders CSV from Shop Manager. It lists the item total, the shipping you collected, discounts and sales tax, which you should exclude from revenue because it is not yours.

Etsy fees. Download the payment or “Deposits” report. Etsy fees come in several parts, and each one lands on a different line:

• A listing fee per listing, charged when you list and again on renewal or on each sale of a multi-quantity listing.
• A transaction fee, a percentage of the item price and, in many cases, of the shipping you charge.
• A payment processing fee, a percentage plus a fixed amount per order, which varies by country.
• Offsite Ads fees, charged only when an order came from an ad Etsy ran for you. Depending on shop volume it is a percentage of the order total, and it cannot always be turned off.
• Optional Etsy Ads spend if you promote listings, billed separately from order fees.

Shipping label cost. If you buy labels through Etsy they appear in the order data. Labels bought elsewhere, such as from a carrier site or a shipping tool, are in that tool’s export. Match them to orders by order number or tracking.

Cost of goods and packaging. This one does not come from Etsy at all. It is your materials, your supplier price, and the box and filler per order. Keep it per SKU in a small table so you can look it up by listing.

A worked example

Take an order with these figures. They are made up to show the mechanics, not a benchmark:

• Item price: $40.00
• Shipping charged: $6.00
• Transaction fee on $46.00 at 6.5%: $2.99
• Payment processing: 3% of $46.00 plus $0.25 = $1.63
• Listing fee: $0.20
• Shipping label you bought: $7.50
• Materials and packaging: $11.00

Revenue is $46.00. Costs are 2.99 + 1.63 + 0.20 + 7.50 + 11.00 = $23.32. Profit is $22.68, which is 49% of revenue. Now add Offsite Ads at 15% of the order total, $6.90, and profit drops to $15.78, or 34%. Same order, same buyer, and a third of the profit is gone because of how the order arrived. This is why a per-order view matters more than a monthly total.

Four mistakes that inflate margin

1. Counting sales tax as revenue. Marketplace-collected tax is not yours. Exclude it.
2. Ignoring shipping loss. If you charge $6 and the label costs $7.50, every order carries a $1.50 hole. Across hundreds of orders it is real money.
3. Averaging across SKUs. A shop with a 50% margin on average can have two products at 70% and one at 5%. The 5% product is working for Etsy. Only a per-SKU breakdown shows it.
4. Forgetting refunds and the fees on them. A refunded order may not return every fee. Net the refund against the original order, not against the month it was issued.

Doing it per SKU and per channel

If you also sell on eBay, Amazon or Shopify, each channel has its own fee structure, so the same product can have three different margins. The sane approach is one table keyed by order, with columns for channel, SKU, revenue, each fee type, shipping cost and cost of goods, then pivot by SKU and by channel. The hard part is not the maths. It is getting four differently formatted exports into one shape every month.

That is what I am building TrueMargin to do. You drop in the payment, order and shipping files from Etsy, eBay, Amazon and Shopify, and it shows what each order, SKU and channel earned after fees, shipping and cost of goods. Version one reads CSVs, so there is no marketplace API approval to wait for. TrueMargin runs in production but is not open to customers yet, because sign-in email is still being set up. Read more on the TrueMargin product page, or on the local-first Mac version, where files never leave your machine.

If your problem is the payout side rather than the profit side, see how to reconcile a Shopify payout to orders and the bank.

A one-page routine

• Export orders, deposits and label costs every month.
• Keep a per-SKU cost table and update it when a supplier price changes.
• Compute profit per order with the formula above.
• Sort by profit ascending and look at the bottom ten orders. The cause is usually a SKU, a shipping rule, or an ad-driven sale.
• Fix the cause once, in price, shipping or the listing, not order by order.

Profit per order is a boring number, and it is the one that tells you which listings to keep.