If you all you need to do is change text in the Dutch VAT report, you can easily change that yourself. For example I have already edited the UK VAT Report by changing some of the text. All you do is create a github account if you don’t already have one, open the Dutch .cs file and select edit. Make your changes and click commit or save or whatever it says. Then do a pull request and Lubos will view the changes and if he is happy with that, then he will import the changes.
The only area where editing the file is a problem is if you need to change the VAT codes for like import VAT or whatever, then you need to understand coding. but if all you want to do is change from January 1 2015 to Van 1 Januari - anyone can do that. Just find the text in the file and change it like you would in a word document.
Thanks for your prompt reply, but i would like to give the following comment.
I would like to explain my position. I am one of the translators for the Dutch version and I want to keep the Dutch version to the status of 100% translated. I am a retired financial controller and worked many years for American and British companies, so I am quite familiar with all accounting terms. I am so to say a user and not a programmer and I don’t want to get involved in editing files on github accounts etc. That’s not my expertise and I don’t want to screw up things. I opened the link Lubos gave a few days ago, but sorry I can’t make chocolate out of this (a Dutch saying). By the way, when I opened it, I could not find all the text I commented upon.
Kind regards,
Its a fair point. I have already said to Lubos that I feel that many users will not feel confident in making changes as they are not programmers. So I can appreciate where you are coming from. I wonder if its possible to find a solution that will work for everyone. Regards
@Hennie, I have already made relevant changes but they won’t appear in the program until tomorrow or so.
That’s fine but there is really no other way around it. The good thing is that it really takes only 1 programmer to make it work for everybody in given country.
The dutch tax report is incorrect…
Let’s say I buy services from germany for €100, excl. 0% vat.
I should mark this transaction as EU21% (because the normal tax would be 21%), but there is no real tax collected. The amount should stay at 100.
In the report it should state:
4b = 100 and 21
5b = 21.
So net it’s 0.
And in terms of expenses, it should simply be 100.
Right now I cannot select EU21%, because it will simply split the transaction into 82.64 expenses and 17.36 tax collected.
If I select EU0%, the tax at 4b is not filled nor 5b. The amount to be paid / received, and the expense account are correct.
Thanks. I made adjustments to the latest version so the tax rates should work properly. Now it’s really about testing VAT return for Netherlands to make sure every tax code is represented on the report correctly.
Here is the code which generates VAT return for Netherlands
The key lines in this code are from 45 to 59. Perhaps this portion of the code should be refactored to make it easier to read. If you can describe in your own words what these lines should represent I can refactor the code to make it better to understand.
We’re almost there.
There is a line on the VAT tax form called "5d “Vermindering volgens de Kleine Ondernemers Regeling” also well-known in Dutch as “KOR”. I’ll explain what this means: in case (on annual basis) the total tax amount to be paid at line 5c , is less less than € 1345.- Dutch VAT-law says that this amount is cleared. So the business doesn’t have to pay this amount at all. When the total at line 5c is between an amount of € 1345.- and 1884,- a certain part of this amount has to be paid and when the annual amount is higher than € 1884.- the VAT should be paid in full. Anyway the amount that is cleared has to be shown in the P&L as a profit. So I suggest that you add an extra VAT-code called “KOR” and that a general ledger account number has to be added as well so that this profit is automatically shown in the P&L
A journal entry could then be made like this
Debit Accountnr - VAT to be paid - Amount of the KOR (Balance)
Credit Accountnr - KOR - Amount of the KOR (P&L)
Hi Hennie, Hi Lubos,
I have used every year the KOR. (Kleine ondernemers regeling.) Each year i debit the account VAT to be paid to zero, and credit the account KO regeling with the same amount. Its the same solution as Hennie describes, only whitout an extra VAT code, or extra account. In mine opinion is an extra VAT code for this KOR not relevant, and only confused. Just my 2c
Hi Richard, Hi Lubos
What you describe is exactly what I do as well. It is not a necessity, but when you offer a VAT report to the users I would suggest make it complete and not almost complete, but again it is not a necessity. Let’s leave it up to Lubos what he wants to do with my suggestion. Anyway Lubos is now informed what KOR is all about.
Ok, I looked into this a bit further. I am using the latest version (Manager 16.4.56) Some thing that do not seem to make sense to me:
There is a mismatch between the overview of the VAT transactions and the VAT Summary report that I can not explain. Most reports show 401, which I believe is the correct amount. The transaction overview screen shows 410.94 which is unexplainable to me. See these screenshots:
In the concept BTW aangifte report, line 4b seems to be incorrect. The amoun of VAT should not be the same as the “Bedrag waarover omzetbelasting wordt berekend”. Also, 5a, which is a summation of parts 1 till 4) is incorrect as it would be 401 + 641 which does not make sense.
Also, it is not calculated in the way Joris suggested, where the same amount would be on the report for both 4b and 5b (so net it is zero)
This is the case of receiving refund. On tax summary, refund will reduce BTW purchases, on tax transactions report it will show as BTW sales. Net BTW is the same on both reports.
But I do agree, this is inconsistent and I’ll fix it in the next version.
4a represents “Deliveries/services from countries outside the EU”
When we import from outside the EU, then the import is taxed in the country where it enters the EU.
4b represents “Deliveries/services from countries inside the EU”
Like @joris_manager said, there is no tax liability from countries inside the EU but they need to be specified on the declaration. So we add 4b to the total sum of tax (5a) and also to total tax payed (5b).
Some thoughts about KOR (5d):
5d represents “Reduction according to small entreprise arrangement”
It all depends whether you can or should apply this and the amounts (max limits) can be changed every year. I’d say leave it.
@Hans, then fields 4a and 4b are correct in tax report. You can verify that by creating text file, using relevant tax codes and see it’s presented correctly. What is not correct is 5a and 5b.
var _4a_grondslag = ... Sum(x => x.NetPurchases);
var _4a_omzetbelasting = ... Sum(x => x.NetSales);
var _4b_grondslag = ... Sum(x => x.NetPurchases);
var _4b_omzetbelasting = ... Sum(x => x.NetPurchases);
Should this not be something like this:
var _4a_grondslag = ... Sum(x => x.NetPurchases);
var _4a_omzetbelasting = ... Sum(x => x.TaxCollected); <-
var _4b_grondslag = ... Sum(x => x.NetPurchases);
var _4b_omzetbelasting = ... Sum(x => x.TaxCollected); <-
To answer your question:
5a should add 1a up to 4b. It looks in @patrickdewit example that it doesn’t.
5b should add 4b. as well, since EU tax can be deducted (see my previous under 4b)
