A jam maker's inventory has four kinds of stock: fruit, dry goods like sugar and pectin, packaging, and finished jars. Three of them work like any other shop's: when the count reaches a level, you order more. Fruit doesn't. A maker who buys local fruit buys it once, in season, freezes it, and can't get more at that price until next year. So the list below has the usual columns, and the page adds the sum a reorder level can't do: will the fruit in the freezer last until the next harvest? A second sheet keeps each delivery's lot and each batch's best-by date. The example is a made-up jam maker, counted in November.
The short version
- One list: fruit, dry goods, packaging and finished jars, each in the unit you buy or sell it in.
- A reorder level for every row. For fruit bought once a year, the level is a warning, not an order.
- Work out the jars you'll sell before the next harvest, and the fruit that takes.
- Do that sum in November, while there's time to change something.
- Write the lot of every delivery and a batch code on every cook.
- TaroStack takes fruit, sugar and jars off the shelf as you record a batch. More below.
An example list
Counted in the third week of November.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Strawberries, frozen, 30 lb case | case | 11 | 6 | $54.00 | $594.00 | OK |
| Blueberries, frozen, 30 lb case | case | 4 | 4 | $72.00 | $288.00 | REORDER |
| Peaches, frozen, 30 lb case | case | 7 | 3 | $48.00 | $336.00 | OK |
| Sugar, 50 lb bag | bag | 5 | 4 | $34.00 | $170.00 | OK |
| Pectin, 10 lb tub | tub | 2 | 1 | $96.00 | $192.00 | OK |
| Lemon juice, bottled, 1 gal | jug | 3 | 2 | $13.50 | $40.50 | OK |
Twelve rows in all, $4,075.50 at cost, with four to reorder: blueberries, jars, strawberry labels and blueberry jam. The other six rows are jars, lids, labels and the three finished jams: 312 jars of strawberry, 96 of blueberry and 188 of peach.
Strawberries read OK: eleven cases against a level of six.
Will the strawberries last?
| Strawberry jam | |
|---|---|
| Jars sold a month | 180 |
| Months until next year's berries are in the freezer | 8 |
| Jars needed | 1,440 |
| Jars on the shelf | 312 |
| Jars to make | 1,128 |
| Jars a batch | 144 |
| Batches, rounded up | 8 |
| Cases of strawberries a batch | 2 |
| Cases needed | 16 |
| Cases in the freezer | 11 |
| Short | 5 |
The sales figure and the batch are this maker's own: a batch is 60 lb of berries and 45 lb of sugar and fills 144 jars of 9 oz.
The list said OK and the sum says five cases short. Eleven cases make five whole batches, 720 jars. With the 312 on the shelf that's 1,032 jars, less than six months at 180 a month. The strawberry jam runs out in early May, about ten weeks before the new berries.
A fixed level is the wrong tool. Six cases is plenty in April and nowhere near enough in November. For seasonal fruit the right level is the sum above, 16 cases now, and it falls every month as the harvest gets nearer.
November is when it can still be fixed. Buy five cases of frozen berries from somewhere else, at whatever they cost now. Or hold strawberry back from the shops that take the most and offer peach, which has seven cases and 188 jars. Or raise the price of the jam that will run out. In May there's only one choice, which is to be out of it.
The same sum says what else eight batches take: 96 cases of jars against 46 on hand, and 360 lb of sugar against 250. Those can be ordered. How a normal level is set is in reorder point example.
Deliveries and batches, with their lots
| Received or made | Item | Lot or batch | Quantity | Best by | Note |
|---|---|---|---|---|---|
| Jul 14 | Strawberries, frozen, 30 lb case | Picked 2026-06, field 3 | 20 | Jun 30, 2027 | Frozen at the farm the day they were picked |
| Nov 5 | Jar, 9 oz, case of 12 | Lot J9-44071 | 60 | Lot from the pallet tag | |
| Nov 16 | Strawberry jam, 9 oz jar | Batch SJ-1116 | 144 | May 16, 2028 | Best by eighteen months from the cook |
Fruit from a farm may not come with a lot number. Give it one: the farm, the month it was picked, the field if the farm will tell you. Jars have a lot on the pallet tag, and it's the one to have when a jar chips at the rim. Each cook gets a batch code that goes on the jar. Building one is in how to create lot numbers, and the sheet for the cook itself in jam making log sheet.
The eighteen months is this maker's own date for a sealed jar. Where yours comes from is in jam shelf life.
Counting
Count finished jars every week, by batch, and ship the oldest batch first. Count the freezers once a month, by case, and write the opened case as a fraction. Count jars and lids when a pallet arrives and again before a big cook: twelve cases short on the morning of a batch is a lost day. The file's count sheet takes what the list said and what you found, and works out the difference at cost. What a jar costs to make, from these same numbers, is in jam cost calculator.
Get the template
Download the jam inventory template. The list with values and a status for each row, a sheet for deliveries and batches with lots and best-by dates, a count sheet and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Every cook changes seven or eight rows: fruit, sugar, pectin, lemon juice, jars, lids, labels, and the finished jam. Nobody types them all on a cooking day, so by December the list is November's count. The strawberry sum has to be redone by hand for each fruit, each month. And which berries went into batch SJ-1116 is a line on a paper cook sheet, if somebody wrote it.
How TaroStack does it
In TaroStack the recipe keeps the list.
Recording a batch takes the fruit, sugar and jars off the shelf and puts the finished jars on, from the recipe: buy by the case, cook by the pound.
"What could I make right now" says how many batches of each jam the freezer and the jar rack cover.
The batch notes which lots it used, automatically, and the jars it makes carry your batch code and best-by date.
Planning, on Growth, forecasts sales from your own history and says what will run short and when, in plain words.
First-expired-first-out by default when picking, with lots close to their date flagged.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Stock after a cook | Retype eight rows | Recorded with the batch |
| Batches the freezer covers | A sum for each fruit | What could I make right now |
| Which jam runs out before harvest | A sum, each month | Planning, on Growth |
| Which berries went into SJ-1116 | The cook sheet | On the batch |
Lots, dates, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with planning). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
