Vat added twice on stripe payments imported from zapier

BuyUKData · ‎March 16, 2022

Hi,we are just setting up Quickbooks and using Zapier to link sales made and paid for in Stripe to Quickbooks to automatically create a "paid" sales invoice. This appears to be working however the price we sell online at includes VAT. The products we have on Quickbooks includes VAT but when the sales is ported from Stripe to Quickbooks it adds VAT again - how can we stop this?

We are also finding that the products that are listed in Stripe on sale do not automatically list in Quickbooks when imported even though the same product list is used? Again any help much appreciated

MadelynC · ‎March 16, 2022

We appreciate the details you’ve added, @BuyUKData. Let me impart some information so this VAT concern will get resolved.

When importing data to QuickBooks Online, the program depends on the information shared by your third-party application. This means QuickBooks depends on what details Zapier shares.

You’ll want to contact the Zapier support team for assistance. They can provide you information on why VAT is added twice. Their representatives can also share information on how your data is imported into QuickBooks.

Here’s an illuminating guide in case you’d like to group your products and services into categories to keep things more organised: Group your products and services into different categories.

In addition, you can use this reference to manage your VAT: Set up and edit VAT settings, codes and rates. It includes instructions to submit your return in the future.

Please leave us a message if you have any other concerns or questions about managing your transactions with VAT. We’ll always be here. Have a good one!

View solution in original post

Fiat Lux - ASIA · ‎March 16, 2022

Afaik this is one of the limitations of a connector like Zapier. You should consider to have another app to reconcile Stripe transactions into your QBO account and avoid any duplication.

GeorgiaC · ‎March 16, 2022

Hi BuyUKData, thanks for joining the Community - do you raise the sales invoices manually in QuickBooks, or are all of these all imported and created through Zapier?

BuyUKData · ‎March 16, 2022

These are all imported and raised via Zapier - we do not want to do anything manually. The products bought online include VAT. The payment taken by stripe includes VAT but when it is imported to Quickbooks via Zapier, Quickbooks automatically adds VAT onto the amount and I am wondering if there is something somewhere that needs ticking or unticking to stop this happening.

i.e Product sold is £10 inc VAT. Stripe takes £10 inc VAT but Quickbooks raises the sales invoice/receipt from the Zap as £12 which is incorrect.

MadelynC · ‎March 16, 2022

We appreciate the details you’ve added, @BuyUKData. Let me impart some information so this VAT concern will get resolved.

When importing data to QuickBooks Online, the program depends on the information shared by your third-party application. This means QuickBooks depends on what details Zapier shares.

You’ll want to contact the Zapier support team for assistance. They can provide you information on why VAT is added twice. Their representatives can also share information on how your data is imported into QuickBooks.

Here’s an illuminating guide in case you’d like to group your products and services into categories to keep things more organised: Group your products and services into different categories.

In addition, you can use this reference to manage your VAT: Set up and edit VAT settings, codes and rates. It includes instructions to submit your return in the future.

Please leave us a message if you have any other concerns or questions about managing your transactions with VAT. We’ll always be here. Have a good one!

Topics

Training

Community

Resources

Vat added twice on stripe payments imported from zapier