TTB reporting software built from the cellar log, not re-keyed at month end.
Brews, mashes and crushes recorded as batches; every tank, barrel and bright tank tracked by volume; removals tagged bonded or taxpaid as they happen. The excise return and operations report are drafted from those records for your review. A concept for craft breweries, distilleries and wineries.
Reply within one business day · Written scope and fixed price before any work starts
A proposed product shown with illustrative designs and demo data. We deliver it today as a custom build on our engines.
Status as of November 2026. How we label products
Beer in bond
412.6 bbl
Tanks in use
11 / 14
Ready to package
3
Unlogged transfers
1
Tanks
| Vessel | Batch | Volume | Stage | Status |
|---|---|---|---|---|
| FV-3 (30 bbl) | Hazy IPA #212 | 29.1 bbl | Day 9 · dry hop 2 | On schedule |
| FV-5 (30 bbl) | Pilsner #208 | 28.4 bbl | Lagering · day 19 | On schedule |
| BT-2 (30 bbl) | Amber #210 | 27.6 bbl | Carbonated | Package Thu |
| FV-7 (15 bbl) | Barrel Stout #44 | - | Transferred out | Log transfer |
| BT-4 (15 bbl) | Gose #19 | 13.9 bbl | Carbonated | Package today |
Today
- Canning run: Gose #19, 4 bbl16 oz cans
- FV-7 transfer to barrels not loggedPhoto of log uploaded
- Taproom transfer due6 × 1/6 bbl
Taxpaid removals
318.4 bbl
Returned to bond
6.0 bbl
Tax liability
$1,093.40
Untagged
2
Recent removals
| Date | Destination | Product | Volume | Status |
|---|---|---|---|---|
| Oct 28 | Riverbend Distributing | Hazy IPA - 1/2 bbl kegs | 20.0 bbl | Taxpaid |
| Oct 28 | Taproom | Gose - 16 oz cans | 2.3 bbl | Taxpaid |
| Oct 29 | Returned from Riverbend | Amber - 1/6 bbl kegs | 1.5 bbl | Return to bond |
| Oct 30 | QC lab | Pilsner samples | 0.1 bbl | Tag removal type |
| Oct 31 | Festival booth | Pilsner - 1/6 bbl kegs | 1.0 bbl | Tag removal type |
Report form
Pilot-B
pilot participant
Lines balanced
18 / 19
Opening vs. last report
Matches
Due
Nov 14
Checks before filing
| Check | Records | Draft | Difference | Status |
|---|---|---|---|---|
| Beer produced | 131.8 bbl | 131.8 bbl | 0 | Pass |
| Removed taxpaid | 318.4 bbl | 318.4 bbl | 0 | Pass |
| Ending inventory in bond | 412.6 bbl | 411.2 bbl | 1.4 bbl | FV-7 transfer |
| Returned to brewery | 6.0 bbl | 6.0 bbl | 0 | Pass |
In short
Agenbord Trace for Craft Beverage is a proposed production and compliance system for breweries, distilleries and wineries. It tracks batches, tanks and barrels, records bonded and taxpaid removals as they happen, and drafts TTB excise tax returns and operations reports from those records for a person to review. It is a concept with illustrative designs, delivered as a custom build reusing our production ERP engine's inventory and procurement modules.
What slows breweries, distilleries & wineries down today.
Month end means rebuilding the cellar from memory
Brew sheets, transfer logs, packaging runs and taproom pours live on clipboards and in three apps. Before the report is due, someone reconstructs beginning inventory, production, losses and removals - and hopes it balances.
Bonded vs. taxpaid is easy to get wrong
Kegs to a distributor, cases to the taproom, a pallet back as a return, beer consumed in the lab: each removal has different tax treatment. If removals aren't tagged when they happen, the excise return is an estimate.
Barrels and tanks are a black box
Which barrels hold the 2023 rye, what proof they were filled at, how much has been lost to the angels - or which tank has the blend for next week's release - shouldn't depend on one person's notebook.
How the work flows through the system.
Each workflow runs on one shared record, so nobody re-types numbers between steps.
Batch to bright tank to package
Brewer / distiller / winemaker → cellar → packaging
- A batch is created from a recipe or blend with its volume, vessel and lot number.
- Transfers between fermenters, bright tanks, barrels or totes record volume in and out, with losses noted.
- Packaging runs convert bulk volume into kegs, cases or bottles with package lots.
- Lab readings (gravity, ABV, proof, SO2) attach to the batch at the step they were taken.
- On-hand by vessel and package updates in real time for the cellar and the sales team.
Removals tagged at the door
Warehouse → taproom manager → bookkeeper
- Every shipment and transfer out of the cellar is recorded as a removal: taxpaid, to another bonded premises, for export, or tax-free uses where allowed.
- Taproom and tasting-room transfers are recorded as taxpaid removals from bond as they happen.
- Returns to bond and breakage are recorded with reasons.
- The tax liability for the period builds up as removals post, not at month end.
Draft the TTB reports
Compliance lead → owner → TTB
- At period end, the system drafts the excise tax return and the operations report from the period's records.
- Beginning and ending balances are checked against the last report; mismatches are flagged with the batches behind them.
- The compliance lead reviews each line with a drill-down to the source records.
- You file through Pay.gov as usual; the filed copy and supporting records are saved together.
What's included in Agenbord Trace for Craft Beverage.
Recipes, blends & batches
Brew, mash, crush and blend records with ingredients, volumes, vessels and lot numbers.
Tanks & vessels
Fermenters, brites, tanks and totes with current contents, volume and status.
Barrel inventory
Barrels by ID with fill date, fill proof or ABV, contents, location, and gauge and loss history.
Packaging
Kegs, cans and bottles packaged from bulk, with package lots and keg tracking.
Bonded & taxpaid removals
Every removal tagged by type, with returns to bond, breakage and losses recorded.
TTB report drafts
Excise tax return and operations report drafts from the period's records, with drill-down and saved filings.
Wholesale orders
Distributor and account orders, invoicing, keg deposits and state-by-state product registrations list.
Taproom & tasting-room transfers
Transfers to on-site retail, linked to your POS for sales and depletion.
Ingredient purchasing
Malt, hops, grain, fruit, yeast and packaging bought and received by lot.
AI that does specific jobs and shows its work.
Every AI feature is tested on your own records before it's switched on, and a person approves anything that moves money or goes to a customer.
Report reconciliation check
Before you file, compares the drafted report with the period's batches, transfers and removals and explains each imbalance it finds in plain language, with links to the records. Limits: it flags issues; a person reviews and files. It doesn't decide tax treatment.
Cellar log from photos
Reads a photo of a handwritten brew sheet or transfer log and drafts the batch or transfer record for the cellar lead to confirm, so paper can stay on the floor while records stay digital.
Who it's for and who it isn't.
A good fit if you are
- Breweries, brewpubs, craft distilleries and wineries with a taproom, tasting room or distribution
- Producers whose TTB reports are built in a spreadsheet from paper cellar logs
- Multi-license operators - for example a brewery that also runs a distilled spirits plant
- Teams that want production, inventory, wholesale orders and compliance on one set of records
Probably not the right fit if you are
- Producers happy with a dedicated brewery or winery package that already files their reports
- Large producers with an enterprise ERP and an in-house compliance team
- Anyone looking for a tax or legal advisor - the system drafts reports; you or your preparer file them
Designed around the rules you work under.
Plain-English notes, not legal advice. Software supports your compliance process; it doesn't replace your attorney, CPA or compliance lead.
Excise tax return (TTB F 5000.24)
Breweries, distilled spirits plants and bonded wineries report and pay federal excise tax on TTB F 5000.24. Returns are generally due no later than 14 days after the close of the return period. The removals module is designed to support the liability calculation; you or your preparer file the return. TTB - Preparing returns.
Operations reports by license type
Brewers file the Brewer's Report of Operations, TTB F 5130.9 (or TTB F 5130.26 where eligible to report quarterly). Distilled spirits plants file monthly reports as applicable to their operations: production (TTB F 5110.40), storage (TTB F 5110.11), processing (TTB F 5110.28) and denaturing (TTB F 5110.43). Bonded wineries file the Report of Wine Premises Operations, TTB F 5120.17, monthly, quarterly or annually depending on size. TTB - Due dates for operational reports.
TTB beer tax simplification pilot
Since 2025, eligible brewers can join TTB's pilot and file TTB F 5130.Pilot-A and Pilot-B in place of TTB F 5000.24 and TTB F 5130.9 or 5130.26, with beer reported in total barrels and due dates unchanged. As of TTB's April 14, 2026 update the pilot is ongoing with no stated end date. Report drafts would support both the standard and pilot forms. TTB - Beer tax simplification and Industry Circular 2025-1.
What exists today and what's being built.
Reused from our production engines
Capabilities of the engine this edition is built on.
- Materials and inventory management
- Procurement and supplier ledgers
- Mobile approvals with an audit trail
- AI copilot over company data
Built for your project
Scoped and delivered as a custom build.
- Batches, blends, vessels and barrel inventory
- Bonded and taxpaid removal tracking
- Draft TTB F 5000.24 excise returns and operations reports (5130.9, 5110 series, 5120.17)
- Support for TTB's brewer pilot forms
- Packaging, keg tracking and wholesale orders
- POS and U.S. accounting integrations
Connects to the systems you already run.
Systems we integrate with
Named platforms are examples we build against through their public APIs - not partnership claims.
How it compares - honestly.
Established products are often the right answer. Here's when each one is the better choice.
| Product | What it is | The better choice when |
|---|---|---|
| Ekos | Production, inventory, sales and accounting-sync software for breweries, distilleries, wineries and cideries, including TTB reporting. | You want an established craft-beverage platform you can subscribe to now, with TTB reporting already built in. |
| Ollie | Brewery operations and ordering software from Next Glass, with production, inventory and TTB reporting; it expanded to distilleries in 2026. | You're a brewery that wants a modern packaged app for production and wholesale ordering with a published monthly plan. |
| OrchestratedBEER | A brewery ERP built as an add-on to SAP Business One, sold and implemented through SAP partners. | You're a larger brewery that wants full ERP accounting on the SAP Business One platform with a partner to run it. |
| vintrace | Cloud winery production software covering work orders, vessels, barrels, lab analysis, bulk wine and compliance reporting. | You're a winery that wants a dedicated winemaking production system with deep cellar and bulk-wine features. |
What it costs, up front.
Trace for Craft Beverage is a concept delivered as a fixed-scope custom build. It suits producers whose operations don't fit a packaged app - several license types, contract production, or a heavy wholesale side. Typical ranges:
Cellar records & TTB drafts
From $40k
Batches, vessels and barrels, bonded and taxpaid removals, and drafted excise returns and operations reports for one license type.
3–4 months
Beverage ERP
$80k–$200k
Adds packaging and keg tracking, ingredient purchasing, wholesale orders and invoicing, POS and accounting integration.
5–9 months, phased
Multi-license & multi-site
$200k+
Brewery plus DSP or winery, several production sites, contract and alternating-proprietor production, and data migration.
Phased
Breweries, distilleries & wineries: common questions.
Does it file our TTB reports for us?
No. It drafts the excise return and operations report from your records and checks that they balance. You or your preparer review and file through Pay.gov. This isn't tax or legal advice.
Which TTB forms does the concept cover?
The excise tax return (TTB F 5000.24), the brewer's report of operations (TTB F 5130.9 or 5130.26), the DSP monthly reports (TTB F 5110.40, 5110.11, 5110.28 and 5110.43 as applicable) and the winery report (TTB F 5120.17), plus the brewer pilot forms. Each build covers the license types you hold.
What is TTB's beer tax simplification pilot?
A TTB program, announced in 2025, that lets eligible brewers file combined pilot forms (TTB F 5130.Pilot-A and Pilot-B) instead of the standard excise return and brewer's report, with beer reported in total barrels. TTB's page, last updated April 14, 2026, describes it as ongoing with no end date.
Can it track barrels for a distillery?
Yes - each barrel has an ID, fill date, fill proof, contents, location and gauge history, and DSP storage reports are drafted in proof gallons from those records.
We already use Ekos or Ollie. Should we switch?
Probably not if it covers your operation. A custom build makes sense when you run several license types, contract or alternating-proprietor production, or a wholesale business that a brewery app wasn't designed for.
Is this a product we can buy today?
No. It's a concept delivered as a custom build that reuses our engine's inventory and procurement modules. Ekos, Ollie, OrchestratedBEER and vintrace are established packaged options.
Sources
- TTB - Beer tax simplification
- TTB - Industry Circular 2025-1 (brewer pilot)
- TTB - Due dates for operational reports
- TTB - Preparing excise tax returns
- TTB - Guide to Form 5120.17, Report of Wine Premises Operations
- 27 CFR 19.632 - DSP monthly reports (Cornell LII)
- Ollie - expansion to distilleries (Sep 22, 2026)
Regulatory notes are plain-English summaries, not legal advice.
Concept
Want Agenbord Trace for Craft Beverage built for your business?
Send us your workflow and the systems you use. We'll reply within one business day, then a free 30-minute call, then a written scope with a fixed price - including an honest view on whether an off-the-shelf product would serve you better.
Other editions of Agenbord Trace.
3PL warehouses
Agenbord Trace for 3PL Warehouses
Concept: 3PL billing software that captures every pallet, bin, cubic foot and accessorial charge, with multi-client inventory and a client portal. Custom build.
View productRestaurant groups with a commissary
Agenbord Trace for Commissary Kitchens
Concept: commissary kitchen software for multi-unit restaurant groups - store ordering, production planning, transfers, recipe costing and invoice capture.
View productFood & beverage manufacturers
Agenbord Trace for Food & Beverage Manufacturing
Concept: traceability software for food and beverage manufacturers and co-packers - formulas, batch records, lot genealogy, allergen controls and mock recalls.
View productFood distributors
Agenbord Trace for Food Distribution
Concept: food distribution software for broadline and specialty distributors - text and email order capture, catch weight, order guides, routes and FSMA 204 records.
View productLumber yards & building supply dealers
Agenbord Trace for Lumber & Building Supply
Concept: lumber yard software for independent dealers - contractor charge accounts, job billing, quotes from takeoffs, yard and delivery dispatch, special orders.
View productGuides and services for this decision.
Buyer's guides
Related services
Looking for a different industry? Browse all products.
