United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
frayedknots
Level 1
posted
‎August 01, 2019 02:53 PM
last updated ‎July 31, 2019 9:53 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

 
Reply
5 Comments 5
Intuit Zac
Content Creator
‎August 01, 2019 03:16 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

Hi Frayedknots, 

 

Thank you for reaching out on this. 

 

I did a search for "Etsy" in our App Store and it seems they are not integrating with QBO at the moment. 

 

May I ask what type transactions (Invoice? Bill?) you are looking to import to QBO, please? 

Reply
frayedknots
Level 1
‎August 01, 2019 03:29 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

The amount they paid me, and the fees I paid . Everytime I make a sale they take the fees out and then put the rest into  my bank account. I'm not sure how to put this into quickbooks. 

Say I make a sale for $10, they take $2 in fees and put $8 into my bank account.

 

Reply
Intuit Zac
Content Creator
‎August 01, 2019 03:37 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

Hi Frayedknots, 

 

Thank you for the clarification. 

 

I would suggest you to have your bank feed connected with your QBO and once transactions for your sales come in, you can categorise the income and the expense from tha banking tab. 

 

Please let us know if you have any follow up questions. 

Reply
frayedknots
Level 1
‎August 01, 2019 04:13 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

Yep it is connected and that's fine for my sales.but I I don't know how to add in the fees. Like i said before, I make a $10 sale,Etsy immediately take $2 then deposit $8 in to my bank account. So I can link up the $8 in my bank account, that's no problem, and I can put in $2 for fees but then it doesn't match up? Or I can just leave it as the $8 sale and don't worry about fees, but then I will have no record of the fees at all. I just can't work out how to do it?
Reply
Intuit Zac
Content Creator
‎August 01, 2019 04:47 PM

Can you sync etsy? i have tried to upload a csv but it is just not working for me.

Hi Frayedknots,

 

Thank you for getting back to us on this. 

 

I would suggest you to refer to this article from our online community on how to handle bank charges (you can treat the transaction charges in a similar way that bank charges work):

 

How to account for Bank Fees when matching transactions in Bank Feed

- https://quickbooks.intuit.com/learn-support/en-us/banking/how-to-account-for-bank-fees-when-matching...

In short, create an expense account for the transaction fee charges. When matching the transaction from banking, still match the $10 you invoice your customer, but as you only received $8, QBO is going to ask you if you want to resolve the difference. Select yes, and enter the fee amount as an expense. You do need to put the fee amount ($2) as a negative amount (-$2) in the resolve difference screen but if you click save and check back on the expense transaction created by resolving the difference, you can see the amount on the expense is positive. 

I have tried it in my test file and it worked for me. Please give it a try and see if it works for you as well. 

 

I would also suggest you to consult with your accounting professionals on this. 

 

Please let us know how you go. 

Reply