VAT setup, calculation and rounding rules: Difference between revisions

VAT setup, calculation and rounding rules (view source)

160 bytes added , 15 years ago

30,997

edits

@@ Line 2: / Line 2: @@
 = 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%"
+|- 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)
-|-
-||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)
 |}