Smallholder Farm Cashflow & Budget Planner (Excel) — 12-Month Budget, Cash Log, Monthly & Enterprise Reports in KES

Know exactly where your farm money goes, month by month. The Smallholder Farm Cashflow & Budget Planner is a ready-made Excel workbook for Kenyan mixed farms (dairy, poultry, vegetables, maize, goats and more). Plan your year, record what actually happens, and see which enterprise really makes you money.

What you get (one Excel file, works in Excel 2010+ and Google Sheets):

• Start Here – 5-step guide, colour legend (yellow = type here, grey = calculated).
• Settings – farm name, start month, opening cash, your minimum cash cushion, enterprise and category lists.
• Budget Plan – 12-month planned income and expenses (28 example lines with Kenyan seasonality), net cashflow, cumulative cash and an automatic WARNING for months when cash falls below your cushion.
• Cash Log – 400 rows to record every sale and expense with date, enterprise, category and running balance (drop-downs included).
• Monthly Summary – planned vs actual income, expenses and net for each month, variance and % of plan achieved.
• Enterprise Report – planned and actual margin for each enterprise so you know where to put your next shilling.
• Loan & Savings – simple loan/chama repayment table and a savings-goal calculator.

Why farmers like it: 1,100+ formulas already built and checked (zero errors), realistic example figures you simply overwrite, KES formatting, no macros, prints cleanly.

How it works: buy → download instantly → open in Excel → type your figures in the yellow cells. Reuse it every year.

All figures are editable typical values. This is a planning aid, not financial advice. For animal health, feeding or agronomy decisions consult your vet or local extension officer.

Made by Alphonce Kirui, a working dairy, silage and poultry farmer in Bomet, Kenya. Questions? WhatsApp 0728 801 352.