This "Charging GST Tax on Shipping Cost" document was written for Excel Invoice Manager. If you are using Invoice Manager for Excel (namely Uniform Invoice Software), This customization of tax formulas is also supported. Visit our GST Invoice Template for Australia for a sample.
The default / standard invoice template included in setup program has two tax names pre-defined - the first is , and the second is .
The program also offers an option "Tax invoice total including shipping cost" on thetab of the window that can be opened by clicking the button on the worksheet. If the option is checked, both taxes are calculated on the sum of the + .
If you charge GST-only on shipping cost, here is how to customize the default template.
There are two ways you can address this.
You can also bypass the "" option by customizing the formula of the GST tax cell to include shipping cost and ignore the option.
=ROUND(IF(oknTaxType<>2,0,oknTax2Rate*(oknLineTotalTaxable+ IF(oknTaxTotalIncludingShippingCost=0,0,oknShippingCost)+ IF(oknTax2IsAppliedToTax1=0,0,oknTax1))),2)
As you can see, now the second tax (GST) is charged on both taxable subtotal and shipping cost, even if the "" option is not checked.
This second solution also works for many other template available here on InvoicingTemplate.com as it does not require the "Tax invoice total including shipping cost" option.
A tutorial on customizing the standard invoice template to enable product-type specific tax rates in
Click the following links to download the templates created in this tutorial: