Skip to content

Jam Inventory Template: Fruit, Jars and Batches

An inventory template for a jam maker: frozen fruit, sugar, jars and finished jam on one list, a sum for whether the fruit lasts until next harvest, and lots.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 7 min read

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.

Questions people also ask

What should a jam inventory list include?

Fruit, sugar, pectin and other dry goods, jars, lids and labels, and finished jars by flavor, each with its unit, the amount on hand, a reorder level and a cost. Add a sheet for deliveries and batches with lots and best-by dates.

How much fruit do I need to buy for a year of jam?

Work back from sales. Jars you expect to sell before the next harvest, less jars on the shelf, divided by the jars a batch makes, times the fruit a batch takes. In the example that's 16 cases of strawberries for eight months.

How do I give farm fruit a lot number?

Write the farm, the month it was picked and the field if you know it, and put that on the delivery row and on every batch the fruit goes into.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.