MARGINCANVAS
HomeTools → Farm Cash Flow Forecaster
Farm Cash Flow Forecaster

Harvest money arrives twice a year. The bills arrive every month.

Twelve months of farm cash with income concentrated at harvest, so the gap before it is a number rather than an overdraft notice.

$39 USD · one-time
Buy on Etsy · $39Gumroad coming soon
Instant download · Excel & Google Sheets · works on Mac and Windows · on Etsy today, Gumroad soon
Farm Cash Flow Forecaster dashboard
Who it's for

Made for the way you actually work.

  • Family farms fronting a season of inputs before any income
  • Livestock operations with staggered sales through the year
  • Market gardeners stretching spring cash to first harvest
  • Farm managers making the case at the bank
What's included

Everything in one file.

  • Dashboard: Lowest balance, runway and the cash curve. Read-only.
  • Start Here: Five steps from opening the file to a real number on screen.
  • Cash Flow: Where the forecast is built. The main working sheet.
  • Settings: Forecast horizon and display.
  • Instructions: What each sheet does, and what to do if a number looks off.
  • About: Version, license and support.
  • PDF Quick-Start Guide: two pages, first result in five minutes
How it works

Three steps to a number you trust.

  1. Open Cash Flow. Enter the cash you can actually draw on today, not invoiced, not committed, available.
  2. Set your alert threshold: the balance below which you cannot operate.
  3. Under Money in, enter each source with the amount and the months it runs for. A one-off uses the same number twice.
A look inside

The screens you'll be working in.

List of the seven sheets in the farm cash flow forecasterCash Flow sheet with money in, money out and the balance by monthStart Here sheet with five steps to a readable forecastSettings sheet covering twelve months of one farmThree steps: money in, money out, read the low pointCompatibility: works in Google Sheets and Microsoft Excel 365
Questions

Good to know.

Can I model more than one enterprise?
Yes. Enter each as its own income row with its own months, and the costs likewise. The forecast sums whatever is active.
How do I handle stored crop sold across several months?
One row per sale month. Splitting it that way is the point, it shows the cash effect of holding stock.
Does this work in Excel and Google Sheets?
Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
How do I enter something that happens once?
Put the same month number in the From and To columns.
I'm not confident with spreadsheets. Will I manage?
Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$39 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $39Gumroad coming soon
Related tools

Owners like you also use.