30,915
edits
VAT setup, calculation and rounding rules: Difference between revisions
Jump to navigation
Jump to search
m
VAT setup, calculation and rounding rules (view source)
Revision as of 11:58, 6 November 2015
, 10 years ago→Standard VAT and rounding rules
| Line 7: | Line 7: | ||
{|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||E<br>Total without tax<br>=(B*C | || ||A<br>Description||B<br>Quantity||C<br>Unit price||D<br>Vat rate||E<br>Total without tax<br>=(B*C)||F<br>Exact tax amount<br>=(B*D*E)||nowrap="nowrap"|G<br>Tax amount rounded<br>on 2 dec<br>=round(F)||nowrap="nowrap"|H<br>Exact price<br>inc tax<br>=(E+F)||nowrap="nowrap"|I<br>Price inc tax rounded<br>on 2 decimals<br>=(E+G) | ||
|- | |- | ||
||1||nowrap="nowrap"|Product alpha||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.364||1.36 | ||1||nowrap="nowrap"|Product alpha||1||1.24||10%||1.24||0.124||0.12||1.24+0.124=1.364||1.36 | ||