# Livestock and dairy farm sheet (free Excel template)

> Dairy farm records in Excel: herd register, daily milk and sales, feed rations and costs, breeding and calving dates, vet log, fattening gain, profit.

Source: https://softwiro.com/templates/livestock-dairy-farm
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Livestock and dairy farm sheet

A free Excel sheet for a livestock and dairy farm. You register your herd of cattle, buffalo, sheep and goats, the milk you collect each day and what you deliver to the collection centre, and each group's feed and rations, and the sheet works out your cost per litre and each month's profit. It also tracks breeding and expected calving dates, vaccinations and treatments with their due dates, and the weights of fattening calves with their daily gain and the feed cost per kilo of gain.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

| رقم الحيوان | النوع | السلالة | المجموعة | الحالة | العمر (شهر) | حليبه المسجل (لتر) |
| --- | --- | --- | --- | --- | --- | --- |
| ب101 | بقر | فريزيان | الحلابة | حلاب | 80 | 101.0 |
| ب102 | بقر | فريزيان | الحلابة | حلاب | 84 | 111.0 |
| ب103 | بقر | مخلط | الحلابة | حلاب | 68 | 83.5 |
| ب104 | بقر | فريزيان | الجافة والحوامل | حامل | 74 | 0.0 |
| ب105 | بقر | بلدي | الجافة والحوامل | جافة | 102 | 0.0 |

Example from the “القطيع” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات (Settings): Today's date, the first month to track, the alert days for calving and vet dates, the gestation period for each species (cattle, buffalo, sheep and goats; these are indicative figures you can edit), and the list of herd groups.
- القطيع (Herd): A record for each animal: number, species, breed, birth date, sex, group, status (milking, dry, pregnant, fattening, breeding, sold or dead) and purchase cost. It shows age in months, recorded milk, vet cost and sale price if sold. It holds 300 animals.
- سجل الحليب (Milk log): Morning and evening milk for each animal by its number, or for a whole group by its name, with the total for each row and an alert if the number is not in the herd. It holds 3,000 rows.
- مبيعات الحليب (Milk sales): Your deliveries to the collection centre: quantity, price per litre, fat percentage (optional) and amount paid. The amount and the balance owed by the centre appear. It holds 1,000 rows.
- أصناف الأعلاف (Feed items): Each feed item with its unit and price, and beside it the quantity bought and its value from the purchases log. It holds 40 items.
- العلائق (Rations): How many kilos of each feed item one head eats per day in each group. The sheet works out the cost per head per day, the number of heads actually in the group, and the group's cost per day and per month.
- مشتريات الأعلاف (Feed purchases): What you actually bought in feed, with date, quantity, price and purpose (milking, fattening or other). This is the expense that goes into profit.
- التلقيح (Breeding): The date and result of each insemination. The sheet adds the species' gestation period and shows the expected calving date, days remaining and breeding status: pregnant, close, overdue, awaiting check or calved.
- الولادات (Births): Birth date, dam number, newborn, sex, weight and whether it was born alive, with an alert if the newborn is not registered in the herd.
- البيطري (Vet): Vaccinations, checks and treatments with date, cost and next due date, with a "soon" or "overdue" alert on the due date. The sheet only records what you enter; treatment and vaccination follow the veterinarian.
- الأوزان (Weights): Your animals' weights with dates. The sheet picks out the first and last weight of each animal.
- التسمين (Fattening): For each fattening animal: first and last weight, days in the period, weight gain and daily gain, the feed cost for the period from the rations, and the feed cost per kilo of gain.
- مبيعات الحيوانات (Animal sales): Each animal you sold: buyer, weight, price and amount paid. It shows its purchase cost, profit, price per kilo and the balance owed by the buyer.
- المصروفات (Expenses): Labour, electricity, water, transport, maintenance and other costs with their dates and amounts.
- الربح الشهري (Monthly profit): For each month: milk produced, sold and its revenue, animal sales, feed, vet, breeding and expenses, profit and cumulative profit, cost per litre and average price.
- الملخص (Summary): The herd by status and species, a milk and money summary, each group's rations, the number of upcoming and overdue calvings and vet dates, with four charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

The herd, milk, feed and accounts are in one file. You enter an animal's number once and its milk, treatments, breeding and sale appear against it. The cost per litre is calculated from milking feed, vet costs and expenses, and calving and vaccination dates alert you before you miss them. Gestation periods, groups and prices are all values you edit in the sheet.

## How to use it

1. In the «الإعدادات» (Settings) tab, enter today's date and the first month you want to track, and review the gestation period for each species (the example figures are indicative, so edit them) and the groups.
2. Register each animal in «القطيع» (Herd): number, species, breed, birth date, group, status and purchase cost.
3. Record milk daily in «سجل الحليب» (Milk log), either per animal by its number or for a whole group by its name, but not both for the same day. Record your deliveries to the collection centre in «مبيعات الحليب» (Milk sales).
4. Enter feed items and their prices in «أصناف الأعلاف» (Feed items), set in «العلائق» (Rations) how many kilos a head eats per day in each group, and record what you actually buy in «مشتريات الأعلاف» (Feed purchases).
5. Record each insemination in «التلقيح» (Breeding) to get the expected calving date and the close and overdue alerts, then record the birth in «الولادات» (Births).
6. Record treatments and vaccinations in «البيطري» (Vet), fattening animals' weights in «الأوزان» (Weights), animals you sold in «مبيعات الحيوانات» (Animal sales), and other costs in «المصروفات» (Expenses).
7. Open «التسمين» (Fattening) to see daily gain and feed cost per kilo of gain, and «الربح الشهري» (Monthly profit) and «الملخص» (Summary) for cost per litre, profit and charts.

**Before you start:**

- The gestation periods in Settings (cattle 283, buffalo 310, sheep 150 and goats 150 days) are indicative values for the example only, so edit them for your breed and as your veterinarian advises. Expected calving date = insemination date + the period.
- Milk: for each day, record either one row per animal or one row for the group, because the total of all rows is the production. The difference between production and what you sold to the collection centre is what calves and the household drank or what was lost.
- Rations are an estimate: kilos per head per day x feed price x the number of heads in the group that are still present (not sold or dead) x days of the month in Settings. The Feed purchases tab is the actual expense that goes into profit.
- Cost per litre = (milking feed + vet and breeding + expenses) / litres produced. It loads shared expenses onto all the milk. If you have large-scale fattening, treat it as approximate.
- Feed cost per kilo of gain in the Fattening tab = feed cost for the period from the rations / weight gain, excluding purchase cost and labour.
- Monthly profit = milk sold + animals sold - purchase cost of animals sold - feed purchases - vet and breeding - expenses. An animal born on the farm has a cost of zero unless you enter a value for it.
- The sheet is for organising and calculating only and gives no treatment or vaccination advice: vaccinations, doses and dates follow the competent veterinarian.
- The sheet holds 300 animals, 3,000 milk rows, 1,000 rows each in milk sales, feed purchases, vet, weights and expenses, 500 rows each in breeding, births and animal sales, 80 rows in rations, 40 feed items and 60 fattening animals.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

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

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

## Frequently asked questions

### How do I calculate the cost of a litre of milk on my farm?

Record feed purchases with their purpose (milking or fattening), vet costs, expenses and milk production. The «الربح الشهري» (Monthly profit) tab works out cost per litre = (milking feed + vet and breeding + expenses) / litres produced, and you compare it with the average price per litre you sell at.

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

Enter the insemination date in the «التلقيح» (Breeding) tab. The sheet adds the gestation period entered in Settings for that species and shows the expected calving date and days remaining, and alerts you to those that are close or overdue. The periods in the example are indicative, so edit them for your breed and as your veterinarian advises.

### Should I record milk per cow or for the whole herd?

Both work: one row per animal by its number, or one row per group by its name. But do not record both for the same day, or production will be counted twice. The total of all rows is the farm's production.

### Does the sheet give treatment or vaccination advice?

No. It is an organising and calculating tool: it records the dates, costs and due dates you enter and reminds you of them. Treatment, vaccination and dosage follow the competent veterinarian.

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

- Poultry farm cycle tracker (Excel)
- Crop season expenses and revenue tracker (Excel)
- Racing pigeon loft sheet
- Complete farm management sheet in Excel: plots, workers, crops and sales
- Agricultural waste management sheet: rice straw, residues, compost and recycling
- Trip organizer sheet: participants, instalments, costs and itinerary
- Building maintenance sheet: flat fees, expenses, elevator and pump
- Canteen management sheet
- Lending library management sheet
- Study groups management sheet for a private teacher
- Graduation project manager sheet: tasks, team, phases and deliverables
- English vocabulary and expressions sheet in Excel: words by topic and spaced review
- Accounting rules and equations summary sheet: double entry, statements and financial ratios

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