# Poultry Farm Record Keeping Spreadsheet (Excel)

> A free Excel poultry record keeping sheet: daily egg, feed and loss log per flock, hen-day %, broiler feed conversion, costs, sales and profit per flock.

Source: https://softwiro.com/templates/poultry-flock-tracker
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Poultry Flock Tracker for Excel: Eggs, Feed, Mortality and Profit

A free Excel workbook for keeping poultry records, from a backyard flock of hens to a small commercial run of layers and broilers. You list each flock once, then log eggs, feed and deaths every day. The workbook works out each flock's age in weeks, mortality %, hen-day egg production for layers and feed conversion for broilers. Add your costs and sales and it shows profit per flock, per bird and per dozen, with a dashboard and charts. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-poultry-flock-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-poultry-flock-tracker-blank.xlsx)

Excel file (.xlsx) · 217 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| As of | 46341 | Change the date and the alert levels on the Settings sheet. Flocks, the daily log, costs and sales are typed on their own sheets. |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |  |  |  |
| Flocks running | 2 |  | Costs logged |  | 1,629.50 |  |  |  |
| Birds on the farm | 64 |  | Sales |  | 1,360.80 |  |  |  |
| Eggs, last 7 days | 373 |  | Profit |  | -268.70 |  |  |  |
| Hen-day %, last 7 days | 83.3% |  | Unpaid by customers |  | 218.60 |  |  |  |
| Mortality, all flocks | 4.0% |  | Eggs this month |  | 788 |  |  |  |
| Flock | Type | Age (weeks) | Birds alive | Mortality % | Hen-day % (7 days) | Feed conversion | Profit | Status |
| Hens-A | Layers | 27 | 39 | 2.5% | 88.3% |  | -177.50 | Running |
| Hens-B | Layers | 26 | 25 | 0.0% | 75.4% |  | -136.50 | Running |
| Broilers-Oct | Broilers | 6 | 0 | 6.7% |  | 1.86 | 45.30 | Closed |
|  |  |  |  |  |  |  |  |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: The farm at a glance on the as-of date: flocks running, birds on the farm, eggs and hen-day % for the last 7 days, overall mortality, costs, sales, profit and what customers still owe. Below it the flocks side by side, a six-week table, costs by category and four charts.
- Daily Log: The sheet you type into every day: date, flock, eggs collected (empty for broilers or an uncounted day), feed used in kg, deaths, a water check and notes. Birds alive and hen-day % are worked out per row, and a Check column flags a missing date, an unknown flock or more eggs than hens. Room for 1,000 rows.
- Flocks: One row per flock: name, Layers or Broilers, breed, house, hatch date, arrival date, starting birds and a closed date. It works out age in weeks, deaths, mortality %, birds sold, birds alive and whether the flock is running or closed.
- Performance: Every figure for each flock in one place: bird-days, feed per bird per day, eggs, hen-day % overall and for the last 7 days, dozens produced and sold, kg sold, feed conversion, costs, sales, profit, profit per bird, cost per dozen, cost per kg sold and unpaid balance.
- Expenses: One row per cost against a flock: chicks or pullets, feed, vaccines and medicine, labour, bedding, utilities or anything else. Vaccines are simply a cost line here.
- Sales: One row per sale: eggs by the dozen or birds by weight, with the customer, price, amount paid and the balance still due.
- Lists: The expense categories behind the dropdown and the cost chart. Rename them or use the spare rows.
- Settings: Farm name, currency symbol, the as-of date, the mortality alert level and the low-lay alert level.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most poultry record sheets are a grid of eggs per day with a total at the bottom. This one keeps the flock, the daily log, the money and the results apart, so you type each fact once and every ratio follows. Layers get hen-day production, broilers get feed conversion, and both get cost and profit per bird. The sample is two laying flocks and one broiler batch from October and November 2026, so you can see every sheet filled in before you clear it.

## How do I calculate hen-day egg production in Excel?

Hen-day production is eggs collected divided by the number of hens alive that day, shown as a percentage. For a longer period you add up the eggs and divide by the total of hens counted on each day. That is why the Daily Log works out the birds alive for every row: the starting birds in Flocks, less deaths up to that day, less birds sold before it.

In the sample, the ISA Brown flock Hens-A laid 1,452 eggs over 46 days, which is 81.8% hen-day production, and 88.3% in the last 7 days. Hens-B, a younger flock of Rhode Island Reds, is at 67.3% overall and 75.4% in the last 7 days. Across both flocks the farm collected 373 eggs in the last 7 days, a hen-day rate of 83.3%. A day you did not count eggs (an empty cell) is left out, so a missed count does not drag the rate down. A real 0 counts as a day with no eggs.

## How do I work out feed conversion for broilers?

Feed conversion is the kilograms of feed used divided by the kilograms of birds sold. A lower figure means less feed for each kilo of meat. Log the feed used for the flock each day in the Daily Log, then enter the weight of each batch you sell on the Sales sheet, and the Performance sheet divides one by the other.

The sample broiler batch, Broilers-Oct, started with 60 chicks, lost 4 (6.7% mortality, shown in yellow because it is above the 5% alert) and was sold at 6 weeks old: 56 birds weighing 132.0 kg. It used 245.7 kg of feed, so feed conversion is 1.86. The sheet measures against the weight you sold, not a live weight at some other day, so use the same basis every batch if you want to compare batches.

## What should I keep in poultry farm records?

A small flock needs five things: when each flock arrived and how many birds it started with, a daily count of eggs, feed and deaths, what you spent, what you sold, and who still owes you. The sheet keeps those on separate tabs so a flock can be added or closed without touching the others.

Costs are logged against a flock, so profit is simply sales minus costs for that flock. In the sample the broiler batch made 45.30 on 535.50 of costs and 580.80 of sales, a cost of 4.06 per kg sold. The two laying flocks show a loss so far, because the pullets are counted as a cost in full while the flocks have laid for only six weeks. That is the honest picture at that point: cost per dozen is 5.73 for Hens-A and 6.35 for Hens-B and falls as the flocks keep laying. For plain cash in and out beside it, see the [cash book template](https://softwiro.com/templates/cash-book-template).

## How to use it

1. On the Settings sheet type your farm name, currency symbol, the "as of" date (today, or the day you are reporting) and the two alert levels.
2. On the Flocks sheet add one row per flock: a short name, Layers or Broilers, breed, house, hatch date, arrival date and the number of birds you started with. When a broiler flock is sold out, type its closed date.
3. Each day add a row to the Daily Log: date, flock, eggs collected (leave empty for broilers or a day you did not count), feed used in kg, deaths, a water check and any notes.
4. Record every cost on the Expenses sheet (chicks or pullets, feed, vaccines and medicine, labour and so on) against the flock it belongs to.
5. Record every sale on the Sales sheet: eggs by the dozen, or birds by weight, with the customer, the price and what has been paid.
6. Open the Dashboard for the flocks side by side, weekly egg production, costs by category and profit per flock. The Performance sheet has the full list of figures for each flock.

**Before you start:**

- Capacity: 20 flocks, 1,000 daily log rows, 500 expense rows and 500 sales rows. Start a new workbook each year or each batch if you fill them.
- Age in weeks = whole weeks from the hatch date to the closed date, or to the "as of" date while the flock is running.
- Mortality % = deaths in the Daily Log / birds you started with. A flock turns yellow when it is above the alert level on Settings.
- Birds alive = starting birds - deaths - birds sold. If it goes below zero the Check column says so.
- Hen-day production % = eggs collected / birds alive, added up over the days you counted eggs. A day with no egg count (empty cell) is left out, a 0 counts as a day with no eggs.
- Feed conversion (broilers) = kg of feed used / kg of birds sold. Eggs are counted per dozen: dozens produced = eggs / 12.
- Cost per dozen = all costs logged for the flock / dozens produced. Pullets are counted as a cost in full, so a young flock shows a high cost per dozen until it has laid for a while.
- Profit = sales - costs logged for the flock. Costs and sales you have not recorded are not in it. A cost shared by several flocks should be split between them when you log it.
- In the sample the "as of" date is 2026-11-15 and the last 7 days are 2026-11-09 to 2026-11-15. Change the date on Settings to look at another week.
- Use one currency in one workbook. The currency symbol on Settings is only a label. Weights are in kg; the sheet does not convert pounds.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-poultry-flock-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-poultry-flock-tracker-blank.xlsx)

Excel file (.xlsx) · 217 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type the day's counts into one file | The barn hand records from a phone and you see it at once |
| One workbook for a limited number of flocks | Any number of farms, houses and flocks, side by side |
| Feed purchases are typed as costs | A feed store that goes down as each flock uses it |
| Customers are typed on each sale | A customer list with orders, invoices and balances |
| Alerts are coloured cells | Messages when mortality or egg production moves outside your own limits |

### Extra features in the app

- The barn hand logs eggs, feed and deaths from a phone, so nobody types the day's numbers twice
- Feed stock that falls as each flock uses it, with a reorder alert
- Several houses and sites with a login and permissions for each person
- Customer orders for eggs and birds, with deliveries and invoices that update what is owed
- Vaccination and other task reminders for each flock on the dates you set
- Ask for the flock with the best hen-day rate or lowest cost per dozen and get the answer from your own data

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this poultry record keeping spreadsheet free?

Yes. Download it, use it for your own flocks and change anything you like: rename flocks, add expense categories, change the alert levels.

### Can I use it for both laying hens and broilers?

Yes. Set each flock's type to Layers or Broilers on the Flocks sheet. Layers get hen-day production and cost per dozen. Broilers get feed conversion and cost per kg sold. Eggs are left empty for broilers.

### How many flocks and records can it hold?

20 flocks, 1,000 daily log rows, 500 expense rows and 500 sales rows. The Dashboard lists the first 10 flocks. If you fill it, start a new workbook for the next year or batch.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. In Google Sheets, upload the file to Drive and open it with Sheets.

### Why is my laying flock showing a loss?

Profit is sales minus the costs you have logged for that flock. A flock bought as pullets carries the full purchase cost from day one, so it needs time to earn it back. Check that every egg sale and every cost is logged against the right flock.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Farming

## More free templates

- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet
- Livestock and dairy farm sheet
- Complete farm management sheet in Excel: plots, workers, crops and sales
- Agricultural waste management sheet: rice straw, residues, compost and recycling
- Dental Practice Treatment Plan Tracker for Excel
- Travel Agency Booking Tracker for Excel
- Generator Maintenance Log Template for Excel
- Equipment Inspection Log Template for Excel
- Coffee Roasting Log and Costing Spreadsheet for Excel
- Hotel Guest Folio Template for Excel (Rooms, Reservations, Billing)
- Auto Parts Inventory and Sales Spreadsheet for Excel
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
