Wine Spirit Additions Reports

This functionality is available starting with vintrace 9.4.3, but is not enabled by default. If you would like to use this functionality, please contact our support team.

The Wine Spirit Additions (WSA) reports track the transactions and gauging that occurs when spirits in Part III of the TTB are added to wines in Part I.

The following WSA reports are available in vintrace:

• Wine Spirits Additions Daily Transactions
• Wine Spirits Additions Transactions
• Wine Spirits Additions Gauging Report
• Wine Spirits Additions Tax Class Summary

Running the WSA Reports

To run any of the WSA reports:

1. Click Reports in the sidebar.
2. Select Government.

The WSA reports are located in the right pane.

Each of these reports displays a Launch Tax History to Compare link that displays the Tax Event Console for the specified date range.

Wine Spirits Additions Daily Transactions Report

The Wine Spirits Additions Daily Transactions report lists all the daily transactions for wine spirit additions for the specified date range. It shows a summary impact from a wine, spirits, and resulting blend perspective. The report includes transfer/rack/blend, one-to-many transfers, and many-to-one operations when the following tax events are recorded:

• Used for wine spirits additions
• Produced by wine spirits additions
• Spirit used

Each date displays on a separate page and includes the total transactions for the day. The number of rows will differ depending on the operation as detailed in the table below.

Additional notes:

• For transfer/rack/blend operations, the Desired Alcohol % field’s value on the Advanced tab displays in the report’s Desired Alcohol (%) column.
• The withdrawal guage is always the same as the proof gallons for the spirits used.
• The proof is calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report uses the alcohol percentage of the tax class (i.e., alcohol % * 2).
• The proof gallons are calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report will use the alcohol percentage of the tax class. (See S2 on the TTB’s Distilled Spirits FAQs.)
• The Kind is the base material of the beverage type/color.

Wine Spirits Additions Transactions Report

The Wine Spirits Additions Transactions report lists the wine spirit transactions and calculation details of the wine’s starting and target alcohol for the specified date range. The report includes transfer/rack/blend, one-to-many transfers, and many-to-one operations when the following tax events are recorded:

• Used for wine spirits additions
• Produced by wine spirits additions
• Spirit used

Each operation displays on a separate row. The number of rows will differ depending on the operation as detailed in the table below.

Additional notes:

• For transfer/rack/blend operations, the Desired Alchocol % field’s value on the Advanced tab displays in the report’s Desired Alcohol (%) column.
• The Diff column is calculated as follows: (Alcohol % of the wine produced) - (Desired alcohol %)
• The withdrawal guage is always the same as the proof gallons for the spirits used.
• The proof is calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report uses the alcohol percentage of the tax class (i.e., alcohol % * 2).
• The proof gallons are calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report will use the alcohol percentage of the tax class. (See S2 on the TTB’s Distilled Spirits FAQs.)

Wine Spirits Additions Gauging Report

The Wine Spirits Additions Gauging Report lists each official gauge recorded for spirits in Part III of the TTB Report for the specified date range.

The report includes the following operations.

Additional notes:

• The proof is calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report uses the alcohol percentage of the tax class (i.e., alcohol % * 2).
• The proof gallons are calculated from the alcohol percentage set on the batch. If there is no alcohol percentage, the report will use the alcohol percentage of the tax class. (See S2 on the TTB’s Distilled Spirits FAQs.)
• The Identification (B) column includes the proof and post dip of the liquid after the operation.
• The Age of spirits is from the batch of the spirits.
• The Kind is the base material of the beverage type/color.

Wine Spirits Additions Tax Class Summary Report

The Wine Spirits Additions Tax Class Report lists the transactions for wine spirit additions for the specified date range. The report includes the total transactions per day and a total for the reporting period.

The number of rows will differ depending on the operation as detailed in the table below.