Why your Etsy deposit doesn't match your sales
Your deposit is what's left after everything Etsy deducts, and some of the money in your sales total was never yours to keep. Work through it in this order.
- Start with the Sale rows in the monthly statement CSV.
- Take off buyer tax ("Sales tax paid by buyer" Tax rows). Etsy collects it and pays it to the government.
- Take off fees: listing ($0.20 per item), transaction (6.5% of item price, postage and gift wrap), processing (4% + £0.20 in the UK, 4% + €0.30 in euro countries, charged on the order total including postage and tax) and, in the UK, France, Italy, Spain and Hungary, the regulatory operating fee.
- Take off VAT on those fees if you haven't given Etsy a VAT ID (and always, for Irish shops).
- Take off Marketing (Etsy Ads, Offsite Ads) and Shipping (postage labels bought on Etsy).
- Adjust for refunds, net of the fee credits Etsy gives back.
- Check the timing. A deposit can include sales from several days and leave out sales still "available on" a later date.
To see the fee side for one order, use the calculator. To do the whole month, a spreadsheet that reads the CSV saves the retyping.
General information from Etsy's help pages (see sources), not tax advice.
Want this for every order, not just one?
The Profit & VAT Tracker for Etsy sellers reads Etsy's monthly statement CSV (paste it in) and sorts every row into sales, refunds, each fee type, VAT on fees, Etsy Ads, Offsite Ads and postage labels, then shows profit per month and for the tax year. For EU and UK shops, VAT-registered or not. Excel, and built for Google Sheets. If it doesn't read your statement, you get a fix or a refund.
See the tracker ($12.99)Free price calculator spreadsheet (email download)Sold through Payhip by Idea Lab Studio, our own shop, so we earn money if you buy the tracker. The spreadsheet calculator is free (Payhip asks for your email). An organising tool, not tax advice.