Skip to main content
You are here: Compliance

How to get an accurate TTB Report

Overview

This guide discusses Blended's TTB methodology and workflows to ensure you create an accurate TTB Report.

Intake of Grapes and Bulk Juice

Users receive grapes and bulk juice through the intake workflow. These weigh tags automatically populate line items in the Intake Table within Production, and the weights and volumes feed Section IV of the TTB form.

From the Intake table, users create Lots from those weigh tags. This action removes the corresponding weight or volume from TTB Section IV and moves the Lot volume into TTB Section VII.

If fruit or juice is removed through sale or waste, the Lot Sources within the Intake table should be archived with the code "Removed".

Intake of Bulk Wine

Receive bulk wine through the Intake table within Production. Users will select Bulk Wine on the intake receipt. Once a receipt of intake has been created, users can generate a Lot consuming the source from the Intake table.

Once a lot has been created, Users should immediately declare a tax class. This will ensure Blended will add the Lot Volume to the correct Tax Class column within Section A on row 7.

Declaring a Tax Class

When fermentation is complete or bulk wine is received, users will declare a tax class within the Production section of Blended. To do so, use the checkbox to select 1 or more Lots, then use the Other dropdown to select Designate Tax Class.

The modal will allow users to designate individual tax classes for each selected Lot. The date of this choice will determine when this declaration shows up on the TTB report. Designating a tax class for the first time will move that volume from Section VII to Section A.

Changing Tax Class

If a change in tax class is necessary, repeat the same process you used to declare it. When the modal appears, the Lot will be displayed with the current tax class. You can then choose the new tax class.

Sparkling

Choosing one of the sparkling tax classes will cause a shift in gallons on the TTB form. Gallons will be removed from the current Section A column, through line 22 (used for effervescent wine), and will be entered into the new column on line 2.

Bulk Wine

Bulk wine is tracked far more closely than juice. Be careful to accurately capture volume and volume changes, as they will be displayed on the TTB Report.

Gains and Losses

Inventory Gains/Losses

These are gains and losses resulting from normal operations, such as racking, evaporation, and inventory measurements. When recording a new volume through a transfer or Loss/Adjustment process, the reason code helps us note the reason for the gain/loss and put it in this category. Blended reason codes that link to Inventory Losses are:

  • Addition

  • Inventory Reconsiliation

  • Testing

  • Operations

Losses (Other than Inventory)

These losses are significant events that typically require additional TTB documentation. To record a non-inventory loss in Blended, choose the Loss Code: Casualty. All other documentation for the TTB related to these events is done outside of Blended.

Destroyed

To record bulk wine as destroyed, use the checkbox to select the Lot, and then under the Other dropdown, choose Archive. The modal will ask for a volume and reson code. Choose the reason code Destroyed. This will ensure the volume gets entered on the appropriate line of the TTB Report. Please coordinate with the TTB before you destroy wine to ensure you are following their process.

TTB Materials (Other Fruit, Spirits, and Sugar)

See the materials section for how to appropriately create these products and receive batches.

Declare Spirits and Fermentables

To account for spirits, fermentables, or sugars used in production, receive and declare these materials in the material section. This action records their volume or weight in Part 3 (for spirits) or Part 4 (for other fermentables or sugar) of your TTB form.

Bottling and Case Goods

Record Bottling

Choosing and completing the Bottling operation will remove bulk wine from Section A through Bottling and move that volume into Section B.

If the Lot you are bottling does not have a tax class, Blended will display a warning to set a tax class prior to bottling.

Create Case Goods SKU

Once you've bottled, a line item will be created within the SKU Creation table inside Case Goods. This workflow gives users the ability to create a SKU and manage it within Blended. Users have the option to mark wine as Tax Paid from the SKU Creation Menu. Doing so will remove the wine from Section B (In Bond).

If you want Blended to complete Section B but don't manage Case Goods in Blended, you also have the option to Archive Selected. You will be given a choice of reason codes. If the wine was Tax Paid, choose the option Remove Tax Paid. All other options are in-bond methods of depreciating inventory.

Moving Case Goods from In-Bond to Tax Paid

For In-Bond inventory, users have the ability to mark tax paid at any point. Use the checkbox to select the SKUs and choose Send to Tax Paid. From the modal, select how much of the SKU's allocation you are sending to Tax Paid.