An Easy, Step-by-Step Guide to Downloading & Analyzing Your Etsy Shop Sales

As small business owners, we are swimming in a deep sea of numbers, stats, and financial data on a daily basis (whether you choose to ignore this sea or not is a different story!). Luckily, what you may not know is that Etsy makes it super easy for shop owners to download their sales info in order to calculate their net income in a relatively painless process.

download your etsy csv file sales

You can download your sales data from Etsy on an annual or monthly basis and quickly export this info to a spreadsheet, where it can be sorted, filtered, summed, and utilized with other data. This is a quick and easy way to calculate all sorts of helpful numbers, including your total sales and shipping, which will be especially helpful for tax time.

Here’s a step-by-step guide on how to download your sales data from Etsy, and what to do with it once you’ve got it (please note that I use Excel for my spreadsheets):

step by step guide how to download your etsy sales file

 

step by step guide how to download your etsy sales file

 

 

 

 

 

 

 

You’ll then see a screen that looks something like this:

step by step guide how to download your etsy sales file

There are lots of different things you can do from here. Etsy offers several items for download, including a spreadsheet of the listings you currently have for sale, your orders by item, your orders by total, your direct checkout payments, and your direct checkout deposits. Read the descriptions to see what else you might like to download. For now, we’re going to use the orders download to calculate our total sales.

Etsy also gives you the option of downloading any of these spreadsheets for a specific month of a year, or for an entire year. Right now, we’ll download all of our orders from last year.

step by step guide how to download your etsy sales file

downloading etsy sales step4 copy

Since I’m using Windows, I’m going to open my file in Excel. From here on out I’m going to give you some step-by-step instructions on how to format and set up your sales data in Excel. You can obviously format it however you’d like, this is just what makes sense to me, and may be helpful if you’re an Excel novice.

After you’ve got your file open in Excel (should automatically open if you selected “open” in the previous step), let’s first make the column widths all pretty so we can actually read all this data.

downloading etsy sales step5 copy

Now we’ll add filters so we can better analyze all this nice data.

downloading etsy sales step6 copy

Etsy gives you a lot more information here than you probably need, like the names and addresses of all your customers. While the ship state might be helpful to filter for sales tax purposes, we can hide a lot of columns to make our data more manageable. If we decide we need it later, it’s easy to unhide a column.

downloading etsy sales step7 copy

I like to freeze my top row so that as I scroll down I still can refer to the column header to know what I’m looking at.

downloading etsy sales step8 copy

Then we format all our financial data to actually look like money rather than just a number.

downloading etsy sales step9 copy

Now it’s time to use a simple formula to get some great data, like our total sales, total amount we got paid for shipping, sales taxes collected, and credit card fees.

downloading etsy sales step10 copy

Excel makes it easy to use the filter function to sort by all sorts of things. Here, we can put our sales in chronological order. We could even choose to only look at one month or one quarter’s worth of sales (also helpful for quarterly tax returns or payments). We can use this function to look at only paypal sales, only international sales, only sales over or under a certain dollar amount…the possibilities are endless.

downloading etsy sales step11 copy

Let the big green letters below represent the following:

downloading etsy sales step12 copy

Don’t forget that your gross sales on your tax return should include everything you got paid for shipping as well. You’d report A + B as sales on your tax return. E, your credit card processing fees, would be a tax deduction.

You can copy F, your Etsy net sales, to your personal bookkeeping spreadsheet and then add in any other revenue streams and subtract all your other expenses to get your business’ true net income.

So there you go, a step-by-step guide on how to utilize this wonderful asset that Etsy provides for us! If you didn’t know this existed, I hope you found this helpful. You might also want to check out our ongoing Etsy Shop Stats series of articles to get help on another free asset that Etsy provides!

Do you have any questions on how to download and intrepret your Etsy sales spreadsheet?

updated-signature-copy_thumb.jpg

 

 

the etsy seller spreadsheet by paper + spark

4 thoughts on “An Easy, Step-by-Step Guide to Downloading & Analyzing Your Etsy Shop Sales

  1. Angela

    Hi there! Visiting from Handmade Tickle 🙂 This is some awesome information! Thanks for sharing!

  2. Isabel

    Great info Janet, thanks! I do have a question. I’m very new to Etsy and I’m a bit confused with the charges. The credit card fee is different from the fees Etsy charge for transactions and renew right? so should I also deduct this fees to my net? Thanks for the help

    1. lazyowlboutique Post author

      Hi Isabel! Thanks for stopping by! That’s a very good question. Etsy charges several types of fees – a % of each sale transaction, the standard 20 cent fee to list or renew an item, and then a credit card processing fee for all sales sold via their Direct Checkout method. That last one is what is showing up in the “card processing fee” column here. You are correct when you say that the CC fee is different than the charges for transactions and to renew. And you should also deduct those fees to get your net profit. The “Order Net” column already takes the credit card fee into account for you.

      To dive into this further, both Paypal and Etsy Direct Check Out take a % of each sale as their transaction fee. Only the transactions that were paid for via Etsy Direct Check Out will show up as having a card processing fee here. You will have to actually log in to your Paypal to determine the fees that Paypal has taken out and then account for that in your net profit number. Both the Direct Check Out fees and your Paypal fees are tax deductions as well.

      Let me know if that helps!

Comments are closed.