You farm several plots. Each season you spend on labour, fertiliser, irrigation and harvest, then sell the crop in lots, and you want to know: did each plot make or lose money, what did a feddan cost, and which item took the biggest share? The free crop farm expenses sheet answers these from two logs you fill in: expenses and sales. The template and its page are in Arabic.
The problem it solves
Farm costs are spread across many months and several plots, and sales arrive in several lots at different prices. On paper or in memory it is hard to compare plots or know the cost per feddan or per kilo. The sheet groups everything by plot code, so each plot gets its own full picture.
How it works, step by step
- In Plots, write each plot's code, name, crop, area in feddans and planting date.
- In Expenses, record every expense: date, plot code, item and amount. The item comes from a ready list.
- In Sales, record every sale: date, plot code, kilos, price per kilo and buyer.
- Plots works out each plot's expenses, revenue, profit, per-feddan figures, cost per kilo and status.
- Read the Summary for the season total and expenses by item.
What each sheet does
- Plots: the main table: expenses (total and for labour, fertiliser, irrigation, harvest and transport), kilos sold, revenue, profit, cost and profit per feddan, cost per kilo, and a status.
- Expenses: one row per expense, from a list of eight items such as labour, fertiliser, irrigation and harvest and transport.
- Sales: one row per sale; revenue is kilos times price per kilo.
- Summary: area, expenses, revenue and net; plots by status; expenses by item with each share.
A walkthrough with the sample data
These figures come from the sample sheet. They are invented to show the arithmetic: they are not market prices and not a real farm. The example has six plots covering 17.5 feddans.
- South plot (wheat, 5 feddans): expenses 68,500, revenue 106,500 from 13,000 kg, profit 38,000. Cost per feddan 13,700, profit per feddan 7,600, cost per kilo 5.27.
- Canal plot (maize, 3 feddans): expenses 30,500, revenue 37,200, profit 6,700.
- East plot (tomatoes, 2 feddans): expenses 45,000, revenue 68,500, profit 23,500.
- West plot (potatoes, 4 feddans): expenses 74,500, revenue 59,000, a loss of 15,500, shown in red.
- Small plot (onions, 1.5 feddans): 12,500 spent, nothing sold, so "growing" with no profit shown.
- New plot (clover, 2 feddans): nothing recorded, so "not started".
On the Summary, expenses are 231,000 and revenue 271,200, so the net is 40,200, after the 12,500 spent on the unharvested plot. Profit on plots with sales is 52,700. By item: labour 38,000 (16.5%), fertiliser 53,000 (22.9%), irrigation 27,200.
What you get
- Each plot on its own, so you see which crop earned most and which lost money.
- Comparison per feddan and per kilo, since areas differ between plots.
- A clear view of where the money goes, instead of guessing.
- Works in Excel 2016+, Google Sheets and LibreOffice; free. It holds 200 plots, 2,000 expenses and 1,000 sales.
Using the online version
The template page opens on this worked example. Type in the white cells and the grey ones update at once; add expenses and sales through an entry form. Import your own .xlsx made from this template, export to .xlsx, or download the original. Your data stays in your browser. Open the template page or the template list.
Who it suits, and when it stops being enough
It suits a farmer who wants to work out the season personally. Profit depends on the sales you have recorded: if you have sold only part of the crop, cost per kilo will look higher than it really is and the plot may show as loss-making until you record the rest. The sheet does not value the land or count its rent unless you record it as an expense under "other". If several people need to record at once, or you want screens built around your farm, Softwiro can build you a custom program with a login per user and permissions. For daily spending see the cash sheet, and for broiler cycles the poultry farm tracker.
FAQ
How is cost per feddan calculated? A plot's total expenses divided by its area in feddans.
Why does my plot show no profit? Profit appears once the first sale from the plot is recorded. Before that its status is "growing".
What if I rename a plot? Change it in Plots only; the name in Expenses and Sales follows automatically because it comes from the code.