Industry: Distilleries

TTB filing day shouldn't feel like an archaeology project.

The batch records are in a spreadsheet. The barrel inventory is on a whiteboard or a different spreadsheet. The transfer logs are somewhere else. When the TTB filing deadline arrives, someone spends two days assembling data that the operation already captured, just not in a way that's queryable. That's the problem we fix.

  • Batch & Recipe Control
  • Barrel Tracking
  • TTB Compliance
RAWINPUTMASH+ WASHDISTIL-LATIONCUTSBARRELAGINGBOTTLE+ SALESFULL BATCH RECORD — RAW INPUT TO FINISHED SPIRITSECTION A-A — DISTILLERY PRODUCTION CHAIN (DWG-4004)JPL · DWG-4004 · REV A
The Pattern We See

Distillery operations data is scattered across tools that don't connect

Production, barrel inventory, compliance, and sales each have their own records. The connections between them are manual and only happen when someone has time.

These gaps compound as the operation scales. More barrels, more batches, and more SKUs mean more manual reconciliation, not less.

Observation 01

Batch and recipe records live in spreadsheets that capture what happened but can't answer questions about yields, deviations, or cost per batch without manual calculation.

Observation 02

Barrel inventory is tracked in a spreadsheet or whiteboard system. Knowing what's aging, where it is, and when it's ready requires a physical check or a call to the person who maintains the list.

Observation 03

TTB compliance reports are assembled manually from batch records, transfer logs, and sales data before every filing deadline. The process is time-consuming and errors are hard to catch before submission.

Observation 04

Production data and sales data are in separate systems with no connection. Understanding which batches are moving, which are aging, and what's available for release requires pulling from both manually.

What We Build

Production, barrel inventory, and compliance in one system

We connect the batch record to the barrel inventory to the compliance report so nothing requires manual reconciliation before a deadline.

  • Batch records that tell you cost-per-bottle and yield variance without a manual calculation, and a recipe version history you can reference when a run doesn't perform
  • Barrel and tank inventory where every barrel traces back to its originating batch, so "what's aging and when is it ready" is a query, not a phone call to whoever maintains the list
  • Distillation cut and blending records that trace every finished spirit back to its component batches, so you can answer a sourcing question without pulling binders
  • TTB compliance reports generated from the production record, not assembled by hand before the filing deadline, so the archaeology project is over
  • Sales and release tracking tied to barrel and batch records, so inventory counts stay accurate as bottles move without a separate reconciliation step
  • Production cost reporting calculated from actual inputs, not estimated from a separate spreadsheet, so you know the real cost per batch before you price the next release

The goal is a production system where every barrel, batch, and compliance record traces back to a single source of truth.

PRODUCTION LAYER — BATCH, RECIPE, CUTS, BLENDINVENTORY LAYER — BARREL, TANK, RELEASE TRACKINGCOMPLIANCE LAYER — TTB REPORTING, TRANSFERSSINGLESOURCESECTION B-B — THREE-TIER DISTILLERY SYSTEM (DWG-4005)JPL · DWG-4005 · REV A
How We Work

Batch records first. Barrel inventory next. Compliance last.

For distilleries, the batch record is the foundation. Every barrel, every transfer, and every TTB filing traces back to what happened in production. We build in that order.

  • Start with production: batch records, recipe versions, yield tracking, and distillation logs form the foundation before barrel or compliance data is connected. After this step, you can answer "what happened in that run" from the system instead of a spreadsheet
  • Build barrel and tank inventory once the production record is reliable: every barrel traces back to a batch, and release decisions come from accurate aging records instead of whoever last updated the whiteboard
  • Connect compliance reporting once the underlying data is clean: TTB reports become a query against the production record, not a manual assembly project run against a deadline
  • Run compliance reporting before the deadline, not during it: once the data foundation is in place, TTB reports run in minutes from the system of record. The filing becomes a review, not a reconstruction

No platform bet on a single distillery software vendor. One layer built correctly at a time, with working software at each step before moving to the next.

PHASE 01 — PRODUCTION SYSTEMBATCH + RECIPE + YIELD RECORDSPHASE 02 — BARREL + TANK INVENTORYPOSITION, AGING, RELEASE TRACKINGPHASE 03 — COMPLIANCE REPORTINGTTB FILINGS + TRANSFER RECORDSBUILDSEQ.SECTION C-C — PHASED BUILD SEQUENCE (DWG-4006)JPL · DWG-4006 · REV A
Start Here

One conversation about your barrel records and TTB workflow is enough to start.

A 30-minute call is enough to map where your batch data, barrel inventory, and TTB records are disconnected. We'll tell you exactly what we'd build and what it would take to make filing day routine instead of painful.

Start a Conversation