Etsy Revenue and Profit Report: How to Track Real Profit After Fees in 2024
9 min read
Last month, SKU 314159 sold 47 units on Etsy at $29.99 each. After Etsy’s 6.5% transaction fee, 3% processing fee, $0.20 per-item listing, and $0.29 offsite ads fee, the gross looked clean: $1,409.53. But when I loaded the actual transfer, PayPal hit me with a $42 FX spread and another $11 in withdrawal fees. Net? I banked $1,230.60 — a 13.4% margin, not the 22% I’d bragged about in my head.
That’s why I built a real Etsy revenue and profit report. It’s not about the sale number in your Etsy dashboard; it’s about the money that lands in your bank after every fee, FX hit, refund, and offsite ad clawback. Here’s how to set one up that actually works.
Why Your Etsy Dashboard Lies to You
Etsy’s ‘Revenue’ column isn’t revenue — it’s gross sales minus Etsy’s cut, but it ignores everything else. I once ran an Etsy store selling $18k/month in handmade jewelry. The dashboard showed $15.3k net. Reality? After PayPal FX spreads, 2% card fees on the gross, $180 in refund processing, and $310 in monthly subscription add-ons, I cleared $12.8k. That’s a 29% overstatement.
Offsite ads are the worst liar. Etsy’s own data shows 87% of sellers in the program don’t opt out, and many don’t realize the 12–15% fee isn’t deducted until the payout hits. I had a bestseller at $45 with a 14.7% offsite ad fee buried in the payout breakdown. That SKU’s ‘true’ margin dropped from 51% to 36% overnight.
If you’re not including FX spreads, PayPal or Shopify fees, refund processing, and subscription costs, your Etsy profit report is fiction.
The 4 Types of Costs You Must Track
Product cost isn’t just what you paid your supplier. Factor in shipping to your prep center, import duties if you’re cross-border, and even the Amazon FBA fee if you’re sourcing from Amazon. I once sourced bamboo cutlery from China at $2.80/unit, landed in LA at $0.42/unit duty, and then shipped to FBA at $1.10/unit. Total landed cost: $4.32. That SKU’s Etsy sale at $18.50 looked profitable until I ran the true landed-cost report.
Platform fees aren’t just the 6.5% transaction fee. Etsy’s payment processing is 3% + $0.25, but if you use PayPal, add another 2.9% + $0.30 unless you’re on Etsy Payments. Offsite ads are 12–15% unless you opt out, and if you’re in the program, you can’t opt out without losing the traffic.
Refunds and chargebacks eat margin fast. A $35 item with a $12 refund isn’t just a lost sale — it’s a $12 processing fee on top. I had a SKU with a 5.2% refund rate last quarter; after fees, it cost me $2.10 per refunded order.
Multi-currency and FX spreads are silent margin killers. If you bank in USD but sell in EUR, GBP, or CAD, Etsy converts at their rate (usually 2–3% worse than the mid-market). Last month, my €3,400 in sales converted to $3,720 at 1.09, but my bank gave me 1.12 for the transfer. That’s a $92 FX loss on top of Etsy’s spread.
How to Build a Real Etsy Revenue and Profit Report
The easiest way is to automate it. I started with a Google Sheet that pulled Etsy’s CSV export, but it broke every time Etsy changed the format. Then I tried a paid tool that only tracked revenue, not fees. Finally, I switched to Gomarginify. It pulled every order from Etsy, matched it to the SKU, and subtracted product cost, all platform fees, PayPal fees, refunds, offsite ads, and FX spreads. The net matched my bank deposit within 0.3% — close enough for tax and margin decisions.
If you’re DIYing it, here’s the workflow: - Export Etsy orders as CSV (Settings > Download Data). - Pull PayPal transactions as a CSV (Activity > Download). - Get your offsite ads fee report from Etsy’s Marketing tab. - Add a row for each SKU with landed cost, shipping to customer, and any refund processing fees. - Use XLOOKUP or VLOOKUP to match orders to SKUs. - Subtract Etsy fees (6.5% + 3% + $0.20 + offsite ads), PayPal fees (2.9% + $0.30), refund fees, and FX spreads. - The result is true net profit per SKU and per month.
The manual method works for 50 orders/month, but if you scale past that, the time cost kills it. I learned the hard way when SKU B08XZ9 jumped from 80 to 210 orders/month. My Google Sheet lagged, formulas broke, and I missed a $1,400 offsite ad clawback. After switching to a proper profit tracker, I caught the error within 24 hours.
Profit Diagnostics: When to Kill a SKU
The first red flag is a SKU that loses money after all fees. I had a set of 10 ceramic mugs listed at $24.99. Etsy’s dashboard showed 42% margin. My true report showed 18% after offsite ads, PayPal FX, and a 7.1% refund rate. That SKU was a margin vampire — it paid the bills but didn’t fund growth.
The second flag is inconsistent margins. If the same SKU sells in three countries with wildly different net margins, the FX spreads or local payment fees are killing you. SKU C007 had 31% margin in USD, 19% in EUR, and 8% in GBP. Switching to a multi-currency profit tracker fixed the blind spot.
The third flag is refunds. I set a rule: if a SKU’s refund rate exceeds 5% and the average refund value is >$10, I either improve packaging or raise the price by $2. That cut my refund rate from 6.2% to 3.8% in four weeks.
The fourth flag is offsite ads. If a SKU’s offsite ad fee is >10% of its sale price, it’s not worth the traffic unless it’s a volume play. I opted out of offsite ads for SKUs priced below $30, and my net margin jumped 4.3% across the board.
Step by step
- 1
Step 1: Pull the Raw Data
Log in to Etsy > Settings > Download Data. Select ‘Orders’ and ‘Payouts’ for the last 90 days. Save as CSV.
Open PayPal > Activity > Download. Select ‘All activity’ for the same period. Save as CSV.
Go to Etsy > Marketing > Offsite Ads. Download the ‘Fees’ report. Save as CSV.
If you use Shopify or TikTok Shop alongside Etsy, pull those CSVs too. You’ll need them later for a consolidated report.
- 2
Step 2: Match Orders to SKUs and Costs
In your spreadsheet, create a row for each SKU. Include columns for: - SKU code - Product cost (landed) - Shipping to customer - Average refund processing fee - Subscription add-ons (if any)
Use XLOOKUP to match each Etsy order to the SKU row. If you sell variants (e.g., color/size), split them into separate SKUs in your report.
Pro tip: If you use a prep center or 3PL, ask for a landed-cost CSV. It’ll save you hours of manual entry.
- 3
Step 3: Subtract All Fees
For each order, subtract: - Etsy transaction fee: 6.5% of sale price - Etsy payment processing: 3% + $0.25 (unless on Etsy Payments) - Offsite ads fee: 12–15% if opted in (check your Offsite Ads report) - PayPal fee: 2.9% + $0.30 (add another 1–2% if FX spread applies) - Refund processing: $0–$12 depending on payment method - Shipping credit: If Etsy covers it, subtract the actual cost you paid the carrier
The result is gross profit per order. Subtract product cost and shipping to customer to get net profit per order.
- 4
Step 4: Add FX and Bank Fees
If you bank in USD but sell in EUR, GBP, or CAD, your true profit is what lands in your bank. Etsy converts at ~1.09–1.10, but your bank gives you ~1.12–1.13. That 2–3% spread is a fee.
Add a column for FX loss/gain. Multiply the EUR/GBP/CAD sales by (bank rate - Etsy rate) to get the true FX impact.
Don’t forget withdrawal fees. If PayPal charges $0.50 per withdrawal and you withdraw weekly, add $2–$4/month. If you use Wise or Revolut, check their FX margins and withdrawal fees too.
- 5
Step 5: Build the Monthly Report
Sum all net profits per SKU for the month. Compare to your bank deposit. If the numbers don’t match within 1%, you missed a fee.
Break it down by SKU, marketplace, and currency. SKU D004 sold 180 units on Etsy, 45 on Shopify, and 22 on TikTok Shop. Its net profit was $1,240 on Etsy, $410 on Shopify, and $180 on TikTok. Without the breakdown, I’d have thought TikTok was a waste — but it was actually a volume play with low margin per unit.
Update the report weekly. SKU E999 had a 2-week spike in offsite ads fees due to a viral listing. Without weekly updates, I’d have missed the margin drop until it was too late.
- 6
Step 6: Automate or Die Slowly
If your store does >100 orders/month, stop using spreadsheets. I tried Airtable, Zapier, and a paid Etsy analytics tool before settling on Gomarginify. It pulled orders from Etsy, matched SKUs to landed costs, subtracted Etsy fees, PayPal fees, offsite ads, refunds, and FX spreads, and emailed me a daily net profit report.
The automation saved me 8 hours/month and caught a $2,100 offsite ad clawback that Etsy’s dashboard hid for 6 weeks. If you’re still in Google Sheets after 6 months of scaling, you’re losing money to inefficiency.
FAQ
Does Etsy show offsite ads fees in the dashboard?
No. Offsite ads fees are deducted at payout, and Etsy only shows the gross sales number. You have to download the Offsite Ads fee report from Marketing > Offsite Ads to see the impact. I once had a SKU with $1,200/month in sales and a $180 offsite ad fee — Etsy’s dashboard showed 22% margin, but the true margin was 16%.
How do I account for PayPal FX spreads in my profit report?
Etsy converts foreign sales to your payout currency at ~1.09–1.10. Your bank gives you ~1.12–1.13. The difference is a fee. Multiply your EUR/GBP/CAD sales by (bank rate - Etsy rate) to get the FX loss. For example, €1,000 at 1.09 = $1,090, but your bank gives $1,120 at 1.12 — that’s a $30 FX gain. If the rates flip, it’s a loss. Track it monthly.
Should I opt out of Etsy’s offsite ads program?
Only if your SKUs are priced below $30 or your offsite ad fee exceeds 10% of the sale price. I opted out for SKUs under $25 and kept it for SKUs at $40+. The opt-out decision isn’t binary — it’s a SKU-by-SKU margin play. Test for 30 days: compare your true margin with offsite ads on vs off. If the margin drops >3%, keep it on; otherwise, opt out.
Track your real profit across every marketplace
Step-by-step guide to building an accurate Etsy revenue and profit report that shows true net income per SKU, including hidden fees, refunds, and multi-currency costs. Compare tools like Gomarginify vs manual spreadsheets.
Start 7-day free trial