You run a livestock and dairy farm and want answers without flipping through notebooks: how many litres you milked and sold, what a litre costs you, when a given cow is due, whose vaccination is late, whether fattening pays, and what the month earned after feed and labour. The free livestock and dairy farm sheet keeps all of it in one workbook: herd, milk, feed, breeding, births, vet log, weights and sales.
The problem it solves
On many farms milk goes in one notebook, feed in another, breeding dates live in someone's memory and vaccinations on a slip of paper. Ask "what does a litre cost me?" and there is no answer, because the cost is spread across feed, vet and labour. A calving date is found out late. Here each fact is typed once and the rest is calculated.
Steps, from opening the file to the report
- Settings (الإعدادات): type today's date and the first month to track, and review the gestation days per type (cattle 283, buffalo 310, sheep 150, goat 150). These are guideline sample values: adjust them to your breed and your vet's advice.
- Herd (القطيع): one row per animal: tag, type, breed, birth date, sex, group, status and purchase cost. An animal born on the farm costs zero.
- Milk log (سجل الحليب): enter morning and evening litres, either per animal by tag or for a whole group by name, but never both for the same day. Then Milk sales (مبيعات الحليب) for deliveries to the collection centre at the price per litre.
- Feed: enter items and prices in the feed items sheet, set in the rations sheet how many kilos a head eats a day in each group, and log what you actually bought in feed purchases with its purpose (dairy, fattening or other).
- Breeding and births: log each insemination and its result and the expected calving date appears. Log the birth and the calf tag when it happens.
- Vet and weights: log vaccinations and treatments with cost and next due date, and weigh fattening animals regularly.
- Animal sales and expenses: every animal you sell and every other expense.
- Open Fattening, Monthly profit and Summary: they all calculate by themselves.
What each sheet does
- The herd sheet shows each animal's age in months, its logged milk, vet cost and sale price, and warns if a sale is logged while the status is not "sold".
- Rations multiplies kilos per head by item price, by the heads actually present in the group and by the days in a month, to estimate each group's feed cost.
- Breeding adds the gestation days to the insemination date and judges the status: pregnant, near (within a number of days you set), overdue, awaiting check, or calved.
- The vet log flags the next due date as "soon" or "overdue", and treats any later row of the same type for the same animal as having done it.
- Fattening works out daily gain and cost per kilo of gain; Monthly profit gathers everything per month with cost per litre.
Walk-through on the sample numbers
The numbers and names below are fictional sample data, not market prices. The herd has 21 registered animals, 18 present (6 milking, 1 dry, 4 pregnant, 3 fattening, 4 rearing), with two sold and one dead.
October: 2,276 litres were produced and 2,089 sold at 22 EGP, so milk revenue is 45,958 EGP. Calf ب107 was sold for 52,000 and had been bought for 14,000, so income is 97,958 EGP. Costs are 14,000 cost of the animal sold, 41,740 feed purchases, 5,900 vet and breeding and 7,450 other expenses, a total of 69,090, so October profit is 28,868 EGP.
Cost per litre in October: dairy feed 33,800 + vet and breeding 5,900 + expenses 7,450 = 47,150, divided by 2,276 litres = 20.72 EGP, below the selling price of 22. November up to the 15th shows 23.54 against a price of 23: remember the month is incomplete and feed arrives in lumps.
Calving: cow ب104 was inseminated on 10 February, so her expected date is 20 November, 5 days away, and she shows "near". Ewe ض501 was due on 7 November and is 8 days late, so she shows "overdue" for you to follow up with the vet. Cows ب102 and ج201 have calved and their births are logged, so they show "calved".
Fattening: calf ت401 weighed 205 kg on 1 October and 241 kg on 10 November, a gain of 36 kg in 40 days, or 0.9 kg a day. The group's ration costs 142 EGP per head a day, so feed for the period is 5,680 and the cost per kilo of gain is 157.78 EGP (feed only, without purchase and labour).
Rations: a dairy head eats 155.6 EGP of feed a day; with 5 heads in the group that is 778 EGP a day and 23,340 for a 30-day month.
Common mistakes
- Logging a group's milk and each cow's milk on the same day, which doubles production.
- Forgetting to change an animal's status after it is sold or dies, so its ration and group head count are wrong.
- Leaving the purpose empty in feed purchases, so cost per litre is not calculated as it should be.
- Treating gestation days in Settings as fixed fact when they vary by breed.
- Judging fattening profit by feed alone, ignoring purchase price and labour.
When to move to a system
The sheet suits a farm where you or one or two people type the data. When several workers record milking at once, when you want phone alerts for calvings and vaccinations, or a file with photos and the full history of each animal, Softwiro can build you a system your way. If your farm is mainly crops see the crop season expenses sheet or the complete farm management sheet, and for poultry the poultry cycle sheet.
Next step
Download the sheet, type today's date in Settings, enter your animals in the herd sheet and this week's milk in the milk log. After a week open Monthly profit and read your cost per litre.
FAQ
Does the sheet give treatment advice? No. It records the dates, costs and due dates you type. Treatment and vaccination follow the veterinarian.
Does it work for buffalo, sheep and goats? Yes, each type has its own gestation days in Settings.
How do I remove the samples? Download the blank copy, or clear the white cells.





