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.
