# Dairy and livestock farm Excel (free) + online

> Free Excel sheet for a dairy and livestock farm: herd, milk, feed rations, breeding and calving dates, vet log, fattening gain, cost per litre, monthly profit.

Source: https://softwiro.com/blog/livestock-dairy-farm-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Livestock and dairy farm in Excel (free): herd, milk, feed and calvings

One workbook for the herd, daily milk and sales, feed rations, breeding with expected calving dates, vet log, fattening gain and monthly profit.

15 November 2026 6 min read

## In short

- Each animal is typed once, and its milk, vet cost, breeding and sale follow its tag.
- Cost per litre = (dairy feed + vet and breeding + expenses) ÷ litres produced, worked out for every month.
- Breeding adds the gestation days you set to the insemination date and flags near and overdue calvings.
- Fattening shows daily gain and cost per kilo of gain from the first and last weights, and Monthly profit adds animal sales.

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](https://softwiro.com/templates/livestock-dairy-farm) 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

1. 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.
2. Herd (القطيع): one row per animal: tag, type, breed, birth date, sex, group, status and purchase cost. An animal born on the farm costs zero.
3. 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.
4. 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).
5. 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.
6. Vet and weights: log vaccinations and treatments with cost and next due date, and weigh fattening animals regularly.
7. Animal sales and expenses: every animal you sell and every other expense.
8. 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](https://softwiro.com/contact). If your farm is mainly crops see the [crop season expenses sheet](https://softwiro.com/templates/crop-farm-expenses) or the [complete farm management sheet](https://softwiro.com/templates/farm-management), and for poultry the [poultry cycle sheet](https://softwiro.com/templates/poultry-farm-tracker).

## 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.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: livestock and dairy farm (1/3)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-1.jpg)[![Cheat sheet: livestock and dairy farm (2/3)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-2.jpg)[![Cheat sheet: livestock and dairy farm (3/3)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/livestock-dairy-farm/en-3.jpg)

0 downloads · 3 pages

## 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 |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

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

## Questions this raises

### How do I work out the cost of a litre of milk in Excel?

Log feed purchases with their purpose, vet costs, expenses and milk produced. The Monthly profit sheet gives cost per litre = (dairy feed + vet and breeding + expenses) ÷ litres produced.

### How do I know when a cow is due to calve?

Type the insemination date in the Breeding sheet. The sheet adds the gestation days from Settings for that animal's type and shows the expected date and days left.

### Do I log milk per cow or per group?

Either, but not both for the same day, or production doubles.

### Does the sheet give treatment advice?

No. It records the dates, costs and due dates you type. Treatment and vaccination follow the veterinarian.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
