Honey Sales and Batch Tracker batch record and dashboard in use

Honey Sales & Batch Tracker: Beekeeper Jar Inventory, Pricing & Sales Spreadsheet

$24

Track honey from batch to jar to customer.

Record where each batch came from and what it packed out to, cost every jar, keep stock and supplies in view, and follow customers and preorders.

What's included

  • Excel workbook with Start Here and Dashboard tabs
  • Google Sheets copy (make-a-copy link)
  • Fillable PDF and Printable PDF, 13 pages each, US Letter
  • README

Inside the workbook

  • Dashboard: Season totals, pack yield, profit, jars on hand, preorders, month by month and two charts
  • Honey Batches: Every batch: source, date, type, raw weight, processing, packed units, packed weight and yield
  • Products & Pricing: Each product and size: costs, unit cost, price, margin, units sold, revenue and stock on hand
  • Jar Inventory: Packed stock and reserved units by product, flagged Low or Watch from the levels you set
  • Sales: Every sale: customer, channel, product, units, price, discount, payment and batch
  • Customers & Preorders: Repeat buyers, holds, wholesale interest and pickups, with spend this year
  • Supplies: Jars, lids, labels, seals and boxes, with shortfall and restock cost
  • Expenses: Bee supplies, honey bought in, packaging, ingredients, equipment and fees
  • Season Review: Each product side by side, filled in for you, with demand and next-season decisions

Printable pages

Cover, Start Here, Honey Batch Record, Batch Log, Products + Pricing, Jar Cost Worksheet, Jar Inventory, Sales Record, Customers + Preorders, Packaging + Supplies, Season Review, Season at a Glance, Next Season Plan.

Who it's for

Small beekeepers and honey sellers managing raw, creamed or infused honey, comb, samples and gift sets at farmstands, markets, pickup or small wholesale accounts.

Format and delivery

One ZIP download. Totals and dashboards calculate for you. The fillable PDF works in Acrobat Reader, Preview and Edge.

Frequently asked questions

Can I use pounds or kilograms?
Either. Pick one weight unit and use it throughout so pack yield calculates correctly.

Do I need Excel?
No. Use your own free Google Sheets copy, or the PDFs.

A planning and record-keeping tool. It does not replace legal, tax, accounting, licensing, food-safety or labeling advice; check the rules for your state and county.

Instant digital download. Delivered to your email and your account immediately after checkout, no shipping and no waiting.

Designed by Heather Doucette, a small-business owner building tools for people doing the same thing. Read the story →

What you get

This is a digital product. There's nothing shipped. After checkout, your download link is delivered straight to your email and saved under Orders in your account, so you can come back for it any time.

License: what you can do with it

Business Tools License

This covers planners, trackers, worksheets, and business-system kits. It's a license for one person or one business to use and customize the files for your own operations and marketing, for as long as you like.

You can: print and reuse it for your own business, customize editable files and Canva templates with your own brand, and use the finished pages to support your own products and marketing.

You can't: resell or share the source files or editable templates, or use them to build a competing template or digital-product offering.