A beekeeper keeps two kinds of record. The first is the hive inspection: one row for each hive each time it's opened, with whether the queen or eggs were seen, frames of brood, bees and stores, the colony's temper, any pests or disease, and what was fed or treated. The second is the harvest: each extraction with its date, the hives it came from, the weight, and a lot code that goes on the jars. The first tells you what each colony needs next week. The second matters the moment you sell honey, because it ties a jar on a shelf to a day, a set of hives and whatever was done to them. Below are both, a season's example with one failing colony, and a file.
The short version
- One row a hive, every inspection, written at the hive or straight after.
- Queen seen, or eggs seen: one of the two means she's there.
- Count frames of brood, bees and stores. Trends matter more than any one visit.
- Write every treatment: product, lot, date in, date out.
- Give each extraction a lot code and put it on the jar.
- TaroStack tracks jars by lot from the extraction to the customer. More below.
The inspection columns
| Column | Why |
|---|---|
| Date, hive | Number the hives and paint the number on the box |
| Queen seen | Often you won't see her |
| Eggs or young brood | Proof she was laying within the last few days |
| Queen check | Worked out: a flag when neither was seen |
| Frames of brood, bees, stores | The colony's strength and its pantry |
| Temper | A calm hive turned noisy is telling you something |
| Pests or disease signs | Mite counts, with the method |
| Fed | What and how much |
| Treatment | Product, lot, dose, date in and out |
| Supers on | Whether honey for people is on the hive |
A season's end
A made-up beekeeper with three hives.
| Date | Hive | Queen | Eggs | Check | Brood | Bees | Mites | Note |
|---|---|---|---|---|---|---|---|---|
| Sep 5 | 1 | Yes | Yes | OK | 7 | 10 | 2 per 100 | |
| Sep 5 | 2 | No | Yes | OK | 6 | 9 | 5 per 100 | Supers off; treatment started |
| Sep 5 | 3 | No | No | CHECK QUEEN | 2 | 6 | None seen | Look again in a week |
| Sep 12 | 3 | No | No | CHECK QUEEN | 1 | 5 | None seen | Queenless. Combined with hive 1 |
| Oct 3 | 2 | Yes | Yes | OK | 5 | 9 | 1 per 100 | Treatment ended Sep 26; fed 2:1 syrup |
What the rows did
Hive 3. No queen and no eggs on the 5th is a warning, not a verdict: she may have been missed. A week later, still nothing, and brood down from two frames to one. That's a queenless colony, and in September it's too late to raise a new queen, so it was combined with hive 1. The decision took two rows. Without the first, the second visit would have been the first sign.
Hive 2. A mite wash of 5 per 100 bees in September is over this beekeeper's line for acting, so the supers came off and a treatment went in. A month later the count was 1 per 100. The log has the count before, the product and its lot, the dates, and the count after. Your own threshold comes from your local beekeeping association or extension service.
Treatments and honey
This is the part of the record that matters to anyone eating the honey. A treatment's label says whether it may be used with honey supers on, and how long to wait afterwards. Write down:
| Write | Example |
|---|---|
| The product and its lot number | Mite treatment, lot M-4471 |
| The hive | Hive 2 |
| Date in and date out | September 5 to September 26 |
| Whether supers were on | Off, since September 5 |
Then the harvest record can show that no honey was taken from that hive in that window. In the example, hive 2's late supers were left for the bees.
The harvest sheet
| Extracted | Hives | Supers | Honey | Lot code | Moisture |
|---|---|---|---|---|---|
| Jul 18 | 1 and 2 | 3 | 96 lb | H-0718 | 17.4% |
| Aug 29 | 1 | 1 | 34 lb | H-0829 | 17.9% |
One extraction, one lot. H-0718 is spring honey from hives 1 and 2: light, clover and basswood. H-0829 is darker, late summer, hive 1 only. They taste different and they'll crystallize differently, so keeping them apart is good selling as well as good records. The code goes on every jar's label or lid.
Moisture is worth a column. Honey that's too wet can ferment in the jar, and a refractometer reading on the day tells you whether a batch is ready to bottle.
The 96 lb becomes about 128 twelve-ounce jars, and from there it's stock: see honey inventory template. Frames, foundation, jars and feed are in beekeeping inventory spreadsheet, and what to charge in how to price honey.
Get the template
Download the beekeeping records template. Two sheets and a read-me: hive inspections, with the queen check worked out, and the honey harvest with its lot codes. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Print the inspection sheet for a clipboard in the bee yard, with a pencil. Propolis and touch screens don't mix.
Where this stops working
The records end at the extractor. After that, 130 lb of honey is in jars of three sizes, at two markets and a farm shop, and some has been made into creamed honey with a jar of last year's as seed. A customer brings back a jar that's fermenting. The lid says H-0829, if it says anything, and the question is how many more are out there and where.
How TaroStack does it
TaroStack picks up where the bee yard ends.
Each extraction is a lot. Received into stock with its date, the hives and your own fields, such as moisture.
Bottling is a batch. Honey comes off the extraction's lot, jars and lids come off stock, and the jars go on with their own lot code. The batch record notes which extraction they came from, automatically.
Made products keep the link. Creamed honey or a honey blend is a recipe. Its batch record lists the lots that went into it.
Orders record the lot. What went to the farm shop and when.
One report. From an extraction lot to every jar lot, every customer, and what's still on your shelf.
Lot labels print with the code, so every lid really does say H-0829.
| The job | Harvest sheet | In TaroStack |
|---|---|---|
| Jars from each extraction | 96 lb divided by hand | The bottling batch |
| Which extraction is in this jar | The lid, if it was labeled | The jar's lot |
| Where H-0829 went | Memory | Orders, by lot |
| Jars and lids left | Count the boxes | Stock on hand |
TaroStack isn't a hive management tool: inspections stay on your clipboard. Stock, lots and batches 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.
