Etsy seller spreadsheet, UK

Every fee, what you keep, what to put aside

Built for UK sellers for the 2026/27 tax year, and for anyone selling alongside a full-time job. Excel and Google Sheets.

 

What you get

  • Excel workbook, 8 tabsStart here, Settings, Price calculator, Sales log, Expenses, Monthly summary, Tax set-aside, Fee reference
  • Google Sheets versionA make-a-copy link puts it in your own Drive in one click
  • 12 page PDF guideEvery tab explained with screenshots, plus the tax side when you sell alongside a job
  • Open me first fileThe three things to do first, so the sheet is right for you in five minutes

What Etsy really takes from a £12 sale

Transaction fee, 6.5%£0.78
Payment processing, 4% + 20p£0.68
Regulatory operating fee, 0.48%£0.06
Listing renewal, $0.20£0.16
VAT on those fees, 20%£0.33
Total Etsy fees, 16.7%£2.01
You receive£9.99

Through an Offsite Ad the same sale costs £4.17 in fees, or 34.7%. The sheet shows both, on every order.

Inside the workbook

The eight tabs of the workbook The price calculator tab The monthly summary with charts The tax set-aside tab

How it works

  • Type your salary and the dollar to pound rateTwo yellow cells on Settings. Etsy charges its listing fee in dollars, so the sheet converts it. Put 0 if you have no job income
  • Log each order in the yellow columnsFees, payout, costs and profit fill in on every row. Room for 2,000 orders
  • Read the two tabs that do the restMonthly summary for the year, Tax set-aside for what to move on payout day

Works in

Excel Google Sheets Numbers and LibreOffice Rates checked 29 September 2026

Instant access in your library after payment. Tax figures are estimates to help you set money aside, not advice. Something not working? Message me from the contact page and I fix it the same day where I can.