Skip to content

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

← TemplatesFarm & agriculture

Free Farm Record Book (Excel, KES) — daily income, expenses and profit

A farm that keeps no records is guessing, and guessing is expensive. This free record book gives you one honest cash book: every shilling in and every shilling out, with a category, so at the end of the month you can see what you actually earned. The balance and the monthly profit fill themselves in.

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

  • One cash book for all farm income and expenses, in KES
  • Category dropdowns so every entry is tagged the same way
  • A running balance that is always current
  • Monthly profit and loss, worked out for you
  • Formulas locked; only the yellow cells accept typing
  • Works in Excel or Google Sheets, on a phone

The tabs

  • Start Here (guide)
  • Cash Book
  • Monthly Summary

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 dashboard with monthly income, expenses and profit, drawn as in-cell bars
  • A printable monthly report (A4) you can file or take to a lender
  • A deeper category breakdown, so you see where the money really goes
  • Swahili labels alongside English (Mapato, Matumizi, Faida, Jumla)
Get Premium — KES 500 · Excel (.xlsx) ↓Pay once via M-Pesa (Kenya) · yours to keep · opens in Excel or Google Sheets

On the Cash Book tab, add one row per transaction: the date, whether it is income or an expense, a category from the dropdown (crop sales, milk, livestock, seed, fertiliser, labour, transport, feed, vet and more), a short note and the amount. The running balance updates on its own, so you always know where you stand.

The Monthly Summary totals your income, your expenses and your profit for each month, so a season stops being a blur and becomes a set of numbers you can act on. Yellow cells are the only ones you type in; everything else is a locked formula. It opens in Excel or in Google Sheets on your phone. When keeping it by hand gets tiring, Biashara Yangu can keep the books for you automatically.

Do it online instead

Keep the farm's books automatically 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 really free?

Yes. Download the basic Farm Record Book, keep it, and use it season after season at no cost. The premium upgrade, with a dashboard and printable reports, is an optional KES 500.

Is it in KES?

Yes, every amount is formatted in Kenyan Shillings. Type plain numbers into the yellow cells and the totals and balance format themselves.

How is the monthly profit worked out?

The Monthly Summary adds up all your income and all your expenses for each month and subtracts one from the other. Because every entry carries a date, the split by month is automatic.