Last updated 08/09/2020
Once you have downloaded your Alternative Tax Rates from QuickBooks Enterprise, you will need to decide how to assign them.
The ultimate goal here is to set up a logical system, so that the line items you import into QuickBooks Enterprise are taxed at the correct tax rate.
You will find documented below each possible way of automating Alternative Tax Rate assignments. It is also possible to manually override Alternative Tax Rates, and we have documented this underneath.
Because it is only possible to assign one Alternative Tax Rate to a line item, Cin7 has a system of prioritisation, explained at the bottom of this page.
You can view the Alternative Tax Rates in the general settings in Cin7.
You can apply Alternative Tax Rate to individual customers.
When adding a customer with an Alternative Tax Rate to a transaction, the specified tax rate will automatically apply to all the products in the transaction.
This means that unless otherwise specified, all products within this transaction will be taxed at the same tax rate.
You can apply Alternative Tax Rate so that sales from different branches are taxed with the same tax rate. This is particularly useful if you have multiple retail stores.
To apply an Alternative Tax Rate at a branch level:
Each sale is taxed based on the Tax Status setting in the branch contact. This happens at time of import - so unlike customers above, it is not visible in the actual transactions within Cin7. Branch level Alternative Tax Rate are applied unless otherwise defined at the customer level. See priorities below.
You may choose to assign Alternative Tax Rate manually at the time of sale, either to override automatic assignments or just to apply the Alternative Tax Rate on a case by case basis.
There are two places you can do this:
To apply an Alternative Tax Rate to an entire order, click on the Alternative Tax Rate dropdown and choose from the list. This will apply one specific tax rate to all line items in the order.
In a transaction, you can choose an Alternative Tax Rate for each line item by clicking into the Account column and then selecting from the dropdown list that appears.
When an Alternative Tax Rate is applied in multiple places, the Tax Rate that is ultimately applied is decided by the priority below (1 being the highest):
Lets say you have assigned Branch X to the Tax Rate 'GST (15%)'. You also assigned Customer Y to Tax Rate 'GST Free 0%' prior to this. When you sell to Customer Y from Branch X Tax rate 'GST Free 0%' will be applied, because ultimately the customer has a higher priority.
This may happen if your Tax Rate name is too long; the best thing to do is use a naming scheme that allows you to easily see the right account from the first few characters e.g. "GST" "No GST".