Download monthly sales data etsy pdf

Subscription — if you pay a monthly subscription fee to Etsy then you see this detailed,. Payment — any money that you have paid to Etsy. Ideally, this would give a common reference number that you could use to group all your data together for a single transaction. This would mean you could see your revenue and fees for a single sale and easily work out how much you really earned.

This is the Currency of your shop in which you receive payments — NOT the currency that the buyer paid in. All fees and associated taxes plus any Payments that you have made to Etsy. This will include Payments Fees due on any Sales made during the month. Seriously — you need to Go and read it now if you missed it!!

Strangely, Payments that you have made for fees due ARE included in the fees column so the end result of the report is not really accurate. Once you download your information, this final column is missing. You need to do some manual calculations to work out your running balance. OK, so now you have got your Etsy Payments data into Excel and you know what information is shown. The final question is what do you do with it now?? Click through for full details. PS: Why not pin this for later so you can find it again next month when you download your next Etsy Payments Statement?

The sound on the video above is not working. Thank you so so much for sharing your knowledge because accounting with Etsy is my most dreaded thing with my small buisness! Your email address will not be published. Skip to content. Where to Find your Etsy Payments Statement The option to download your monthly payment transactions is hidden away at the bottom of your Payment Account.

Choose the month you want to get the information for, and then click CSV. Related Posts. The bottom section then gives you a choice of 4 different reports. Click on the box CSV Type to make your choice between:. For each of these, you can also choose whether to download for a specific month or get all the data for a full year in one go. Make your choice and save the file onto your computer.

Read more about downloading your Sold transactions at Etsy help. If you want a really easy way to access your Payments data from Etsy, why not check out the Etsy Payments Dashboard. Hooray — you have now successfully downloaded your Etsy information as a CSV file and saved onto your computer. To use your information you first need to open it up in your Spreadsheet programme.

The notes below are written for Excel but most Spreadsheet programmes will have a similar process to access your data. Browse to the folder where you saved your files and select the one you want to view. Because the data is in CSV format which just means that it is a text file with the different data sets separated by commas , we need to push the file through the Text Import Wizard to enable Excel to read the data. Occasionally your file opens straight into Excel without going through the Wizard.

If this happens — Happy Days — just double check that your data looks ok. The Import Wizard works automatically but there are a couple of options we need to select to make sure the data loads correctly. You should see that lines have now appeared in the bottom data section splitting the information up into separate columns. We can help the data load along by changing the format of any date column from General to Date — and then by selecting MDY in the drop down box as below.

Make them wider and all will be revealed.