Etsy Data for your Taxes


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2012-2018
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 the download page:

https://www.etsy.com/your/shops/me/download

2. Page down to the Orders section.

3. From the drop down menu select Orders.

4. Skip the next drop down (for month), and select the year you need on the Year option.

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

For Annual NY sales tax: Do this once for the previous year and once for the current year since our annual returns are split across 2 years. After download you’ll need to remove the unneeded months from what you downloaded, but since the downloads are in date order this shouldn’t be too time consuming.

5. 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-2018
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.

Updated March 2018

One thought on “Etsy Data for your Taxes”

Leave a Reply