Your barrel program runs on precise data. From the moment a barrel arrives at your loading dock to the day it’s harvested, dozens of details accumulate — fill dates, proof readings, angel share losses, warehouse locations, cost allocations — each one building a record of what that barrel is, where it’s been, and what it’s worth.
Most distilleries track some of this data. Fewer track all of it. And fewer still track it in a system that connects each data point to production records, lot traceability, compliance reporting, and financials without someone manually reconciling the pieces.
If you’re evaluating whether your current setup is keeping pace with your barrel program, this checklist is a good place to start.
What a Barrel Program Requires Your ERP to Track
A well-managed barrel program generates data across six categories. Here’s what each one includes and why it matters.
Barrel Identity
- Cooperage type and wood species
- Toast and char level
- Barrel size (gallons)
- Fill count (how many times the barrel has been used)
- Entry proof
- Fill date
- Vendor or supplier
Barrel attributes directly affect aging outcomes and flavor profiles. Without consistent tracking, it’s difficult to replicate successful expressions or identify which barrels are performing best across your program.
Liquid Details
- Spirit type and style
- Batch or lot number
- Entry volume (proof gallons)
- Current proof
- Current volume
Liquid details connect each barrel to the production records for the batch that filled it. That connection is how you maintain lot traceability from grain to glass. A barrel that can’t be traced back to its batch is a compliance liability.
Aging and Location Data
- Warehouse, row, bay, and level
- Age statement date
- Previous barrel contents
- Transfer history (every time the barrel has moved)
Location data is what makes your barrel program searchable. Without it, finding the right barrels for a blend or a single barrel selection means walking the warehouse and reading tags. Age statement dates and previous contents are what give your team the information to make confident harvest and blend decisions.
Operational Records
- Fill schedule (upcoming fills against available barrels)
- Harvest schedule (projected harvest dates by barrel or batch)
- Barrel activity log (every transaction the barrel has been part of)
The activity log is the complete story of every barrel in your program — every fill, every transfer, every adjustment. It’s what auditors, buyers, and regulators look at when they want to verify the provenance of your product.
Financial Data
- Original acquisition cost (barrel plus fill costs, including overhead and labor)
- Per-period storage costs allocated over the aging cycle
- Overhead and utility allocations
- Current per-barrel valuation
- Period adjustments as the spirit ages
Your barrel inventory is likely the largest single asset on your balance sheet. Tracking it at the per-barrel level, not just as a bulk inventory number, is what gives your finance team, lenders, and potential acquirers an accurate picture of what that inventory is worth.
Compliance Data
- Angel share loss (proof gallons or LALs lost to evaporation)
- Yield at harvest (volume harvested vs. volume filled)
- Lot traceability linking each barrel to its original batch
The TTB requires producers to account for losses during aging. Angel share documentation is how you demonstrate that your proof gallon figures are accurate, and how you protect against compliance exposure when the numbers don’t add up.
Where Does Manual Tracking Break Down?
A single distillery with a handful of barrels and a disciplined team can maintain a reasonable spreadsheet-based barrel log. As the program grows, the cracks appear quickly.
Version control becomes a problem. Two people editing the same spreadsheet produce two versions of the truth. There’s no audit trail. Cost allocations have to be calculated manually and re-entered for every period close. Angel share percentages have to be calculated from gauging records and entered separately. Location tracking is only as current as the last person who updated it.
And none of it connects. A spreadsheet barrel log doesn’t talk to your production records, your compliance reports, or your financial statements. Every time data needs to move between systems, or between a piece of paper and a computer, there’s an opportunity for error.
The data doesn’t fail all at once. It degrades, slowly, across hundreds of small gaps, until the record of your barrel program no longer reflects what’s actually in your rickhouse.
What Crafted ERP Barrel Management Handles Automatically
Crafted ERP Barrel Management tracks every category in this checklist and connects each data point to the rest of your operation.
Barrel records carry the full identity and liquid profile of every barrel in your program. The activity log captures every transaction automatically: fills, harvests, transfers, and receivings. Lot traceability connects each barrel to the original batch that filled it, which means your compliance data is generated by your production records, not entered separately.
Barrel fill and harvest schedules surface on your dashboard so upcoming production activities are visible before they become urgent. When a barrel is harvested, yield data is captured automatically, and angel share loss flows directly into your TTB reporting. No manual calculation required.
Beyond the operational foundation, Crafted ERP Barrel Management also includes advanced capabilities for distilleries managing their barrel program as a financial asset. Barrel intelligence surfaces per-barrel value, overhead and labor allocations, and storage costs across aging cycles alongside warehouse location visibility and aging distribution.
The single barrel process collapses harvest, production of the aged liquid, and production of the blended liquid into one workflow, with every transaction firing automatically in the background. Additionally, partial barrel harvest gives your team the flexibility to draw off a portion of a barrel for bottling, proofing, or blending while leaving the remaining spirit to continue aging.
The Data Gap Closes at the Point of Work
The checklist is only as useful as the accuracy of the data behind it. That’s where Crafted ERP Mobile closes the loop.
Barrel data doesn’t originate at a desk. It originates in the rickhouse — at the barrel, during the fill, at the moment of harvest. Crafted ERP Mobile puts data entry where the work happens: warehouse staff can log barrel transfers, receive shipments with attributes set on receipt, locate any barrel instantly by scanning its tag, and run proofing and blending calculations without leaving the floor.
Most features work without Wi-Fi, and transactions queue on the device and sync automatically to your Crafted instance when a connection is restored. Warehouse and production staff don’t need a full NetSuite user license to use the app. They access only the part of the system their role requires.
The result is a barrel program where the record in your system reflects what’s actually in your rickhouse. Right now. Not what was there last Thursday when someone had a few minutes to update the spreadsheet.
If you want to see how Crafted handles your barrel program specifically, reach out to our team to set up a demo or business analysis.
