How to Track Etsy Profit as a Print Seller: A Monthly P&L That Adds Up

To track Etsy profit, take a month's gross sales and subtract refunds, every Etsy fee (including VAT on those fees), your print and delivery costs, ad spend and your monthly subscriptions. Do it from Etsy's monthly statement and orders export, not your bank deposits. Most print sellers who do this for the first time find their profit is a third or less of the sales figure Etsy shows them.

Why your Etsy sales figure is not your profit

The number on your Etsy dashboard is gross sales. It includes the shipping you charged and ignores everything that comes out afterwards. For a print-on-demand seller, the biggest deductions are:

• Etsy fees. A transaction fee on the item price and shipping, payment processing per order, listing and renewal fees, a regulatory operating fee in some countries, and Offsite Ads on orders that came through Etsy's external advertising. Etsy fees explained goes through each one.
• VAT on Etsy's fees, if you are a UK seller who is not VAT registered.
• Print and delivery. What your print partner charges for the product and postage.
• Refunds and reprints. Money returned to buyers, plus the cost of replacing a print that arrived damaged.
• Etsy Ads. Billed from your balance, so easy to forget.
• Subscriptions and tools. Mockup software, design tools, listing tools, Etsy Plus if you use it.

None of these are hidden, but they arrive on different pages and at different times. A profit figure is just all of them on one sheet, for one month.

Where to find each number

You need three sources for each month:

1. Etsy's monthly statement (Shop Manager, Finances, Monthly statements). This lists sales, refunds, every fee and ad charge, and the VAT charged on fees. It is the single most useful document for profit.
2. The orders CSV (Shop Manager, Settings, Options, Download Data). One row per order, so you can count orders and match each one to its print cost.
3. Your print partner's invoices and the receipts for your subscriptions. These are the costs Etsy cannot see.

Use the date the order was placed for sales and print costs, and the statement month for fees. Mixing "when the money arrived" with "when the sale happened" is the most common reason a home-made P&L never reconciles.

The monthly P&L layout

Keep it to one row per cost type, not per order. Per-order detail lives in the orders CSV; the P&L is the summary.

Add two derived figures underneath: profit per order and profit as a percentage of gross sales. These are the ones worth comparing month to month.

A worked example month

Here is a made-up but realistic month for a UK print-on-demand poster shop that sells in pounds, is not VAT registered, and uses UK fee rates (6.5% transaction fee, 4% plus £0.20 payment processing, 0.32% regulatory operating fee). Check Etsy's current fee page before copying the rates, because they change.

The shop had 60 orders at an average of £24 for the print plus £4 shipping, so £28 per order.

That is £7.88 per order and 28% of gross sales. The Etsy dashboard said £1,680. A seller who only subtracted print costs would have thought they made £888.

A few notes on the example:

• Fee refunds are simplified. When you refund an order, Etsy returns some fees but not all of them. Your statement shows exactly what came back, so use its figures rather than estimating.
• The listing fee is charged in US dollars and converted, so the pound amount moves slightly from month to month. A sale from a listing with more than one in stock also triggers an automatic renewal, which is another listing fee.
• The VAT on fees line comes straight off the statement. Etsy shows it separately, and it is a real cost if you cannot reclaim it.
• Offsite Ads only applied to 6 of 60 orders, but at 15% each those 6 cost more than the regulatory fee and listing fees combined.

What to look at once you have three months

One month tells you very little. Three months in a row start to show where the money goes.

• Print and delivery as a share of sales. In the example it is 47%. If it creeps up, your supplier raised prices or your order mix shifted to sizes with thinner margins. Print-on-demand profit margins covers how to compare products.
• Profit per order against Etsy Ads spend. If ads went up £50 and profit went up less than £50, the ads did not pay for themselves. The Etsy Ads guide has a way to read this per listing.
• Refunds and reprints. Two refunds and one reprint in 60 orders is a cost of about £69. A pattern of damaged deliveries is usually a packaging or supplier problem, and the returns and refunds guide covers how to handle it.
• Subscriptions per order. £35 a month is 58p per order at 60 orders and 18p at 200. Fixed costs only make sense at the volume they are bought for.

If profit per order is too low at every volume, the fix is usually price, not cost. How to price Etsy listings works backwards from the margin you want.

Spreadsheet or tool?

A spreadsheet is enough when you have one shop, fewer than about a hundred orders a month, and a single print partner. Set up the table above once, paste in the statement totals on the first of each month, and keep a separate tab per month. It takes about half an hour once you know where everything is.

A tool starts to pay for itself when:

• You have hundreds of orders and want profit per listing, not just per month.
• You use more than one print partner, so matching costs to orders by hand gets slow.
• You run more than one shop and need them on one sheet.
• You need the figures in a shape your accountant or tax return can use.

For a single sale, the free Etsy profit calculator shows what one order leaves after fees and product cost, which is the right tool for setting a price. For the whole shop, PSDmate has a Sales page that shows each sale with its artwork, the Etsy fees estimated and what you keep, and a Finance page that puts revenue, expenses, Etsy fees and refunds together. Whichever you use, the lines are the same as the table above.

A short monthly routine

1. On the first of the month, download last month's Etsy statement and orders CSV.
2. Copy the statement totals into your P&L.
3. Add print partner invoices and subscription receipts for the same month.
4. Calculate profit, profit per order and profit as a percentage of sales.
5. Compare with the previous two months and write one sentence on what changed and why.

Keep the statements, CSVs and invoices in one folder per month. You need them for your tax return anyway, and a year of tidy monthly P&Ls makes that job much shorter.