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.
