Download
Etsy bookkeeping
- Etsy fees worked out per order
- Expenses by category
- Profit by month
Opens in Excel, Google Sheets and Apple Numbers.
Free tools · Ecommerce
Free Etsy bookkeeping spreadsheet: every order, fee and profit in one place.
Excello's free Etsy bookkeeping spreadsheet records every Etsy order, works out Etsy's fees and your profit on each one, and adds them up month by month.
Download it for Excel below, or try the Etsy fee calculator first to see what one order leaves you.
Free. No sign-up. Opens in Excel, Google Sheets and Numbers.
- Spreadsheet
- Etsy fees worked out
- Profit by month
- Fee calculator included
- Price free
What is in the Etsy bookkeeping spreadsheet
The file
| Month | Orders | Sales | Etsy fees | Product and postage | Other costs | Profit | Margin |
|---|---|---|---|---|---|---|---|
| January | 4 | $189.00 | ($30.13) | ($63.50) | ($15.40) | $79.97 | 42.3% |
| February | 4 | $257.50 | ($38.21) | ($85.70) | ($41.60) | $91.99 | 35.7% |
| March | 4 | $206.00 | ($26.95) | ($62.60) | ($33.00) | $83.46 | 40.5% |
| Three months | 12 | $652.50 | ($95.29) | ($211.80) | ($90.00) | $255.41 | 39.1% |
Figures from the template's example shop, calculated by its own formulas.
Etsy fee calculator for one order
The calculator
Enter an order to see each of Etsy's fees and what you keep before your own costs. The spreadsheet does the same for every order you take.
Etsy's fees
- Order total
- Transaction fee (6.5%)
- Payment processing fee
- Offsite Ads fee
- Listing fee, renewed on sale
- Total Etsy fees
- You keep
- Fees as a share of the order
Before your product cost and postage. The listing fee is 0.20 USD, converted for other currencies.
Etsy fees, explained
What Etsy takes
| Fee | How Etsy charges it |
|---|---|
| Listing fee | 0.20 USD a listing for four months, charged again each time a listing with several in stock sells |
| Transaction fee | 6.5% of the item price plus what you charge for delivery and gift wrap |
| Payment processing fee | 3% + 0.25 USD in the US, 4% + 0.20 GBP in the UK, on the full order amount |
| Offsite Ads fee | 15%, or 12% once your shop has made 10,000 USD in sales over the past 365 days, only on orders from those ads, at most 100 USD an order |
| Currency conversion fee | 2.5% of the sale if you list in a different currency from your payment account |
| Regulatory operating fee | A fixed percentage in some countries, set out in Etsy's Help Center |
On a $40 item with $6 delivery, a US seller pays a transaction fee of $2.99, a processing fee of $1.63 and the $0.20 listing fee: $4.82 in all, leaving $41.18.
A UK seller paid in pounds pays 4% + £0.20 in processing instead: £2.04 on a £46 order.
If the order came through Offsite Ads, Etsy adds $6.90, and the fees reach $11.72, more than a quarter of the order. That is why the spreadsheet asks which orders came from those ads.
Source: Etsy Fees and Payments Policy and Etsy Payments Policy. Checked 22 September 2026.
Bookkeeping for Etsy sellers, step by step
Once a month
Etsy seller taxes, and when a spreadsheet stops being enough
Where Excello fits
Etsy seller taxes
Profit from an Etsy shop is business income, taxed where you live or where your business is set up. The spreadsheet gives you that profit and the records behind it.
Excello prepares the US Form 1040 with Schedule C for a shop owned by one person in the US, and the CT600 and annual accounts for a UK limited company. See the tax pages.
Etsy accounting with Excello
A spreadsheet suits a young shop. Once orders run into the hundreds, you also sell on other channels, or you carry stock, Etsy accounting belongs in real books.
Excello brings Etsy in from its exports on a regular schedule, keeps the books inside your own QuickBooks, Xero or Odoo, and closes each month within five business days, from $150 a month. See ecommerce bookkeeping.
Frequently asked questions
Is there a free Etsy bookkeeping spreadsheet?
Yes. Excello's Etsy bookkeeping spreadsheet on this page is a free Excel download with no sign-up needed. It records each order, works out Etsy's fees and your profit, and totals everything by month.
What is the Etsy transaction fee?
The Etsy transaction fee is 6.5% of the price you list an item for plus what you charge for delivery and gift wrap. On a $40 item with $6 delivery, it comes to $2.99.
What fees does Etsy charge sellers?
A 0.20 USD listing fee, a 6.5% transaction fee and a payment processing fee of 3% + 0.25 USD in the US on every order. Offsite Ads orders add 15% or 12%. On a $46 order without Offsite Ads, the fees come to $4.82.
How do I do bookkeeping for my Etsy shop?
Record every order at its full price and Etsy's fees from your payment account. Then add what each product and postage label cost you, list other costs by category, and once a month match what Etsy deposited to your bank and read your profit.
Should I record Etsy sales before or after fees?
Before. Record the full amount the buyer paid as your sale and Etsy's fees as a cost. Recording only what Etsy pays out hides your real sales and makes it impossible to see what the fees cost you.
Do Etsy sellers pay tax on their profit?
Yes. Profit from an Etsy shop is business income and is taxed where you live or where your business is set up. The spreadsheet gives you the yearly profit figure and the records behind it.
Can I use this spreadsheet in Google Sheets?
Yes. Upload the Excel file to Google Drive and open it with Google Sheets, or open it in Apple Numbers. The formulas and drop-down lists carry over, and it works in Excel on Windows and Mac.