Using the Xero Dashboard

Accounting for WET tax with Cin7 and Xero

How Wine Equalization Tax (WET) is implemented within Cin7 for Xero users.

Overview

The Wine Equalisation Tax (WET) is a value-based tax collected when wine is bought or sold in Australia.

If you make wine, import wine into Australia or sell it wholesale, you'll have to account for WET. Currently, WET is a tax of 29% of the wholesale value of wine.

Within Cin7 this means that when creating a Purchase Order or Sales Order, an additional 29% should be added to the wholesale value of applicable items in the order. This additional amount must then be passed to the appropriate account in Xero.

So you don't have to remember to apply WET tax, you can assign this tax to specific products, or specific customers or suppliers, so that the tax is automatically applied for the correct products.

Setting up WET

You can now enable WET on your end. This can be done by going to the Settings page for each of the modules below:

• CRM module - Select 'Yes' for the 'Show WET Tax' option
• Products module - Under 'Show Additional Fields In The Product Form', tick the WET box option
• Purchase Order module - Select 'Yes' for the 'Show WET Tax' option
• Sales Order module - Select 'Yes' for the 'Show WET Tax' option
• Xero Dashboard - Check the tickbox for WET and select the applicable WET liability account from the dropdown box.

WET setup has to be done by the Cin7 team - so simply ask your onboarder or the support team to set up WET for you. This will include the following:

• Adding WET to the POS (if required).
• Adding WET reports to the Standard Report module.

Please note that these options will only be visible in Australian (AU) accounts.

Flagging WET Applicable Products

Once the above options have been set up for you, you will be able to flag products for which WET is applicable.

To do this:

1. Find a product that is applicable for WET, and click on the product name.
2. Check the WET Tax check box.
3. Click Save.

Assigning WET Calculation to Customers

Next, assign each applicable customer a WET option. There are two options:

To assign these options to a customer:

1. From the CRM module, find a contact and click on their name.
2. From the WET Tax dropdown choose either WET on Retail or WET on Wholesale.
3. Click Save to save the contact details.

WET in Transactions

Now it's time to see the result of all the settings! You will notice that in each purchase order there is a field called WET Tax Status. When a contact is entered that has a WET option assigned to them, the field will automatically be populated with the rate assigned to the contact. If no WET option has been assigned you can always manually enter the correct option.

You will be able to see what product has WET assigned from the WET column in the line item list.

There are three relevant scenarios:

WET on Purchases

For Purchase Orders, you will almost certainly use 'WET on Wholesale'.

When a product is entered that has WET Tax checked in its product details, WET Tax will be calculated for that item.

The total WET for a Purchase Order order will be shown in the Surcharge field at the bottom of the order.

WET on Wholesale Sales

For WET on wholesale sales:

• WET Tax Status must be set to WET on Wholesale
  
• Tax must be set to exclusive, and
• WET is charged at 29% of the value of applicable goods.

The total WET for a Sales Order will be shown in the Surcharge field at the bottom of an order:

WET on Retail Sales

For WET on Retail Sales:

• WET Tax Status should be set to WET on Retail
• Tax must be set to inclusive, and
• WET will represent 29% of the notional wholesale value of the applicable products, using the ‘half retail price method’ i.e. retail price x 0.5 x 0.29. See the Australian Tax Office Website for more information.

The total WET for a Sales Order will be shown in the Surcharge field at the bottom of an order:

WET on Retails Sales in the POS

WET can also be set up for the POS for retail sales only.

In order for WET to be applied in the POS the following criteria must be true:

• The customer has been assigned WET Retail in the backend
• The product has been assigned WET.

WET will be calculated as above and will appear also appear in the Sales Order when ultimately synced to the backend.

WET and Xero

To prepare Xero to receive WET applicable transactions, you must first make sure you have a current liabilities account for WET.

Next, add this account number to your Xero settings in Cin7.

1. Whilst logged in as an Administrator click on your username, top right, then click Settings.
2. From the Accounting Menu, click Xero Setup.
3. Click on Default Accounts.
4. Add the number of your liability account to the WET Tax field.
5. Click Finish.

Provided you have followed the above instructions above, when importing a Purchase Order the specified liability account will be debited. When importing a Sales Order to Xero the specified liability account will be credited.

Reporting on WET

Finally, to get an overview of the Taxes being collected, you can view a report:

1. From the left navigation click Admin and Reports, then Standard Reports.
2. Select WET Tax (Invoice Date).

In this report you will be able to see the total sales and total taxes collected.