Thursday, April 23, 2009

Etsy Seller workbook

It's a simple but sweet Google spreadsheet - the Etsy seller workbook. I could have done with keeping better records - than stashing my receipts in a cardboard box and not knowing what went with what.

It was the first time I used Google spreadsheet so it took me a bit to get used to something other than Excel. First thing you want to create your own copy, so click on File then "Create a copy". I called mine 'Etsy-sellerworkbook-diggitydugs'. Don't worry about where it is saved (somewhere in the cloud).

Now you can get to business - widen the columns on the 'Instruction' page. Always read the how-to:) To get to the instruction page (known as a sheet) use the links at the bottom of the site.

I would imagine that the non-US user would find the following sheets useful:
  • etsy sales - download your sales data and copy and paste into this sheet (well part of it - the other part I find really useful to keep track of the actual postage and any tracking numbers - these you will have to fill in manually).
  • etsy expenses - luckily you don't need to enter this by hand - simply download it from "Your Etsy bill" - go to the specific month and then right at the bottom of that page is a link to download your bill as a CSV file to copy and paste
  • other expenses - a very useful page to track how much you spend on raw materials. You need to enter these manually.
Thanks to earthskyfirewater.etsy.com.

No comments:

Post a Comment