Financing, tax rates, and accounting
Join us March 21 for an AMA on planning your 2023 marketing budget with 2H Media co-owners, Matt and Aron
Hello, I don't know what's going on, but Shopify gives me around 16-17% for FR VAT (while it's 20%), and much lower for others EU VATs.
For example on the order page, I put the taxes are included in the price in the options and there Shopify marks 18.99 euros (18.99 / 113.93 or 16.66%), but it should be 22.786 euros (113.93 * 0.2 or 22,789)
Another example, on my tax report for the current month, I have 60.25 euros in FR VAT (for information, I made 360 euros sales figures), or 360 * 0.2 should give me 72 euros, but Shopify marks me 60.25 euros which gives me a French VAT rate of only 16.7%, however Shopify marks me the correct rate in the "rate" column.
Thanks for your help
Hi @LucasMondon - while I can't lend any advice on how to correct these miscalculations directly in Shopify, I can point you towards BeProfit Profit Tracker which you can use as a workaround solution.
After syncing with your Shopify store, BeProfit will show the same data that Shopify shows by default, but you can then easily edit any segment of your data (including taxes) in order to create and maintain accurate records.
With the bulk update feature, you quickly export your data, correct it, and upload it to make sure your tax records are showing correctly. You can do that as often as you want, and it will only take a few clicks of the mouse to get it done.
Plus, BeProfit lets you:
Try BeProfit and let us know if you find it helpful. Plus, if you have any suggestions on how we can improve the app, we're always happy to get feedback!
I think what you are doing here is calculating 20% of the total cost and are then receiving an incorrect figure. If you have listed the tax-inclusive price as €113.93, then you need to work backwards to calculate the correct amount of VAT.
We can see from the screenshot you have shared that €18.99 of the €113.93 figure is VAT, giving us a pre-tax price of €94.94 (113.93 - 18.99 = 94.94). If we take that pre-tax price of €94.94 add on 20%, we are given the tax-inclusive cost of €113.93. This is calculated by multiplying 94.94 by 1.2, which gives us a total of 113.928.
You can work this out by using an online VAT calculator such as this one:
Again, with the tax report you've cited, if we use the calculator we can see that with €360 worth of tax-inclusive sales, only €60 of that is VAT:
I hope this explains things but please let me know if you have further questions.
Victor | Social Care @ Shopify
- Was my reply helpful? Click Like to let me know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit the Shopify Help Center or the Shopify Blog
Thanks to all Community members that participated in our inaugural 2 week AMA on the new E...By Jacqui Mar 10, 2023
Upskill and stand out with the new Shopify Foundations Certification programBy SarahF_Shopify Mar 6, 2023
One of the key components to running a successful online business is having clear and co...By Ollie Mar 6, 2023