# Crop season expenses and revenue tracker (Excel)

> Plots, an expenses log by item (labor, fertilizer, irrigation, harvest) and a sales log, with each plot's profit, cost per feddan, cost per kg and status.

Source: https://softwiro.com/templates/crop-farm-expenses
Language: English
Softwiro, softwiro.com

---

Free Excel template

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.

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

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

| كود القطعة | اسم القطعة | المحصول | المساحة (فدان) | إجمالي المصروفات | الإيراد | الربح | تكلفة الفدان | الحالة |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| P01 | قطعة الجنوب | قمح | 5.0 | 68,500.00 | 106,500.00 | 38,000.00 | 13,700.00 | رابح |
| P02 | قطعة الترعة | ذرة | 3.0 | 30,500.00 | 37,200.00 | 6,700.00 | 10,166.67 | رابح |
| P03 | قطعة الشرق | طماطم | 2.0 | 45,000.00 | 68,500.00 | 23,500.00 | 22,500.00 | رابح |
| P04 | قطعة الغرب | بطاطس | 4.0 | 74,500.00 | 59,000.00 | -15,500.00 | 18,625.00 | خاسر |
| P05 | القطعة الصغيرة | بصل | 1.5 | 12,500.00 | 0.00 |  | 8,333.33 | قيد الزراعة |
| P06 | القطعة الجديدة | برسيم | 2.0 | 0.00 | 0.00 |  | 0.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.

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

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)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/en-1.jpg)[![Cheat sheet: crop season accounts (2/3)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/en-2.jpg)[![Cheat sheet: crop season accounts (3/3)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/crop-farm-expenses/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 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](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)
- Racing pigeon loft sheet
- Livestock and dairy farm sheet
- Complete farm management sheet in Excel: plots, workers, crops and sales
- Agricultural waste management sheet: rice straw, residues, compost and recycling
- Wedding and event budget planner (Excel)
- Car rental fleet tracker (Excel)
- Fleet fuel and maintenance tracker (Excel)
- Car showroom accounts sheet
- Freelancer projects, hours and invoices tracker
- Supplier purchase orders and payables tracker
- Charity donations and disbursements tracker
- Travel agency bookings tracker

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