How to handle spirits in vintrace

vintrace now supports the handling of spirits on your TTB reports. For more details please read here: http://jx2.com.au/support/question/support-for-spirits-in-the-ttb-report-us/

Currently VINx2 does not report spirit use in our 702 Report and requires you to do some calculations outside of the report to get the correct value.  This is something we plan to rectify in the near future in the meantime the following is a guide to help make tracking your spirits easy in VINx2.

Remember you can click on the images to see larger copies of them

Setup Step 1. Setup A New Tax Class
This first step allows you to bring the spirit into the system and not have it effect any of the values in your current Tax Classes. This is done via the Winery Setup -> Policy -> Tax Class

Give the class the name and description ‘Spirits’ and use a TTB Class ref of ‘y’.
The Class ref of ‘y’ is really important!

Setup Step 2: Create an ‘Add Spirit’ treatment
This time in Winery Setup -> Treatment -> Treatment(Product) you can create a treatment to show that you added spirits. Make sure the Product type is set to Wine/Juice

Setup Step 3. Make Sure your multi top operation allows for treatments.
Open up a multi top operation and make sure there is a treatment directly under transfer options.

This can only be turned on by a support tech so please email us at support@jx2.com.au to request that treatments be turned on for Multi Topping Operations.

Ok so now the setup is done we can put it to use the following steps outline the use of these items.

Step 1. Bulk Intake Some Spirits
Using a standard Bulk Wine Intake bring the volume of spirits you have received and put it into the correct tank. You will be able to give the spirit all the grape origin information you require as per any bulk wine. The most import option is to ensure you give the spirit a tax state of ‘Bonded’ and a tax class of ‘Spirit’

Step 2. Use the Spirit
So now you have a tank full of spirit and you want to use it with some of your wine. Use the multi topping operation. This operation deliberately allows you to blend wines across different classes so you can use your spirit with a wine in any class. However be aware that the resulting blend will take on the tax class of the largest component. So if you are putting more spirits in than you have wine the whole lot will end up in our new spirit class and drop off the 702 Report.

When filling in the multi top make sure the Topping Mode is set to increase volume and select the ‘Add Spirit’ treatment we setup earlier.

Once you enter this operation your wine will show the ‘Add spirit’ in the history and it’s composition will include the spirit origins as well.

702 Reporting
Now that some of the spirit is in a wine with a reportable tax class VINx2 will show this gain in Section A Row 9. Inventory Gains. If this is were you currently report gains from spirit use then you need do nothing with this value. If you wish to report this gain on a different Row of the 702 you will need to calculate how much of Row 9 is from spirit.

To do this run the 702 Break down report selecting only spirit as an option

This will open the CSV in Excel where you can see how much spirits has been consumed in the ‘Inventory and non-tax losses’ column which by default is Column AK at the time of writing this documentation.

Once you have this value you then simply subtract this amount from Section A Row 9 and Add it to the Section/Row you wish to report this value in.

You will also have to report how much spirit you had on hand at the beginning of the period, how much you received, how much you used and the balance at end of period. Each of these are all in the CSV in the columns titled “Opening balance”, “Bulk received in bond”, “Inventory and non-tax losses” and “Closing balance”