30,909
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 12:07, 6 November 2015
, 10 years ago→For Canada
m (→For Spain) |
m (→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 | ||