You raise broilers, and at the end of each cycle you want to know: what it cost, what you made, what a kilo of birds cost you, how many died, and whether it beat the last one. The free poultry farm cycle tracker answers those questions from five records you keep as you go: feed, mortality, weights, sales and expenses. The template and its page are in Arabic.
The problem it solves
The numbers of a cycle are scattered: feed invoices in one place, deaths on a sheet in the house, expenses in your pocket, sales in the trader's notebook. You learn the real profit only after adding it all by hand, and a high-mortality spell can pass unnoticed. Comparing cycles is harder when chick counts and prices differ. The sheet gathers every figure under the cycle's code and calculates the results each time you open it.
How it works, step by step
- In Settings type today's date (or =TODAY() so it updates itself) and the mortality rate above which you want a warning.
- In Cycles type the cycle code, description, placement date, number of chicks and price per chick.
- In Feed, Mortality and Expenses record each entry under its cycle code, and in Weights the samples you take.
- In Sales record each batch with its birds, total weight and price per kilo.
- When the cycle ends, type its closing date in Cycles and its profit and cost per kilo appear.
What each sheet does
- Cycles: per cycle the age, mortality %, birds left, total cost and revenue, and for a closed cycle the profit, cost per kilo and feed per kilo sold.
- Feed, Expenses and Sales: added up by cycle; each entry is costed from its quantity and price.
- Mortality and Weights: deaths by cause, the average bird weight per sample, and the latest average per cycle.
- Summary: closed cycles compared, cost to date for running ones, feed by type and expenses by item.
A walkthrough with the sample data
These figures come from the example built into the sheet, not a real farm. It has four cycles: two closed, one running and one just started (Settings says 1 November 2026):
- C01: 5,000 chicks at 18, 95 died (1.9%), 4,905 birds sold weighing 9,445 kg for 703,490 pounds. Cost is 509,000 (chicks 90,000, feed 372,000, other 47,000), so profit is 194,490, cost per kilo 53.89, and feed per kilo sold 1.80 kg.
- C02: 4,000 chicks, 90 died (2.25%), 3,907 sold weighing 7,420 kg for 530,430. Cost is 431,000, so profit is 99,430 and cost per kilo 58.09. It shows "check counts" (3 birds unaccounted for) and "high mortality" (2.25% exceeds the 2% in Settings).
- C03: a running cycle, 37 days old, with 4,915 birds, a cost to date of 402,500 and a last weight sample averaging 1.88 kg. No profit is shown because it is not closed.
- C04: placed today with 4,500 chicks; its 103,500 cost so far is the chicks alone.
In the Summary the two closed cycles made 293,920 pounds, 146,960 on average, with an overall cost per kilo of 55.74 and a margin of about 23.8% of revenue.
Why this way
- Each cycle's profit on its own: a code ties feed, deaths and sales to one cycle.
- Early warnings: mortality above your limit, counts that do not match, a wrong cycle code.
- Works in Excel 2016 and later, Google Sheets and LibreOffice; free, with no sign-up.
Using the online version
The template page opens on this worked example. Type in the white cells and the grey ones update. You can add a record with a form (feed, mortality or sale), import your own .xlsx made from this template, export to .xlsx, or download the original Excel file. Open the template page or the template list.
Who it suits
Owners of small and mid-size fattening farms who want each cycle's profit and cost per kilo. For general costs outside the cycles see the business expenses sheet, and for daily cash see the cash book.
Common mistakes, and when a sheet stops being enough
Typical mistakes: forgetting a feed delivery or a sale, typing the closing date before the last sales are in, and using a wrong cycle code in a log (a red warning appears). A sheet is also a file one person edits at a time. If several people on several farms must record at once, a custom program can be built for you. To weigh ready-made options first, read how to compare business software.
FAQ
How is a cycle's profit worked out? Sales revenue minus total cost (chicks + feed + other expenses), shown for closed cycles only.