Skip to main content
U
U1511M
January 12, 2022
Question

QBSE for Etsy UK Sellers.

  • January 12, 2022
  • 1 reply
  • 0 views

Hi, 

 

Hopefully someone can help with a few questions I have. I am based in the UK, use QBSE and have no prior experience of accounting.

 

I have linked my bank account and Etsy account. I have gone through a marked everything as business or personal and categorised everything the best I could However, the final amount doesn't match with final Etsy deposit amounts into my bank. All the numbers just don't add up. 

 

Say I get an order I get an order for say £11.84. The transactions for this are:

Etsy Transaction Fee £0.40

Etsy Regulatory Operating Fee £0.03

Transaction Fee (Postage) £0.19

Etsy Processing Fee £0.67

Etsy Sale £11.84

Etsy Listing Fee £0.20

 

1. How do I categorise these? Bearing in mind, I am in the UK and I also have my bank account linked.

 

2. When Etsy deposits this final amount after fees into my bank account at the end of the month, how do I deal with this? Won't it mean that transaction will come up as income of £10.35 (Etsy sale deposited into bank) and £11.84 Etsy sale amount?

 

3. What is the standard way to check everything is correct? Monthly/weekly steps to take? I know the obvious way is to go through every single transaction, but surely there must be a quicker way? 

 

4. If you categorise Etsy fees as expenses, what receipt do you use? The only thing I have found is a CSV but that isn't a receipt. 

 

Your assistance is greatly appreciated! 

 

Many thanks

 

 

1 reply

AlexV
AlexV
January 13, 2022

Hi U1511M!

 

Welcome to QuickBooks Community. I'm here to assist you in categorising the transactions.

 

First, please note that linking your Etsy account is just the same as linking a bank account. Since you linked both, you'll want to make sure that this won't cause a duplicate. You have the option to exclude or delete the transaction that causes discrepancies.

 

There are different categories in QuickBooks Self-Employed depending on the transaction. For example, for the Etsy processing fee, you can categorise it as Transaction/processing fee. You simply need to review the Category column. Select a general type, and choose a more detailed category.

 

Please check this article for your reference: Categorise transactions in QuickBooks Self-Employed.

 

Also, it's always best to refer on your bank statement when categorising transactions. This is to ensure that everything is accurate and matches your real-life bank account.

 

You'll want to check if Etsy provides receipts for these fees. That's what you'll want to attach to the transaction. Please check this article for more details: Record or attach expense receipts.

 

Lastly, I added this link if you need help in filing your taxes: Year-end Taxes.

 

Post a comment below if you need anything else. I'll help you!

U
U1511MAuthor
January 14, 2022

Thank you for your response.

 

I still have some questions, if that is alright.

 

So under the Etsy account, will I need to exclude all Etsy sales and Etsy deposit transactions? So the only transactions under this account will be fees. Or, do I mark the deposit transactions as transfers? 

 

When excluding the transactions, will QuickBooks pick up on this and do it automatically? Would it be wise to add a note on the transaction detailing why I have excluded it or is that pointless?

 

Also, before excluding a transaction, should I fill out all the necessary details? I.e type, category and any notes? 

 

Thanks in advance!

Rose-A
Rose-A
January 15, 2022

Thanks for getting back to us, U1511M. I'd be happy to answer all your queries.

 

You have the option to exclude all Etsy's sales and deposits as long as they're duplicating your transactions. QuickBooks will not pick up the transactions automatically, so you'll need to exclude them manually. 

 

And yes, you can also add notes to your transactions before excluding them. Here are the steps to complete the process:

 

  1. Click Transactions in the left panel.
  2. Find the transaction you want to exclude and select it to expand the view.
  3. Select the Exclude this transaction checkbox.
  4. Hit Save.

 

Additionally, the following resources are good references. These will provide you with more details on how to manage your transfers as well as deposits in QuickBooks Self-Employed:

 

Transfers: Owner's Deposit.

Categorise money transfers in QuickBooks Self-Employed.

 

I want to ensure that your questions are addressed accordingly. I'll be your helping hand whenever you one. Have a nice day!

Terms & ConditionsAccessibility statement