Skip to main content

TTB Brewers Report of Operations Dashboard Data Sources

Brewery reference for where each line of the TTB Brewers Report of Operations (BRO) dashboard in Encompass gets its data, and which statuses and TTB codes are required to show. Requires v22.12+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.12

Steps

  • All calculations are based on data from a chosen Location and its related Tax Entity
    ​
    ​

  • All Invoice Load Sheets must be in Loaded, Balanced, or Verified status in order to populate on report
    ​
    ​

  • All Production Orders must be in Confirmed or Verified status in order to populate on report
    ​
    ​

  • FIFO Adjustment invoices as well as Inventory Adjustment invoices created without a TTB Tax Code are omitted from the report

Monthly BRO
​
​

Additions to Beer Inventory
​

Line 1 - On hand beginning of this report period: Sum of Inventory on given start date of all Brands.TTB Category: Beer and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled
​

  • Note: The SUM of these values should match the Expected amount in Line 33 of the previous month's report. It will NOT match the Calculated amount which can be the result of issues stemming from configuration, processing transactions or manual cell overrides.

Line 2 - Beer produced by fermentation: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced brought into inventory through a Production Order
​

Line 3 - Addition of water and other liquids: Not calculated. Additions of water and other liquids in ECP should be expressed by Production Orders
​

Line 4 - Beer received from racking and bottling: This is for beer that was previously sent to a dedicated kegging or bottling area and returned to the facility. This line is not currently calculated.
​

Line 5 - Beer received in bond: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought into inventory on a Purchase with positive NumUnits using Vendors with TTBTaxCode: Received in Bond
​
​

Line 6 - Beer received from cellars: Same as Line 9 Column D and Line 10 Column F
​

Line 7 - Beer returned to this brewery after removal from this brewery: Sum of Product with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought back into inventory on a negative Invoice
​

Line 8 - Beer returned to the brewery after removal from another brewery of same ownership: This line is not currently calculated
​

Line 9 - Racked: Sum of Products brought into inventory through a Production Order with Brands.TTBCategory: Beer and ProductType.TTBProcessType: Racked
​

Line 10 - Bottled: Sum of Products brought into inventory through a Production Order with Brands.TTBCategory: Beer and ProductType.TTBProcessType: Bottled and/or Canned
​

Line 11 - Physical inventory disclosed an overage: Sum of Product with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled written out of inventory on an Inventory Adjustment type Invoice using Customer with TTBTaxCode: Overage or Shortage
​

Line 13 - Total additions to inventory, plus beer on hand: The sum of Lines: 1 - 12

Removals from Beer Inventory
​
​

Line 14 - Removed for consumption or sale: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice
​
​

Line 15 - Removed tax-determined for consumption or sale to tavern on brewery premises: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Tavern on Brewery Premises

-And Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through a negative PurchaseTrans using Vendors with TTBTaxCode: Tavern on Brewery Premises
​

Line 16 - Removed without payment of tax for export: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Export
​

Line 17 - Removed without payment of tax for use as supplies (vessels/aircraft): Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Used as Supplies
​

Line 18 - Removed without payment of tax for use in research and development: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Research and Development
​

Line 19 - Removed without payment of tax to other breweries and pilot brewing plants of same ownership: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Removed Without Payment of Tax to Other Brewery
​

Line 20 - Removed without payment of tax as beer unfit for sale removed for use in manufacturing: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Unfit for Sale
​
​

Line 21 - Beer consumed on premises: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Consumed on Premise
​

Line 22 - Beer transferred for racking: Same as Line 9 Column D
​

Line 23 - Beer transferred for bottling: Same as Line 10 Column F
​

Line 24 - Beer returned to cellars: This is for beer that was previously sent to a dedicated kegging or bottling area and returned to the facility. This line is not currently calculated
​

Line 25 - Beer racked: Same as Line 9 Column D
​
​

Line 26 - Beer bottled: Same as Line 10 Column F
​

Line 27 - Laboratory samples: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Laboratory Samples
​
​

Line 28 - Beer destroyed at brewery: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Destroyed
​

Line 29 - Beer transferred to a distilled spirits plant: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Transfer to Distillery
​

Line 30 - Losses, including theft: Sum of Products with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Loss
​
​

Line 31 - Physical inventory disclosed a shortage: Sum of Product with Brands.TTB Category: Beer and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled written into inventory on an Inventory Adjustment type Invoice using Customer with TTBTaxCode: Overage or Shortage
​

Line 33 - Total amount of beer on hand at the end of this period: Sum of Inventory on given end date of all Brands.TTB Category: Beer and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled
​

  • Calculated = Amount needed to balance Lines 13 and 34 given the report inputs.

  • Expected = Amount based on actual ending inventory in the system. A difference between expected and calculated is indicative of overriding report values without fixing the root transactions, configuration issues with brands or customers resulting in missing removals/additions or error transactions.

Line 34 - Total Beer: The Sum of Lines 14 - 33


Part 2 - Cereal Beverage Summary

Line 1 - Produced: Sum of Products with Brands.TTB Category: Cereal Beverage - Below .5% ABV and ProductType.TTBProcessType: Produced brought into inventory through a Production
​
​

Line 2 - Removed: Sum of Products with Brands.TTB Category: Cereal Beverage - Below .5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice
​

Line 3 - Received: Sum of Products with Brands.TTB Category: Cereal Beverage - Below .5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled brought into inventory on a Purchase with positive NumUnits using

Vendors with TTBTaxCode: Received in Bond
​
​

Line 4 - Loss and Wastage: Sum of Products with Brands.TTB Category: Cereal Beverage - Below .5% ABV and ProductType.TTBProcessType: Produced, Canned, Racked, or Bottled removed from inventory through an Invoice using Customer with TTBTaxCode: Loss
​

Line 6 - Total on hand at end of period: Sum of Inventory on given end date of all Brands.TTB Category: Cereal Beverage - Below .5% ABV and Products with Product Type.TTBProcessType: Produced, Canned, Racked, or Bottled

Did this answer your question?