• Home
  • /
  • Etsy Entry App

Etsy Entry App

1/4/22 - Etsy recently made changes to their financial reporting and CSV files. This change has caused errors with the Etsy Entry App. I am currently working with a programmer to update the Etsy Entry app to reflect the Etsy changes. I am unsure how long this process will take. In the meantime, if you are in a rush to complete your 2021 bookkeeping, I suggest you calculate your Etsy journal entry manually. This video will show you how. Sorry for the inconvenience! (If you happened to have downloaded your CSV files before Etsy made the changes, then the Etsy Entry App should work for those months. Lucky you!)

The Etsy Entry App

While the Etsy Entry App is still a great way to record your Etsy Sales and Fees accurately in QuickBooks Online (Simple Start, Plus, and Advanced), QuickBooks has just released (February of 2021) their own integration called Sync with Etsy. You can find it in the Apps section of your QuickBooks Online account. Sync with Etsy is a great tool for Etsy sellers, and it's free. Watch this video to see how it works. Currently, the Sync with Etsy app is my recommendation for bookkeeping for Etsy sellers. However, Sync with Etsy only works for one shop, and is not available to international sellers at this time. If you need an Etsy bookkeeping method for a second shop or are an international seller, than my Etsy Entry App is still a great solution for you. Read on!

A great option for recording your Etsy Sales and Fees within QuickBooks is the Etsy Bank Method. Watch the video below that explains the Etsy Bank Method, why we need it, how it works, and how to use this app to calculate your monthly journal entry. 

Try the app out first, if you are happy with the results, then consider making a small payment to keep the app updated and running. 

For a complete look at why we need a method to record our Etsy sales and fees, how to calculate the entry manually, and how it all works together, watch this comprehensive video first.

Any questions? Leave them in the comments on YouTube.

Disclosures: This Etsy entry app is not endorsed by Etsy or guaranteed in any way. Use at your own convenience. This page may contain affiliate links.

     Recap from Video - How To Use the Etsy Entry App

  • From your Etsy shop payment account, select the month you are creating the journal entry for
  • Below the graph for that month, click the CSV button to download that month's statement
  • Note the ending Etsy balance while on this screen
  • Next, from the left menu go to Settings, Options, Download Data
  • Select the Orders CSV file for the applicable month
  • On the app select your sales tax state (the state in which you live). If you collect sales tax for another state, select a state from the second box. 
  • Browse for your Orders and Statement CSV files
  • Hit the gray button to upload the CSV files and calculate your entry
  • Post the entry as a journal entry, make sure to date it as of the last day of the month
  • From the bank feed, all Etsy deposits should be categorized to Etsy Bank
  • Pull up the Etsy register, does the ending Etsy balance per QuickBooks agree with the ending balance per Etsy?

The Etsy Entry App banner
Optional Payment For Use of App

Thank you! Your support makes it possible for me to provide this Etsy bookkeeping tool, and keep it updated and functional. Use the app first, if you love it, then I would appreciate your support. Thanks!


The Etsy Entry App Get Started

The Etsy Entry App

**NOTES and UPDATES**

In 2021 Etsy made a change to their Etsy Statement CSV file. This change caused any Shipping Expense (labels purchased) to not populate in the Etsy Entry generated by this application. The Shipping Expense figure can still be obtained by sorting the statement CSV as shown in my video. This issue should be fixed. If not use the form below to report a problem.

To report issues with the Etsy Entry App, please follow this link.

Report issues only after you have used the CSV files to manually calculate the entry amounts, and have concluded that the Etsy Entry App is generating misinformation. 


Select your sales tax state(s):

Select CSV Files to upload:
Orders -
Statement -