I need some feedback on Dutch tax codes. Currently we have these:
BTW 0% EU
BTW 0% non-EU
BTW 0% verlegd
BTW 0% vrijgesteld
BTW 21%
BTW 21% EU
BTW 21% non-EU
BTW 21% verlegd
BTW 6%
BTW 6% EU
BTW 6% non-EU
BTW 6% verlegd
BTW 9%
BTW 9% EU
BTW 9% non-EU
BTW 9% verlegd
BTW privégebruik
To make Manager stop guessing whether tax amount relates to sale or purchase and to better match what is actually needed for Concept BTW Aangifte report. I propose the following tax codes:
For section 1, we require these tax codes:
BTW 21% on sales
BTW 9% on sales
BTW 6% on sales
BTW 0% 6% 9% 21% verlegd on sales (we don’t need separate tax code for each rate here)
BTW 0% vrijgesteld on sales
BTW privégebruik
For section 2, we require these tax codes:
BTW 0% verlegd on purchases
BTW 6% verlegd on purchases
BTW 9% verlegd on purchases
BTW 21% verlegd on purchases
For section 3, we require these tax codes:
BTW 0% 6% 9% 21% EU sales (we don’t need separate tax code for each rate here)
BTW 0% 6% 9% 21% non-EU sales (we don’t need separate tax code for each rate here)
For section 4, we require these tax codes:
BTW 0% EU on purchases
BTW 6% EU on purchases
BTW 9% EU on purchases
BTW 21% EU on purchases
BTW 0% non-EU on purchases
BTW 6% non-EU on purchases
BTW 9% non-EU on purchases
BTW 21% non-EU on purchases
For section 5, we require these tax codes:
BTW 21% on purchases
BTW 9% on purchases
BTW 6% on purchases
There is one tax codes which I don’t see anywhere on Concept BTW Aangifte report to fit…
BTW 0% vrijgesteld on purchases
Also, on sales and on purchases suffix will need get translated. I don’t know what would be appropriate translation.
For section 1: Okay, but what do you mean with “BTW 0% 6% 9% 21% verlegd on sales (we don’t need separate tax code for each rate here)”
Section 2 Okay
Section 3 No seperate codes are required. Codenames could be for 3a: BTW 0% Export EU and for 3b: BTW 0% Export Non-EU
Section 4:Okay with the remark that VAT 6% is since 1-1-2019 no longer in use
Section 5 Okay with the remark that the values calculated with the taxcodes in section 4 must be added to 5b. If you need an explication for this please let me know.
There is simply no tax code BTW 0% vrijgesteld on purchases. This one doesn’t exist.
As far as I can see, the report requires only total amount for all these rates. Thus one tax code.
Again, as far as I can see, not necessary to have separate tax codes as report requires total amount for all the rates. And technically tax rate for all those tax codes is 0%.
Are all BTW 6% tax rates obsolete across all sections?
I was just stating, as part of the big discussion that is going on in the forum, that not having tax ledgers is making everything very complicated and error prone.
Very good.
In Ireland we would need something similar except that we have more VAT rates 23%, 13.5%, 9%, 4.8%, 5.4% and 0%
and we need to report on purchases for resale separately to purchases not for resale along with the EU non-EU split for imports & exports
Choosing the correct VAT tax code is not a task for the faint-hearted
Admittedly, few if any businesses would use all of these rates but they would all be required to be comprehensive
In Italy we have four IVA rates: 22% 10% 5% 4% with permutation on sales and purchases with permutation for IT, EU and non EU with permutation for tax recoverable and not recoverable. Than we have 0% with a mess of code and subcodes to justify the tax exemption or exclusion.
On line 5b you report only the recoverable VAT. The purchase value is not requested. I know ohter countries would like to know the purchase values as well but niot the Dutch tax-administration.
So you’re not missing something.
The “new” one comes with new set of tax codes. I just want to make sure the new one is correct before writing upgrade script to move everyone in Netherlands from “old” to “new”.
To test this, I recommend to import this new report into empty business and create transactions for each tax code and check whether amounts are put correctly into the “Concept BTW Aangifte” report.
Dear Dutch users:
As I wrote before, I’ll tke care of testing the new Concept BTW Aangifte Report.
I have finalized testing and have send my results in a private message to @Lubos.
. Good to know people with knowledge are persistently looking for a working solution!