Skip to main content
E
etsygirl
February 19, 2025
Question

How do I add Etsy fees to quickbooks UK

  • February 19, 2025
  • 1 reply
  • 0 views

Hi, I hope you can help.  I am an etsy seller based in the UK and I am new to using quickbooks.  I have setup my quickbooks as a sole trader and have also used the Etsy integration app to transfer my sales data.  

 

As my business is still quite small, most of the money I make from Etsy is used up for advertising, listing fees, etc so any profit I make very rarely makes it to my personal bank account which is my only bank account which I use for everything.  I don’t buy many supplies, etc either as most of my orders are digital files and require very few supplies.  So I don’t want to connect my bank account to my quickbooks.

 

My question is: As the etsy integration app only imports my transactions, not all the data from etsy.  How do I manually add these fees to my quickbooks.  I am assuming this is done through expenses but don't know which fields, etc I have to add.  Also I have created csv files from etsy which include listing fees, processing fees, vat on processing fees, regulatory operating fees, vat on transactions, etc.  Is it easier to import these files/figures to quickbooks than manually add? I have searched everywhere for answers but most of the answers I have found relate to the US version of etsy/quickbooks or are vastly out of date.

 

Thank you for any help

1 reply

Bryan_M
Bryan_M
February 19, 2025

Thanks for the detailed information you've shared, @etsygirl. There are two ways to record these fees: manually or in bulk. Let me share them with you.

 

It is correct that these transactions fall into expenses. Please know that the ease of adding the fees in QuickBooks Online (QBO) will based on how many transactions you'll add.

 

If there are only a few fee transactions, you can add them by creating a category in the Chart of Accounts (COA) and then adding them to the Expenses tab manually.

 

Here's how to add a category in COA:

 

  1. Go to the Gear icon.
  2. Select the Chart of Accounts (COA) from the Your Company column.
  3. Click the New tab.
  4. Enter the Account name, Account type (Expenses), Detail type, and Description if applicable.
  5. Once done, click the Save icon.

 

You can follow these steps to add the fees in the Expenses tab:

 

  1. Click the +New icon.
  2. Pick Expenses from the Suppliers tab.
  3. After choosing a Payee, select the account you created from the Category tab, Amount, and other information needed.
  4. Once finished, click Save and close.

 

I'll also recommend contacting an accountant on or before performing this to ensure that the transactions added are categorised correctly.

 

However, if there are bulk fees, you can use the CSV file you created for your fees and import them in QBO at once. You can visit this article to check if you formatted the file correctly: Format CSV files in Excel to get bank transactions into QuickBooks Online.

 

Moreover, to learn how to import them, feel free to read this article: Manually upload transactions in QuickBooks.

 

You might want to map your eCommerce payment methods to corresponding payment accounts in your QBO account. Check out this article: Map your payments in QuickBooks Connector (OneSaas).

 

Let me know if you have additional questions about adding fees from the Etsy app into QBO. We'll be willing to lend a hand. Keep safe always.

E
etsygirlAuthor
February 20, 2025

Thank you for your reply, it was a real help.  I have a follow up question if that’s okay.  to record the VAT that I pay on my Etsy Fees (I am not VAT registered), do I record them in chart of accounts as 'Current liabilities' such as Etsy Sales Tax Collected or 'Expenses' such as Etsy Fees and what do I choose as 'detail type'

 

thanks for your help

Terms & ConditionsAccessibility statement