bookkeeping tax

How to generate your Etsy seller totals for tax time

Unfortunately, Etsy doesn't currently provide a easy way of obtaining your financial sales information for tax time. We show you an easier way!

So, how can you quickly download your seller tax totals from Etsy? The bad news is that Etsy doesn’t make this task particularly easy.

Take your Etsy business to the next level!

Get your inventory organized with our award winning Etsy inventory software. Track raw materials and product stock levels (in real time!), lot and batch tracking, COGS, pricing guidance and much more. It's your Etsy store's production central.

If you are looking to do this yourself instead of using automatic Etsy bookkeeping software (which will do this in minutes for you) you’ll want to follow these instructions:

Finding your Etsy Direct Checkout Fee Total

Download your Direct Checkout Payments CSV file. This will provide you with your raw list of all payments made by this method. In this file, you’ll find your gross Direct Checkout total and your Payment Processing fees.

To download your Direct Checkout Payments CSV file, navigate to Shop > Shop Settings > Options > Download Data.

Finding your Order Shipping & Sales Taxes Total

Next, you’ll want to find your totals for shipping and sales tax. This is located in your Orders CSV.

  1. Download your Orders CSV file by navigating to Shop > Shop Settings > Options > Download Data.

Finding your Etsy Fee Total

You’ll now want to download your monthly billing files - the steps below need to be repeated for each of the months inside your last financial year (so 12 times if you are using a standard calendar year)

  1. Navigate to Your Shop > Finances > Your Bill
  2. Select the month from the dropdown
  3. Click “Download this entire monthly statement as a CSV file.”
  4. Wait for the file to download and then open it in your spreadsheet program

Tip: If you are confused about how Etsy has calculated any of the Etsy fees you are seeing here, check out our Complete Guide to Etsy Fees 2024 for a detailed rundown with examples.

Finding your Etsy PayPal fee totals

If you also use standalone PayPal as a payment option, you’ll also want to login to your PayPal account and download your transaction fee history file.

  1. Go to www.paypal.co.uk and log in to your account.
  2. Click ‘History’ near the top of the page.
  3. Navigate to the ‘All activity’ page, or click the links near the top of the page to view ‘Recent Activity’ or to find an individual transaction.
  4. Click the More dropdown list, then select Download History
  5. Choose the date range of transactions and the file type (for opening in a spreadsheet you’ll most likely want ‘CSV’)
  6. Click ‘Download History.’

Thinking there must be a better way than this?

You’ll be happy to hear that there is: Craftybase can instantly import your data from Etsy and PayPal, compiling into exactly the right numbers you need for your bookkeeper. Give Craftybase a try today!

Nicole Pascoe Nicole Pascoe - Profile

Written by Nicole Pascoe

Nicole is the co-founder of Craftybase, inventory and manufacturing software designed for small manufacturers. She has been working with, and writing articles for, small manufacturing businesses for the last 12 years. Her passion is to help makers to become more successful with their online endeavors by empowering them with the knowledge they need to take their business to the next level.
accounting bookkeeping tax seller-fees etsy handmade-success