Tag Archives: excel

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