Etsy Seller Bookkeeping Spreadsheet (Real Profit)

Hey folks, it's Ren here. A maker friend showed me her Etsy dashboard at my desk one morning, thrilled, sales up forty percent on last year.

Then I asked what she actually kept from a forty dollar order, and the room went quiet.

That quiet is exactly why an etsy seller bookkeeping spreadsheet matters, because turnover and profit are not the same thing.

"Beware of little expenses; a small leak will sink a great ship." — Benjamin Franklin

🛒 Why do busy Etsy shops still feel broke?

Busy Etsy shops feel broke because sellers track turnover, not profit.

Sales climb, the dashboard looks great, and the fees, materials and tax quietly take most of it before the money ever feels real.

Please do not be hard on yourself if this is you. Etsy shows you sales front and centre and buries what it took.

• Fees come out in pieces, so the total bite is easy to miss.
• Cost of goods rarely gets logged against each sale.
• Tax is forgotten until it lands as one unwelcome bill.

📊 How much does Etsy really take per sale?

Etsy takes roughly 9.5% plus 45c on a typical order, before any of your own costs.

Seeing it as a stack, not a single number, is what makes the leak obvious.

Now put real numbers on it. On a forty dollar order, fees take roughly four dollars twenty five, so you are at about thirty five seventy five before you have paid for a single material. That is the figure my friend had never seen.

Here is the insight that changes how a shop is run. The number that matters is not the sale, it is what survives after fees, cost of goods and tax, and it belongs in its own column on every single order. Track that column and a busy week and a profitable week stop being the same thing by accident.

✅ How to set up your Etsy bookkeeping

You can set up real per-order bookkeeping in about twenty minutes.

Full sale in, fees out, costs out, tax aside.

1. Log every sale with its full total. Record the item price plus shipping, the real number the customer paid.
2. Subtract the Etsy fees on that order. Take off 6.5% of the total, then 3% plus 25c processing, plus the 20c listing fee.
3. Subtract your cost of goods. Deduct what that item actually cost you to make or buy, materials, packaging and postage.
4. Set aside a tax percentage. Move a fixed slice of what is left into a tax column before you ever call it profit.

If you also draw an income from the shop, the self-employed budget spreadsheet shows how to pay yourself a wage from lumpy sales.

FROM JREN DIGITAL

See true profit, not just turnover

The Ultimate Small Business Budget Template tracks income, expenses, tax, cash flow and a profit dashboard for sole traders to teams of ten, for $30 one-time. Drop your Etsy sales in and watch real profit per order, not vanity sales. Used by over 70,000 customers, no subscription.

Try it today →

⚠️ Etsy bookkeeping mistakes to sidestep

• Reading turnover as profit. Fix it: add a profit-per-order column after fees and costs.
• Ignoring the small fees. Fix it: log all three Etsy fees on every sale, not just the headline.
• Leaving tax until year end. Fix it: set aside a percentage on each order as you go.

To see how the shop fits a whole business, the small business budget template guide covers the full picture.

🎯 Your shop setup this week

• Add a row for your last ten Etsy orders with their full totals.
• Subtract the three Etsy fees on each one.
• Subtract your cost of goods, then a tax percentage.
• Read the profit-per-order column and find your real best sellers.
• Fold the shop into your wider numbers with the small business budget template.

⚡ Quick answers

What should an Etsy seller bookkeeping spreadsheet track?

An Etsy seller bookkeeping spreadsheet should track each sale's full total, the Etsy fees on it, your cost of goods, and a tax set-aside, so every order shows true profit. Turnover alone hides whether you are actually making money.

How much does Etsy take per sale?

Etsy charges roughly 9.5% plus 45c on a typical order: a 6.5% transaction fee on the item and shipping, 3% plus 25c payment processing, and a 20c listing fee. Sellers over $10,000 a year also pay a 12 to 15% Offsite Ads fee on some orders.

Do I need separate bookkeeping if Etsy gives me reports?

Yes, because Etsy's reports show fees and payouts but not your cost of goods or a tax set-aside, so they cannot show true per-item profit. A simple spreadsheet ties all of it together in one place you own.

How much should I set aside for tax as an Etsy seller?

A common starting point is to move a fixed percentage of profit into a tax column on every sale, so the bill is never a shock. The right rate depends on your situation, so treat the column as a holding bucket and confirm the figure with your accountant.

Can one spreadsheet handle Etsy and my wider business?

Yes, a small business budget template can hold Etsy sales alongside other income, expenses, cash flow and a profit dashboard, so your shop is part of the whole picture rather than a separate guess.

To your financial freedom,
Ren

My maker friend can answer the forty dollar question now, to the cent. Her sales did not change, but for the first time she knows which of them are actually worth making.

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.