Skip to content

Beekeeping Records Template: Inspections and Harvest Lots

A free beekeeping records template: one row a hive each inspection (queen, brood, stores, mites, treatments) and a harvest sheet that gives honey a lot code.

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

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.

Questions people also ask

What records should a beekeeper keep?

For each hive at each inspection: queen or eggs seen, frames of brood, bees and stores, temper, pests, feed and treatments. For each extraction: date, hives, weight and a lot code.

Why keep records of hive treatments?

To know what was used, from which lot, and when, and to show that honey wasn't taken while a treatment that forbids it was in the hive.

Does honey need a lot number?

If you sell it, a lot code on each jar lets you tell which extraction it came from when a customer has a question or a problem.

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.