Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3. Configuration of VAT GL Account

Is it done ?
No, there are only US and CANADA Sales Tax accounts for now.

Should it be per rate - different accounts for collected and duty tax for each rate ?
Per rate is not an obligation. A problem here is that it should be dynamic since rates can be created dynamically.

Separating collected and due taxes is mandatory and done in OFBiz though no VAT specific accounts exist.
See point 7. We need at least an incoming tax (sales) GLAccount and an outgoing tax (purchase) GLAccount.

...

Currently OFbiz applies global discount on invoice level. This is not valid for VAT. For VAT amount for each line must be known, so discounts have to be applied per line.

5. Reporting

 In In some countries (Poland, Italy, France, Germany, more ?) there is need for monthly or quaterly VAT report with all sales and purchases. Reports can be separated per "Registry". Each registry contains separate type of transactions. E.G : EU sales, EU buys, Non EU Buys, Non EU Sells.

 66. Dates

There is not always direct connection between invoice date and VAT. E.g in Poland if purchase invoice is received more than 2 months from purchase it will not decrease amount of VAT to be paid. Same in France, must be the same month, but you may regularise in a delay of 2 years.  

Some invoices can be not valid.

For Export invoice there can be requirement for document which will confirm that goods has been exported (to apply 0% VAT)

 77. Purchase order VAT

I will implement this shortly the following way: (have a customer who wants it)1. add

  1. Add a second glAccountId for outgoing tax to the

...

  1. TaxAuthorityGlAccount.

...

  1. Adjust the programs to calculate the vat (sales tax) on purchase

...

  1. orders the same way as sales orders, but use for the productstoreId a

...

  1. blank entry.

JLR note 2008/11/18 : not sure who wrote that, nothing in Jira yet.

8. Shipment cost VAT

 Shipment Shipment cost should be VAT aware (amounts should be splitted  splitted for netto + VAT on invoices). There is a field for that in Tax Autorithies/Product Rate : TaxAuthorityRateProduct.taxShipping. But shipping amounts are no VAT splitted.

...

  • An unique bill number based on a chronological and continuous sequence,
  • the complete names of salesman and customer with respective addresses,
  • the individual number of identification to the VAT of the salesman and customer (the number of VAT of the customer remains optional for operations for operations realised in France),
  • the date back to delivery or bill transmission.

On each  each invoice line you must show

...

  • The tax amount to pay and, by rate, VAT excluded total and corresponding tax (If the liable is brought to bill another VAT that the French VAT, she/he must specify very clearly that it is a tax of such or such foreign country).
  • If need be, a mention indicating that the operation benefits from a measure of exemption (with law reference), or of an auto-liquidation or profitable margin system.
  • The date at which the payment must take place,
  • the rate of the payable penalties begining the day following the date at which the payment must take place,
  • discount conditions.

11. Exemption tracking

Currently exemption is not tracked at the accounting level (invoices). Not sure why, but it would be easier to have this information at least in invoices.

Requirements by region

France VAT link there are many other languages links from this link, very interesting
Eu VAT specificities change language if you need

requirement

region

needed?

unique bill Unique invoice number based on a chronological and continuous sequence

France

yes

 

Germany

yes

 

Spain

yes

Discounts applied per line

 

 

Ofbiz supports invoice level discounts. This is not valid for VAT. For VAT, amount for each line must be known, so discounts
have to be recalculated for each line.

Poland

yes


Germany

yes

 

France

yes

I.e. there can be invoices with different VAT rates per line.

Spain

yes

Rounding

 

 

Important: rounding may only take place one time per VAT rate (after all calc. VAT amounts are summed up for that rate)

Germany

yes

 

France

yes

 

EU

yes?

Exemption

 

 

Some products can have different tax rate when selling to different type of customer. E.g. In Poland flat/house renting is 0% for individual
customer but 22% when renting for company. This is usually handled by creating different products for different VAT rates.

 

 

Similar situtation in Germany: FastFood restaurants: take-a-way food has 7%, stay-here is 19%, usually handled via different products, too.

 

 

Same in France : only rates change (5.5% and 19.6%) (I wonder why they did not choose 5.55468 and 19.65548754, hey it's France ;o)

 

 

Has different VAT rates, for different type of goods 

 

 

Official EU document Wikipedia (could be more updated than EU document)

EU

yes

0%, 7%, 19%

Germany

yes

2.1%, 5.5% 19.6% (there is no 0% rate in France only conditionnal exemption)

France

yes

0%, 4%, 7%, 16%

Spain

yes

Apply VAT for sales in INTERNAL_ORGANIZATION country Official EU document

 

 

EU

yes

Apply VAT for sales outside EU

 

 

Buyer may get VAT back from German Customs Auth. when he proves, that goods leave Germany (or EU?)

Germany

yes

There are some exceptions with DOM-TOM (no metropolitan territories) and electricity.
See http://fr.wikipedia.org/wiki/Taxe_sur_la_valeur_ajout%C3%A9e#Territorialit.C3.A9 for details, notably about services
which can be complex

France

no: goods
complex : services

 

Poland

yes


Spain

no

Apply VAT for sales outside INTERNAL_ORGANIZATION country && inside EU && with valid VAT ID (B2B)

 

 

INTERNAL_ORGANIZATION may have to proof that goods left Germany (for Tax Auth.)

Germany

no

Found no such requirement in France, but sounds weird there is not a such need

France

no

In Poland there is also need for spedition document to have proof that goods left Poland

Poland

no

 

Spain

no

Apply VAT for sales outside INTERNAL_ORGANIZATION country && inside EU && without valid VAT ID (B2C)

 

 

 

Germany

yes

 

France

yes

 

Poland

yes

 

Spain

yes

Apply VAT for purchases like sales

 

 

 

EU

yes

...