Skip to content

Beekeeping Inventory Spreadsheet: Boxes, Frames, Feed

A free beekeeping inventory spreadsheet: hive bodies, supers and frames in the barn, feed and mite treatments with use-by dates, jars, and what to reorder.

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

Beekeeping inventory is about being ready three weeks before you need to be. The nectar flow doesn't wait for a shipment of frames, and a swarm doesn't wait for you to nail together a box. A beekeeping inventory spreadsheet lists what's sitting in the barn, not what's on the hives: spare hive bodies and supers, frames and foundation, feed, treatments and jars, each with a count, an amount to reorder at and a cost. Treatments and feed supplements get a second sheet with their lot and use-by. Here's one for a made-up 20-hive apiary.

The short version

  • Count the spares in the barn. Equipment on the hives belongs in your hive records.
  • Reorder amounts come from what the season can ask for at short notice.
  • Mite treatments and pollen substitute get a lot and a use-by date.
  • Count in late winter, and order before everyone else does.
  • TaroStack keeps the reorder list and records each lot. More below.

An example sheet

Mauka Hives is a made-up 20-hive honey business on Oʻahu. Six of its ten rows:

Item Unit On hand Reorder at Unit cost Value Status
Deep hive bodies, assembled each 6 4 $24.00 $144.00 OK
Medium supers, assembled each 14 10 $19.00 $266.00 OK
Frames with foundation, deep each 40 30 $3.40 $136.00 OK
Frames with foundation, medium each 55 60 $3.10 $170.50 REORDER
Queen excluders each 8 4 $9.50 $76.00 OK
Sugar, for feed lb 150 100 $0.76 $114.00 OK

Pollen substitute, mite treatment strips, smoker fuel and honey jars are the rest. The barn holds $1,726.90 in spares and supplies. Medium frames and mite strips are under their amounts.

Where the reorder amounts come from

Start from what a good week could demand.

If this happens You need on hand
A strong flow: a super on half the hives 10 supers, 100 medium frames
Two swarms caught or splits made 2 deeps, 20 deep frames
Treatment time for 20 hives 2 packs of strips at 10 hives a pack

Ten frames to a super, so 14 supers need 140 frames, and there are 55. That mismatch is the kind of thing the sheet exists to show: plenty of boxes, not nearly enough frames to fill them. The frames row says REORDER at 60; the honest shortfall is 85.

Lots and dates for what goes in the hive

Received Item Lot Use by Note
Aug 12 Mite treatment strips MT-250811 Feb 28, 2027 Follow the label; note the yards treated
Sep 20 Pollen substitute PS-25-0917 Mar 31, 2027

Treatments are the row to be careful with. They have an expiry date and label directions about timing around honey supers. Write the lot, the date you used it and which yard got it. If a buyer or an inspector asks what went into hives that produced a batch of honey, that's the record. The sheet flags a pack as USE FIRST inside 60 days of its date.

Honey itself, in buckets and jars, has its own sheet: honey inventory template.

Get the spreadsheet

Download the beekeeping inventory spreadsheet. Four sheets: 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

The barn count is right in February. Then boxes go out to yards a few at a time from April on, jars are bought in three sizes, and treatments are used across two visits. By July the sheet describes a barn that no longer exists.

How TaroStack does it

TaroStack keeps the count moving with the season.

Equipment and supplies are items with reorder points. The reorder list shows frames and strips before the flow does, in days of cover where there's a usage history.

Yards can be sites. On the Business plan, the barn and each bee yard are sites, and moving ten supers to a yard is a transfer, so you know what's where.

Treatments by lot. Each pack is received with its lot and use-by. Using it is recorded with the date and a reason, and expiring lots are flagged.

Honey is a recipe. Bottling takes bulk honey, jars, lids and labels off stock and makes a lot of jars with a date.

Counting in the barn. On a phone, with no signal, sent later.

The job Spreadsheet In TaroStack
Frames before the flow Remember to check A reorder list
What's at which yard Memory Sites and transfers
Which treatment lot, when A notebook Recorded with its lot
Jars after bottling Subtract Come off with the batch

Lots, the reorder list and counting are on every plan, from $9.99 a month; more than one site is on Business at $89 a month. 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 equipment should a beekeeper keep in stock?

Spare boxes and frames for a flow and for swarms or splits, feed, the season's treatments, and jars and lids for the next extraction.

How many supers do I need per hive?

It depends on your flow. This example plans for a super on half its 20 hives at short notice and holds 14.

How do I price honey from a small apiary?

From what a jar costs and what your market pays. See how to price honey and honey business profit margin.

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.