Winery cellar & excise ERP records: reconcile crush must, fermentation lees, barrel ullage and bonded registers
For HR managers, plant administrators and operations heads · Compare approaches
TL;DR — what you’ll learn
- Record the unit-of-measure transition at the crush pad explicitly: grape intake is weighed in metric tonnes, whereas clarified juice/must and wine are tracked in temperature-standardized litres across bonded cellar vessels.
- Never allow barrel topping operations to mask evaporative ullage: log the ullage volume lost as a cellar shrinkage event first, and then log the topping wine transferred in from the donor lot so both excise loss registers and varietal/vintage genealogy stay accurate.
- Separate gross racking lees from recovered lees-filter wine and disposed wet lees, and tie every volume change to physical tank dips or calibrated flowmeters rather than applying flat percentage write-offs.
- Track alcohol-by-volume (ABV) and tax-class transitions across bonded storage, laboratory sampling, bottling losses and tax-paid dispatch so excise returns reconcile directly to vessel movement logs.
A winery completes a 12-month barrel maturation cycle for an estate reserve lot and transfers the wine to a stainless bottling tank. The cellar master reports zero barrel loss because the 150 barrels were topped full every month. Yet the topping tank is down 1,380 litres with no corresponding work-order consumption, and the compliance team discovers that the donor topping tank came from a different vineyard block and vintage—pushing the final blend close to the statutory vintage and varietal declaration limit. Because the cellar spreadsheet recorded only "150 full barrels," it simultaneously distorted the bonded excise loss ledger and erased the topping lot's genealogy.
How do wineries and cideries reconcile grape crush Brix/must volumes, barrel evaporation ullage top-ups, racking lees losses, and bonded cellar excise registers?
Record the unit-of-measure transition at the crush pad explicitly: grape intake is weighed in metric tonnes, whereas clarified juice/must and wine are tracked in temperature-standardized litres across bonded cellar vessels. Never allow barrel topping operations to mask evaporative ullage: log the ullage volume lost as a cellar shrinkage event first, and then log the topping wine transferred in from the donor lot so both excise loss registers and varietal/vintage genealogy stay accurate.
- 01Capture batch contextLot, unit, timestamp and source reference
- 02Verify against rulesActive specification, tolerance and cut-off
- 03Reconcile variancesSeparate physical events from timing gapsDo the batch records and tolerances agree?YesApprove ledger postingNoKeep the disputed quantity in a visible hold status and route to the designated owner.
- 04Approve ledger postingRetain signed-off evidence and history
Illustrative information flow. The article explains the evidence, exceptions and responsible decisions. Diagram: NextEdge Labs.
Scope and evidence boundary: cellar record architecture vs winemaking and excise law
This guide defines the ERP and cellar-management record controls for volume reconciliation, lot genealogy and excise audit readiness. It does not provide winemaking instructions, yeast/malolactic inoculation protocols, sulphur dioxide ($\text{SO}_2$) or tartaric acid dosing rates, cross-flow filtration operating parameters or jurisdiction-specific legal tax advice.
Oenological process definitions follow international references such as the OIV International Code of Oenological Practices, while bonded premises record-keeping, physical inventory cutoffs and allowable unexplained loss explanations are governed by national excise authorities (illustrated in the US context by TTB 27 CFR Part 24 — Wine and in India by applicable State Excise Manufactory / Bonded Warehouse rules). Winemakers, laboratory managers and licensed excise officers hold sole authority over oenological treatments, laboratory release and statutory tax filings.
Scroll horizontally to see all columns.
| Cellar stage / transaction | Solid mass (t) | Liquid volume change (L) | Running wine balance (L) | Lot T2 share in blend (%) | Accounting classification & evidence |
|---|---|---|---|---|---|
| **1. Grape crush intake (Lot V1, 24.2 °Brix)** | **50.00** | — | — | — | Weighbridge net grape tickets + crush-pad lab slip |
| Less: Destemmer stems & press pomace (marc) | (9.20) | — | — | — | Pomace bunker weighbridge dispatch manifest |
| **2. Settled / pressed must established in tank** | — | **+36,500.0** | **36,500.0** | **0.00%** | Calibrated receiving-tank dip & temperature check (730.0 L/t) |
| Less: Fermentation $\text{CO}_2$ evolution & thermal contraction | — | (550.0) | 35,950.0 | 0.00% | Post-fermentation cold tank dip vs initial must dip |
Source: GS1 · Lot identification and movement event records. Reference details
1. Crush-pad mass-to-volume conversion (tonnes to litres)
Grapes arrive at the weighbridge in tonnes (gross bin weight minus tare) with an intake sample recording Brix (or Baumé/Oechsle), titratable acidity and pH. After destemming, crushing and pressing: Solid pomace (marc)—stems, skins and seeds—exits in tonnes to compost, tartrate recovery or distillation. Liquid free-run juice and press fractions enter settling or fermentation tanks where the primary accounting unit switches to litres (standardized to $20\text{ }^\circ\text{C}$ or $60\text{ }^\circ\text{F}$ per local excise rules).
In a red-wine fermentation where skins and juice ferment together as unsettled must before pressing, any pre-press tank volume is an estimated liquid-equivalent volume; the authoritative initial wine-volume establishment for the bonded cellar ledger occurs only when free-run and pressed wine are measured in calibrated receiving tanks after pressing.
Source: Frappe / ERPNext · Material movement and reconciliation controls. Reference details
2. Fermentation contraction, gross racking lees and lees-filter recovery
During alcoholic fermentation, sugar converts to ethanol and carbon dioxide ($\text{CO}_2$ gas escapes), and cooling from fermentation peak temperatures to cellar storage temperatures causes thermal volume contraction. When wine is racked off settled solids: Gross racking bottoms (L) are pumped from the fermenter base to a lees tank. If the winery processes those bottoms through a rotary drum vacuum filter, plate-and-frame lees filter or centrifuge, recovered lees wine (L) returns to bulk wine inventory (either rejoined to the parent lot or downgraded to a separate bulk wine lot), while net wet lees cake/slurry (L or kg) is discharged to waste or a distillery byproduct manifest.
Recording only the net loss—or booking gross racking bottoms as destroyed before lees filtration finishes, leaves recovered wine unrecorded or breaks lot genealogy.
3. Oak barrel evaporative ullage ("angel's share") and topping genealogy
Wine stored in oak barrels loses water and ethanol vapour through stave pores and bung seals (typically 2% to 5% per year depending on cellar humidity, temperature and airflow). To prevent oxidation, cellar crews periodically top each barrel with wine from a designated topping lot. Every topping cycle requires two explicit transactions on the barrel group: Ullage loss write-off ($-\Delta V$): Equal to the exact measured volume of topping wine required to bring the barrel group back to full capacity (plus any net deficit in partially filled breakdown barrels). Topping transfer in ($+\Delta V$): Depleting the donor topping tank/keg by $\Delta V$ and appending the donor lot's vintage, varietal and vineyard/appellation composition to the receiving barrel group's weighted-average genealogy ledger.
If the ERP simply transfers wine from the topping tank into the barrel group without booking the equal and opposite ullage evaporation loss, the system will show the barrel group holding more wine than its physical capacity. Conversely, if the cellar crew tops barrels without logging the transfer, the topping tank develops an unexplained shortage and the barrel group's varietal/vintage composition percentages become unauditable.
4. Bonded vs tax-paid inventory and laboratory/tasting removals
Excise authorities distinguish between: Authorized operational losses (fermentation, racking lees, barrel evaporation and filtration hold-up within documented norms). Tax-exempt removals (authorized laboratory analysis draws, cellar quality-control tastings or verified destruction under excise supervision, where permitted by statute). Dutiable / tax-paid removals (bottled case dispatches, bulk wine sales or tasting-room transfers across the bonded boundary).
Illustrative worked example: 50.00-tonne crush through 12-month barrel maturation
All figures below are illustrative and synthetic. They trace a 50.00-tonne grape lot (Lot V1) through pressing, fermentation, lees filtration, 12-month maturation in 150 oak barrels (230 L capacity each) with topping from a separate reserve lot (Lot T2), and final pre-bottling filtration.
Summary
Reliable winery fermentation brix ullage bonded cellar excise depends on consistent lot identity, shared cut-off times, and explicit exception ownership across production, quality, and finance. When teams verify physical evidence before posting adjustments, both traceability and margin reporting remain defensible.
What to do next
- Audit one recent week of winery fermentation brix ullage bonded cellar excise transactions to identify unrecorded movements, unit mismatches, or late entries.
- Define the mandatory lot, unit, and approval fields required before an operator or integration can post a status change.
- Pilot the exception queue on one product line and review unresolved variances at a fixed daily cut-off.
Compare this workflow with your current setup
Share the step that takes the most manual work, the systems involved and the exceptions your team handles. That gives us a concrete starting point for comparing approaches.
Sources and further reading
Sources checked 15 October 2026. The worked examples and software evaluation suggestions are NextEdge Labs’ editorial analysis.
- GS1 Global Traceability StandardGS1 · Release 2.0, August 2017
Reference framework for identification and traceability data. Citing it does not imply that a proposed system is GS1 certified.
- Stock EntryFrappe / ERPNext · Online product documentation, accessed October 2026
Examples of distinct material receipt, issue, transfer and manufacturing transactions, including transit handling.
Visual credits
AI-generated illustration created for NextEdge Labs; it does not depict a client facility. Workflow diagram by NextEdge Labs. Icons from Lucide (ISC licence).
