TTB Report Configuration

Owned by Conner Helton (Unlicensed)
Last updated: Jun 08, 2015 by Eric Metcalf (Unlicensed)
5 min read


Summary

The TTB Brewer's Report of Operations is the primary tax filing report filed by breweries. It consists of two parts, the first is the Report of Operations, which outlines production at a brewery for a given period. the 2nd is the Federal Excise tax. This page will walk you through the setup required to enable you to run the report. There are four main things that need to be configured before your TTB report will run.

What has Changed in OBeer 3.5

  • The 'TTB Report' has been updated to support multi-location / contract brewing / alt-prop arrangements. 
  • An easy-to-use setup workbook has been created to help fix items that may not be appearing
  • Minor bug-fixes and improvements

 

 

 

 

1) Proprietorships & Entity Setup

Navigate to Administration → Setup →Inventory → TTB Proprietorship

 

Proprietorships

An OBeer proprietor is the highest level of grouping in relation to you TTB Report.  For example, if your brewery contains an alternating proprietorship component, then you would have one proprietorship setup for your brewery, and another for each of your alternating partners.

 Even if your brewery does not operate with an alternating proprietorship, breweries will often setup a secondary proprietorship for their alternate ventures such as spirits, cider, and wine, in order to isolate those transactions from their standard beer reports.

Entities

Entities are designed for the next tier of reporting.  Entities are also linked to the 'Locations' within OBeer.  Most common use would be one entity for your main brewery tied to a specific location, and a second entity tied to a taproom that reports separately from your main brewery.

 You will need to have at least one entity per proprietorship for each BR# that you file the TTB report for. 

 

TIP #1: When setting the location, click the magnifying glass to bring up the list.

TIP #2: Dont worry, if you mess up and delete the row, you can add a new one by right-clicking on the word 'Line' and selecting Add Row

 

2) Warehouse Location & Tax Determination Review

Navigate to Administration → Setup → Inventory → Warehouses

  1. Verify that your existing tanks and warehouses are set to their appropriate location. By default everything is set to Brewery #1
  2. Verify that Tax Determination is set to N for everything but your tasting room.
     

 

 

3) Associate Proprietorship to Brands Master Data and TTB Group to Item Master Data

Every item within OBeer must be associated with an appropriate TTB Group. That sounds really scary, especially if you have hundreds of items within the system. Because of this, we have built a setup tool within the TTB Report to make doing these updates easy.

  1. Navigate to Production → Production Reports →  TTB Reporting
  2. Once the TTB Report is open, click the  in the top right hand corner of the report.


  3. Once you have the setup workbook open, READ THE INSTRUCTIONS CAREFULLY, when ready, press the  button. When the workbook has finished syncing, two new tabs will appear at the bottom, one for Brands and the other for Items


  4. Select the Brands Worksheet. From here, select yellow cell to alter the data, a drop menu will appear allowing you to select the appropriate proprietorship for each brand you produce. Once completed, press the  button.


  5. Select the Items Worksheet. For each item set a Brand for each finished good, a verify and set the Pack Type (important!) for every item within the system and the TTB Grouping (important!). Once completed, press the  button.
    1. Finished Goods - Set the Brand, verify the Pack Size, and Set the TTB Grouping to either Racked/Kegged for Draft Beer or Bottled/Canned for Packaged.
    2. Semi-Finished Goods - Set the Pack Size (UoM-BBL in most cases) & TTB Group to either Capture Losses or Produced by Fermentation depending on how you report.
    3. Raw Materials -  Set the Pack Size (UoM Pound in most cases) & TTB Group to what you have setup in Section III of your report (Grain, Hops, Sugars, etc)



      TIP #1: If you setup filters within the workbook, you can filter for a particular Item Group, then select TTB Grouping for that Item Group and do a fill down in Excel.
      TIP #2: You can use the same filtering to find items without either brand, pack size or TTB grouping. Select the filter for one of those, and uncheck everything but "Blanks"

 

4) Optional - Set / Change TTB Group Labeling

The TTB Group is what shows up each section of the TTB Report. Commonly different breweries will report section III materials in different order or even with different labels.

  1. Navigate to Administration → Setup → Inventory → TTB Groups


  2. From here there are two sections to pay attention to. ONLY MAKE CHANGES TO THESE TWO COLUMNS
    1. Name - This is what is displayed in the Item Master Data under TTB Group
    2. Display Title - This is what is displayed on the TTB Report as well as the TTB Setup Workbook.