Batch Records That Pay for Themselves
Make your own: hot sauce recipe builder → Choose a pepper, scale a sourced recipe, and print your batch.
A batch card is the cheapest cost control a sauce kitchen owns. It costs one sheet of paper and records the numbers that the next purchase order has to know. A 5 fl oz woozy bottle lists at $0.630 each at 12 bottles, its closure at $0.163, and a 5 gallon pail at $4.940. Co-packers already print the lot code that ties a case to a run, so the record only has to catch what is already on the case.
Log the four numbers you reorder
A batch record has one job that pays immediately: it tells the next order what the last one consumed. Four numbers do most of that work, and all four are already on somebody else's invoice.
Start with the container. A 5 fl oz woozy bottle runs $0.630 each at 12 bottles and steps down as the order grows. Write the price and the quantity break you actually bought at, because the gap between the two is the money you leave on the table by reordering late. The closure is a separate line: $0.163 each at single-unit pricing. Bottles and caps are quoted separately by every packaging distributor, so a record that stores one combined number cannot tell you which side moved when the invoice changes.
Then the bulk vessel. A 5 gallon white plastic pail lists at $4.940 at one unit and $4.540 at 120. If your sauce ferments or rests in pails, that is a real per-batch cost, and it repeats every time you scale a run.
Last, the batch size itself. Write the gallons you started and the gallons you packaged, not just the yield percentage. A co-packer quoting a 40 gallon hot-fill start and a kitchen filling 5 gallon pails are working in the same unit, and the only way to compare quotes is to keep the unit consistent. Once those four numbers live in one place, a reorder is a lookup rather than a rebuild.
Capture the lot code at fill
The lot code is the single field that cannot be reconstructed later. Every other number on a batch card can be rebuilt from invoices, but the code printed on the case exists only while the run is happening.
Co-packers put it there as part of the run: labeling, lot coding and case packing are services on the same quote as the filling. That means the code is being generated whether or not anyone writes it into your file. The record's job is to capture it against the date, the formula version and the quantity, so that a question about one case can be answered without opening every box in the warehouse.
Retention is the other half. Records held at the processing plant or another reasonably accessible location are kept for three years from the date of manufacture. Three years is longer than most small brands keep a paper folder, and it is longer than most point-of-sale exports survive a software migration. If the file is a spreadsheet, the record is only as durable as the laptop it sits on.
A practical shape: one row per batch, with date, code, formula revision, starting gallons, packaged units and the four reorder numbers. Nothing else. A card that takes ninety seconds to fill gets filled on a bad day; a form that asks for twelve fields gets filled in for the first two batches and then abandoned.
Record yield in pounds and gallons
Yield is where a batch record stops being paperwork and starts being a forecast. Inputs are easy to count because they arrive on a pallet. Outputs are messy because they shrink.
Roasting is the clearest case. A 25 lb box of fresh chile yields roughly 15 lbs of usable roasted chile once the skins, stems and water loss are gone. That is a working number for planning, not a guarantee, and it belongs in the record as the observed figure for your own process rather than the supplier's planning figure. If your kitchen gets 14 lbs from the same box, the record should show 14.
The gap between input and output is the part of the cost that never appears on an invoice. A batch that starts at 40 gallons and packages less than that has a loss somewhere in the line: kettle heel, filler priming, spillage, rejected units. Writing the two numbers side by side makes the loss visible without anyone having to argue about it.
For frozen inventory the record also needs a date, because frozen product is not permanent. Roasted chile held at 0°F keeps its quality for 12+ months. A case with no date on it has an unknown remaining life, and unknown life gets discounted or dumped. Date plus code plus pounds is enough to run first-in-first-out without a warehouse system.
Let price breaks show up across batches
Single-batch costing hides the largest lever in packaging: quantity breaks. The same pail costs $4.940 at one unit, $4.540 at 120 and $4.460 at 240. None of those numbers is visible if each batch is costed in isolation at the price you happened to pay that week.
Glass behaves the same way. The woozy bottle steps from $0.630 at 12 bottles down through $0.590 at 576 and $0.570 at 1,152. A brand filling a few hundred bottles a month is sitting on the top step and does not know it, because the invoice always shows the price for the quantity actually bought.
A batch log turns that into a decision. Once twelve months of batches are in one table, the annual bottle count and the annual pail count are just sums, and the next step down becomes a target with a date attached. Buying to a break is not free: it converts cash into inventory and adds storage. The record is what lets you compare the saving against the shelf space it costs.
Caps follow the same curve from $0.163 at single-unit pricing down to $0.114 at 4,000, and they are the easiest item to over-order because they are small. The log keeps the count honest: caps consumed per batch, not caps ordered per panic.
Keep the record cheap enough to keep
The failure mode for batch records is not missing fields. It is a system so heavy that nobody updates it after the third week.
The minimum viable version is a single sheet per batch, filled at the kettle, plus one folder that survives staff turnover. Three years of retention is roughly one archive box per year for a small brand, which is cheaper than any software subscription and easier to hand to an accountant. If the file is digital, keep a copy that does not depend on a single login.
The numbers above make the cost case. A batch card costs one sheet of paper; the pail price break alone is worth $0.48 per pail between the single-unit and the 240-unit price, and the bottle break is worth $0.06 per bottle between 12 and 1,152. On a 40 gallon start, those two lines are worth more than the paper by a wide margin.
What to leave out: anything you will not read. Sensory notes are worth a line if you actually compare them across batches. Marketing copy is not. A record that holds date, code, formula revision, starting gallons, packaged units and the four reorder prices is complete enough to answer a customer question, a co-packer question and a cost question without a second document.
Price of one 5 gallon plastic pail by order quantity
List prices for the same 90 mil pail, part 57WPP5. Each step down is a break a batch log can target once annual usage is known.
| Item | Value | Unit |
|---|---|---|
| 1 pail | 4.94 | $ |
| 120 pails | 4.54 | $ |
| 240 pails | 4.46 | $ |
FAQ
What has to be on a hot sauce batch record
Date, lot code, formula revision, starting gallons, packaged units and the packaging prices you paid. The lot code is the one field that cannot be rebuilt later, because co-packers generate it during the run as part of labeling and case packing. Everything else can be reconstructed from invoices if the record goes missing.
How long should a batch record be kept
Three years from the date of manufacture is the retention period in the acidified foods record rule, which calls for records kept at the processing plant or another reasonably accessible location. For a small brand that is about one archive box a year, and it outlasts most spreadsheet migrations.
Does a co-packer hand over batch records
A co-packer prints the lot code as part of the run and can include labeling, lot coding and case packing on the same quote as filling. Ask what the handover looks like before any run ships: which fields come back, in what format, and how quickly after the batch leaves.
What does a batch card cost per batch
One sheet of paper plus the time to fill it. The savings it exposes are larger: the 5 gallon pail price falls from $4.940 at one unit to $4.460 at 240, and the 5 oz woozy bottle falls from $0.630 at 12 bottles to $0.570 at 1,152.