Skip to main content
M
MattEstlea
June 7, 2022
Question

Integrating WooCommerce and Quickbooks for Automated EU Sales

  • June 7, 2022
  • 2 replies
  • 0 views

Hi,

 

I'm having an utter mare trying to connect my WooCommerce store to Quickbooks. If anyone is willing to guide me out of this mess, I'd be eternally grateful! 

 

What I do:

I am a YouTuber who generates income through various sources such as ad revenue, affiliate marketing, and donations among other things. However I also sell digital products (woodworking plans) from my website, and physical products that are either dropshipped, or dispatched from me directly. I am based in the UK and have customers all over the world, the majority of which are in the USA and UK. But I also have many customers scattered throughout Europe.

 

My Problem:

In one word, Brexit. I have linked my PayPal account with Quickbooks so that I can assign VAT rates to each individual transaction, rather than grouping all transactions into a lump sum to be deposited into my main checking account at the end of the month. The latter of which would obviously create reporting issues.

The issue I am facing is that I am needing to manually adjust the VAT rate for each and every transaction that comes in to ensure it's accurate. Which as you'll see in the above screenshot is an ever growing list, currently sat at 124 transactions. (The worst I let it get to was 750)

 

I have added the OneSaas Woocmmerce to Quickbooks app to my account which has proven to be somewhat helpful, but not fully. So far, it's managing to find matching transactions, however it's not applying the correct VAT rate in my Quickbooks transaction feed. So despite matching to the correct sales receipt, I still need to manually adjust it anyway.

 

I have attached three photos that clearly show Quickbooks failing to figure out that a 19% Germany tax should be applied.

 

Photo 1: The Transaction Feed
The column for tax has automatically populated with 20% S

Photo 2: The Sales Receipt

At the bottom of the matched sales receipt, it seems to show the 19% Germany Tax. So why hasn't it copied across to the transaction feed?

Photo 3: The sale on WooCommerce

Just putting this one here for verification.

TLDR:

I want my PayPal transaction feed to automatically apply the correct sales tax for EU countries so I can simply press confirm to categorise the transaction.

 

Final Notes:

I also take Payments via Stripe which I cannot connect to Quickbooks in the same way as PayPal. Which then begs the question, how do other eCommerce seller do this so effortlessly. Which then leads me to believe that I'm going about this entirely the wrong way.

 

If anyone has any suggestions, please let me know!

2 replies

K
Kevin_C
June 7, 2022

Thanks for sharing the complete details of your concern and for adding screenshots, @MattEstlea. Allow me to provide some insights into your VAT concerns in QuickBooks Online (QBO).

 

I recognize the convenience of automatically assigning VAT rates to your transactions in QBO. I also understand that you want to make some changes and improvements to QBO to meet your business needs. The VAT rates will not be updated, even when matching your transactions. As a way around, I would still suggest manually editing these transactions with different rates and amounts.

 

While this option is unavailable, I recommend sending your feedback to our Product Development Team so they can review it and might consider implementing it in the future. Here's how.

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions. 
  4. Then select Next to submit.

 

For your query about integrating Stripe and QBO integration, this program can only be integrated using a third-party app connector. However, you can also request a .CSV file from Stripe and upload it as a bank transaction.

 

Feel free to visit this article for more information on how to manage your VAT process, edit your VAT settings, codes, and rates, and add additional tax rates, group rates, or custom tax.

 

You can also refer to the following article about the common VAT codes and how to create a new VAT code.

 

Please don't hesitate to leave a comment below if you have other concerns or questions. I'd be happy to help. Stay safe!

Fiat Lux - ASIA
Fiat Lux - ASIA
June 8, 2022
@MattEstlea wrote:

I have added the OneSaas Woocmmerce to Quickbooks app to my account which has proven to be somewhat helpful, but not fully. So far, it's managing to find matching transactions, however it's not applying the correct VAT rate in my Quickbooks transaction feed. So despite matching to the correct sales receipt, I still need to manually adjust it anyway.

 

@MattEstlea 

OneSaas/QB Connectors only offers limited functions. You need to consider purchase a 3rd party app to reconcile your transactions and avoid any duplications from PayPal/WooCommerce/Stripe.

Terms & ConditionsAccessibility statement