# Farm management Excel (free): plots and workers

> Free Excel sheet for a mixed farm: plots in feddan and qirat, operations, workers and wages, machinery, harvest, sales, profit per feddan and monthly cash flow.

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

---

Free Excel template

# Complete farm management in Excel (free): plots, workers, crops and sales

One workbook for plots in feddan and qirat, operations and inputs, workers' wages, machinery, harvest, sales and cash flow.

15 November 2026 6 min read

## In short

- Plot area = feddan + qirat ÷ 24, and every operation, input, wage and machine hour is charged to its plot.
- Each plot shows total cost, revenue, profit, cost and profit per feddan, and what buyers still owe.
- Attendance multiplies days by the daily wage, and shows what each worker is still owed.
- Cash flow by month counts receipts, inputs, wages and rented machinery, with the closing cash balance.

You run a farm with several plots, crops, workers and machines, and you want clear answers: what each plot cost, what you earned per feddan, who is owed wages, what traders still owe you, and how much cash is left at the end of each month. The free [complete farm management sheet](https://softwiro.com/templates/farm-management) puts it all in one workbook: plots, operations, workers, machinery, harvest, sales and cash flow.

## The problem it solves

On many farms the accounts are scattered: fertiliser spending in one notebook, workers' days on the foreman's slip, the combine's rent in the owner's head and sales to traders in WhatsApp messages. Ask for the profit of the maize plot alone, or what one trader still owes, and there is no number you can rely on. Here every operation, input, wage and machine hour is charged to the plot that used it, then compared with what its crop sold for.

## Steps, from opening the file to the report

1. Settings (الإعدادات): type today's date, the first month of the cash flow and the opening cash. The qirat per feddan is set to 24: a qirat is one twenty-fourth of a feddan.
2. Plots (الأحواض): for each plot a code, name, feddan, qirat, crop, season and planting date.
3. Inputs (المدخلات): seeds, fertiliser, pesticides and fuel with unit, price and what you bought.
4. Operations log (سجل العمليات): each operation with date, plot, type, the input used and its quantity, and outside labour if you paid a contractor or crew for it.
5. Workers and attendance: each worker's daily wage, then attendance in days with the plot worked and any cash paid.
6. Machinery (الآلات): hours of tractor, harvester or pump per plot, owned or rented.
7. Harvest and sales: what you picked and what you sold, by kilo, price, buyer and amount paid.
8. Small livestock (الماشية الصغيرة): optional, for the income and expenses of poultry or a few animals.
9. Open Plots, Cash flow and Summary.

## What each sheet does

- The plots sheet is the heart: for each plot it adds inputs, outside labour, wages and machinery into total cost, sets it against sales revenue, and shows profit, cost and profit per feddan, cost per kilo of crop, what buyers still owe and the plot status: not started, growing, profitable or losing.
- Inputs compares quantity bought with quantity used in operations and warns if more was used than bought.
- Workers shows each worker's days, wages, amount paid and what remains owed.
- Cash flow counts receipts on the collection date, inputs on the date used, wages when paid, and only rented machinery (owned machines count in plot cost, not in cash).

## Walk-through on the sample numbers

The names and numbers below are fictional sample data, not market prices. They cover October and November with the start of the maize and tomato seasons, so enter your full season for a true profit.

The sample has six plots totalling 14.25 feddan. The **tomato plot** is 2 feddan and 6 qirat, so 2 + 6 ÷ 24 = 2.25 feddan. It cost 33,340 EGP (inputs 16,770, outside labour 13,200, wages 2,530, machinery 840). 17,700 kg were picked and 17,300 kg sold for 95,700 EGP, so profit is 62,360 EGP, or 62,360 ÷ 2.25 = 27,715.56 EGP per feddan. 400 kg are unsold and buyers owe 16,000 EGP.

The **maize plot** is 3 feddan, cost 21,970 EGP and yielded 10,800 kg, which is 3,600 kg per feddan. It sold for 76,560 EGP, a profit of 54,590 or 18,196.67 EGP per feddan, with 14,560 still owed by the grain store.

The **wheat plot**, planted on 10 November, has cost 21,235 EGP and no sales yet, so its status is "growing" and it shows no profit.

For the whole farm: crop revenue is 172,260 and plot costs 95,325, so crop profit is 76,935 EGP. Small livestock adds a net of 4,050 (income 9,500, expenses 5,450), making farm profit 80,985 EGP. Workers are owed 1,800 EGP unpaid and buyers owe 30,560.

**Cash:** the sample opens with 80,000. In October 136,400 came in (131,700 from sales and 4,700 from livestock) and 37,655 went out, leaving 178,745. In November 14,800 came in and 29,900 went out, a net of −15,100 and a balance of 163,645.

## Common mistakes

- Entering wages twice: as outside labour in operations and again in attendance. The first is for a contractor or crew, the second for your own daily workers.
- Leaving the plot empty in attendance or machinery, so wages show in the summary as "no plot" and the real plot cost is understated.
- Logging the harvest without logging its sale, so the plot has no revenue or profit.
- Giving an owned machine an hourly cost of zero, which understates plot cost.
- Comparing a plot whose season is unfinished with one that is closed.

## When to move to a system

The sheet suits a farm where the owner or one accountant types the data. When supervisors need to log operations from the field, or you want irrigation and spraying alerts on the phone and photos of each plot, Softwiro can [build you a system your way](https://softwiro.com/contact). For a deeper look at expenses only see the [crop season expenses sheet](https://softwiro.com/templates/crop-farm-expenses), for poultry the [poultry cycle sheet](https://softwiro.com/templates/poultry-farm-tracker), and for a dairy herd the [livestock and dairy farm sheet](https://softwiro.com/templates/livestock-dairy-farm).

## Next step

Download the sheet, enter your plots with their area, then log this week's operations and your workers' attendance. After the first sale open Plots and read your profit per feddan.

## FAQ

**How do I convert qirat to feddan?** Plot area = feddan + qirat ÷ 24.

**Do I write the fertiliser price in every operation?** No. Write it once in Inputs and pick the item in the operation.

**Does it work out tax or subsidies?** No, those follow local law.

## 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: farm management (1/3)](https://softwiro.com/uploads/cheatsheets/farm-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/farm-management/en-1.jpg)[![Cheat sheet: farm management (2/3)](https://softwiro.com/uploads/cheatsheets/farm-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/farm-management/en-2.jpg)[![Cheat sheet: farm management (3/3)](https://softwiro.com/uploads/cheatsheets/farm-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/farm-management/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 profit per feddan in the sheet?

Enter the plot area, log its operations, inputs, workers' attendance and machinery, then its crop sales. The Plots sheet gives profit = sales revenue − cost, and profit per feddan = profit ÷ area in feddan.

### How do I convert qirat to feddan?

A qirat is one twenty-fourth of a feddan, so area = feddan + qirat ÷ 24. Example: 2 feddan and 6 qirat = 2.25 feddan.

### How do I charge workers' wages to plots?

Enter each worker's daily wage in Workers, then in Attendance the date, worker, days and plot. The sheet works out the wage and charges it to the plot.

### Does the sheet work out tax or subsidies?

No. Any tax obligation or subsidy follows local law and should be checked with a specialist.

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