TTB Quarterly Report of Brewer's Operations

What Is The TTB Quarterly Report of Brewer's Operations?

The Alcohol and Tobacco Tax and Trade Bureau (TTB) regulates and monitors the production of alcoholic beverages in the U.S. The TTB Quarterly Report of Brewer’s Operations (BROP) in your ABM is a helpful tool to help you submit your TTB requirements. Use this guide to learn how the actions in your ABM generate the data in this report.

Prerequisites

This report is activated during your ABM onboarding process, upon request. If you don’t see it in your ABM, reach out to your ABM Implementation Manager or Arryved Support to activate it for you.
All ABM User Roles except for the ‘Delivery’ Role will grant access to the TTB Quarterly Report of Brewer’s Operations.

Limitations

The TTB Quarterly Report of Brewer’s Operations is simply a record-keeping tool based on the data in your ABM. It does not guarantee your TTB compliance. It’s up to you to verify, download, and submit your TTB reporting.
Please consult your financial advisor or TTB specialist to determine best practices. Arryved cannot provide any advice and is not responsible for any misreporting or malpractice of your business’s TTB reporting.
This report does not include excise tax information. Arryved Brewery Management does not provide an excise tax tool at this time.
This report only records Inventory in your ABM set to Beverage → Beer and Beverage → Seltzer.
Inventory Count differences assigned to a ‘System Correction’ are not included in this report.

How It Works

Find The Report

Log into your ABM.
From the left navigation bar, click Reports.
Click the TTB Quarterly Report of Brewer’s Operations to open it.

Top Section

The top section of this report includes the white/gray boxes.

Date Range: This report generates data based on the date range selected here. When you first arrive at the report, the default view is year-to-date (YTD).
Starting BBLs: This section displays the start date of the date range selected and the Inventory On Hand (in Beer and Seltzer BBLs) on that date. Inventory On Hand includes Inventory in storage and in transit.
Ending BBLs: This section displays the end date of the date range selected and the Inventory On Hand (in Beer and Seltzer BBLs) on that date both in storage and in transit.
Net change in BBL: The difference between your starting and ending BBLs. A positive number indicates you had a higher quantity of BBLs on the end date. A negative number indicates you had a higher quantity of BBLs to start.

Data In The Middle

The data in the middle section includes the green and red boxes. The green boxes represent BBLs of Beer and Seltzer added to your Inventory. The red boxes represent BBLs removed from your inventory.

LINE 2 - NEW INVENTORY: Beer and Seltzer Inventory produced during the report date range. This line records the following actions:

Finished Goods produced in Batches moving to a Storage or Taproom Location.
Inventory Adjustments from ‘New Inventory’ to a Storage Location.
Inventory Adjustments from the ‘Unloading’ Location (returned from Routes) that’s marked as New Inventory.
Any gains in volume due to an Item repackage.

LINE 3 - RECEIVED IN BOND: Beer and Seltzer Inventory moving between non-Taproom Locations in the same Site (no excise tax).

LINE 4 - RETURNS: Beer and Seltzer Inventory returned to Storage Locations after previously being removed.

Inventory returned from delivery and added back into Inventory.
Inventory transfers from Taproom Locations to Storage Locations. Transfers of the same Item(s) back and forth are netted out in Line 10 at the end of the calendar month.

LINE 5 - OVERAGES: Overages from Inventory Counts when Beer and Seltzer Inventory is greater than expected. Overages assigned to a ‘System Correction’ are not included here.

LINE 10 - REMOVED FOR SALE: Beer and Seltzer Inventory removed for sale or distribution during the report’s date range. This includes sales to wholesalers, retailers, and any other Customers.

Inventory transferred from Storage Locations to Taproom Locations. Transfers of the same Item(s) back and forth are netted out in Line 4 at the end of the calendar month.
Inventory from Invoices fulfilled on a Route.
Inventory Count shortages that are marked as sold in non-Taproom Locations.

LINE 11 - REMOVED IN BOND: Beer and Seltzer Inventory removed from a Location, without excise tax.

LINE 13 - DESTROYED: Inventory Adjustments transferred to the ‘Reduction - Destroyed’ Location.

LINE 14 - LOSS: Losses due to spillage, breakage, evaporation, or any other factors that result in loss of Beer and Seltzer Inventory.

Inventory Adjustment to the ‘Reduction - Loss & Breakage’ Location.
Inventory Adjustment to the ‘Reduction - Spoilage’ Location.
Inventory repackages with a smaller ending volume than starting.

LINE 15 - SHORTAGE: Shortages from Inventory Counts when Beer and Seltzer Inventory is less than expected. Shortages assigned to a ‘System Correction’ are not included here.

Summary Of All Relevant Moves

The table at the bottom of the report records each Inventory action that takes place in your ABM.

The numbers in the ‘BROP Line’ column indicate which Line # the action was allocated to. If the field is blank, that means the action did not have an effect on any data in this report.

Pro Tip! You can export this summary by clicking the download icon in the upper right corner. From there, you have the power to filter or re-organize the information to meet your needs.

If you need a PDF, use the download icon at the bottom of the summary. To the left of that, you can change the Time Zone.

Inventory Counts

Inventory Adjustments

Inventory Location Type Behavior