29,033
edits
Changes
VAT setup, calculation and rounding rules (view source)
Revision as of 17:42, 18 August 2011
, 13 years ago→Standard usage
Line 2:
Line 2:
|-
−||Product 2||1||1.24||10%||1.24||0.124||1.24+0.124=1.354||1.24+0.12=1.36 (rounded to nearest to have price on 2 decimals)
= Standard usage =
= Standard usage =
−Let's start with the example we will use. Imagine in invoice that contains the following lines (We also live into a country where total must be rounded with 2 decimal numbers).
+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).
{|class="wikitable centre" width="80%"
{|class="wikitable centre" width="80%"
+|- valign="top"
+||Col/Line||A<br>Description||B<br>Quantity||C<br>Unit price||D<br>Vat rate||E<br>Total without tax||F<br>Exact tax amount||nowrap="nowrap"|G<br>Tax amount rounded<br>on 2 dec||nowrap="nowrap"|H<br>Exact price<br>inc tax||nowrap="nowrap"|I<br>Price inc tax rounded<br>on 2 decimals
|-
|-
−||Desc||Qty||Unit price||Vat rate||Total without tax||Exact tax amount||Exact price inc tax||Price inc tax rounded on 2 decimals
+||1||nowrap="nowrap"|Product 1||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.354||1.24+0.12=1.36 (rounded to nearest)
|-
|-
−||Product 1||1||1.24||10%||1.24||0.124||1.24+0.124=1.354||1.24+0.12=1.36 (rounded to nearest to have price on 2 decimals)
+||2||nowrap="nowrap"|Product 2||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.354||1.24+0.12=1.36 (rounded to nearest)
−|}
|}