30,997
edits
VAT setup, calculation and rounding rules: Difference between revisions
Jump to navigation
Jump to search
VAT setup, calculation and rounding rules (view source)
Revision as of 00:28, 16 December 2014
, 11 years ago→For Canada - Quebec
m (→For Spain) |
|||
| Line 69: | Line 69: | ||
== For Canada - Quebec == | == For Canada - Quebec == | ||
Lexique. | Lexique. | ||
* TPS = Taxe sur les Produit et Services | * GST (TPS = Taxe sur les Produit et Services for Quebec) | ||
* TVQ = Taxe de Vente Québecoise | * PST (TVQ = Taxe de Vente Québecoise for Quebec) | ||
'''Setup''' | '''Setup''' | ||
The | The GST is applied automatically on each lines (when added or edited) when vat rate used is 5. | ||
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. | 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: When | Setup example: When GST rate is 5, tax 2 (PST) is type 1 (tax 2 is added for product and services and calculated on net price), rate is 9.975 | ||
'''Example''' | '''Example''' | ||
| Line 86: | Line 83: | ||
{|class="wikitable centre" width="80%" | {|class="wikitable centre" width="80%" | ||
|- valign="top" | |- valign="top" | ||
|| ||A<br>Description||B<br>Quantity||C<br>Unit price||D<br>Vat rate | || ||A<br>Description||B<br>Quantity||C<br>Unit price||D<br>Vat rate GST||D<br>Vat rate PST||E<br>Total without tax<br>=(B*C*D)||F<br>Tax GST<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax PST (B*C*D)||nowrap="nowrap"|H<br>Price inc GST + PST=(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 | ||