Blog Post

The AccountRight Blog
4 MIN READ

Wine Equalisation Tax (WET) for cellar door sales

SupportNoteGuy's avatar
SupportNoteGuy
MYOB Staff
9 years ago

WET is a tricky area of taxation which usually requires assistance from an accounting advisor to set up in your MYOB software.

 

To learn more about WET and the producer WET rebate, visit the ATO website.

 

This article is provided for guidance only - it might not be suitable for your business requirements. If you need clarification, check with your accounting advisor or post your question below.

 

To track WET for cellar door sales, you'll need to create some new tax codes, accounts, and an inventory item. We'll describe these below, but for details on creating them press F1 in your MYOB software to view the help.

 

 

Set up a new tax code for Cellar Door Sales

 

The rate of this tax is 50% of the WET based on the tax inclusive retail value.

  • WET Tax=29%
  • Modified rate for cellar door sales=14.5%
  • GST on modified rate=14.5% x 1.1=15.95%
  • As the WET is calculated on the tax inclusive retail price, 15.95% needs to be expressed as a tax inclusive percent, this is equal to:
    • Tax rate/(1-Tax Rate) = 0.1595/0.8405 = 18.9768
    • The tax inclusive WET rate is equal to 18.9768%

Here's an example:

 

9271-1.PNG

 

 

 

Set up a tax code for GST based on the WET inclusive retail price

 

This is equal to the GST rate plus 10% of the WET, in other words 18.9768% X .1 = 1.89768% + 10% = 11.8977%.

 

Here's an example:

 

9271-2.PNG

 

 

Set up a consolidated tax code to combine CDS and CDG

 

This tax code will be used on sales invoices. The total value of the combined tax should equal 30.8745%. 

 

Here's an example:

 

9271-3.PNG

 

 

Set up two new accounts to track the producer WET rebate

 

Create a liability account called 'Producer WET Rebate'. This account is used to track the amount of rebate owed to you by the ATO. It is set up as a liability account so that it is grouped with your other tax tracking accounts and will have a debit (negative) balance and in effect be an asset.

 

Here's an example:

 

9271-4.PNG

 

Also create an income account called 'WET Refundable'. This account will track the rebate amount paid to you by the ATO.

 

Here's an example:

 

9271-5.PNG

 

 

Set up two new tax codes to calculate the WET rebate

 

Create a new tax code called "Producer WET Rebate". Make the Tax Type Goods & Services Tax with a rate of 16.959%. The WET rebate is calculated as 29% of half of the retail price (including WET and GST), or 14.5% of the full retail price. The equivalent inclusive percentage is 0.145 divided by 0.855 (in other words 1 - 0.145), which equals 16.959%.

 

Make the Linked Account for Tax Collected the liability account set up earlier.


As this tax code should only ever be used for sales, you may want to create a liability account called 'Misallocated GST' and select this account as the Linked Account for Tax Paid. This way, if the tax code is ever accidentally used in a purchase, the misallocated GST will be isolated.

 

Here's an example:

 

9271-6.PNG

 

Create a second new tax code called "Producer WET Rebate offset".

 

Make the Tax Type Goods and Services Tax with a rate of 16.959%.

 

Make the Linked Account for Tax Collected the income account created earlier.

 

Similarly, select the 'Misallocated GST' account as the Linked Account for GST Paid.

 

Here's an example.

 

9271-7.PNG

 

 

Set up a new inventory item to record the WET rebate

 

Create a new inventory item called "WET Rebate Item". Select the option I Sell This Item and choose your applicable income account. On the Selling Details tab, choose N-T as the Tax Code When Sold.

 

Here's an example:

 

9273-3a.PNG

 

 

Enter your sales invoice

 

Enter your wine sales as Tax Inclusive. The first line contains the wine being sold, and the second and third lines handle the WET rebate using backorder quantities.

 

Here's an example:

 

9271-9.PNG

 

This sale will create an invoice which records the WET and GST payable by the customer, and also an order that will account for the WET rebate to the wine producer.

 

Before recording the sale, go to the Edit menu and choose Recap Transaction. This will show the journal entries from the sale which will look like the example shown below:

 

9271-10.PNG

 

Note that the Sales Tax Payable is half the retail value ($60) x 29%, and that the GST collected equals 1/11th of the $120 sale price.

 

The order created above needs to be recorded as an invoice so that the WET rebate payable is recorded in the accounts. Go to the Sales command centre, click Sales Register and the click on Orders tab. Locate the order and open it. Make sure that all of the details are correct and then click the Invoice button to convert the order to an invoice. Click Record. The invoice will be for $0.

 

A negative liability (asset) will be posted for the amount of the producer rebate ($120 x 29% x 50%=$17.40), which will be cleared when the rebate is received. Also, the amount of the rebate will be recorded against an income account.

 

How are the cellar door sales and the rebate reflected in the BAS?

 

The tax codes CDS and CDG should be selected at G1 on the calculation sheet of the BAS. CDS should also be selected at 1C to show the WET that is payable.

 

The producer rebate should be entered at 1D, 'Wine Equalisation Tax Refundable'. This can be done in BASlink by clicking the Setup button at field 1D and selecting the PWR tax code used in the example above.

 

9271-12.JPG

 

If you're reporting GST on a cash basis, you'll have to manually enter the figure in to the T1 field.

 

Hope this helps. Feel free to post any questions or comments you may have on this topic. One of our Business Gurus or other experts on this forum should be able to help you further.

Updated 9 years ago
Version 1.0
  • Hi Jmac,

     

    Thank you for your post confirming it's a viable approch. As for the customizing packing slip as an invoice, if you could post a customised packing slip picture, or give more instructions regarding this. Thanks. 

  • There is an error on the last page regarding the WET refundable.  When using cash accounting method the figure needs to be manually entered in the 1D field NOT T1 (which is PAYG instalment income).

     

    Also, BK-Julie, the invoice cannot hide the WET rebate items, you need to customise the packing slip and use that as an invoice, it does not show the WET rebates.  I know it's a while since you posted, but thought this was worth acknowledging.  It's a slightly clunky approach (you can't email packing slips straight out of MYOB as far as I'm aware) but it does work.

     

    I wish MYOB would run a course specific to WET set up in MYOB, it would be extremely useful.  However the above instructions are good - apart from the little error I mentiond.

  • KGrove's avatar
    KGrove
    Contributing User

    Is this the process you do before BAS? Not sure why it's a zero figure. I need to put payments against it. 

     

    I'm a winery producer and need to record the wet and gst so that i can use the BAS function in accountright. 

  • hello in the above sales invoice example, is there a way to hide the wet rebate line items form the actual printed invoice that the customer receives