Softwiro
Free Excel template

Crop season expenses and revenue tracker (Excel)

A free Excel template for working out the profit of a farming season. Enter your plots, log every expense by category (labor, fertilizer, irrigation, harvest and transport, and others) and every sale of the crop. For each plot the sheet calculates total expenses, revenue, profit, cost per feddan, profit per feddan, cost per kg and status. It then shows a season summary and how expenses split across categories.

Excel file (.xlsx) · 135 KB · 6 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

Example from the “القطع” tab (Arabic), with the numbers and formulas that are in the file.
كود القطعةاسم القطعةالمحصولالمساحة (فدان)إجمالي المصروفاتالإيرادالربحتكلفة الفدانالحالة
P01قطعة الجنوبقمح5.068,500.00106,500.0038,000.0013,700.00رابح
P02قطعة الترعةذرة3.030,500.0037,200.006,700.0010,166.67رابح
P03قطعة الشرقطماطم2.045,000.0068,500.0023,500.0022,500.00رابح
P04قطعة الغرببطاطس4.074,500.0059,000.00-15,500.0018,625.00خاسر
P05القطعة الصغيرةبصل1.512,500.000.008,333.33قيد الزراعة
P06القطعة الجديدةبرسيم2.00.000.000.00لم تبدأ

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

What is inside

  • "القطع" (Plots): Plot code, name, crop, area in feddans and planting date. The sheet then calculates total expenses and expenses for labor, fertilizer, irrigation, harvest and transport, plus quantity sold, revenue and profit, cost per feddan, profit per feddan, cost per kg and status (profitable, loss-making, growing or not started). The example has six plots covering 17.5 feddans, and the table has room for 200 plots.
  • "المصروفات" (Expenses): Record each expense: date, plot code, category (seed and seedlings, labor, fertilizer, pesticides, irrigation, plowing and equipment, harvest and transport, other), amount and a note. The plot name fills in automatically. Room for 2,000 expenses.
  • "المبيعات" (Sales): Each sale with its date, plot code, quantity in kg, price per kg and buyer. Revenue is calculated as quantity x price, and the plot name fills in automatically. Room for 1,000 sales.
  • "الملخص" (Summary): Number of plots, total area, total expenses, revenue and net result, expenses on plots still growing, profit on plots that have had sales, a table of plots by status, and a table of expenses by category with each category's share of the total.

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

What makes it different

From the "القطع" (Plots) sheet you see which plot made you money and which lost it, and what a feddan and a kilo cost you. From the "الملخص" (Summary) you see where the season's expenses went across labor, fertilizer, irrigation and the rest, instead of adding them up from scraps of paper.

How to use it

  1. In the "القطع" (Plots) sheet, enter each plot's code, name, crop, area in feddans and planting date.
  2. In the "المصروفات" (Expenses) sheet, record every expense: date, plot code, category (labor, fertilizer, irrigation, harvest and transport, and so on) and amount.
  3. In the "المبيعات" (Sales) sheet, record every sale of the crop: date, plot code, quantity in kg, price per kg and the buyer's name.
  4. The "القطع" (Plots) sheet calculates each plot's total expenses, revenue, profit, cost per feddan, profit per feddan, cost per kg and status.
  5. Open the "الملخص" (Summary) sheet to see the totals, the plots by status and the split of expenses across categories.

Before you start:

  • Profit = sales revenue - all of the plot's expenses, and it appears once the first sale from the plot has been recorded. A plot that has expenses but no sales yet has the status "قيد الزراعة" (growing).
  • Plot status: "لم تبدأ" (not started) if no expense or sale is recorded, "قيد الزراعة" (growing) if there are expenses only, and "رابح" (profitable) or "خاسر" (loss-making) depending on how recorded sales compare with expenses.
  • Cost per feddan = plot expenses / area. Cost per kg = expenses / quantity sold. If you have sold only part of the crop, it will be higher than the true figure until you record the rest.
  • If you type a code in expenses or sales that is not in the "القطع" (Plots) sheet, the message "كود غير موجود" (code not found) appears.
  • The figures and prices in the example are made up to show the calculation and are not market prices. Clear them and enter your own.
  • The sheet has room for 200 plots, 2,000 expenses and 1,000 sales.

Excel file (.xlsx) · 135 KB · 6 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: crop season accounts (1/3)Cheat sheet: crop season accounts (2/3)Cheat sheet: crop season accounts (3/3)
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 sheetIn 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 · Ask for a demo

Frequently asked questions

How are cost per feddan and profit per feddan calculated?

Cost per feddan = the plot's total expenses / its area in feddans, and profit per feddan = the plot's profit / its area. Profit appears once the first sale from the plot has been recorded.

Why does a plot show "قيد الزراعة" (growing) with no profit?

Because it has expenses but no sales recorded yet. If you have sold only part of a plot's crop, the sheet compares the sales recorded so far with all of the expenses. It may show "خاسر" (loss-making) and the cost per kg will be higher than the true figure until you record the rest.

What happens if I type a plot code that does not exist?

"كود غير موجود" (code not found) appears in the expenses or sales row instead of the plot name. The entry is not counted against any plot in the "القطع" (Plots) sheet, although it is included in the totals of the "الملخص" (Summary).

Are the prices in the example market prices?

No. The names, quantities and prices in the example are made up to show how the calculation works. Clear them and enter your own figures.

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

More free templates for: Farming

More free templates

All templates · Free tools