How to Prepare Your Brewery TTB Report Using Production Data

Every brewery in the United States, regardless of size, must file the Brewer's Report of Operations (BROP) with the Alcohol and Tobacco Tax and Trade Bureau. If you've ever stared at TTB Form 5130.9 and felt a knot in your stomach, you're not alone. The form asks for detailed figures on production, transfers, losses, and tax determinations that span your entire operation. Getting it wrong can mean penalties, audits, or worse.

But here's the thing: if your production data is already accurate and well-organized, filling out the BROP becomes a straightforward exercise in pulling the right numbers from the right places. The real challenge isn't the form itself. It's having clean, reliable data ready when you need it.

This guide walks you through the entire process of preparing your BROP, from understanding what the TTB expects, to organizing your production records, to mapping those records onto each line of the form. Whether you file monthly or quarterly, the principles are the same. And if you're using a system like BrewPlanner's inventory management tools to track ingredients, finished goods, and batch-level production data, you already have most of what you need.

Let's break it down.

Understanding the BROP and What the TTB Actually Wants

Before you touch a single cell on the form, it helps to understand the logic behind the Brewer's Report of Operations. The TTB doesn't just want to know how much beer you brewed. They want a complete accounting of every barrel that entered, moved through, and left your brewery during the reporting period.

Think of it as a barrel-level balance sheet. You start with what you had at the beginning of the period, add what you produced or received, subtract what you shipped, lost, or used, and end with what remains. If those numbers don't balance, the TTB will have questions.

The Core Structure of Form 5130.9

The form is divided into several parts, but the most important sections for production-focused breweries are:

• Part I, Section A: Beer Production. This covers total barrels produced during the period. The TTB measures everything in barrels (31 gallons each), so you'll need to convert your batch volumes accordingly.
• Part I, Section B: Disposition of Beer. This is where you account for everything that happened to the beer you produced or had on hand. Taxable removals (beer you sold and shipped), tax-exempt removals, transfers to other breweries, losses, and shortages all go here.
• Part II: Operations in the Brewhouse. This section tracks raw materials used in production, including malt, hops, adjuncts, and other ingredients measured in pounds or bushels.
• Part III: Materials and Processes. Some breweries need to report on specific processes like concentrate production or contract brewing arrangements.

The TTB's official requirements page outlines filing frequency based on your production volume. Breweries producing fewer than 10,000 barrels annually may qualify for quarterly filing, while larger operations must file monthly. Either way, the data requirements are identical.

Why Production Data Accuracy Matters More Than Timing

Many brewery owners focus on the filing deadline and scramble to compile numbers at the last minute. This is backwards. The filing deadline is fixed and predictable. What trips people up is not having trustworthy data when it's time to fill in the blanks.

Consider this scenario: you brewed 12 batches during a quarter, but three of them had yield discrepancies because your brewhouse volume measurements were inconsistent. One batch had a significant loss during transfer from the fermenter to the brite tank, but nobody recorded it. Two batches were packaged into kegs and cans, but the packaging counts were tracked in separate spreadsheets that don't reconcile.

Now you're sitting down to complete your BROP, and the numbers don't add up. Your beginning inventory plus production minus dispositions doesn't equal your ending inventory. You have a gap, and you don't know if it's a measurement error, an unrecorded loss, or an actual discrepancy that needs to be reported.

This is exactly the kind of problem that brewery management software solves by connecting production scheduling, tank assignments, and inventory tracking in a single system. When your brewhouse, fermenter, and brite tank data all flow into one place, the numbers reconcile themselves.

The bottom line: the BROP is only as good as the data behind it. Get the data right, and the form practically fills itself.

Organizing Your Production Records for Each Section of the Form

Now let's get practical. To prepare an accurate BROP, you need four categories of data organized and ready before you open the form. Think of these as the building blocks that map directly onto the form's sections.

Building Block 1: Batch Production Records

Every batch you brew generates a production record. For the BROP, the critical data points from each batch are:

• Date brewed. This determines which reporting period the batch falls into.
• Volume produced in barrels. Measure the volume at the point of completion, typically when beer transfers out of the fermenter or brite tank into packaging. Remember: 1 barrel = 31 gallons. A standard 7-barrel brewhouse system that fills to 6.5 barrels of wort doesn't necessarily yield 6.5 barrels of finished beer after losses.
• Beer type or style. While the BROP doesn't require style-level detail, tracking this helps you verify volumes against your recipe logs.
• Gravity readings. Original gravity and final gravity readings help verify that the reported volume aligns with expected yield.

For Part I, Section A, you'll sum the total barrels produced across all batches in the reporting period. This should be a clean number if you've been recording volumes consistently at the same point in your process.

A practical tip: pick a single measurement point for "production complete" and use it every time. Most breweries use the volume at packaging, but some use the volume at the end of fermentation. Either works, as long as you're consistent. The TTB cares about consistency and accuracy, not which specific measurement convention you choose.

Building Block 2: Disposition and Removal Records

Disposition is the TTB's term for "what happened to the beer after you made it." Part I, Section B is where you account for every barrel. The main categories are:

• Taxable removals for consumption or sale. This is the beer that left your brewery for distribution, taproom sales (if applicable), or direct delivery to retailers. This is also the basis for your excise tax calculation.
• Tax-exempt removals. Beer sent to labs for testing, exported beer, or beer provided to government agencies falls here.
• Transfers to other breweries. If you contract brew or transfer beer to another licensed facility, those barrels go in this category.
• Losses and shortages. Spillage during packaging, beer dumped due to quality issues, samples poured in your taproom for staff training. These are real, reportable events.

To compile this data, you need accurate shipping records, sales records, and loss logs. If you're tracking inventory with a system that records every transaction (inbound, outbound, and transfers), pulling these numbers is straightforward. If you're working from delivery receipts and sales invoices, you'll need to convert units back to barrels. A half-barrel keg is 0.5 barrels. A case of 24 twelve-ounce cans is approximately 0.0726 barrels.

Here's a quick conversion reference:

Package TypeVolumeBarrel EquivalentHalf-barrel keg (15.5 gal)15.5 gallons0.5 barrelsSixth-barrel keg (5.17 gal)5.17 gallons0.1667 barrelsCase of 24 x 12oz cans2.25 gallons0.0726 barrelsCase of 24 x 16oz cans3.0 gallons0.0968 barrelsCase of 12 x 22oz bottles2.0625 gallons0.0665 barrels

Keep this table handy. You'll reference it constantly.

Building Block 3: Raw Material Usage

Part II of the BROP asks for the pounds of malt, hops, and other materials used during the reporting period. This is where your ingredient tracking pays off.

For each batch, you should have a record of:

• Pounds of malt and grain used
• Pounds (or ounces) of hops used
• Pounds of adjuncts (sugar, fruit, spices, etc.)
• Gallons of water used (some breweries track this, though it's less critical for TTB purposes)

Sum these across all batches in the reporting period. If your recipes are stored digitally and linked to actual production runs, this becomes a simple report. If you're working from handwritten brew sheets, set aside time to tabulate manually.

Building Block 4: Beginning and Ending Inventory

The BROP requires your on-hand beer inventory at both the start and end of the reporting period, measured in barrels. This means you need to count (or have a system that tracks) every barrel of beer in your facility, whether it's in a fermenter, a brite tank, kegged and sitting in your cooler, or cased and stacked on pallets.

This is where many small breweries stumble. If you don't do regular inventory counts, your ending inventory is a guess. And if your ending inventory is off, your entire BROP is off, because the form is designed to balance.

Your beginning inventory for the current period must match the ending inventory from your previous filing. If it doesn't, the TTB will notice.

Using craft brewery software that tracks stock levels in real time across tanks and packaged goods eliminates the guesswork. Every transfer, every packaging run, and every shipment updates your inventory automatically. When filing day arrives, you pull the number and move on.

Mapping Your Data to the Form and Catching Common Errors

You've organized your production records into the four building blocks. Now it's time to actually fill out the form and, more importantly, verify that everything balances before you submit.

The Balance Test Every Brewer Should Run

Before you submit anything, run this fundamental equation:

Beginning Inventory + Production + Receipts = Ending Inventory + Taxable Removals + Tax-Exempt Removals + Losses

If both sides of this equation match, your BROP will balance. If they don't, you have a discrepancy to investigate.

Let's walk through a simplified example for a small craft brewery:

A 9.5-barrel discrepancy is significant. In this case, the brewer might discover that two keg deliveries totaling roughly 9.5 barrels were made at the end of the period but not logged in the sales system until the following week. Fixing the records to reflect the actual date of removal resolves the imbalance.

This is why running the balance test before filing is so important. Catching errors proactively is a routine bookkeeping task. Explaining errors to a TTB auditor is a stressful, time-consuming ordeal.

Common Mistakes That Trigger TTB Scrutiny

After speaking with brewery owners and compliance consultants, the same filing mistakes come up again and again:

1. 1Inconsistent volume measurement points. Measuring wort volume pre-boil for some batches and post-fermentation volume for others creates production figures that don't correlate with disposition data. Pick one standard and stick with it.
2. 2Unreported losses. Every drop of beer that leaves your tanks but doesn't end up in a package or a customer's glass is a loss. Trub left behind in the fermenter, beer blown off during active fermentation, samples pulled for quality checks, and beer dumped for off-flavors all count. Many breweries underreport losses because they don't track them, which makes production look higher than disposition, creating an imbalance.
3. 3Rounding errors across many batches. Rounding each batch to the nearest barrel might seem harmless, but across 30 or 40 batches in a quarter, rounding errors compound. The TTB allows reporting to two decimal places. Use them.
4. 4Misclassifying taproom sales. Beer sold in your taproom for on-premise consumption is still a taxable removal. Some brewers mistakenly exclude taproom pours from their disposition totals, underreporting their taxable removals and overstating their ending inventory.
5. 5Failing to account for beer in process. Beer sitting in a fermenter on the last day of the reporting period is part of your ending inventory. It hasn't been "produced" yet for BROP purposes if it hasn't reached your defined completion point, but it needs to be tracked somewhere. Make sure your inventory methodology accounts for work-in-progress beer.

The TTB's sample reports and helpful hints guide provides color-coded examples showing which production activities map to which lines on the form. It's one of the most useful resources the TTB publishes, and worth reviewing side-by-side with your own data the first few times you file.

Building a Repeatable Filing Routine

The best thing you can do for TTB compliance is to make BROP preparation boring. Not stressful, not frantic, not something you dread. Boring. And the way you make it boring is by building a repeatable routine.

Here's a checklist you can adapt for your brewery:

• Verify all batch production records are complete and volumes are recorded in barrels
• Confirm all packaging runs are logged with accurate package counts and barrel conversions
• Reconcile all shipments and sales against delivery records
• Record all losses, dumps, and samples for the period
• Calculate beginning inventory (must match prior period ending inventory)
• Calculate ending inventory from current tank volumes and packaged goods counts
• Run the balance test (inputs must equal outputs)
• Investigate and resolve any discrepancies before filing
• Complete Form 5130.9 and submit via TTB's online portal
• Archive a copy of the filed report along with supporting records

The TTB requires you to keep supporting records for at least three years. That includes brew logs, packaging records, shipping documents, and inventory counts. Storing these digitally, ideally in a system that links each record to the relevant batch, saves enormous time if you're ever audited.

For a deeper look at how production data feeds into broader financial decisions at your brewery, the guide on running a SKU rationalization audit using margin data covers how to connect production volume to profitability analysis.

Turning Compliance Into a Competitive Advantage

Most brewery owners view TTB reporting as a necessary burden. File the form, pay the tax, move on. But there's a different way to think about it.

The data you collect for the BROP, production volumes, ingredient usage, loss rates, inventory levels, is some of the most valuable operational data your brewery generates. When that data is accurate and well-organized (which it has to be for compliance), it becomes a foundation for smarter business decisions.

Consider what accurate production data tells you beyond what the TTB requires:

• Yield efficiency by batch. If your 10-barrel system consistently yields 9.2 barrels of packaged beer, your process loss rate is about 8%. If one batch yields only 8.1 barrels, something went wrong, and you can investigate while the details are still fresh.
• Ingredient cost per barrel. When you know exactly how many pounds of grain and hops go into each barrel produced, you can calculate your ingredient cost per barrel by style. That feeds directly into pricing decisions.
• Seasonal production patterns. Over several filing periods, your BROP data reveals production trends. Which quarters have the highest output? When do losses spike? When does inventory build up before busy selling seasons?
• Loss benchmarks. The Brewers Association suggests that well-run breweries typically see process losses between 5% and 15% depending on their equipment and packaging methods. Your BROP data lets you calculate your actual loss rate and compare it against industry benchmarks.

Breweries that invest in good production tracking tools don't just file cleaner BROP reports. They make better decisions about what to brew, when to brew it, and how to price it. The compliance data and the business intelligence data are the same data. The only difference is how you use it.

Making the Investment in Clean Data

If your current process involves handwritten brew logs, disconnected spreadsheets, and a frantic scramble at the end of each quarter, the cost isn't just your time. It's the errors you don't catch, the insights you miss, and the stress that takes you away from the parts of running a brewery you actually enjoy.

Moving to a system where batch records, tank volumes, packaging counts, and shipment logs all live in one place transforms TTB reporting from a dreaded chore into a 30-minute exercise. The numbers are already there. You just pull them.

More importantly, clean data gives you confidence. Confidence that your BROP is accurate. Confidence that an audit won't uncover surprises. And confidence that you're making production and purchasing decisions based on real numbers, not estimates.

The BROP isn't going away. The TTB will always require it. But how painful it is to prepare is entirely within your control. Start with clean data, build a repeatable process, and let the compliance take care of itself.

Ready to get your production data organized? Explore how BrewPlanner connects your brewhouse, inventory, and reporting so your next BROP is the easiest one you've ever filed.