Règles de paramétrage, calcul et arrondi de TVA: Difference between revisions

Jump to navigation Jump to search

Règles de paramétrage, calcul et arrondi de TVA (view source)

Revision as of 18:27, 11 May 2014

208 bytes added ,  12 years ago
m
no edit summary
VisualWikitext
mNo edit summary
mNo edit summary
Line 2: Line 2:




= Standard VAT and rounding rules =
= TVA standard et règles d'arrondi =
Let's start with the example we will use. Imagine an invoice that contains the following lines (We also live into a country where total must be rounded with 2 decimal numbers).
Commençons par l'exemple que nous allons utiliser. Imaginons une facture qui contient les lignes suivantes (On suppose aussi être dans un pays ou les totaux doivent être arrondis avec 2 chiffres maximum après la virgule).


{|class="wikitable centre" width="80%"
{|class="wikitable centre" width="80%"
|- valign="top"
|- valign="top"
||&nbsp;||A<br>Description||B<br>Quantity||C<br>Unit price||D<br>Vat rate||E<br>Total without tax<br>=(B*D)||F<br>Exact tax amount<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax amount rounded<br>on 2 dec<br>=round(F)||nowrap="nowrap"|H<br>Exact price<br>inc tax<br>=(E+F)||nowrap="nowrap"|I<br>Price inc tax rounded<br>on 2 decimals<br>=(E+G)
||&nbsp;||A<br>Description||B<br>Quantité||C<br>Prix unitaire||D<br>Taux de TVA||E<br>Total sans tax<br>=(B*D)||F<br>Montant taxe exacte<br>=(B*D*E)||nowrap="nowrap"|G<br>Montant taxe arrondie<br>sur 2 déc<br>=round(F)||nowrap="nowrap"|H<br>Prix exact<br>inc tax<br>=(E+F)||nowrap="nowrap"|I<br>Price avec tax arrondi<br>sur 2 décimals<br>=(E+G)
|-
|-
||1||nowrap="nowrap"|Product alpha||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.364||1.36
||1||nowrap="nowrap"|Product alpha||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.364||1.36
Line 14: Line 14:
|}
|}


We have 2 ways to calculate the total of invoice: making a sum of rounding lines or rounding the sum of lines.
Il y a 2 manières de calculer le total de la facture: faire la somme des lignes arrondies ou l'arrondi de la somme des lignes.


1) If we choose to make the sum of lines after rounding (on 2 decimals) lines, we get:
1) Si nous choisissons de faire la somme des lignes après les avoir arrondis (sur 2 décimals), on obtient:
* Total without tax: 1.24(E1) + 1.24(E2) = '''2.48'''
* Total sans taxe: 1.24(E1) + 1.24(E2) = '''2.48'''
* Total tax 10%: 0.12(G1) + 0.12(G2) = '''0.24''' (we sum the rounded values of tax on each line)
* Total taxe 10%: 0.12(G1) + 0.12(G2) = '''0.24''' (nous sommons les valeures arrondis de chaque ligne)
* Total inc tax (we sum total without tax + total tax): 2.48(Ex) + 0.24(Gx) = '''2.72'''
* Total avec taxe (nous sommont le total sans taxe + le total de taxe): 2.48(Ex) + 0.24(Gx) = '''2.72'''


Note that if we sum rounded price inc tax on each line, we get: 1.36(I1) + 1.36(I2) = '''2.72''' (same result so we know there is no error)
Notez que si nous sommons le prix incluant la taxe arrondi sur chaque ligne, nous avons: 1.36(I1) + 1.36(I2) = '''2.72''' (même résultat, aussi nous savons qu'il n'y a pas d'erreur)


2) If we choose to round (on 2 decimals) amount after summing all lines, we get:
2) Si nous choisissons de faire l'arrondi (sur 2 décimals) du montant total après avoir sommer les lignes, nous avons:
* Total without tax: 1.24(E1) + 1.24(E2) = '''2.48''' (same than in method 1)
* Total without tax: 1.24(E1) + 1.24(E2) = '''2.48''' (same than in method 1)
* Total tax 10%: (1.24(E1) + 1.24(E2)) * 10% = 0.124 + 0.124 = 0.248 rounded to nearest to have a total on 2 decimals give '''0.25''' (we sum amount without tax for each lines, calculate vat rate on this and after we round value on 2 decimals)
* Total tax 10%: (1.24(E1) + 1.24(E2)) * 10% = 0.124 + 0.124 = 0.248 rounded to nearest to have a total on 2 decimals give '''0.25''' (we sum amount without tax for each lines, calculate vat rate on this and after we round value on 2 decimals)
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/32212"

Navigation menu