Federal and state tax reclassification (US)

This feature was added in vintrace version 7.4.4

Due to the difference in federal and state tax classes, vintrace has introduced changes to help you track your bulk and bottled wines by adding a gap class of 14 to 16% . We’ve automatically converted the Not more than 16% tax class to Not more than 14% and 14-16% tax classes.

Wines that have a tax class of 14 to 16% in vintrace are included in the Not over 16% class in the Federal tax report, and in the 14 to 21% class in the State tax report.

Product Overview tax class

The Tax class in Product overview shows the Federal tax class.

Click the Tax information icon to view Federal and State tax class for the wine.

Stock Item Overview tax class

The Stock Item Overview shows both the Federal and State tax classes.

Federal and state tax reclassification

We’ve made it easy for you to reclassify those wines that are in the Not more than 16% tax class to the 14 to 16% tax class through the new tax class reclassification form.

To access the tax class re-classification form, click the Federal & state tax reclassification link on the right side of the vintrace desktop under the logo.

In the menu, there are separate links for reclassifying your bulk wine and bottled wine (if you have inventory module turned on).

Reclassifying bulk wine as 14 to 16% tax class

Wines that were in the Not over 16% and 16 to 21% tax classes and have a recent alcohol between 14% and 16% have been pre-selected for you, and you can easily select any wines that don’t have a recent alcohol but should be moved to the 14 to 16% tax class.

In the example below, we want to change the tax class of the 11CHBLRR-DEMO wine batch that has an alcohol metric of 14.65% from the Not over 16% tax class to the 14 to 16% tax class. Select the Start date you want to set on the reclassify action and the Operator.

Note: Wines that have left the system since January 1, 2018, that is, bulk dispatched or packaged, are displayed as a separate line entry in the list.

  1. Click the Vessel link of each wine to open the Product Overview screen for the wine.In the example, the 11CHBLRR-DEMO wine in vessel T40-01 is currently classified as Not over 16% tax class.

    If you look at the history of the wine, there was a declare wine tax event on January 1, 2018. This was the first tax reclassification done to update the tax class to the new Not over 16% for the TTB tax reform changes.

    Looking at the Historic Revision of the packaged 11CHBLRR-DEMO wine, it had a tax class of  Not over 16% and history shows that it was packaged on January 6, 2018.

  2. Click Reclassify in the Federal & State tax reclassification form to confirm the tax class change to 14 to 16%.
  3. After the reclassification, go the Product Overview of the wine and click on the TTB information icon to view the Federal and State tax classes. Wines that are in the 14 to 16% vintrace tax class are classified under Not over 16% in Federal tax reporting and under 14 to 21% tax class in the State tax reporting.

    Viewing the wine’s history shows that a treatment has been applied to the wine to change the tax class and the operation date is January 1, 2018.

    When you view the packaged 11CHBLRR-DEMO wine, the Federal and State tax classes have been updated and the tax event of the packaging has also been updated.

  4. There is no tax class change reflected in Section A – Not over 16% column (a) of the January 2018 TTB 5120.17 form because wines that are in the 14 to 16% vintrace tax class belong to the Not over 16% for Federal tax class reporting. However, for the State Government Tax Class Report, there is a tax class change from Not over 14% to 14 to 21% because wines that are in the 14 to 16% vintrace tax class belong to the 14 to 21% for State tax class reporting.For more information on the State Government Tax Class Report, click here.

 

Reclassifying bottled wine

On the Federal & State tax class reclassification – Bottled wine form, bottled wines that were in the Not over 16% and 16 to 21% tax classes but have an alcohol content of 14% to 16% have been pre-selected. Select the Start date of the reclassification.

In the example below, we want to change the tax class of stock item 11CH-CASE from Not over 16% to 14 to 16%.

  1. Click Code to open the Stock Item Overview screen of the bottled wine. In our example, 11CH-CASE currently has a Federal tax class of Not over 16% and a State tax class of Not over 14%.

    The History tab of the stock item shows that there are two stock actions that triggered a tax event since January 1, 2018.

  2. Click Reclassify in the Federal and State tax reclassification – Bottled wine form to confirm the tax class change.
  3. Open the Stock Item Overview screen, to view the updated tax classes.

    The tax events that occurred after January 1, 2018 have also been updated.

  4. There is no tax class change reflected in Section B – Not over 16% column (a) of the January 2018 TTB 5120.17 form because bottled stock that are in the 14 to 16% vintrace tax class belong to the Not over 16% for Federal tax class reporting. However, for the State Government Tax Class Report, there is a tax class change from Not over 14% to 14 to 21% because bottled that are in the 14 to 16% vintrace tax class belong to the 14 to 21% for State tax class reporting.For more information on the State Government Tax Class Report, click here.

Support for spirits used in wine production on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports spirits used in Part III – Summary of Distilled Spirits of the TTB Report of Wine Premises Operations in vintrace.

New spirit tax class

A new tax class “Spirit” is automatically created for you in Winery Setup – Policy – Tax Class. If you already have an existing “Spirit” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New spirit tax class

You have to input the alcohol percentage in Alcohol (%) field for your spirit tax class. It is important to input the Alcohol (%) for spirits since this value will be used in calculating the proof gallons in the TTB report.

Input alcohol percentage in spirit tax class

Any TTB event for this tax class will get reported in Part III column (a) in the TTB report.

Spirit tax class TTB Class ref

If you more than one alcohol %/proof, you may create additional spirit tax classes; add one (named appropriately) for each additional alcohol % and specify columns “b” through “d”.

TTB - Spirits - add new spirits tax classes

Bulk intake of 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 spirits product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the spirits product a tax state of “Bonded” and select the tax class “Spirits” you have setup in the previous step.

Bulk intake spirits

TTB reporting for spirits

Upon generating your TTB report, you have the option to view Part III in either proof gallons or gallons. The TTB requires reporting by proof gallons. Tick on Calculate Proof Gallons for Part III checkbox when you want to see the spirits reported in proof gallons.

Generate TTB report

The bulk intake of spirits we have done in the previous step is reported in Part III row 2 Received, under column (a). In the below example we have generated the report in proof gallons for spirits. For information on calculating proof gallons, click here for the TTB conversion table and formulas.

TTB report for bulk intake

Using spirits

So now you have a tank full of spirits and you want to use it with some of your wine. You can use spirits in any of the transfer operations in vintrace. Let’s take for example, you want to blend spirits into wine.

Blend spirits into wine

Important Note: the wine into which you are blending must already have been declared as vintrace doesn’t allow blending of declared and non-declared products. 

Once you complete the operation, the spirit used will be reported in Part III row 5 Used (shown in proof gallons).

TTP report for blending spirit into wine 1

And the  wine involved in the blend operation will be reported in Part I  in row 4 Produced by addition of wine spirits and in row 20 Used for addition of wine spirits.

TTP report for blending spirit into wine 2

 

 

Support for juice and concentrate on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports juice and concentrate use in Part IV – Summary of Materials Received and Used of the TTB Report of Wine Premises Operations in vintrace. This is to track juice/concentrate that is not intended to be fermented (i.e. it may sit in a tank or drum to be used for sweetening in production), and in other cases, it may be produced and perhaps sold to other wineries as concentrate.

From this point on “juice” is grape juice that is not intended to be fermented
(i.e. added to wines directly, potentially sold later on).

Summary of sections in this article

New juice tax class
Bulk intake of juice
TTB reporting for juice
Using juice
Extraction operation for juice

New concentrate tax class
Bulk intake of concentrate
TTB reporting for concentrate
Using concentrate

Undeclare juice for wine production

New juice tax class

A new tax class “Juice” is automatically created for you in Winery Setup – Policy – Tax Class. If you already have an existing “Juice” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New juice tax class

Any TTB event for this tax class will get reported in Part IV column (c) in the TTB report.

Juice tax class 2

Bulk intake of juice

Using a standard Bulk Wine Intake bring the volume of juice you have received and put it into the correct tank. You will be able to give the juice product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the juice product a tax state of “Bonded” and select the tax class “Juice” you have setup in the previous step.

Juice bulk intake

TTB reporting for juice

The bulk intake of juice we have done in the previous step is reported in Part IV row 2 Received, under column (c).

TTB report after juice bulk intake

Using juice

So now you have a tank full of juice and you want to use it to sweeten some of your wine. You can use juice in any of the transfer operations in vintrace. Let’s take for example, you want to blend juice into wine.

Blend juice into wine

Once you complete the operation, the juice used will be reported in Part IV row 5 Used in wine production.

TTB report after blending juice into wine

And the  wine involved in the blend operation will be reported in Part I  in row 3 Produced by sweetening and in row 18 Used for sweetening.

TTB report after blending juice into wine 2

Extraction operation for juice

For an extraction operation where the juice produced is not intended to be fermented, you have the option to specify that this is for juice use only. You can do this by ticking on For Juice use only checkbox in the extraction operation screen.

Extraction for juice only

The juice produced will have a tax class of Juice.

Juice after extraction

The volume produced in the extraction operation will be reported in Part IV row 3 Juice or Concentrate Produced in the TTB report.

TTB report after extraction for juice only

The following section will be for reporting concentrate in Part IV column reference (d) Concentrate in the TTB report.

New concentrate tax class

A new tax class “Concentrate” is automatically created for you in Winery Setup – Setup Options – Policy – Tax Class. If you already have an existing “Concentrate” tax class, it gets updated to have the correct values in TTB Part and TTB Column ref fields.

New concentrate tax class

Any TTB event for this tax class will get reported in Part IV column (d) in the TTB report.

Concentrate tax class 2

Bulk intake of concentrate

Using a standard Bulk Wine Intake bring the volume of concentrate you have received and put it into the correct tank. You will be able to give the concentrate product all the grape origin information you require as per any bulk wine. The most important option is to ensure you give the concentrate product a tax state of “Bonded” and select the tax class “Concentrate” you have setup in the previous step.

Bulk wine intake concentrate

TTB reporting for concentrate

The bulk intake of concentrate we have done in the previous step is reported in Part IV row 2 Received, under column (d).

TTB report after concentrate bulk intake

Using concentrate

So now you have a tank full of concentrate and you want to use it with some of your wine. You can use concentrate in any of the transfer operations in vintrace. Let’s take for example, you want to blend concentrate into wine.

Blend concentrate into wine

Once you complete the operation, the concentrate used will be reported in Part IV row 5 Used in wine production, under column (d).

TTB report after blending concentrate into wine

And the  wine involved in the blend operation will be reported in Part I  in row 3 Produced by sweetening and in row 18 Used for sweetening.

TTB report after blending concentrate into wine 2

Undeclare juice/concentrate for wine production

If you have a juice product, concentrate product, or any product that has a tax class that belongs to d,e,f,g in Part IV of the TTB report that you decided you want to use for wine production, you can undeclare them by applying a product treatment operation.

Firstly, you need to setup a product treatment to undeclare the juice. Go to Winery Setup – Treatment – Treatment (Product) and click on New Product treatments… button.

Product treatment to undeclare juice 1

In Product Treatment Definition, provide a Treatment name, tick on Wine/Juice checkbox in Applies to field, and tick on Use for Wine Production checkbox.

Undeclare juice or concentrate

Applying this product treatment will change the bonded state of the juice/concentrate from bonded to non-declared.

You can use this product treatment on a juice product by clicking on Operations – Treatment (Product) from Product Overview.

Product treatment to undeclare juice 3

Select the product treatment you created to undeclare the juice in the Treatment (Product) screen and click on Now+Save button.

Product treatment to undeclare juice 4

The product’s tax class is now changed to non-declared.

Product treatment to undeclare juice 5

In the TTB report, the volume will be reported in Part IV row 5 Used in wine production and under Part VII row 1 In fermenters.

TTB report after undeclaring juice for wine production

Support for sugar (dry and liquid) on the TTB report (US)

This feature was added in vintrace Version 5.2.4

This feature reports sugar used (dry and liquid) in Part IV – Summary of Materials Received and Used of the TTB Report of Wine Premises Operations in vintrace.

Setup a dry sugar tax class

Firstly, you need to setup a tax class for dry sugar in Winery Setup – Setup Options – Policy – Tax Class. Click on New Tax class button.

Setup new tax class

Give the Name, TTB Class ref, and select Part IV – Materials in TTB Part where this tax class will get reported in the TTB report.

Sugar tax class 1

Input “h” in TTB Class ref. Any TTB event for this tax class will get reported under the corresponding column in Part IV of the TTB report. In the example below, we have entered “h” in TTB Class ref and this tax class will get reported in Part IV column (h) in the TTB report.

Sugar tax class 2

Setup dry sugar as an additive

Unlike the other materials (grapes, juice, and concentrate) in Part IV of the TTB report, sugar will be handled as an additive in vintrace. You need to setup a new additive by going to Winery Setup – Production – Additive. Click on New Additive… button.

For more information on how to setup new additives, refer to this article.

Setup dry sugar additive 1

Provide the Name, Unit of addition, and Owner for the dry sugar additive you want to setup. Click on Save button.

Setup dry sugar additive 2

Setup an additive stock item to link to your dry sugar additive by going to Winery Setup – General stock items – Additive. Click on New Additive stock item… button.

Setup dry sugar stock additive 1

Enter the Stock Code, Unit, and Owner, select the Tax class “Dry sugar” that was created in the previous steps, and select “Dry Sugar” in the Additive field to link this to the additive created previously. It is very important that you select the correct tax class so that the sugar used will be reported correctly in the TTB report.

Setup dry sugar stock additive 2

Stock receival of dry sugar

To receive sugar into your inventory, go to Inventory – Receive. Enter the receival details such as the vendor, carrier, stock item, received units, and routing information.

Dry sugar receival

TTB reporting for dry sugar

The stock receival done in the previous step is reported in Part IV row 2 Received column (h) in the TTB report.

TTB report after stock receival dry sugar

Using dry sugar

You can add dry sugar to your wine like any other additive by performing additive/multi addition operation, or as an inline addition in any of your transfer/blend operations. In the example below, we have added dry sugar to wine by performing an additive operation.

Additive operation dry sugar

After the additive operation, the dry sugar used will be reported in Part IV row 5 Used in Wine Production.

TTB report after additive operation dry sugar 1

 

Setup a liquid sugar tax class

Firstly, you need to setup a tax class for dry sugar in Winery Setup – Setup Options – Policy – Tax Class. Click on New Tax class button.

Setup new tax class

Give the Name, TTB Class ref, and select Part IV – Materials in TTB Part where this tax class will get reported in the TTB report.

Setup liquid sugar 1

Input “i” in TTB Class ref. Any TTB event for this tax class will get reported under the corresponding column in Part IV of the TTB report. In the example below, we have entered “i” in TTB Class ref and this tax class will get reported in Part IV column (i) in the TTB report.

Setup liquid sugar 2

Setting up additives for liquid sugar is the same as dry sugar, just make sure you specify the Liquid sugar in the tax class of the liquid sugar stock item. Using liquid sugar is the same as dry sugar by using it in any addition operation.

 

Notification of TTB impact for loss/gain reasons (US)

This feature was added in vintrace version 5.2.3

This feature allows you see the information on how the loss reason you selected for a particular operation will impact your 702 report. This feature is only available to US customers.

As an example let’s record a measurement operation for a wine product in vintrace, and you have a loss of 1 gal.

Measurement loss

You then select a loss reason; in the case of the example below, the loss reason selected is Evaporation. Click on the ttbOn icon beside the Loss Reason field to view the 702 reason used for that particular loss reason.

702 reason

TTB Event Console (US)

This feature was added in vintrace Version 5.2.3

The TTB Event Console is a new feature in vintrace that shows all the TTB events for a selected bond and tax class within a date range. You can click on each event to go to the operation/action that caused the event.

Accessing the TTB Event Console

You can access the TTB Event Console by navigating to Console – TTB event history…

Console access 1

You can also access it from Product Overview or Stock Item Overview – Actions – View related TTB tax events…

Console access 2

Another way to access the TTB Event Console is from Winery Reports – Government Reports – TTB Report of Wine Premises Operations, then click on Launch TTB history to compare.

Console access 3

The TTB Event Console

To run the console, you have to select the From and To dates, Bond, and Tax Class of the TTB events you want to view and then click on Search button.

You also have the option to filter the search either by Batch or Item.

TTB Event Console

The From and To dates are set to the start date and end date of the previous month by default.

You can change the default date range to yearly, quarterly, or monthly by going to Winery Setup – Work-flow – Defaults and under Policy Defaults set the Preferred TTB Period. Please note that this setting also changes the default period when you run the TTB reports under Winery Reports – Government reports.

Preferred TTB Period

The event data in the TTB Event Console is separated into Section A and Section B, and they correspond to the same sections in the TTB report. Each section shows the Opening and Closing balance for each section if you ticked the Show Opening/Closing balances checkbox.

TTB Event Console 2

The TTB Event Console also shows the detail of each event such as Date occurred, Operation, Target (batch or stock item code), Tax change reason, and Volume change.

TTB Event Console 3

Clicking on the operation link for each event will bring up the operation screen that caused the event. In the example below, we clicked on the Bulk wine intake operation under Section A.

Operation link

Compare against TTB Reports

You can also compare the TTB events against the TTB reports for the date range, bond, and tax class you have selected in the console by clicking on Compare against TTB Reports… button.

You have the option to either Run TTB Report or TTB Breakdown Report.

Generate related reports

Clicking on Run TTB Report would bring up the TTB Report of Wine Premises Operations screen with the date and bond selected based on the one you have in the TTB Event Console.

generate related reports 2

Edit Tax Volume Event details

You can edit the Tax Volume Event details of a TTB event by clicking on the pencil icon beside the event and this will show you the Tax Volume Event [UPDATE] screen.

Note: You need to have the Can edit TTB Tax Volume Events user permission in order to edit the Tax Volume Event details.

Edit TTB Tax Event

In the Tax Volume Event [UPDATE] screen, you can change the details such as Volume Change, Tax class, Tax state, Tax change reason, and Bond.

Any changes you make in this screen will only impact the TTB Reports and will not change the operation or batch/stock item that created the TTB tax event.

Tax Volume Event Update

We urge you to please be cautious if you do choose to edit the Tax Volume Event details because this will impact your TTB report.

How has TTB bond tracking changed between Version 3.x.x and Version 4.x.x of VINx2?

What used to happen

In version 3.x.x (and below) of VINx2, TTB bonds were tied to the Owner of a batch of wine.  This forced a number of customers with multiple facilities to have to create two sets of Owners if wine was moved from one facility to another.  Even though the wine may not have been changing ownership, the system would force you to change it to get the bonds correct.  In some cases, if you had the same wine stored at two facilities it would need to be configured as two separate owners (and batches) just so you could report it on your 702 report.

What happens now

In version 4.x.x (and above), TTB bonds are tracked based on the physical location of the wine.  Typically, this means that the bond that gets used for a particular lot of wine will be based on which winery the vessel it is in is located at. So rather than changing owners when transferring wine between bonds, you just have to transfer the wine from a vessel located at one winery to a vessel located at another.  Details on moving a wine between facilities can be found here.  This makes bond tracking much closer to the real world movements of your wines that are taking place. The only real restriction that would be enforced now is if you have one lot of wine in barrel with some barrels at multiple bonded wineries, you would need to have a separate barrel group for the barrels at each physical location.  It is good practice to do this anyway, as you would typically be completing separate topping and other work orders for the barrels at the different locations.

So what do these changes mean?

Generally, you won’t have to change anything to start getting the benefit of the improved way VINx2 tracks your bonds.  The conversion from versions 3 to 4 will take care of most of the work for you.  But, if you have been using multiple copies of the same owner with different bonds, you can take steps to consolidate the owners in the system to represent the real ownership, rather than the ownership+bond combination that Version 3.x.x required.

One thing to note is if you have been using the different bond per owner to track multiple bonds at the same physical location (ignoring AP bonds for now, we’ll get to them in a bit) you could potentially end up needing to adjust the bond details after your version 3 to 4 conversion.  Depending on the reason you were tracking things this way, there will be a different solution, so rather than try and explain them all here, it would be best to contact VINx2 Support do we can help you work out the best option and help you update the system accordingly.

A special note on Alternating Proprietorship bonds

AP bonds are largely unaffected by this change, since they are designed to allow you to track a special sub-bond at the winery based on a special class of Owner owning that wine.  As such, you should not need to change anything with the way that AP bonds are tracked within VINx2.

How to dump bottles to bulk

The following support article will help you take bottles in inventory and dump them to bulk, and also trigger off the correct TTB events for your TTB report to show that the wine has been dumped to bulk.

Please note: if you are using our Sparkling module and the bottled wine is still on tirage, then you should use the Tirage Admin operation to transfer your tiraged stock back into tank in a single operation.  This will also take care of your TTB reporting.  The specific options for moving tirage stock back to tank are under the Split / Transfer tab.

There are a few requirements before we get started, the first is that you have a wine batch linked to your bottles so that it is classed as a wine stock item and tracked on your TTB report.
If the wine has previously been packaged within VINx2 it is pretty likely it is already linked up, if the bottles were not however there is a good chance they are not linked to a wine batch in the system.

When viewing the bottled stock you can check if it is a wine stock item in the bill of materials.
There will be a line item on the bill of materials containing a [wine batch]/BLK item, with a associated volume.
Additionally it will also need a tax class set.

The following support article also covers receiving and setting up wine stock items within VINx2.
Have a read over this before continuing if you are unsure whether or not the wine you are dumping to bulk is a wine stock item, or if you would like to first receive the goods before dumping to bulk.
[How to receive bottled wine stock into inventory]

After you have confirmed that the stock item is a wine stock item, or created the appropriate wine stock item you can then move onto dumping the bottles to bulk.
Start by performing a Stock Adjustment against the bottles, make sure to select the Reason ‘TTB – Dumped to Bulk’, this will show the bottled stock as dumped to bulk on your TTB report.

This finishes up the inventory side of things, now we need to bring the wine into the system.

Under the operations menu on the main screen select the bulk wine intake operation.
On the wine details tab you’ll want to select the batch/lot of the wine you are dumping to bulk, or create it.
After this is done enter in 0.01 gallons as the volume you are bringing in, this is important for the next step.
After this fill in the other wine details such as fraction type, fermentation state and colour.

Now head into the vessels tab, select the vessel you want to put the wine into and enter the amount you are dumping to bulk into the Transfer in amount.
Press the calculator button on the bottom right, this will calculate the gain required on the left hand side.
Finally Select the loss reason, ‘TTB – Bottled dumped to bulk’.

After filling out the composition information for the wine along with any other details you would like to record (such as analysis or additions) save the operation.
This will have 0.01 gallons of the wine arrive in the winery followed by a gain up to the amount as ‘bottled dumped to bulk’, depending on your TTB precision this will be rounded to the nearest whole gallon.

If you have any questions regarding the process feel free to contact the support desk and we can answer any questions or give you a run through.

Creating your first TTB Report (‘702’)

Generating a TTB Report (‘702’) in vintrace is usually a simple task that you can perform at the end of your reporting period (monthly, quarterly or yearly).  However, the first one you generate is likely to need some adjustments due to the fact that you would have been tracking gallons/movements in your old system/spreadsheets/paperwork part-way through the reporting period as well as in vintrace after going live.

If you are in this situation you will need to combine the details of two TTB Reports (‘702’) for your first report after go-live.

1) The first step is to work out the correct go-live date to use. This is typically the date of your vintrace training. If this date coincides with the first day of the reporting period, then you might not need to do anything other than run your first TTB report in vintrace. If you make any corrections to your opening vintrace balances that they are back-dated prior to this date.

2) Okay, so now you have the date, generate the TTB Report using your old system/spreadsheets/paperwork up until this date.  From the old system, we’re focusing on the opening balance and items describing “movements” in Sections A and B.  From this point, we’ll refer to this report as the “old 702”.

3) In VINx2, run the TTB Report (Reports -> Statutory reports -> TTB Report of Wine Premises Operations) with a start date of our date above, and a closing date of the end of the period.  In here, we’re we’re interested in the movement items and closing balances in Section A and Section B.  The 702 that vintrace generates will allow you to override the values before you print/submit to the TTB.  From this point on, this document will be referred to as the “vintrace 702”.

Please note that if the closing balances on your “old 702” do not match the opening balance on your “vintrace 702” it may be that the load-up data you sent us to be imported did not match up with your old system/spreadsheet/paperwork balance.  If this is the case, contact the Helpdesk so we can help you correct any inconsistencies before continuing.

4) On your “vintrace 702”, remove the opening balance volumes from Sections A and B and replace them with the values in the “old 702”.  For each of the movement items in Section A (items 2-11 and 13-30) and Section B (items 2-6 and 8-19), add the value from your “old 702” into the corresponding item on your “vintrace 702” (if the item is empty on your “vintrace 702” just copy the value from the “old 702” into the corresponding item).

5) The next step is to calculate the TOTAL for Section A (items 12 and 32) and Section B (items 7 and 21).  For Section A, add up items 1 through 11 in your “vintrace 702” and enter the value into item 12.  Then add up items 13 through 30, and subtract this number from item 31.  Enter the result into item 32.  At this point, 12 and 32 should be identical.  If not, double-check that you have not missed any items in step 4.  Do the same for Section B.  Total up 1-6 and enter into 7.  Then total up 8-19, and subtract this from value in 20.  Enter result into 21.  Again, these should match up.  If they do not, double-check step 4.

6) The last step is to check the back of the form.  You should be able to use the same principles as Steps 4 and 5 to record opening (from “old 702”) and closing (from “vintrace 702”) and items (combination of both 702s) for these parts.  For Part VII, the value from vintrace should be all you need in the “IN FERMENTERS END OF PERIOD” section.

Once you’re happy that the TTB Report balances, create a hard-copy by printing this, and file it away for future reference.

Now that you’re just using vintrace for recording your wine movements, each subsequent TTB Report (‘702) is as easy as running the one report in vintrace.  Simply go to Reports -> Statutory reports -> TTB Report of Wine Premises Operations then check the date range is the period you’re reporting for, and click the “Generate” button.

 

3.1.1 Artifically carbonated 702 TTB events

US Customers can now setup a treatment to apply to a wine that has been artificially carbonated.

Configure the treatment under Winery Setup | Treatments | Treatment (Product)

Name the treatment Carbonate Wine, tick Wine/Juice and the Change tax class check boxes. Select the Tax Class Carbonated wine and the change reason Produced by fermentation.

When the treatment is recorded against a wine VINx2 will record the 702 events for the “used for effervescent wine” reason