- Document for Excel Invoice Manager
This version of the document, "Settings / Taxes Tab", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
Click thebutton on the worksheet to open the window. This is where you set the tax options for your invoice template.
The options on thetab control how the workbook calculates taxes. You can choose , , or . The tax name is a description string for the tax charges (GST, VAT, etc), and it will appear on your invoices and reports. The tax rate (a percentage) here is a default value that will be used to update the tax rate value on the worksheet each time you click the button.
|Tax invoice total including shipping cost||Tax 1 and tax 2 are calculated on the sum of the Subtotal + Shipping Cost|
|Tax 2 is applied to tax 1||Tax 2 is calculated on the sum of the Subtotal + Tax1|
|Tax rate can be zero||By default tax rates cannot be set to zero. If you check this option, you can set the tax rates to zero. This is useful if most of your customers do not have sales tax, but a few do. |
You still can set the tax rates on a per-invoice basis when creating invoices, by entering the tax rates directly into the cells namedand . However, this applies to the standard template only. If you are using a customized version of the template, the per-invoice tax rates feature may not work properly.
Invoice Template with Support for Product-Type Specific Tax Rates for a sample on customizing taxes.is flexible enough that allows you to define your own taxes. You can even modify the formulas to calculate taxes. However if you do this, please don´t use this tab to set tax options. See