Etsy Data for your Taxes


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2012-2016
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

For your Etsy Income:

Download a spreadsheet of your Etsy transactions including both the item prices and shipping collected.

1. Go to: Your shop–here’s a link to the sold page for easy reference:

https://www.etsy.com/your/orders/sold

2. In the left side bar under “Shop settings”, click Options.

3. In the top-center of the screen click the tab for Download Data.

4. Scroll down to the “Orders” section and select Orders to download a file of all your transactions, then select the time frame you want to download.

Hot tip: If you want to download the entire year in one file,
just select the year (don’t select a month).

5. Click the teal button Download CSV and save to your computer.

Remember: the shipping you collect from your customers is part of your income. (You deduct postage & supply expenses on the schedule C.)

6. If you take payments through either Etsy’s Direct Checkout or Etsy’s Integrated Paypal you can also download your fees paid on this page–select Direct Checkout Payments from the drop down menu.

Etsy Fees and Postage Costs:

What did you pay to Etsy in listing, advertising & transaction fees? (See #6 above for Etsy’s Direct Checkout Fees.) How much postage did you purchase through Etsy? You’ll find that on your monthly bills–I print out the first page of each bill to keep for my income tax records. (The IRS doesn’t love spreadsheets as evidence since they can be altered, and the Etsy bill page is more like receipt.)

1. Go to the Your Etsy Bill > Monthly Statements page:

https://www.etsy.com/your/bill/statements

2. Open each month for a breakdown of

  • Listing fees
  • Transaction fees
  • Renew fees
  • Renew Expired fees
  • Renew Sold fees
  • Search Ads fees
  • Promoted Listings fees and your
  • Postage for Shipping labels

3. Create a new spreadsheet, with columns and rows for each month and type of fee, copy and paste the info from each month’s bill into it so it’s all in one place for the year.

Use Auto Sum To Add It Up Quickly

Now that you’ve got all that info saved to your computer/printed out, what do you do with it? Add it up!

Auto-sum: Adding Up Your Totals Using the Free Program “Open Office” (if you need help with Excel, there’s a link to that here too):

Adding Up Your Totals

and then put it on your taxes… Help with what goes where on your income taxes:

Income Tax Help for Small Businesses:
Schedule C links to the IRS.gov site

Here’s hoping that helps you get things in order quickly! 🙂

Go To Great Panes, Kathryn Maloney ©2012-2016
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

One thought on “Etsy Data for your Taxes”

Leave a Reply