Skip to content

We've built 200+ tools — open your toolbox, there's something in here you probably need.

← TemplatesFarm & agriculture

Free Crop Sales & Market Price Tracker (Excel, KES) — Kenya

Selling produce on trust is normal, and forgetting who owes you is how the money disappears. This free tracker keeps it: log each sale against a customer, record the price you got, and it shows what each buyer has paid and the balance they still owe. A market-price log helps you sell where it pays best.

Download — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up
Prefer Google Sheets? You don't need Microsoft Excel →
  1. Download the file above.
  2. Open Google Drive, then New → File upload and choose the file.
  3. Right-click it in Drive → Open with → Google Sheets. It becomes a fully editable Google Sheet — every formula and tab intact — and works on your phone too.

The .xlsx format opens free in Google Sheets, LibreOffice, or Excel for the web — no paid software required.

What's inside

  • Customer records with phone and location
  • Sales logged by crop, quantity and price, in KES
  • Amount paid and balance owed, worked out per sale
  • A market-price log to compare where to sell
  • Outstanding balances by customer at a glance
  • Works in Excel or Google Sheets

The tabs

  • Start Here (guide)
  • Customers
  • Sales
  • Market Prices
  • Balances

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

Basic vs Premium

The free version does the job. The premium does more of it.

The free basic workbook above is a complete, formula-driven template you can use forever. The premium upgrade adds the extras that turn record-keeping into a management tool.

Basic — Free

  • The core sheets and formulas, in KES
  • Works in Excel or Google Sheets, on your phone
  • Yours to keep, no sign-up

Premium — KES 500

  • A printable customer invoice and statement (A4)
  • A dashboard of sales by crop and balances owed, drawn as bars
  • A market-price comparison so you sell where it pays best
  • Swahili labels alongside English (Mauzo, Salio, Wateja)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On Customers, keep each buyer once with a phone number and location. On Sales, log the date, the customer, the crop, the quantity and the price, and enter what they have paid; the balance owed works itself out. On Market Prices, jot the prices you see at different markets so you can compare before you sell.

An outstanding-balances view shows exactly who owes what, so a follow-up is a glance, not a guess. Yellow cells are your only inputs. The premium version prints a proper invoice and statement, and puts sales by crop and balances owed on a dashboard. Opens in Excel or Google Sheets.

Do it online instead

Track sales and balances with Biashara Yangu

Open the free tool →

Custom work

Need a template made just for you?

Can't find the exact workbook, or want one branded and built around how your business actually runs? We build custom Excel & Google Sheets — bespoke financial models, dashboards, sector trackers, data clean-up and automation. Need it in English or Kiswahili, or another language? Just ask. Tell us what you need and we'll quote.

Frequently asked questions

Is the basic version free?

Yes. The basic sales and market-price tracker is free to download and keep. The premium upgrade, with printable invoices and a sales dashboard, is an optional KES 500.

How does it track who owes me?

Each sale records the amount and what has been paid; the balance is the difference. The Balances view sums each customer's unpaid amounts, so you can see and chase what is outstanding.

What is the market-price log for?

It is a simple record of the prices you see at different markets over time, so before you sell you can compare and take your produce where it pays best.