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

6 min read

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 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. For a deeper look at expenses only see the crop season expenses sheet, for poultry the poultry cycle sheet, and for a dairy herd the livestock and dairy farm sheet.

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)Cheat sheet: farm management (2/3)Cheat sheet: farm management (3/3)
0 downloads · 3 pages

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