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

Jump to navigation Jump to search
Line 57: Line 57:
{|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||D<br>RE||E<br>Total without tax<br>=(B*C*D)||F<br>Exact tax amount<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax RE (B*C*D)||nowrap="nowrap"|H<br>Price inc standard vat + RE=(E+F+G)
||&nbsp;||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate||D2<br>RE||E<br>Total without tax<br>=(B*C)||F<br>Exact tax amount<br>=(B*C*D1)||nowrap="nowrap"|G<br>Tax RE (B*C*D2)||nowrap="nowrap"|H<br>Price inc standard vat + RE=(E+F+G)
|-
|-
||1||nowrap="nowrap"|Product alpha||10||10||10%||1.4%||100||10||1.4||111.4
||1||nowrap="nowrap"|Product alpha||10||10||10%||1.4%||100||10||1.4||111.4
Line 81: Line 81:
{|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 TPS||D<br>Vat rate TVQ||E<br>Total without tax<br>=(B*C*D)||F<br>Tax TPS<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax TVQ (B*C*D)||nowrap="nowrap"|H<br>Price inc TPS + TVQ=(E+F+G)
||&nbsp;||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate TPS||D2<br>Vat rate TVQ||E<br>Total without tax<br>=(B*C)||F<br>Tax TPS<br>=(B*C*D1)||nowrap="nowrap"|G<br>Tax TVQ (B*C*D2)||nowrap="nowrap"|H<br>Price inc TPS + TVQ=(E+F+G)
|-
|-
||1||nowrap="nowrap"|Product alpha||10||10||5%||9.975%||100||5||9.98||114.98
||1||nowrap="nowrap"|Product alpha||10||10||5%||9.975%||100||5||9.98||114.98
Line 99: Line 99:
{|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||D<br>Vat rate withholding tax||E<br>Total without tax<br>=(B*C*D)||F<br>Tax VAT<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax 2 (B*C*D)||nowrap="nowrap"|H<br>Price inc VAT + Tax 2=(E+F+G)
||&nbsp;||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate||D2<br>Vat rate withholding tax||E<br>Total without tax<br>=(B*C)||F<br>Tax VAT<br>=(B*C*D1)||nowrap="nowrap"|G<br>Tax 2 (B*C*D2)||nowrap="nowrap"|H<br>Price inc VAT + Tax 2=(E+F+G)
|-
|-
||1||nowrap="nowrap"|Product alpha||10||10||22%||-20%||100||22||-20||102
||1||nowrap="nowrap"|Product alpha||10||10||22%||-20%||100||22||-20||102
Line 114: Line 114:
{|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||D<br>Vat rate AIRSI||E<br>Total without tax<br>=(B*C*D)||F<br>Tax VAT<br>=(B*C*D)||nowrap="nowrap"|G<br>Tax 2 (B*C*D)||nowrap="nowrap"|H<br>Price inc VAT + Tax 2=(E+F+G)
||&nbsp;||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate||D2<br>Vat rate AIRSI||E<br>Total without tax<br>=(B*C)||F<br>Tax VAT<br>=(B*C*D1)||nowrap="nowrap"|G<br>Tax 2 (B*C*D2)||nowrap="nowrap"|H<br>Price inc VAT + Tax 2=(E+F+G)
|-
|-
||1||nowrap="nowrap"|Product alpha||10||10||18%||7.5%||100||18||8.85||102
||1||nowrap="nowrap"|Product alpha||10||10||18%||7.5%||100||18||8.85||115.85
|}
|}

Navigation menu