TTB F 5110.40 · 5110.11 · 5110.28 · 5000.24
Distillery compliance software that closes your month to the proof gallon
ProofLogic builds your TTB Forms 5110.40, 5110.11, and 5110.28 from what actually happened on your floor — every gauge, cut, transfer, and bottling run — then runs nine reconciliation checks so the month ties out before you sign it. PG = WG × proof ÷ 100, to four decimals, everywhere.
Built inside a working DSP — running production, storage, and processing accounts across 166 vessels before it ran anywhere else.
TTB Form 5110.40 — Monthly Report of Production Operations
27 CFR 19.611 · Prepared by ProofLogic
Permit #
DSP-CO-99999
EIN
84-•••1927
Period
Jun 1–30, 2026
Account
PRODUCTION
| Line | Description | Whiskey ≤160° | Brandy ≤170° | Gin | Vodka | Total |
|---|---|---|---|---|---|---|
| 1 | Spirits produced6 src | 412.8600 | — | — | 128.4400 | 541.3000 |
| 5 | Transferred to storage account4 src | 398.2100 | — | — | 128.4400 | 526.6500 |
| 9 | Destroyed (TTB-authorized) | — | — | — | — | — |
| 10 | Losses2 src | 3.1200 | — | — | — | 3.1200 |
| 12 | On hand end of period | 11.5300 | — | — | — | 11.5300 |
| 13 | Total dispositions | 412.8600 | — | — | 128.4400 | 541.3000 |
Monthly operational reports
TTB reporting software that fills in the forms you actually file
Form 5110.40 Production (27 CFR 19.611), Form 5110.11 Storage (19.616), and Form 5110.28 Processing (19.618) are generated — not typed — from your gauge events, distillation cuts, bottling runs, and loss records. Your rye lands in Whiskey ≤160°, your GNS in Alc. & Sp. ≥190°, classified automatically by the 160/170/190 proof boundaries across all ten TTB spirit-class columns.
- Per-line source-count badges — drill from any report line to the gauge records behind it
- Statuses that match how you work: draft, review, filed, amended — with immutability after filing
- Structured JSON download that mirrors the pay.gov form line by line, with 27 CFR citations embedded
- Daily production log backbone: runs, distillations, PG produced, PG bottled, monthly totals
Cross-report reconciliation
BALANCED- Production form cross-foot (line 4 = line 13)541.3000 PG
- Storage form cross-foot (line 4 = line 10)9,312.4000 PG
- Processing form cross-foot (line 4 = line 9)965.4500 PG
- Production → Storage tie (5110.40 L5 = 5110.11 L2)526.6500 PG
- Storage → Processing tie (5110.11 L6 = 5110.28 L2)402.1000 PG
- Tax determination tie-out (feeds the 5000.24)322.5600 PG
- Production beginning = prior month ending0.0000 PG
- Storage beginning = prior month ending9,180.2200 PG
- Processing beginning = prior month ending884.7100 PG
Production account
11.5300 PG
Storage account
9,312.4000 PG
Processing account
965.4500 PG
Tolerance 0.05 PG — half the 0.1-PG tick a gauge record carries. When a check fails you see the exact delta: Δ 12.4000 PG — 845.2000 vs 832.8000
Nine accounting checks tie your three monthly forms to each other, to your tax determinations, and to last month's ending balances — before you file, not after TTB asks.
Month-end close
Nine reconciliation checks before you sign under penalty of perjury
Every form has to cross-foot. The proof gallons your production report sends to storage must equal what your storage report shows received — checked line against line. Tax determinations must tie to what feeds the 5000.24. This month's beginning on-hand must equal last month's ending — per account. Tolerance: 0.05 PG, half the 0.1-PG tick a gauge record carries. When the badge says BALANCED, it means balanced — and when it doesn't, it shows you the exact delta in PG and which line disagrees.
14-item closing checklist
Runs finalized, bottling entered, determinations created, physical inventory complete, all three forms generated and reconciled.
Signed, chained, locked
An authorized signatory confirms by name and server-verified PIN, affirms the 18 USC 1621 perjury statement, and signs. Signatures are SHA-256 hash-chained.
Period lock at the database
Closed months reject back-dated edits at the database level — not with a warning dialog someone can click through.
Gauging
Proof gallon tracking with real Table 1 and Table 6 corrections
The operator types exactly what they see — hydrometer reading, thermometer reading, observed volume — and ProofLogic computes true proof at 60°F (TTB Gauging Manual Table 1), wine gallons at 60°F (Table 6), and proof gallons, live. One math library powers every gauge, cut, blend, report, and reconciliation check, so the number on the still-side laptop is the number on the 5110.40.
- Every fill, transfer, cut, and dump writes a canonical gauge record: account, proof, WG, PG, who performed it
- Obscuration testing per 27 CFR 30.32 for liqueurs and high-solids spirits
- Instrument ID and calibration-date tracking on every reading
- Nine pocket proofing calculators: cut-to-proof, mingling, bottling estimator, and more
Gauge record — type what you see; ProofLogic corrects it
Apparent Proof
130.0
As read on the hydrometer
Temperature (°F)
65.5
Spirit temp at reading
Observed Volume
61.14 gal
Volume at observed temp
TTB-canonical (Table 1 + Table 6 corrected)
True Proof @ 60°F
128.4
Wine Gallons @ 60°F
61.02
Proof Gallons
78.35
Δ proof: −1.6 · volume mult: 0.9980 · PG = WG × proof ÷ 100
Instrument HYDRO-001 · calibrated 2026-05-02 · obscuration per 27 CFR 30.32 supported
Authority cited in the code itself: 27 CFR Parts 19 and 30, TTB Gauging Manual. Never ÷200.
Operations floor
Distillery management software your still-side computer can run
Every vessel in the distillery, live, across seven TTB-relevant stages — mash tun to bulk processing. Start a distillation run by charging the still and lighting the fire; come back at shutdown to record heads, hearts, tails, and feints with real cut times and TTB dispositions per 27 CFR 19.225. Every run must name its source batch, so a TTB agent pointing at the still can trace the contents back to grain.
Production
Operations Floor
Live state of every production-account vessel — mash tuns through bulk production.
Fermentation
8 vessels · 5 activeFV-01
Bourbon Mash
1,200 gal
FV-03
Bourbon Mash
1,200 gal
FV-04
Rye Mash
800 gal
FV-06
Vodka Wash
1,500 gal
Distillation
3 stills · 1 runningS-01
Bourbon · RUN-0716
500 gal
S-02
Empty
300 gal
ST-07
Vodka 190°
550 gal
23 active / 166 vessels · Production 1,204.70 PG · Storage 9,312.40 PG · Processing 965.45 PG
Vessels sorted fullest-first, empties collapsed, per-stage PG totals — 166 vessels stay readable on one screen.
Live run — cut control
Collecting Hearts since 10:42
Hearts — the salable cut. Transfers to storage account.
Apparent Proof
130.0
As read on the hydrometer
Temperature (°F)
65.5
Spirit temp at reading
Observed Volume
61.14 gal
Volume at observed temp
TTB-canonical (Table 1 + Table 6 corrected)
True Proof @ 60°F
128.4
Wine Gallons @ 60°F
61.02
Proof Gallons
78.35
Δ proof: −1.6 · volume mult: 0.9980
Disposition (27 CFR 19.225)
Transfer to storage account
Destination
Tank ST-04 — Stainless 550 (320 gal free)
This cut: 78.35 PG at 128.4°
One-tap cut boundaries stamp real times. A mass-balance guard flags collections exceeding the charge. Cut drafts persist locally — closing the laptop mid-run loses nothing.
Federal excise tax
Excise tax at the right CBMA rate, on the right return
Every taxable removal gets a numbered tax determination computed live at the correct CBMA tier — your first 100,000 PG at $2.70 — with a warning when a removal splits across the tier boundary. Exports, destructions, and samples are recorded as $0 documentary rows that don't consume Tier 1 capacity (26 USC 5001(c)). The Form 5000.24 builds itself for any semi-monthly, quarterly, or annual period: Schedule A by tier, withdrawals by removal type, due date computed, deadline banner that turns amber at 7 days and red at 3.
- Marking a return filed locks every included determination via database immutability triggers
- One-click tax determination straight from a completed bottling run
- State excise too: shipments by destination state, per-state CSVs, Colorado DR-0442 computed from bottling runs
CBMA Tier 1 Progress — 2026
Tier 1 — $2.70/PG18,442.3100
taxable proof gallons removed YTD
$49,794.24
total federal excise tax YTD
Monthly breakdown
| Apr | 2,804.1200 PG | $7,571.12 |
| May | 3,110.4800 PG | $8,398.30 |
| Jun | 3,422.5600 PG | $9,240.91 |
Rate calculator
5,000 additional PG
T1 · 5,000.0000 PG @ $2.70
$13,500.00
effective rate $2.7000/PG
Year-round tier tracking: headroom remaining at $2.70/PG and dollars saved vs. the standard rate, with a what-if calculator that splits across tiers.
Bonded inventory
Bonded inventory you can count, explain, and sign
Barrel warehouse
Every barrel a clickable graphic with entry gauging, regauge history, and angel's-share math — cumulative and annualized loss, flagged above 6%/yr, the annualized equivalent of TTB's 1.5%-per-quarter excessive-loss test for bulk storage (27 CFR 19.462). Rackhouses, barrel profiles, char levels, fill/dump log.
TTB physical inventory
Per 27 CFR 19.333 and 19.371–19.372: snapshot book values, count the floor container by container, categorize and explain every variance, sign under penalty of perjury. Signing trues book to physical.
Raw materials by lot
Grain, botanicals, and packaging received by lot with COA uploads, depleted FIFO from mash bill to bottling BOM — every deduction traces to a specific lot and supplier receipt.
Grain-to-glass traceability in both directions
Forward: pick any vessel or barrel and get the dated activity timeline with proof, wine gallons, and proof gallons at every step. Reverse: pick a bottling run and walk back through the processing batch and blend sources to the tax determination that paid its excise. Every tank-to-tank transfer writes two chained gauge events plus a lineage record.
BOTTLING → Run BR-124 · 312 × 750ml @ 80pf
← PROCESSING batch PB-2026-031 (80.0°)
← ST-07 draw · 178.85 gal @ 190.0° = 339.82 PG
← S-01 finishing run · neutral @ 190.0°
← FV-06 wash · 812.00 gal @ 8.2% ABV
Traced back through 7 transfers
to origin batch B-2601-VDK-003.
Tax: TD-2026-0031 — 49.45 PG · $133.52 (Tier 1)Switching is the easy part
Switching from DISTILL x5? Bring your history.
The migration wizard ingests DISTILL x5's exact CSV exports — 17 import types with a parse preview before anything writes, per-file progress, and inserted / updated / skipped counts. Batch numbering continues in the x5 grammar, so your numbering doesn't reset at go-live. A full multi-year production history has been migrated this way and reconciled exactly: 1,612 bottling runs and six years of tax history included.
Craft DSPs first
Built for craft DSPs — plays well with the rest of your stack
ProofLogic wasn't built in a product studio. It was built inside a working Denver distillery — dogfooded on real production, storage, and processing accounts, real barrel warehouses, and real TTB filings — before it ran anywhere else.
Scaled for craft
For distilleries running real bonded accounts — not a brewery tool with a spirits checkbox, and not a NetSuite implementation with a six-month onboarding.
QuickBooks-ready
Double-entry journal lines from tax determinations and bottling runs, balance-checked, exported as QuickBooks Online CSV mapped to your chart of accounts. Live OAuth connection is on the roadmap.
Alongside ShipCompliant
ProofLogic is your production records and federal operational reporting. State registration and DtC shipping tools like Sovos ShipCompliant sit alongside it, not instead of it.
FAQ
Distillery compliance questions, answered straight
How do I file TTB monthly reports for a distillery?
A DSP files three monthly operational reports: Form 5110.40 (Production, 27 CFR 19.611), Form 5110.11 (Storage, 19.616), and Form 5110.28 (Processing, 19.618), each due by the 15th of the following month. ProofLogic generates all three from your live production records — gauge events, distillation cuts, transfers, bottling runs, and losses — classifies spirits into the correct TTB columns automatically, and exports structured JSON that mirrors the pay.gov filing line by line, so filing is a copy-over, not archaeology. Each line carries a source-count badge so you can drill into the records behind any number.
How do you calculate proof gallons?
Proof gallons = wine gallons × proof ÷ 100. A gallon of spirit at 100 proof is one proof gallon; 61.02 wine gallons at 128.4 proof is 78.35 PG. The catch is temperature: TTB requires correcting your hydrometer reading to true proof at 60°F (Gauging Manual Table 1) and your observed volume to wine gallons at 60°F (Table 6) before you multiply. ProofLogic does both corrections live as you type the readings, and uses one math library for every gauge, report, and reconciliation check.
What is Form 5000.24 and when is it due?
Form 5000.24 is the federal excise tax return. Most craft DSPs file semi-monthly (periods ending the 15th and last day of the month, due 14 days after each period ends); smaller taxpayers may qualify for quarterly or annual filing. ProofLogic builds the return for any period from your tax determinations, computes Schedule A by CBMA tier, breaks out withdrawals by removal type, and shows a deadline banner that turns amber at 7 days and red at 3.
How does the CBMA reduced tax rate work for distilleries?
Under the Craft Beverage Modernization Act, your first 100,000 proof gallons of taxable removals each calendar year are taxed at $2.70/PG instead of $13.50 — a $10.80/PG savings. Only taxable removals consume the allocation; exports, destructions, and samples are recorded at $0 and don't burn Tier 1 capacity. ProofLogic tracks your year-to-date position, warns when a removal splits across tier boundaries, and applies the correct rate to every determination automatically.
Can I migrate from DISTILL x5 — or another system?
For DISTILL x5, yes, with purpose-built importers: the migration wizard ingests x5's exact CSV exports across 17 import types — vessels, barrels, recipes, in-bond products, SKUs, completed batches, transfers, bottling history, and orders — with a parse preview before anything imports, per-file progress, and inserted/updated/skipped counts. Batch numbering continues in the x5 grammar so nothing resets at go-live. A full multi-year production history has been migrated this way and reconciled exactly — 1,612 bottling runs and six years of tax history included. Coming from Whiskey Systems or another platform? The generic CSV bulk-upload covers vessels, barrels, rackhouses, products, formulas, and customers with manual column mapping.
What records does TTB require a distillery to keep, and does ProofLogic satisfy them?
27 CFR Part 19 requires daily production, storage, and processing records, gauge records for every movement, physical inventories (quarterly for bulk spirits per 19.333 and 19.371, semiannual for bottled goods per 19.372), and three-year retention (19.575). ProofLogic writes a canonical gauge event for every fill, transfer, cut, and dump; runs the full physical-inventory workflow with variance explanations signed under penalty of perjury; keeps an immutable audit log; and scores your audit readiness 0–100 across nine weighted factors so you know where you stand before an agent does.
Does ProofLogic integrate with QuickBooks?
ProofLogic generates double-entry journal lines from each month's tax determinations and bottling runs, previews them with a balanced/unbalanced check, and exports a QuickBooks Online-ready CSV mapped to your own chart of accounts. A live OAuth connection with automatic journal posting is on the roadmap; the CSV path (QuickBooks → Import Data → Journal Entries) works today.
Do I still need Sovos ShipCompliant if I use ProofLogic?
They solve different problems. ProofLogic is your DSP production record system and federal operational compliance: the 5110-series reports, the 5000.24, proof-gallon accounting, and bonded inventory. Tools like ShipCompliant handle state brand registrations and direct-to-consumer shipping compliance. Many distilleries run both; neither replaces the other.
Your next 5110.40 is already half-written
It's sitting in your gauge records. Let ProofLogic finish it.