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.

Paypal Classic–here's how I got it to stick!

Go To Great Panes, Kathryn Maloney ©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.)

If you are like me and are not a fan of the website design trend that has pages with oversized graphic links and very little text, then you’re probably not enjoying the new Paypal design very much.

After much searching for a permanent solution and switching the view back to classic every time I logged in (under “More”, “Switch to Classic”, answer the survey or close it, then proceed to the classic version of Paypal), I contacted customer support.

I sent an email in the middle of the night, received a generic reply (as usual) offering assistance with things I don’t need help with–and telling me that if the auto-reply didn’t answer my question, I should reply to the email.

I am so pleased to say, that after my 10 PM reply email to support, my account was set to Paypal Classic View as its default view as 3 AM of this morning. Huzzah!

What a relief to be looking at a professional looking, clean, concise & fast loading design where I can see many orders all at once as soon as I log in, instead of the oversized image-heavy slow loading new version where only a few orders fit on the screen at one time.

Now I know that Classic isn’t here to stay, but until I haaavvvvee to switch, I am glad to have easy access to the version of Paypal I prefer. 🙂

Thank you Paypal Support Rep for setting my account to Paypal Classic as the default!

Go To Great Panes, Kathryn Maloney ©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.)

Ordering USPS Shipping Supplies Online (and small delay for supplies coming up–order now!)

Did you know that you can order shipping supplies straight from USPS.com to be delivered to your door for free?

Lots of post offices don’t carry the full variety of Priority & Express Mail boxes (none carry the “regional rate boxes” as those must be paid for online or there are additional fees on the quoted postage rates) but that doesn’t mean you should have just the right box on hand!

I go through a lot of the small Priority Mail envelopes myself and could easily wipe out my post office’s regular stash, and nothing beats the regional box rates for some of my small but very heavy items. I order the Priority Mail envelopes and boxes online for free and have them delivered to my home so I don’t even have lug them in from the car. (There are also items for sale in the USPS shop–use the menu on the left to refine your selection of goods.)

https://store.usps.com/store/browse/category.jsp?categoryId=shipping-supplies

If you are ordering supplies online, you might also need to know that there will be a small delay for supplies coming up soon so put in your order now!

From USPS:

“…orders placed Tuesday, July 21 (2015) through Sunday, July 26 will require an additional 3-5 business days for delivery.”

Hope that keeps you from running out of shipping supplies!


Getting Etsy Sales & Shipping Totals for Your Taxes (Paypal Totals Too)


Visit our Etsy shop: GoToSupplies
Go To Great Panes, Kathryn Maloney ©2015
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.

Here’s how to retrieve your Etsy transaction data & listing expenses to add them up for tax reporting–you’ll be able to add up:

  • orders & shipping income
  • sales tax collected (Should you be collecting sales tax? See here!)
  • credit card processing fees (when buyers chose Direct Checkout–you’ll need to get info about Paypal transactions from Paypal–help for Paypal here)

(Please note that the IRS doesn’t like just seeing spreadsheets for tax records, so be sure to keep back up documentation for your business–like email records of payments made and received, print outs of the “Your Bill” page for quick reference of monthly bills.)

Download Your Etsy Transaction Records

(See below for postage records for items shipped using Etsy labels.)

If you use both Etsy and Paypal to receive funds, you can download just the Direct Checkout (DC) Payments you recieved for DC orders on Etsy, then go to Paypal to download those transaction records.

1. Go To Your Shop
(Direct link if you’re logged in: https://www.etsy.com/your/orders/sold)

2. On the left under “Shop Settings” click Options

3. In the center of the page click the Download Data tab

4. Page down to Orders, choose the download type and time frame for the CSV you want to download and save them to your computer.

Great tip: If you want to download the full year’s worth of records at once, don’t select a month–just select the year and it will include all 12 months.

Remember–you need to include the shipping you collected as well as the item price in your income. You deduct actual shipping expenses on the income tax form separately.

Download Your Etsy Postage Cost Records

Postage records for items shipped using Etsy labels

5. Go To Your Shop
(Direct link if you’re logged in: https://www.etsy.com/your/orders/sold)

6. On the left under “Orders” click Shipping Labels.

7. In the center, near the top of the page, click the tab for “Purchased Labels”.

8. On the “Purchased Labels” tab near the top left, you’ll see a link for “Summary”. The default is “Daily Summary” with a link to “View by Month” below it. For some reason, you must click the “View by Month” link to be able to download your records, so give it a click.

9. Now look over to the right–you’ll see a menu that says Yearly Summaries. Click it and it will give you a choice of years to download. Save what you need and use Autosum (see below) to add it all up.

Download your Paypal Records

10. See this post: Downloading Paypal Records

Add Up A column

If you don’t have a spreadsheet program already, total a columns using the Open Office program (totally free–get it here: http://www.openoffice.org):

Open Office Autosum: Adding Up Your Totals

Total a colum using Microsoft Excel’s Autosum:

See the second half of this post for details.

Sales Tax

Help with adding up your sales tax here–for both states with origin- and destination-based sales tax:

Etsy & Sales Tax Returns


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2015
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.

bloke

Etsy Forums Survey

Etsy admin have put up a survey about the forums–when doing the survey please also give this forum thread a bump so more people see it & get to offer their opinions:

https://www.etsy.com/teams/7722/discussions/discuss/14746837

I almost missed the announcement because I no longer find the forums as dynamic & enticing as they once were & so rarely visit.

It would be great if they returned the Techniques & Materials, (real) Business Topics, Etc and Site Help sections to the main forums so I hope these are things that are on the table for the next version!

Etsy Teams Have New Landing Pages!

Well they do if your team captain is on the ball like Old Time Etsy‘s team captain–thanks Heather from janedean:

janedean

janedean's Marie Antoinette Charm Bracelet--so beautiful!

Look what a lovely landing page she’s created for Etsy’s team for folks who have been a member of Etsy since at least 2008 (buyers & sellers both welcome!)–the page will be ever changing I’m sure:

Old Time Etsy's New Landing Page
Click here to see the full view of the beautiful
Old Time Etsy Team’s New Landing Page

All the kinks aren’t worked out yet–like:

  • you can only curate one of these pages per Etsy account even if you are captain of more than one team,
  • I don’t think the embed feature does the page justice (see how the embed feature looks below),
  • there’s no link to the page from within your team’s regular pages and
  • the fact that the nice big name of the team at the top of the page only links back to itself instead of leading folks to the team’s about/home page… So be sure to be a swifty like our team cap’ and add a link to your team home page at the top of the description!

The embed tool produces this–not so exciting a representation as the page itself, but still not bad:

Read more about the team landing pages and how to get one for your team in the Captains’ Quarters team. Here’s hoping this tool will help us all promote our teams better!

Can USPS open my mail?


Visit our Etsy shop: GoToSupplies
Go To Great Panes, Kathryn Maloney ©2014
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.

Ever wonder if the US postal service has the right to open your letters or your packages?

There are three times your packages run the risk of being opened while in transit through USPS:

1. International shipments–Customs has the right to inspect packages in the destination country. This doesn’t seem to happen too often for most online transactions where the seller has included the proper documentation with the package though some countries are stricter about it than others. Packages mailed into the US are subject to inspection by U.S. Customs and Border Protection.

2. USPS can open the following classes of mail to inspect them–basically to be sure you have shipped your goods via the right class of mail since these services receive discounted rates:

  • Periodicals items.
  • Standard Mail items.
  • Package Services (including Media Mail, Library Mail and Bound Printed Matter) items.
  • Standard Post
  • Parcel Select®
  • Incidental First-Class Mail attachments or enclosures mailed under DMM 703.9.
  • GXG items that contain non-documents.
  • Priority Mail International items except the Flat Rate envelope and small Flat Rate box.
  • M-bags.
  • Items sent via “Free Matter for the Blind or Other Physically Handicapped Person” under 39 U.S.C. §§ 3403–06 and IMM 270.
  • All other Domestic / International mail not specifically stated below.

USPS cannot open these classes, they are “closed against postal inspection”–see # 3 for exceptions to that:

  • First-Class Mail® items.
  • Priority Mail® items.
  • Priority Mail Express™ items.
  • Global Express Guaranteed® (GXG®) items that contain only documents.
  • Priority Mail Express International™ items.
  • Priority Mail International™ Flat Rate envelope and small Flat Rate box.
  • First-Class Package International Service items
  • First-Class Mail International items.
  • International Priority Airmail™ (IPA®) items, excluding IPA M-bags.
  • International Surface Air Lift® (ISAL®) items, excluding ISAL M-bags.
  • Certain Global Direct™ (GD) mail.
  • International transit mail.

3. The US Postal Inspectors are like the police force for USPS. They can open any of the mail services, though if it’s one of the services in the “USPS cannot” list above, they get a search warrant to open letters/packages that they believe violate federal law.

Where can you see this info yourself from an official source?

On the U.S. Customs and Border Protection website here:

https://help.cbp.gov/app/answers/detail/a_id/114

https://help.cbp.gov/app/answers/detail/a_id/115

the USPS website here:

http://faq.usps.com/adaptivedesktop/faq.jsp?ef=USPSFAQ

and here on the US Postal Inspectors website, see #4:
https://postalinspectors.uspis.gov/contactUs/faq.aspx


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2014
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.

bloke

Etsy records for your Sales Tax Returns


Visit our Etsy shop: GoToSupplies
Go To Great Panes, Kathryn Maloney ©2014
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.

I’ve seen quite a few posts lately from folks looking to download their Etsy records to add up what they collected to file their sales tax return–also helpful for getting your info for your income taxes.

If you need help knowing whether or not you should be collecting sales tax for your in-state transactions, see here: Sales Tax Links to Official State Web Sites

Here’s how to retrieve and add up your sales tax:

Download Your Records

1. Go To Your Shop
(Direct link if you’re logged in: https://www.etsy.com/your/orders/sold)

2. Just below the last order click the link to the download page:
“Download a CSV file with the details for each order.”

3. Page down to Orders, choose the download type and time frame for the CSV you want to download.

To find the sales tax column:

If you choose to download the Order Items CSV, sales tax is column J.
If you choose to download the Order CSV, sales tax is column U.

Add Up the Sales Tax Collected

If you have just one rate for the entire state you can use auto-sum to add them up in a flash. Here’s how:

Autosum: Adding Up Your Totals

If you have just different rates based on the ship-to address, it’s not that easy…

Etsy doesn’t list the sales tax rates for the transactions in the download, so if your state has different rates based on the ship-to address (don’t know if it does? see the Sales Tax Links to Official State Web Sites link at the top of the post), you’ll probably be best off keeping a running list of in-state transactions and all the details you need to properly report your sales tax throughout the year. We do this in an Excel file just like the CSV that you can download from Etsy.

If you didn’t do that for the previous sales tax period, you can still use the Etsy download, it’s just a lot more work to research which zip code was in which jurisdiction. You’ll be able to sort the file so all your in-state transactions are grouped together, which will help you find the orders you need to remit sales tax on, then do the math for the rate based on the buyer’s ship-to address.

And when you’re done, you’ll have a model to build your new document for tracking transactions as they come in to make next year easier. 🙂

Don’t have a spreadsheet program like Excel? The Autosum link above will also hook you up with a free downloadable program that will allow you to use spreadsheets.


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2014
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.

bloke

New USPS Rates for 2014

If you haven’t updated your shipping rates, now is the time! Find the new USPS rates on usps.com, they go into effect January 26, 2014

Download all the service info in one document with the rates on different tabs here:

http://pe.usps.com

On the left, select “Shipping Services Prices – Excel”
or “Shipping Services Prices – csv” depending on the program you use.

Download each service as a separate file here:

https://www.usps.com/new-prices.htm

.

So Many Friends! {A Little Thank You Treasury}

When you’re feeling “blue”,
you can count on friends to make you feel “bright and cheery”
all over again!
Thanks for restoring my “sterling” rating!

Thanks so much for the support the past few weeks both in forum threads & in our shop–here’s a few of your items to show my appreciation. I am sure there are others I have missed, thanks to you all!

Thanks everyone!

Between shipping orders and working custom requests it took me this long to have the time to put this together!

There are still a few promo-priced items in my shop including pinback buttons and a little note cards for Halloween featuring my little bat!

gem flowers WM one button 100 hanbd cropped 300 WM

Thanks again for your support,
Kathy