1) I noticed already I could add the GR/IR account back in manually but was wondering why it was removed from the default settings in the Dutch COA as it is setup by default in the English version. Probably because you personally don't use it indeed
Ok, I will set GR/IR account to 1605 by default in the update COA ? By mistake i didn't know this setting is default in the English COA.
2) Preferably I still have all possible VAT scenario's setup like Social Bookkeeping have done in their VAT preconfig. Joost Oosterhoff also described them here http://www.oosterhoff.org/cms/nl/alle-artikelen/21-information-control/foutloos-boekhouden-met-frontaccounting/46-nederlandse-btw-in-frontaccounting.html
Looks like right now only 1a, 1b and 5 are preconfigured. Personally I also need 3b and 4b. The value reported here in the standard VAT report to the Dutch IRS has to be included in the ICF report as well. I can imagine other potential Dutch customers require one of the other tax groupings as well though hence my suggestion to include them all in the default COA to make it easy for new adopters to just pick what they need rather than having to set the VAT groupings up from scratch themselves.
Alternately we could still go the route of having me upload a second COA into FA repository with a description similar to "Dutch COA suitable for import/export to/from Netherlands and companies having the need to reconcile stock receipts".
What about changing the VAT-scenario's to the following:
BTW Hoog covers 1a on the Ducth IRS Tax form (sales, also 5b purchases)
BTW Laag covers 1b (sales, also 5b purchases)
BTW Vrij (EU) covers 3b and 4b
BTW verlegd covers 1e and 2a
BTW Vrij (non EU) covers 3a and 4a
Not covered is:
- 1c --> non routine transactions, to be crecorded by manual journal entry?
- 1d --> idem
- 3c --> no idea how to set this up?? Non routine/branch specific?
- 5d --> non routine, to be recorded by manual entry
- 5e idem
- 5f idem
Almost all GL accounts are allready present, just needed one account to be added.
I prefer one Dutch COA, so i prefer to update the existing COA with above changes? After receiving you comments I will generate an updated COA and will send it to you for testing purposes. After testing i will ask Janusz to update it in the repository.
May I ask what type of company you've implemented FA in? Service companies only or also trade companies? Already when you ship product to/from Belgium to Netherlands (quite common I guess) you need 3b/4b if you plan to invoice with 0% VAT.
I use FA in a few service companies and a few non-profit companies. So no trading company indeed, that's why I don't use the GR/IR account.
Also in case someone is planning to build an interface between FA and Dutch IRS to be able to automatically submit the tax return it would be easier I guess to just map all preconfigured tax groupings from FA to the Dutch IRS (I haven't found an API on the site of the Dutch IRS yet though so not sure yet how other packages obtained the required info to build their interfaces).
I don't know if such interface exists. If it exists i'm also interested. But i think it would be really hard to build an interface like this. If i'm right all electronic communications like this must be going through Dutch "Digipoort" and you will need an "PKI Overheid Services" certificate for this.
Do you also know if there's a standard VAT/ICF report preconfigured in FA already or whether we need to build this from scratch? I'm playing around with Rapidminer now to see if I can easily build the required tax report from this 3rd party tool for the time being.
No i don't think this is available yet. But if you're planning to configure one, i'm also interested.