29,128
edits
Changes
VAT setup, calculation and rounding rules (view source)
Revision as of 12:07, 6 November 2015
, 9 years ago→For Canada
Line 95:
Line 95:
{|class="wikitable centre" width="80%"
{|class="wikitable centre" width="80%"
|- valign="top"
|- valign="top"
−|| ||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate GST||D2<br>Vat rate PST||E<br>Total without tax<br>=(B*C)||F<br>Tax GST<br>=(B*D1*E)||nowrap="nowrap"|G<br>Tax PST (B*C*D2)||nowrap="nowrap"|H<br>Price inc GST + PST=(E+F+G)
+|| ||A<br>Description||B<br>Quantity||C<br>Unit price||D1<br>Vat rate GST||D2<br>Vat rate PST||E<br>Total without tax<br>=(B*C)||F<br>Tax GST<br>=(B*C*D1)=(D1*E)||nowrap="nowrap"|G<br>Tax PST (B*C*D2)=(D2*E)||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