Skip to content

Honey Inventory Template: Bulk, Jars, Lots by Harvest

A free honey inventory template for a small apiary: bulk honey by harvest lot in pounds, jars, lids and labels, jarred honey by bottling date, and reorders.

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 19, 2026 · 5 min read

Honey is easy to count and easy to lose track of. It sits in buckets by the pound, turns into jars by the dozen, and if you buy honey from another beekeeper to fill orders, two harvests can end up in jars that look the same. A honey inventory template needs a row for each bulk lot (your own, by harvest, and anything bought in), rows for jars, lids and labels, and rows for finished jars by size. Then a second sheet that says which bulk lot each bottling run came from. Here's one filled in for a made-up 20-hive apiary, with the file.

The short version

  • Bulk honey in pounds, one row for your own and one for honey you buy in.
  • Jars, lids and labels in eaches, with reorder amounts.
  • Finished jars by size, with a lot for each bottling day.
  • On the lots sheet, note which bulk lot each bottling came from.
  • TaroStack records the bulk lot behind every jar when you record the bottling. More below.

An example sheet

Mauka Hives is a made-up honey business on Oʻahu that I use in these examples. Six of its eight rows:

Item Unit On hand Reorder at Unit cost Value Status
Raw honey, bulk, own hives lb 420 150 $5.50 $2,310.00 OK
Raw honey, bulk, bought in lb 180 150 $5.50 $990.00 OK
Jars, 12 oz hex each 900 600 $0.72 $648.00 OK
Lids, gold each 1000 600 $0.11 $110.00 OK
Labels, 12 oz each 500 600 $0.08 $40.00 REORDER
Jarred honey, 12 oz each 310 200 $5.04 $1,562.40 OK

The last two rows are comb honey in 8 oz boxes (24 left, reorder at 30) and 35 lb of rendered beeswax. The honey house holds $6,033.60 at cost. Labels and comb honey are under their amounts.

What a jar costs, and why the sheet needs it

The $5.04 on the jarred row isn't a guess. A 12 oz jar holds three quarters of a pound:

Part Cost
Honey, 0.75 lb at $5.50 $4.125
Jar $0.72
Lid $0.11
Label $0.08
A jar $5.035, so $5.04

Use the same $5.50 a pound for your own honey that you'd pay a neighbor for theirs. It keeps the two bulk rows comparable and it's what the honey is worth to you unjarred. How to turn the cost into a price is in how to price honey.

The lots sheet is the point

Date Item Lot Quantity Note
Jun 14 Raw honey, bulk, own hives H-0614-MK 520 lb Spring pull, makai yard
Aug 30 Raw honey, bulk, bought in NB-0830 360 lb Their lot kept with the invoice
Oct 19 Jarred honey, 12 oz J-1019 360 Bottled from H-0614-MK
Nov 9 Jarred honey, 12 oz J-1109 240 Bottled from NB-0830

Two bottling days, two sources. The jars from November 9 hold a neighbor's honey, and the note says so. If that neighbor ever calls about a problem with their August harvest, you know it's lot J-1109, 240 jars, and you can read the lot off any jar on a shop's shelf.

It also keeps your label honest. A jar that says the honey is from your own hives had better trace to a row that says "own hives".

The numbers check, too. The November run of 240 jars took 180 lb (240 times 0.75), and 360 less 180 leaves the 180 lb on the bought-in row. October's 360 jars took 270 lb of the June lot, leaving 250; the other 170 lb on that row came from a later pull. If the bucket count and the arithmetic disagree by more than a few pounds, something was sold in bulk and not written down.

Honey doesn't spoil the way most food does, but stores want a date. This apiary prints two years from bottling.

Get the template

Download the honey inventory template. Four sheets: the inventory with value and REORDER, lots with days left, a count sheet that fills itself, 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 bottling day is four subtractions and one addition, and the bulk row is in pounds while the jars are in eaches. One Saturday at the market sells 40 jars from three lots. The sheet keeps up only if somebody types all of it in that night.

How TaroStack does it

TaroStack does the pounds-to-jars arithmetic and remembers which bucket filled which jar.

A jar is a recipe. Three quarters of a pound of honey, a jar, a lid, a label. Record a bottling of 240 and 180 lb of honey comes off the bulk lot you chose, along with 240 of each package part.

The bulk lot is on the batch. Your own harvest and bought-in honey are separate lots, and the batch record notes which one went into these jars. One report shows where a lot ended up and who bought it.

Units convert themselves. Buy by the bucket, stock by the pound, sell by the jar.

The market works offline. Record sales at the stall on a phone with no signal; it sends itself later.

The job Spreadsheet In TaroStack
Pounds left after bottling Multiply and subtract Comes off with the batch
Whose honey is in this jar A note On the batch record
Jar cost when honey goes up Redo the table Follows the lot's cost
Labels running low Watch for red A reorder list

Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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

How do beekeepers keep track of honey inventory?

By harvest lot in pounds while it's in buckets, and by bottling lot once it's jarred, with the package parts on the same sheet.

Do honey jars need a lot number?

Stores usually ask for one, and it's the only way to pull one harvest without pulling all of it. What else goes on the jar is in how to package honey for sale.

Do I need a license to sell honey?

It depends on your state and how much you sell. The rules are in license to sell honey.

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.