IThe .json localisation file is a text file, open it with a text editor and change it to what you want it to be. You can then import it into your Manager business and test it produces the results you want.
When you have corrected it’s problems then everything one can benefit from your work.
The bottom HTML section is not as easy to read as the prior presentation in the localisation section however the the top calculation section is relatively easy to read.
Hopefully it will make sense to you as that way the Duch are likely to get a better localisation and in the longer term localisation by local users is exactly what needs to be done. Clearly there is no way Lubos can generate or maintain localisation for over 200 countries.
For the localisation transformation to work, the untransformed report needs to be correct, which maybe why Lubos called it the same problem.
I definitely disagree with what you wrote.
I am a financial controller and a user of Manager and I expect the software to work the way it should work. I am not a programmer and I don’t want it to be or to be pushed into that role.
You can’t expect from users that they take over the work a developer should do.
To say it very rude, that is his problem, regardless the fact whether it is just for one country or over 200 countries. If you make it user friendly for instance by parameters then it is up to the user how he wants the software to work.
It is a standard Dutch report, according to the EU-rules so the software should be able to cope with the requirements. It is not a custom report.
And suppose I modify the localization file, how can other Dutch users benefit from the modified file as this file is stored on my laptop? And the next question is: how do users address the mistake I made?
If I might make a comment, I had a look at using the Dutch VAT report as a base for creating an Irish VAT report. I’m not an accountant but have worked in installing, configuring and supporting financial systems and also have a good practical knowledge of analysis and programming.I also have experience of working in Ireland, Uk and France.
My impression is that EU VAT reporting is quite similar but not identical across the EU. Of particular difficulty is the recording and reporting of intra-EU purchases and sales where you are expected to account for notional VAT charges on invoices.
A lot of smaller businesses in Ireland, even in today’s EU would not have a lot of sich transactions and so the current VAT reports will cover most of their needs.
It is true that corrections carried out by journal entries are problematic but many small businesses wouldnt be that fussed about details like that - it would be a distraction to their main goals.
I am not sure how to continue - do I forge on and try to create a complicated report system which most Irish users will simply ignore or use incorrectly in any case…
The mechanics of VAT are in almost every country in the EU basically the same.
The tax-return forms differ per country as well as the VAT-rates.
When we have Intra-community transactions (goods or services) most of the EU countries want to know the value of the transactions and the corresponding VAT for their internal financial (VAT) position.
Additional detailed information is in most cases required by the local tax-authority.
When you have only inland sales and purchases, it is not that complicated.
When a report is incorrectly used, that is always the responsibility of the user, but when a report shows figures, these figures need to be correct.
As long as it is not a custom report, I think it is the developers responsibility to take care that the report is correct. Custom reports however are a different kind of report and there it is the users responsibility for what they create.
As for the rounding, there is now new version of the report. It’s basically exactly what @Daniel_Peppelenbos has done except I’ve used round filter instead of floor filter. I assume figures should be rounded up or down based on decimal being 5 or higher. Floor filter will always round down.
Is there a way to also add the Including results for also adding the Intra-Community transactions declaration (ICP declaration) in addition to the VAT report? In the EU in addition to the VAT filing every quarter, also the Intra Community transaction need to be reported.
It would save quite some time, if a standard report for this was available.
No there is not a standard report available. It is far beyond the scope of Manager to create a report like the ICP declaration. I think we must be very happy that we have the Concept BTW Aangifte as a report especially created for the Dutch customers. To be honest: I think that @Lubos will not give this any priority as the list of ideas is quite long and that are ideas everyone will benefit if they are implemented.
I don’t know. This is something that would be of value for a lot of European companies, as all European companies who sell something outside their own nation borders in Europe are encountered by this.
I understand that Manager.io may not be able to develop automatic interfaces with all European tax offices, but a report with all accumulated Intra-Community transactions per customer per period, should not be too difficult I believe? This way we it can be used for the manually filing. This way Manager.io would be a more regular option for European companies, as this is part of the normal administrative process in Europe.
@AA236, does the Taxable Sales per Customer report not provide what you need? It breaks down sales by both customer and tax code. If you have used the proper tax codes, sales to customers within the EU should be obvious. Likewise, the Taxable Purchases per Supplier report will give you corresponding information on purchases.
For my tax filing I have used the report ‘Taxable Sales per Customer’ to file the Intra-Community transactions declaration (ICP declaration). Unfortunately the tax office has send me a letter, that I have an inconsistency in the amount I filed at the VAT and with the ICP.
It seems the report ‘Taxable Sales per Customer’ , does not take credits into account, so my ICP filing was higher than my VAT filing, as alle the credits were not included.
Would it be possible to adjust the report ‘Taxable Sales per Customer’ , so that all credits are also included in this report (which would make sense, as you would like to know the acual amount, not the amount without credits)