Quarterly 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
​

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 - 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 or Purchase with Non-Production Order type Shipment (for example: imported purchase).

Line 4 - Beer returned to the 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 which doesn't include reversal invoice

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

Line 6 - (not a standard BRO line) Packaged Products Out of Balance: Populates data when ttbOutput Product by Packaging Production Orders (Lines 25, 26) not equal Produced (WIP) Raw Material type component

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

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

Removals from Beer Inventory
​
​

Line 10 - 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 a Non-Inventory Adjustment type Invoice with TTBTaxCode: None

- And 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

Line 11 - Beer removed without payment of tax as outlined under Subpart L of 27 CFR part 25: 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
​

- And 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
​

- And 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
​

- And 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
​

- And 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 12 - 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 13 - 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 14 - 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.

Columns C and E also include Bulk Beer Loss (Consume as Component (Wasted Raw Material)) trans for Racking and Bottling.
​

Line 15 - 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 Invoice using Customer with TTBTaxCode: Overage or Shortage

Line 16 - (not a standard BRO line): Populates data in situations where the BBLs consumed and received on a repackaging Production Order do not match.

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

Line 19 - Total Beer: The Sum of Lines 10 - 17

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 - 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 4 - 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 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