Record Keeping & Data Tracking: Building Your Apiary Intelligence
Every beekeeper has stood in front of a hive and thought: Did I treat this colony for mites last month, or was that the one next to it? Memory is unreliable. The bees do not care whether you remember — they simply respond to what you did or did not do. Good record keeping is the single habit that separates beekeepers who improve season after season from those who repeat the same mistakes and wonder why their apiary is not thriving.
This guide covers everything from simple hive cards to full digital systems, so you can choose the approach that fits your operation and actually stick with it.
Why Records Matter
Pattern Recognition
Colonies behave in patterns. A hive that swarms every May, a yard that struggles with small hive beetles every August, a queen line that consistently overwinters well — these patterns are invisible without records. After two or three seasons of notes, you start seeing connections that no textbook can teach you because they are specific to your location, your management style, and your microclimate.
Legal and Regulatory Protection
Many states require beekeepers to register their apiaries and maintain treatment records. If a neighbor complains about your bees, or if your colonies are inspected by your state apiarist, having documented treatment dates, product labels used, and compliance with label directions protects you legally. In some jurisdictions, selling honey or nucs without verifiable treatment records can expose you to liability.
Learning and Mentorship
Your records become a personal textbook. When a colony dies, your notes tell you what happened leading up to the event. When you mentor new beekeepers, your logs become case studies. Nothing teaches like reviewing what you actually did and comparing it to what happened.
📝 Key Insight: The best record system is the one you will actually use consistently. A simple index card you fill out every inspection beats a fancy spreadsheet you abandon after three weeks.
What to Track
Not every beekeeper needs to track the same level of detail. Here is a comparison of minimum essential data versus a more comprehensive approach.
| Data Point | Minimum Tracking | Comprehensive Tracking |
|---|---|---|
| Date of inspection | Yes | Yes |
| Hive identifier | Yes | Yes |
| Queen status (present/absent) | Yes | Yes — plus mark color, year, source |
| Brood pattern | Good/fair/poor | Estimated frames of brood, capped vs. open |
| Temperament | Note if aggressive | 1-5 rating scale |
| Population strength | Light/medium/heavy | Estimated frames of bees, coverage rating |
| Mite count | Yes (if tested) | Method used, exact count, percentage |
| Treatments applied | Product name and date | Product, dose, duration, weather conditions |
| Honey supers | Number on/off | Weight per super, estimated yield |
| Feeding | Type and amount | Type, amount, consumption rate, syrup ratio |
| Diseases observed | Note if found | Identification, severity, photos, lab results |
| Weather | General note | Temperature, wind, humidity, forage conditions |
| Swarming signs | Yes | Cell count, stage, action taken |
| Harvest | Date and weight | Date, weight per super, moisture content, source hive |
| Queen lineage | — | Mother queen, breeding program, graft date |
| Nectar flow | — | Flow start/end, major sources, dearth periods |
The minimum columns give you enough to make basic management decisions. The comprehensive columns turn your apiary into a research-grade operation where you can evaluate queen lines, predict yields, and optimize treatment timing.
Paper-Based Systems
Hive Cards
The simplest and most widely used system in commercial beekeeping. A 4x6 or 5x8 index card is clipped or stapled to the inner cover or placed in a waterproof sleeve on the outside of each hive.
How to set it up:
- Write the hive number and queen year at the top
- Draw columns: Date | What I Saw | What I Did | Next Visit
- Write in pencil (does not smear when wet)
- Update at every inspection
Advantages:
- Zero learning curve
- No batteries, no signal required
- Data stays with the hive — anyone opening it sees the history
- Works in rain, cold, and with gloved hands
Disadvantages:
- No aggregation — you cannot compare ten hives at a glance
- Cards get lost, damaged, or illegible over time
- No backup if a card is destroyed
- Difficult to spot trends across your apiary
Binder System
A step up from hive cards. Use a three-ring binder with one page per hive, organized by apiary location. Include a master log sheet at the front for yard-level observations.
Recommended sections:
- Apiary map with hive positions
- Individual hive pages (chronological entries)
- Treatment log (required in many states)
- Harvest log
- Expense tracking
- Seasonal summary page
🗂️ Tip: Use waterproof paper (Rite in the Rain is the standard) and keep the binder in your truck or bee shed, not in the house where it is easy to forget on inspection day.
Spreadsheet Templates
A well-designed spreadsheet gives you the best of both worlds: structured data entry with the ability to sort, filter, and analyze across hives and seasons.
Recommended Column Structure
| Column | Example Entry | Purpose |
|---|---|---|
| Date | 2026-04-10 | Sort chronologically |
| Apiary | Back Yard | Filter by location |
| Hive # | B-07 | Identify colony |
| Queen Year | 2025 | Track queen age |
| Queen Source | Wildflower Acres | Evaluate genetic lines |
| Frames of Bees | 8 | Population trend |
| Frames of Brood | 5 | Brood rearing pace |
| Queen Seen | Yes | Confirm presence |
| Eggs Seen | Yes | Verify laying |
| Mite Count | 2% alcohol wash | Quantify infestation |
| Treatment | Apivar, 2 strips | Document intervention |
| Food Stores | 3 frames honey, pollen patty | Assess provisions |
| Supers On/Off | 2 honey supers added | Track management |
| Notes | Gentle, good pattern, building fast | Free-form observations |
| Next Action | Check in 2 weeks for swarm cells | Plan follow-up |
Seasonal Tabs
Create separate tabs for each season or month. This keeps individual sheets manageable and lets you compare the same period across years.
Tab structure example:
2026-Spring— March through May inspections2026-Summer— June through August inspections2026-Fall— September through November inspections2026-Winter— December through February notesAnnual-Summary— Aggregated data, year-end reviewTreatment-Log— Required documentation for regulatory complianceHarvest-Log— Yields per hive, per apiary, per season
Spreadsheet Tips
- Use data validation dropdowns for common entries (yes/no, treatment names, temperament ratings)
- Freeze the header row so column names stay visible while scrolling
- Color-code rows by apiary location for quick visual scanning
- Back up your file to cloud storage after every inspection session
- Add a
Follow-Upcolumn with conditional formatting to flag overdue actions
Mobile Apps for Beekeepers
Apps combine the convenience of field entry with the analytical power of digital systems. Here is a comparison of popular options.
| App | Platform | Offline Use | Key Strengths | Limitations |
|---|---|---|---|---|
| CosmoBee | iOS, Android (PWA) | Full offline | Hive management, inspections, QR codes, analytics | Newer platform, growing community |
| HiveTracks | iOS, Android | Partial | Research-grade data, mapping, large community | Subscription required for full features |
| BeePlus | iOS | Partial | Clean interface, colony comparison, reminders | iOS only, limited reporting |
| Apiary Book | Android | Full offline | Detailed tracking, multi-apiary, free version | Android only, dated interface |
| Beetight | Web-based | No | Simple, web access anywhere | Requires internet, limited customization |
| MyBeeLine | iOS, Android | Partial | Social features, mentorship tools | Less focused on raw data tracking |
Choosing the Right App
Consider these factors when selecting a digital tool:
- Offline capability — If you keep bees in areas with no cell signal, offline-first design is non-negotiable
- Inspection workflow — How many taps does it take to log a standard inspection? If it is more than about ten, you will stop using it
- Export options — Can you get your data out? CSV export ensures you are never locked in
- Multi-apiary support — If you manage more than one yard, the app needs to handle location-based filtering
- Cost model — Free apps with ads, one-time purchases, and subscriptions all have trade-offs. Choose what fits your budget and tolerance
📱 Practical Test: Commit to using any app for exactly three inspections. If you find yourself reaching for a pencil instead of your phone, the app is not the right fit for your workflow. Try another.
Tracking Mite Counts and Treatment History
Varroa destructor is the number one threat to colony health in most of the world. Tracking mite levels and treatments is not optional — it is the difference between beekeepers who lose colonies and beekeepers who keep them alive.
What to Record
| Field | Why It Matters |
|---|---|
| Test date | Timing of infestation relative to season |
| Test method | Alcohol wash, sugar roll, sticky board — methods have different accuracy |
| Sample size | Number of bees tested (standard is 300, or roughly half a cup) |
| Mite count | Raw number of mites found |
| Infestation rate | Mites per 100 bees (count divided by sample size times 100) |
| Treatment product | Legal compliance, rotation planning |
| Treatment start date | When the product was applied |
| Treatment end date | When it was removed |
| Post-treatment count | Did the treatment work? |
| Weather during treatment | Temperature and humidity affect efficacy of some products |
Mite Thresholds for Action
| Season | Action Threshold | Critical Threshold |
|---|---|---|
| Early Spring | 1% | 2% |
| Late Spring | 1% | 2% |
| Summer | 2% | 3% |
| Late Summer/Early Fall | 2% | 3% |
| Fall (pre-winter cluster) | 1% | 2% |
These thresholds are general guidelines. Your local climate, colony strength, and management goals may shift them. The point is to have a threshold and track whether your colonies are above or below it at every check.
Treatment Rotation Record
Maintain a separate log showing which active ingredients you have used over the past two to three years. Rotating between chemical classes (amitraz, oxalic acid, formic acid, thymol-based products) reduces the risk of mite resistance.
Tracking Harvests and Yields
Honey harvest data tells you which apiary locations are most productive, which hives are your best performers, and whether your management changes are making a difference.
Essential Harvest Data
- Date of harvest — Tracks seasonal timing
- Apiary and hive number — Attribute yield to specific colonies
- Number of supers harvested — Production per colony
- Gross weight — Total weight before extraction
- Net honey weight — After extraction, actual yield
- Moisture content — Should be below 18.6% for safe storage
- Honey color and flavor notes — Track terroir and seasonal variation
- Sales channel — Farmers market, wholesale, retail, personal use
Yield Benchmarking
Track your average yield per hive per year. National averages in the United States range from 30 to 60 pounds per hive, but local conditions vary enormously. Your own records are the only benchmark that matters.
| Metric | How to Calculate | Why Track It |
|---|---|---|
| Yield per hive | Total honey / number of production hives | Compare colony performance |
| Yield per apiary | Total honey from location / hives at location | Evaluate yard productivity |
| Year-over-year change | Current year yield minus prior year | Measure improvement or decline |
| Yield per super | Total honey / supers pulled | Evaluate comb drawing and storage efficiency |
Tracking Queen Performance and Lineage
A queen defines a colony. Tracking where she came from, how she performs, and when she was installed gives you the data to make smart requeening decisions.
Queen Data Points
| Field | Description |
|---|---|
| Installation date | When the queen was introduced to the colony |
| Queen source | Breeder name, apiary, or if she was a local raise |
| Marking color | International color code by year |
| Clipping status | Whether one wing is clipped for swarm management |
| Mother queen | If known, the parent queen's identifier |
| Breeding trait focus | Gentleness, varroa resistance, honey production, overwintering |
| Supersedure events | Date and whether successful or failed |
| Egg-laying pattern rating | Consistent, spotty, drone-laying, failed |
Queen Performance Review
At the end of each season, rate your queens on three dimensions:
- Population building — Did she build a strong workforce for the flow?
- Temperament — Was the colony workable without excessive smoke or protective gear?
- Overwintering — Did the colony survive winter in good condition?
Rate each on a 1-5 scale. Queens scoring below 3 in any category should be candidates for replacement the following spring.
International Queen Marking Colors
| Year Ending In | Color |
|---|---|
| 1 or 6 | White |
| 2 or 7 | Yellow |
| 3 or 8 | Red |
| 4 or 9 | Green |
| 5 or 0 | Blue |
Seasonal Review — What Your Data Tells You
Collecting data means nothing if you never review it. Schedule a seasonal review at four points in the year.
Spring Review (March-May)
- Which colonies survived winter and built up fastest?
- Were there enough food stores, or did colonies need emergency feeding?
- What was the first mite count of the year? Are you starting behind?
- Which yards had the earliest nectar flow?
Summer Review (June-August)
- How did swarm management perform? Which hives attempted to swarm?
- What is the mite load trend? Are treatments holding?
- Which colonies are your top honey producers?
- Are there signs of queen failure in any colony?
Fall Review (September-November)
- Did fall treatments bring mites below threshold before winter?
- How does this year's harvest compare to last year?
- Which colonies are going into winter strongest?
- Are there any yards with chronic problems worth relocating?
Winter Review (December-February)
- Overall winter survival rate so far
- Estimated honey stores remaining in each colony
- Equipment inventory and repair needs for spring
- Budget and supply planning for the coming year
🔍 Review Tip: Block out thirty minutes at each seasonal transition. Bring your records, a cup of coffee, and no distractions. The patterns you notice during these reviews will reshape your entire approach to beekeeping.
Using Data to Make Better Decisions
Data without action is just numbers. Here are practical examples of how records translate into better decisions.
Case Study: The Disappearing Hives
A beekeeper in Ohio lost four out of twelve colonies over winter for three consecutive years. Each spring, she would replace the deadouts with packages and repeat the cycle. After starting to track mite counts monthly, she discovered that her August mite counts were consistently above 5% — far beyond the treatment threshold. She had been treating in October, months too late. By shifting her treatment to early August based on her mite data, her winter survival improved to 90% the following year.
Lesson: Timing matters more than treatment product. Records revealed that her treatment timing was the problem, not the product.
Case Study: The Mystery Yard
A beekeeper noticed that his hives at one particular apiary consistently underperformed, producing 40% less honey than identical colonies at his other yards. His records showed similar mite levels, similar colony strength, and similar management across all locations. The only difference in the data was timing: the underperforming yard consistently started brood rearing two weeks later in spring.
He investigated further and found the yard was in a low-lying frost pocket that delayed early pollen availability. He relocated the yard to higher ground half a mile away. The following season, that yard matched his others in production.
Lesson: Yield data across apiaries pinpoints location-specific problems that no amount of hive-level management can fix.
Case Study: Queen Evaluation
A beekeeper tracked queen source and overwintering success for three years across forty colonies. The data showed that queens from one particular breeder had a 92% overwintering rate, while queens from another source had only a 65% rate. The price difference was minimal. By standardizing on the better-performing queen line, he reduced his annual colony losses significantly without changing any other management practice.
Lesson: Tracking queen source against outcomes gives you objective data to evaluate genetics. Your apiary is your own test yard.
Digital Tools Integration
How CosmoBee Helps
Modern beekeeping benefits from tools designed specifically for the workflow of managing living colonies across multiple locations.
Offline-first design means you can log inspections in the field without cell service. Every entry syncs automatically when you return to coverage. This eliminates the most common failure point of digital systems — the moment you are standing in the bee yard with no signal and your app refuses to open.
Key capabilities for record keeping:
- Hive management — Track individual colonies with unique identifiers, QR code labels, and complete history
- Inspection logging — Structured data entry that captures queen status, brood pattern, food stores, and observations in a consistent format
- Treatment tracking — Record products, dates, and post-treatment results with regulatory-compliant documentation
- Harvest records — Log yields by hive and apiary with weight, moisture, and sales tracking
- Analytics dashboard — Visualize trends across your entire operation, from mite counts to honey production to colony strength
- Multi-apiary support — Filter and compare data across all your yard locations
Integration with your existing workflow: Whether you are transitioning from paper cards, spreadsheets, or another app, the key is consistency. Start by logging your basic inspection data for one full season. The patterns will emerge on their own.
Getting Started with Digital Records
If you are moving from paper to digital:
- Do not try to backfill historical data — Start fresh from today
- Keep your paper system running in parallel for one month — Build the habit before you trust the tool
- Customize your inspection template — Every apiary is different; your data fields should reflect what you actually check
- Set a weekly review reminder — Five minutes of looking at your data beats five hours of data entry you never review
🔄 Migration Tip: The transition from paper to digital is the most common failure point. Expect it to feel slower and more cumbersome for the first two to three weeks. Your muscle memory for the old system is strong. Push through — the payoff comes at your first seasonal review when you can filter, sort, and compare in seconds what used to take hours of flipping through cards.
References
- Delaplane, K. S., & Mayer, D. R. (2000). Crop Pollination by Bees. CABI Publishing.
- Dietemann, V., et al. (2013). "Standard methods for varroa destructor research." Journal of Apicultural Research, 52(1).
- Honey Bee Health Coalition. (2024). Tools for Varroa Management: A Guide to Effective Sampling and Treatment. Available at: honeybeehealthcoalition.org
- National Beekeeping Inspection Standards. American Beekeeping Federation. beehealth.org
- Seeley, T. D. (2010). Honeybee Democracy. Princeton University Press.
- USDA National Agricultural Statistics Service. (2025). Honey Bee Colonies Report. nass.usda.gov