Configure and collect WET (QuickBooks Online)
Overview
Find out how to configure Cin7 Omni and your QuickBooks Online integration to collect wine equalisation tax (WET).
Only businesses registered for tax in Australia must collect WET.
Wine equalisation tax (WET) applies to sales and purchases of wine classified as an assessable dealing by the Australian Tax Office (ATO).
If you’re based in Australia and buying or selling wine or wine products, you can configure Cin7 Omni to automatically collect WET on assessable dealings, and configure your QuickBooks Online integration to allocate WET to a liability account.
Only businesses registered for tax in Australia must collect WET. Find out more about wine equalisation tax (WET) and assessable dealings on the website of the Australian Tax Office (ATO).
Configure WET
Before collecting WET, you must
enable Cin7 Omni to collect WET,
tag products and contacts that incur WET, and
choose a QuickBooks Online liability account where WET gets allocated.
1. Enable Cin7 Omni to collect WET
First, log in to Cin7 Omni as an administrator and enable WET for contacts:
From the navigation, open the CRM.
Select Settings and open the tab General.
Set Show WET Tax to Yes.
Select Save.
Then enable WET for products:
From the navigation, open Products.
Select Settings and open the tab General.
Under Show Additional Fields In The Product Form, select WET.
Select Save.
And finally, enable WET for transactions:
From the Sales menu in the navigation, open Sales Orders.
Select Settings and open the tab General.
Under WET Tax, set Show WET Tax to Yes.
Select Save.
From the Purchases menu in the navigation, open Purchase Orders.
Select Settings and open the tab General.
Under WET Tax, set Show WET Tax to Yes.
Select Save.
2. Tag products and contacts that incur WET
Whether a transaction incurs WET depends on what sold, who sold it, and who they sold it to. So you must tag products and contacts that may give rise to WET.
Then, when you buy or sell a tagged product in a transaction with a tagged contact, Cin7 Omni will calculate the WET liability of that assessable dealing.
First tag each product WET applies to:
From the navigation, open Products.
Open the product.
Under Special Tax, select WET.
Select Save and Close.
Then tag each customer and supplier who gives rise to WET liability:
From the navigation, open the CRM.
Open the contact.
-
Under Accounts, choose a WET Tax option:
Choose WET on Retail if transacting with this contact gives rise to a retail or own use assessable dealing – Cin7 Omni always uses the half retail price method to calculate WET on retail.
Choose WET on Wholesale if transacting with this contact gives rise to a wholesale assessable dealing.
3. Choose a QuickBooks Online liability account where WET gets allocated
Now you must choose a liability account where WET gets allocated.
First, contact Cin7 Omni support and ask them to enable WET in your QuickBooks Online integration, and choose a liability account in your QuickBooks Online chart of accounts to allocate WET to.
Then configure your QuickBooks Online integration:
Log in to Cin7 Omni as an administrator.
From the Accounting menu in the navigation, open your QuickBooks Online integration.
Open Settings.
Under Default Accounts, set WET Tax to your chosen liability account.
Select Save Settings.
Collect WET
Once you’ve configured WET (see above), Cin7 Omni will automatically calculate WET for transactions that qualify as assessable dealings – that is, for sales and purchases of tagged products in transactions with tagged contacts.
When you create a transaction for a tagged contact, the contact’s WET option (retail or wholesale) is displayed in the WET Tax Status field on the transaction. Then, when you add a tagged product to the transaction, that product’s WET liability is calculated according to the contact’s WET option:
If the contact’s WET Tax Status is WET on Wholesale, the WET liability is calculated and recorded in the Surcharge field.
If the transaction is tax exclusive and the contact’s WET Tax Status is WET on Retail, the WET liability is calculated and recorded in the Surcharge field.
If the transaction is tax inclusive and the contact’s WET Tax Status is WET on Retail, the WET liability is calculated and included in the Product Total.
Optionally, you can manually set or override each transaction’s WET Tax Status.
Finally, when you sync the transaction with QuickBooks Online, the WET is allocated to your chosen liability account – the account will be credited for WET on sales orders and debited for WET on purchase orders.
View WET insights
Find insights on your assessable dealings by installing Cin7 Omni’s WET Tax (Invoice Date) report:
Log in to Cin7 Omni.
From the navigation, open Insights.
From the navigation, open the Reports Library.
Find WET Tax (Invoice Date) and select Install.
Now the WET Tax (Invoice Date) report is available under Standard Reports in Insights.