Spreadsheet · Excel & Google Sheets
Flock Tracker
$12 planned price, USD
A single workbook for egg production, true cost per egg, flock health, and sales. Sample data for a seven-bird backyard flock is already filled in so every dashboard number has something to show.
The file is finished, but payment checkout is not connected yet. We are not taking orders or card details on this page. The button below is disabled on purpose.
Planned as a one-time purchase, not a subscription. When checkout opens, you will receive the Excel file to keep. Works in Microsoft Excel and Google Sheets.
What’s in the file
- Start Here — a short setup guide.
- Settings — flock name, record year, your selling price per dozen, and a store comparison price.
- Dashboard — live totals. Eggs, laying rate, cost per egg, cost per dozen versus the store, revenue, and net. All formulas; you don’t type here.
- Flock Register — one row per bird. Status (Active, Broody, Sold, and so on) drives the eggs-per-hen math.
- Egg Log — one row per collection day. Color columns are optional.
- Feed & Supplies — bags of feed, grit, oyster shell, bedding, with cost and finish dates.
- Expenses — hardware, packaging, coops, utilities, and similar costs.
- Egg Sales — neighbor, stand, or market sales.
- Health Log — vaccines, injuries, illnesses, vet visits.
Good to know
- Formulas work in Excel and Google Sheets. No VBA macros.
- Setup takes about fifteen minutes once you replace the sample birds.
- A dashboard figure of $0.00 usually means a blank date or a record year that doesn’t match your log.
- The first year often shows a backyard dozen costing more than the store — common while you are still buying equipment. The workbook will show that honestly, in red, when it is true.
- A free companion file, Egg Log Lite, tracks eggs and the flock only.
Inside the workbook
These previews are screenshots of the actual file, including the sample “Maple Street Flock” data. Replace that data with your own before you rely on the totals.
