Monday, January 7, 2008

Examine Your Etsy Billing Information - Cheap!

This is now available in my shop CHEAP! I began offering it as a PIF, but realized I'd go broke paying .20 with each one. So, it's only a little over a buck!


Instructions for adding your Statement Data to Etsy_Statements_Summarization.xls. From now on, I'll call this the Statements File.
PC Instructions only. I'm sorry, I'm not familiar with Mac. This assumes you have Microsoft Excel 95 or greater.
  1. Open your new Statements File,
  2. Login to Etsy
  3. Click on Your Etsy
  4. Under the Money section, click on Your Etsy Bill (https://www.etsy.com/billing_main.php)
  5. Click on the month you wish to begin with. I'll choose Dec 2007
  6. Scroll down to the bottom of the page and click on the link "Download this entire montly statement as a CSV file".
  7. You'll receive a choice to Open or Save. Choose Open.
  8. Select OK to any other prompts you may receive until the data opens up in Excel.
  9. Now you should be in Excel, with the data viewable.
  10. Select all of the data. One way is to hold down the Ctrl key, while pressing A.
  11. Copy the data. One way is to hold down the Ctrl key, while pressing C.
  12. Now navigate to the new Statements File.
  13. Click on the Dec tab.
  14. Click on the cell A11 and paste the data. One way is to hold down the Ctrl key, while pressing V.
  15. Voila! The data is automatically totaled on the Dec tab and on the Totals Tab.
  16. Continue on with the other months.
Hope this makes sense. Thanks and have fun!

4 comments:

LoveMeKnot Creations said...

wow... i don't understand the billing/accounting stuff quite yet but somehow you make it seem fun...

KMalinkaVintage said...

Very interesting!

Anonymous said...

Hey there! Finding my info really interesting to track...but...not sure how to make this work for 2009 and scared I'll bugger the 2008 one up - any hints for me? Cheers!

LooseWireStudio said...

Sure, Natalia, just copy your existing file - the whole thing and name it 2009 or something. Your 2008 would be a separate file from 2009. Then clear out the data and paste in the new.

I started to create a two year version. Hmm... Maybe I should? Or a three year? Or... ?

Glad you're finding it interesting!