28,967
edits
Changes
VAT setup, calculation and rounding rules (view source)
Revision as of 17:49, 22 November 2015
, 9 years ago→Second or Third Tax
Line 39:
Line 39:
== For Spain ==
−Specific management for spain are supported from Dolibarr 3.0.
−In spain, there is 2 more vat rate for each line:
−* The vat rate RE (a vat rate calculated on total without tax for products, and added to total to obtain total with tax)
−* The vat rate IRPF (a vate rate calculated on total without tax for services, and substracted from total to obtain total with tax)
−Both complementary taxes can't be found in an invoice. RE is applied only for products and IRPF only for services. Because IRPF tax is always negative, in credit invoices the total IRPF will be positive.
−'''Setup'''
−The two vat rate are applied automatically (if company has been setup to use them) on each lines (when added or edited). Value of rates are found into the dictionary table from the standard vat rate ([[Table llx_c_tva]]). Total with tax and total amount of vat is modified according to calculation.
−Setup example: For standard vat rate 10, Localtax 1 (RE) is set with type "3" (tax is applied on net price, for products only), rate 1.4%
−'''Example of calculation'''
−{|class="wikitable centre" width="80%"
−|- valign="top"
−|| ||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)=(D1*E)||nowrap="nowrap"|G<br>Tax RE (B*C*D2)=(D2*E)||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
−|}
−'''Example of calculation in credit notes'''
−{|class="wikitable centre" width="80%"+|- valign="top"
−|| ||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate||D2<br>IRPF||E<br>Total without tax<br>=(B*C)||F<br>Exact tax amount<br>=(B*C*D1)=(D1*E)||nowrap="nowrap"|G<br>Tax RE (B*C*D2)=(D2*E)||nowrap="nowrap"|H<br>Price inc standard vat + RE=(E+F+G)
−|-
−||1||nowrap="nowrap"|Product alpha||10||-10||21%||-21%||-100||0||21||100
−|}
−'''Note'''+R.E. (Localtax1) is applied to product sales and not to service sales. But a service may be invoiced in the same invoice with a product sale if this is related to the product sales and it increasing its cost (ex: shipping costs).
−Currently to treat this case you must enter these services (ex: shipping costs) with a free line, and indicating the type as product, not as service.
= Second or Third Tax =
= Second or Third Tax =
−== For Brazil ==
−See page [[BrasilTaxes]]
−== For Canada ==
== For Canada ==
Line 123:
Line 91:
There is a second vat.
There is a second vat.
It seems to work like vat RE for spain (See in a Spain chapter)
It seems to work like vat RE for spain (See in a Spain chapter)
+
+
+
+== For Spain ==
+Specific management for spain are supported from Dolibarr 3.0.
+
+In spain, there is 2 more vat rate for each line:
+* The vat rate RE (a vat rate calculated on total without tax for products, and added to total to obtain total with tax)
+* The vat rate IRPF (a vate rate calculated on total without tax for services, and substracted from total to obtain total with tax)
+
+Both complementary taxes can't be found in an invoice. RE is applied only for products and IRPF only for services. Because IRPF tax is always negative, in credit invoices the total IRPF will be positive.
+
+'''Setup'''
+
+The two vat rate are applied automatically (if company has been setup to use them) on each lines (when added or edited). Value of rates are found into the dictionary table from the standard vat rate ([[Table llx_c_tva]]). Total with tax and total amount of vat is modified according to calculation.
+
+Setup example: For standard vat rate 10, Localtax 1 (RE) is set with type "3" (tax is applied on net price, for products only), rate 1.4%
+
+'''Example of calculation'''
+
+{|class="wikitable centre" width="80%"
+|- valign="top"
+|| ||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)=(D1*E)||nowrap="nowrap"|G<br>Tax RE (B*C*D2)=(D2*E)||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
+|}
+
+'''Example of calculation in credit notes'''
+
+{|class="wikitable centre" width="80%"
+|- valign="top"
+|| ||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate||D2<br>IRPF||E<br>Total without tax<br>=(B*C)||F<br>Exact tax amount<br>=(B*C*D1)=(D1*E)||nowrap="nowrap"|G<br>Tax RE (B*C*D2)=(D2*E)||nowrap="nowrap"|H<br>Price inc standard vat + RE=(E+F+G)
+|-
+||1||nowrap="nowrap"|Product alpha||10||-10||21%||-21%||-100||0||21||100
+|}
+
+'''Note'''
+
+R.E. (Localtax1) is applied to product sales and not to service sales. But a service may be invoiced in the same invoice with a product sale if this is related to the product sales and it increasing its cost (ex: shipping costs).
+
+Currently to treat this case you must enter these services (ex: shipping costs) with a free line, and indicating the type as product, not as service.