Complete the following to set up the New Zealand’s alcohol excise duty rates in vintrace and integrate the excise tax as a liability in an external accounting package such as Xero. 

Setting the Alcohol Metric

It’s important to confirm that the Excise Alc Metric to Alcohol is set to Alcohol. If it isn’t set to Alcohol, wine that you've packaged won’t automatically calculate the estimated alcohol percentage even if you’ve entered the % alcohol on a packaged stock item.

To confirm that the Excise Alc Metric to Alcohol is set to Alcohol in the Winery Setup window (Setup Options > Work-flow > Defaults):

1. Click  Set Up in the sidebar.
2. Click General.
3. From the Defaults tile, click Configure.
4. Select the System tab.
5. Set the Excise Alc Metric to Alcohol.

6. Click Apply. 

Setting Up a Tax Rate

Set up the appropriate tax rates as detailed in our Setting Up Sales Tax Rates article.

Setting Up an Excise Duty

You can set up an excise duty in the Winery Setup window (Setup Options > Tax > Excise Duties):

1. Click  Set Up in the sidebar.
2. Click Tax.
3. From the Excise Duties tile, click Configure.
4. Click New Excise Duty.
5. Specify the details for the excise duty. Below is an example for the 2018-2019 excise rates for wine.

Only one excise rate may be active for a date range.

6. Click Save.

Linking the Tax Rate to a Sales Price List

When you create sales orders, it’s important to ensure that the correct tax rate is set for the items you’re selling. You can do this by setting the tax rate for the price list.

To link the tax rate to a sales price list:

1. Create or edit a sales price list.
2. Set the Default Tax Rate of the price list to the tax rate that you created.

3. Click Save.

Alcohol Value

If you’ve measured the metrics and have a volume on your wine, vintrace calculates the alcohol percentage. When you add items to a sales order where the excise tax rate is selected, you may be asked to confirm the alcohol content of your wine.

Confirming or modifying the alcohol percentage also sets the stock item’s alcohol content.

Below is an example of a sales order with two different items that have the same value, but different alcohol metrics to illustrate the difference between the excise rates.

Reporting on Excise Tax 

To report on your excise tax, run either the Sales Summary Report or the Sales Tax Report.

To access these reports:

1. Click  Reports in the sidebar.
2. Select Sales.