How to Track Profit Per Product on Etsy (Without a Spreadsheet)

Why Revenue Tells You Almost Nothing

When Etsy sellers talk about how their shop is doing, they almost always talk about revenue. "$3,000 last month." "My best month ever — $8,000." Revenue is easy to see. It is the number on your dashboard. It is what you tell your friends when they ask how the shop is going.

But revenue has no relationship to how much money you actually made. A shop doing $8,000 in revenue with 40% effective costs is clearing $4,800. A shop doing $4,000 in revenue with 15% effective costs is clearing $3,400. The first shop has twice the revenue and only $1,400 more in actual money. If the first shop's owner is working twice as many hours, they are earning less per hour of their time.

This is why profit per listing — not total revenue — is the metric that actually tells you how to run your Etsy business. Once you know which listings generate profit and which consume it, every decision becomes clearer: what to promote, what to reprice, what to discontinue, and where to spend your limited hours.

The COGS Calculation Most Etsy Sellers Get Wrong

COGS stands for Cost of Goods Sold — the direct costs attributable to producing and selling a specific item. Most sellers undercount their COGS in at least three ways:

1. They Forget Packaging Materials

The mailer, the tissue paper, the sticker, the thank-you card, the bubble wrap, the branded box — these are real costs on every single order. For a physical product seller, packaging often runs $1.00–$3.00 per order. On a $25 item, that is 4–12% of the sale price before a single Etsy fee is paid. Most sellers either forget to track this or mentally round it to zero.

2. They Forget the Listing Renewal Fee Per Sale

Every time a unit sells on Etsy, the listing is automatically renewed at $0.20. This is separate from the periodic listing renewal charged every four months. It happens on every single transaction. For a shop selling 200 units a month, that is $40/month — $480/year — in listing fees that often never make it into a seller's COGS calculation.

3. They Forget Transaction Fees on Shipping

Etsy's 6.5% transaction fee applies not only to the item price but to the shipping amount the buyer pays. If you charge $6 for shipping on a $30 item, your transaction fee is calculated on $36, not $30. The extra $0.39 per order from shipping adds up. For a seller doing 150 orders/month with $6 shipping, that is an extra $58.50/month in underestimated transaction fees.

4. They Forget the Time to Photograph and List

A new listing on Etsy requires photos, a title, tags, a description, pricing, and inventory management. For a well-optimized listing, that is 45–90 minutes of work. Amortized over the lifetime units sold from that listing, this labor cost per unit may be pennies — or it may be dollars if the listing sells slowly. Many sellers never account for it at all.

Full COGS Calculation: Worked Example for a Handmade Candle

Let us build a complete COGS from scratch for an 8 oz hand-poured soy candle, priced at $34 with free shipping (shipping cost built into price at ~$5.50 average).

Now the Etsy fees on a $34 sale with no offsite ads:

Net profit per unit: $34.00 − $26.52 COGS − $3.48 fees = $4.00 net profit (11.8% margin).

If this order came through an offsite ad at 15%: additional $5.10 fee, netting −$1.10 per unit. A loss.

The Winner/Loser Matrix: Your Decision Framework

Once you have real profit-per-listing data, you need a framework to act on it. Here is the 2x2 grid that every Etsy seller should use to categorize their listings:

The power of this framework is that it converts raw data into four specific, actionable decisions. Without the data, all four quadrants look the same on your Etsy dashboard — they are just listings. With per-listing profit data, the right move for each one becomes obvious.

The Spreadsheet Tax: What Manual Tracking Actually Costs You

Many sellers who want to track per-listing profit turn to Google Sheets. It is free, flexible, and familiar. It is also the wrong tool for ongoing profit tracking in a live Etsy shop, for a specific reason: it requires manual data entry that scales with your order volume, not with your effort budget.

Here is a realistic time breakdown for manually calculating per-listing profit in a 50-listing shop doing 150 orders/month:

3.25 hours is almost a half-day of work, every month, to produce a number you should already know at a glance. And that estimate is for a 50-listing shop. Scale to 150 listings and 400 orders/month and the spreadsheet becomes a part-time job.

The spreadsheet is not bad math — it is the wrong tool. A spreadsheet is designed for one-time analysis. Per-listing profit tracking is an ongoing, real-time need. Every new order changes your numbers. A static spreadsheet you update monthly is already out of date the moment you close it.

Step-by-Step: How to Track Profit Per Listing on Etsy Without a Spreadsheet

Step 1: Calculate Your COGS for Every Listing

Use the template from the candle example above. For each listing:

• List every material input and its per-unit cost at your current purchase rate
• Add packaging materials (box, tissue, mailer, labels, inserts)
• Add your actual shipping cost (if you build it into the price)
• Add $0.20 for the Etsy listing renewal per sale
• Add labor time × your hourly rate (be honest — most handmade items take longer than you think)
• Amortize photography and listing time across expected units sold

Do this once per listing. Update it when material prices change (quarterly is a good cadence).

Step 2: Enter Your COGS Into a Profit Tracking Tool

Connect your Etsy shop to a tool that reads your order data automatically. Enter your per-listing COGS once, and let the tool apply it to every order automatically. The tool should also calculate all Etsy fees — transaction, processing, offsite ads — per order, without you manually extracting those from CSVs.

Step 3: Review Per-Listing Profit Weekly, Not Monthly

Monthly reviews catch problems 30 days after they started. Weekly reviews let you catch a repricing issue, a sudden spike in offsite ads attribution, or a cost increase from a supplier within days. The goal is not more analysis — it is faster detection of problems and opportunities.

Step 4: Apply the Winner/Loser Matrix Monthly

Once a month, sort your listings by profit margin. Apply the four-quadrant framework. Make one specific decision for each listing that is not performing: reprice, promote, or delete. Do not let underperforming listings sit unchanged because changing them feels risky. Keeping a loss-making listing active is a guaranteed loss. A change has at least the possibility of improvement.

Step 5: Monitor Your Offsite Ads Attribution Rate

In your Etsy payment account, you can see which orders were tagged as offsite-ads orders. Track what percentage of your total orders this represents each month. If it is climbing, your effective fee rate is climbing with it. Use this to decide whether to adjust your prices proactively.

Common Mistakes That Make Your Per-Listing Data Unreliable

What Good Per-Listing Tracking Looks Like in Practice

A seller with 60 active listings runs a weekly profit review. She sorts by net margin. Her top five listings — three digital SVG files, one printable wall art bundle, and one vintage-style enamel pin — all run above 45% net margin. Her bottom five listings — two complex resin pieces and three heavily-discounted seasonal items — are below 8% net, and two are negative after offsite ads.

Her actions from this data: she raises prices on the two resin pieces by 22%, removes the three seasonal listings (they were cluttering her shop off-season anyway), and runs a $3/day Etsy Ad on her highest-margin digital bundle. She does not change the top performers. The next month, her revenue is flat — but her net profit is up 18% because she stopped subsidizing the loss-makers and put budget behind her winners.

That outcome is only possible if you know the per-listing profit number. Without it, every listing looks equally worthy of your attention. With it, the right decisions are obvious.