List every payment and receipt of the crop year in the month the money will move, then add them month by month. The amount to have ready in credit or savings is the lowest balance of the year (the low point), not the year’s result. On the example farm below, the low point comes at the end of month 6, at minus $270,000.
The example is a grain farm with illustrative numbers. It opens the year with $100,000 in the account and closes it with $150,000, which is $50,000 more than it started with. Yet the balance is below zero at the end of six months in a row. A farmer who looks only at the year’s result sees the $50,000. A farmer who writes a cash budget, a sheet of the cash going in and out of the farm month by month, sees the six months. The account is lowest at the end of month 6, the last month before any sale is paid, and not in month 3, the month of the biggest payment.
Why can a year that ends ahead leave the account below zero for six months?
In the example the biggest payment is $120,000, in month 3. The balance keeps falling after it, because nothing is received until month 7. The farm opened with $100,000 and pays $370,000 in months 1 to 6, so the balance at the end of month 6 is minus $270,000. In month 7 the farm receives $300,000 from a sale and pays $40,000, so the balance rises from minus $270,000 to minus $10,000 (-$270,000 + $300,000 - $40,000).
| Month | Money in | Money out | Net | Balance at month end |
|---|---|---|---|---|
| Start | 100 | |||
| 1 | 0 | 60 | -60 | 40 |
| 2 | 0 | 90 | -90 | -50 |
| 3 | 0 | 120 | -120 | -170 |
| 4 | 0 | 35 | -35 | -205 |
| 5 | 0 | 35 | -35 | -240 |
| 6 | 0 | 30 | -30 | -270 |
| 7 | 300 | 40 | 260 | -10 |
| 8 | 260 | 50 | 210 | 200 |
| 9 | 100 | 50 | 50 | 250 |
| 10 | 30 | 50 | -20 | 230 |
| 11 | 0 | 40 | -40 | 190 |
| 12 | 0 | 40 | -40 | 150 |
| Year | 690 | 640 | 50 | 150 |
Net is negative through month 6, so the balance falls every month until then. From month 7 to month 9 Net is positive and the balance rises. In months 10 to 12 it falls again, from 250 to 150, yet stays far above the month 6 level. A farm with income in several months can dip more than once, and the deepest dip is the one that counts.
A crop budget gives the margin of the cycle, what the crop should leave after its costs. It adds the year’s receipts and costs into one figure, so the low point is not in it. The article on writing the margin before planting is the guide to that budget. The cash budget takes the same quantities and writes a date on each.
Four U.S. university extension services (Kansas State, Colorado State, Mississippi State and Wisconsin-Madison), the farm-advice arms of public universities, publish the guides this article draws on. Colorado State warns that a cash flow analysis cannot show how profitable the business is or how much it is worth. Read it, then, beside the income statement (the year’s receipts minus its costs) and the balance sheet (what the farm owns and owes). Wisconsin-Madison points out that “cash flow statement” names two sheets: a report of cash that already moved and a plan for the cash of the months ahead. This article calls the plan a cash budget, and it is the second sheet.
Which payments and receipts go on the sheet, and on which date?
Each line goes in the month the money leaves or arrives, not the month of the invoice, the delivery or the work. Kansas State counts a capital purchase (a machine or other large asset) in the period it is actually paid, together with loan principal and interest and the ordinary bills. The household goes on the sheet too. Colorado State and Wisconsin-Madison include the family’s living expenses, Mississippi State the owner’s withdrawals, and off-farm income used for farm costs comes in as a receipt.
Two dates are easy to get wrong. The first is the sale: a sale is not a receipt until the buyer pays. Ballaminut and colleagues built cash flows for typical cotton and soybean farms in three regions of Goiás, Brazil, for the 2006/07 crop year, from meetings with farmers and farm technicians. In the regions it describes, the advance sales (sales contracted before the harvest) were paid only when the harvest began, so they did not help the cash of the months before it. Pesticide contracts fell due in March and April and fertilizer in September, the months of the largest deficits. The study is in Portuguese and describes typical farms, not audited accounts.
So write a sale in the month the contract sets for the money to arrive. For a buyer who has not paid, ask for the date in writing; the article on who still owes you and since when is about keeping the list of what buyers still owe. The dates of taxes, insurance and fees come from the farm’s calendar of what comes due, a dated list of the farm’s obligations.
The second is the order of dates inside one month. Take a payment and a receipt of the same size, one on the 2nd and the other on the 30th. Summed as one month, they cancel and the month looks balanced, yet the account is below zero for 28 days, from the 2nd to the 30th. Carlos Omar Sánchez, who writes on financial planning of farm businesses in Argentina, points out this problem. He says to fix it by writing the payment in the month before or the receipt in the month after. The rule for this sheet is Rurivia’s, not his, and is narrower. Each line stays on its real date, except in a month that closes at zero or above despite the stretch below zero in the middle. There, move the line and mark it as moved, so the stretch below zero shows on the sheet.
He also gives two margins, and they are different things. One is for the order: aim for each receipt to come about five days before the payment it covers, so a payment due on the 10th is covered by money that arrives around the 5th. The other is for the date. Assume a receipt arrives five to seven days after its due date, so a receipt due on the 30th is counted in the next month, around the 5th to the 7th.
Where do the figures for twelve months come from before the year starts?
Colorado State describes two ways to fill in the twelve months. The quick one starts from last year’s cash by month and adjusts it for the price changes expected, which Colorado State warns may be too imprecise when prices, costs and output vary a lot. The detailed one budgets each activity from acres, expected yield, inputs and prices. Either way, each cost goes in the month it is paid.
The quick way is enough for a farm with one or two activities, such as dryland wheat and sorghum, and the detailed way fits a farm with several. Colorado State advises a farmer who has never made a cash budget to start from past bank statements, both the farm’s and the household’s.
The lines that repeat come from the statements: rent, insurance, installments, the household’s monthly draw. These are the same twelve closed months of statements used to count the months of reserve (how many months of the farm’s expenses its own cash covers). One afternoon of work serves both the cash budget and the reserve count.
The lines that depend on this crop come from the plan, not from habit. The quantity comes from the crop budget (if you have none yet, from the supplier’s quote and your expected yield), and the date from the supplier’s terms and the buyer’s contract. Last year’s date is only a guess until a contract or notice carries the same date. Write beside every sale the price it assumes, because the sale line is the one that moves most.
How much credit does the farm need in the lowest month, and what moves it?
The credit the farm needs is the size of the low point, the amount its own cash does not cover. On the example farm, after spending its $100,000, it needs $270,000 of credit or other money ready by the end of month 6. Kansas State’s form shows the credit in two rows, the cash balance and the operating loan balance (the loan that pays the season’s costs), month by month. This way the need to borrow is visible before any loan is taken. Kansas State also notes that some cash must stay in the checking account and cannot be spent. That makes the loan you read off the form smaller than the loan the farm needs, by the cash held back.
A late receipt moves the low point, and so does a payment larger than planned (the next section shows that case).
Start with the late receipt. Suppose the buyer pays the $300,000 in month 8 instead of month 7. Nothing else changes: the farm still pays $40,000 in month 7 with no money coming in, so month 7 ends at minus $310,000 (-$270,000 - $40,000). A credit line of $300,000 (the limit the bank lets the farm use) covers the base sheet, the one in the table above, with every receipt on time. It falls $10,000 short in month 7 of the late-receipt sheet. A payment nobody scheduled, such as a loss the insurance leaves out, weighs on cash the same way, so what is insured and what was left out tells you how large a margin to keep.
For the income statement, Colorado State finds it useful to write three sets of assumptions, optimistic, unchanged and pessimistic, since prices, yields and costs are uncertain. Applying that idea to cash is this article’s reading, not Colorado State’s: the late-receipt sheet is the pessimistic case for a cash question. Work out the credit from it, not from the base sheet.
How do you keep the sheet true once the year has started?
Write the actual receipts and payments beside the projected ones at the end of each month. Kansas State recommends comparing projected with actual cash item by item, so the difference on each item is known, and watching for receipts that fall short or payments that run over. Colorado State’s example is a rancher whose veterinary bills run above the plan and who adjusts other payments to stay inside it.
Then redo the months ahead from the new balance, because a difference carries forward. If the farm pays $135,000 in month 3 instead of $120,000, month 3 ends $15,000 lower, and the low point moves from minus $270,000 to minus $285,000. Sánchez’s model for Argentine farms is updated at least every quarter. Monthly is better while the balance is below zero, since a difference in any month before the low point carries into it.
Does keeping a cash budget make a farm earn more?
The guides and studies behind this article do not test whether a cash budget makes a farm earn more. The method comes from the extension guides (Kansas State, Colorado State, Mississippi State, Wisconsin-Madison), which describe how to build and use the sheet and do not test it. It also comes from a descriptive study of typical farms in Goiás and from Sánchez’s practical model for Argentina, built from interviews and his own experience. None compares farms with and without a cash budget. Having no test is not evidence that the sheet fails.
The nearest evidence is Gloy, Hyde and LaDue (2002), on 107 dairy farms in a voluntary New York program, not grain farms. Those with a hand ledger or computer records did not earn a significantly higher return on assets (the income earned on what the farm owns) than those with no formal records. It measures who keeps accounts, not who projects cash, so it does not support the idea that a cash budget raises income.
The case for the sheet rests on something the year’s result does not contain, the lowest month and its size, and on the extension guidance for farmers and lenders. That is a reason to make one, and not a promise of what it will bring.
Where to start
One afternoon with the contracts, the notices and the last twelve months of bank statements produces a twelve-month sheet and one number: the lowest balance and its month.
With the sheet done before the first input bill falls due, you take to the lender or the supplier the lowest month and its size, not the year’s result. Working out when the money moves is part of managing the farm as a business; other articles on farm money are in the finance section of the library.
Related: Income statement by crop: three results, not one, for the profit of each crop, which this sheet does not measure. Related: Inputs paid in grain: work out the rate hidden in bushels, for the farm that pays inputs in grain and wants the interest rate hidden in that deal. Related: One-page farm dashboard: seven numbers, each dated, for the seven dated numbers a farm can keep on one page.