Farm financial spreading, explained.

From a cash tax return to what the farm earned: farm spreading told simply

A farm package's trip from year-end to credit committee

1. The farmer sends the year-end packageHalvorsen Farms' 27 documents arrive October 6, after the CPA files the 2025 return on extension.
2. The loan officer checks it is completeReturns for three years, balance sheets at two dates, a grain count, invoices, the spouse's W-2, a family living worksheet.
3. An analyst spreads itEvery line keyed, cash converted to accrual, grain repriced, missing debts found, ratios and repayment capacity computed. This is where the 1.11x becomes 1.42x, and where the missing $372,000 note is found or missed.
4. The officer writes the credit memoCoverage, the trend, a price stress and the conditions to ask for.
5. Committee decides, and the spread comes back next fallMost farm lines renew every year, so the whole job repeats with next year's return.

Step 3 is the subject of this guide. The farm, people and figures in this example are fictional.

How a tax return can mislead, and three more spreading surprises

What Schedule F, accrual-adjusted and repayment capacity mean

Fourteen terms are defined in the one-page summary.

A tax return, two balance sheets and a grain count: what goes into a farm spread

In shortA farm spread combines three kinds of evidence: the tax return, which shows cash in and out; balance sheets at the start and end of the year, which show what changed; and supporting documents (counts, invoices, letters, leases, bank statements) that prove the balance sheet. Each answers some questions well and others badly, so the spread ties them to each other.

A commercial borrower usually sends an accountant's statement with an income statement and balance sheet that already agree with each other. Most farms do not. The Council's own implementation guide describes the usual starting point for a farm loan: "market-value balance sheets; most likely, not at the beginning/end of the tax reporting period, and a cash basis income statement prepared using information collected solely for tax reporting purposes."1 The lender has to make the pieces fit.

Why lenders ask for three years

Farm income swings with weather and prices, and a cash return can move income from one year into the next. Program rules reflect that: Farm Service Agency guaranteed loans over $125,000 need "Three years financial history" and verification of income and debts, and the lender must perform "at least the same level of evaluation and documentation" it uses for its own loans.6 Iowa State's guidance to farmers says the same thing in plainer words: calculate the measures "for several years to observe trends and to avoid making judgments based on an unusual year."7

Who sets the rules for a farm spread, and what changed between 2021 and 2026

In shortNo law says how to spread a farm. The Farm Financial Standards Council publishes voluntary definitions that lenders, universities and USDA use. Regulators require each lender's own policy to set its standards and examine it against them. FSA sets document rules for loans it guarantees. Five changes matter now: the Council's 2021 ratio revision, the 2025 tax law, new marketing loan rates, the 2026 model risk guidance and a small business data rule that left farm loans out.

The OCC's Comptroller's Handbook also has an Agricultural Lending booklet for national banks. In June 2026 the OCC replaced its general Loan Portfolio Management booklet with a new "Lending and Loan Portfolio Risk Management" booklet. This guide does not quote either booklet.

From 21 measures to 13 ratios: the Farm Financial Standards Council's 2021 revision

In shortFor years the Council recommended 21 criteria and measures in five groups. Its 2021 revision keeps 13 ratios, drops the dollar figures (they are numbers on the statements), adds a debt coverage ratio that counts all interest, and moves term debt coverage, equity-to-asset and debt-to-equity to an alternatives list. Many lenders still band term debt coverage in their policies, so most spreads show both.

The five groups have not changed, and USDA's Economic Research Service uses the Council's definitions for its own farm sector ratios.15 Liquidity asks whether the farm can meet obligations due within a year from cash and assets that will soon be cash. Solvency asks how much of the farm is financed by debt. Profitability asks what the farm earns on what it owns. Repayment capacity asks whether income covers principal and interest. Financial efficiency asks where each dollar of revenue goes.

The University of Minnesota's FINPACK team summarized the change when the Council approved it in 2021: "previously 21 recommended criteria and measures", now 13 ratios, with net farm income, EBITDA (earnings before interest, taxes, depreciation and amortization), capital debt repayment capacity and margin and replacement margin dropped from the list because they are statement figures. The new debt coverage ratio counts all interest because separating current and term interest "was difficult for many respondents".3 An accountants' conference session the next year put it the same way: the list "has been reduced from 21 to 13."4

The ratios a farm committee reads first

Halvorsen figures are the fictional example used throughout this guide; the $120,000 replacement allowance is the example lender's policy setting.

How to convert Schedule F to accrual-adjusted net farm income, line by line

In shortStart from Schedule F line 34, add gains from Form 4797, then add the increase in crop and livestock inventory, receivables and prepaid expenses, and subtract the increase in payables and accrued interest. Each change comes from the two balance sheets, so the conversion is only as good as they are. For Halvorsen Farms, six changes add $154,050 and turn $173,500 into $327,550.

The Council defines the accrual-adjusted income statement as cash figures adjusted by "the changes to accounts receivable, inventories, prepaid expenses, raised breeding livestock, accounts payable, accrued liabilities, deferred income taxes and other accrual amounts not otherwise recorded in the cash basis".1

Iowa State's worksheet does the same in ten lines: start with net farm profit on line 34, add ending current assets other than cash and subtract beginning ones, subtract the increase in accounts payable and taxes due, and replace tax depreciation with an estimate of economic depreciation.16 The sign of each change follows one rule: anything that grew on the asset side was earned and not yet sold; anything that grew on the liability side was spent and not yet paid.

Fictional example. The price sheet, counts and balances belong to the fictional lender and borrower; real market prices appear only where a source is cited.

How far apart cash and accrual income run

The difference has no fixed sign. A farm that sells two crops in one calendar year shows a cash income far above what it earned; a farm that stores its crop or prepays inputs shows less. That is why a lender that judges repayment on Schedule F alone will turn down some good farms and renew some weak ones.

Six traps in the conversion

The 2025 tax law makes the depreciation trap larger. For 2025, the IRS instructions restore the 100% special depreciation allowance for qualified property acquired after January 19, 2025, and set the section 179 limit at $2,500,000, phasing out above $4,000,000 of property placed in service.2 A farm that bought a combine in 2025 can deduct most of it at once, so Schedule F line 14 says little about the machinery's real wear.

Market value or cost? Why a farm balance sheet needs both columns, and the deferred tax behind them

In shortFarm balance sheets are usually at market value, which shows what the farm could sell for. The Council also asks for cost, which shows what the farm has earned and kept. The gap between them is mostly land that has risen in value, and selling it would trigger a tax the Council says should be shown as a deferred liability. Lenders read solvency at market and earned equity at cost.

The traditional farm balance sheet lists land, machinery and livestock at what they would fetch today. That is the right number for collateral, but it mixes two things: equity the family built by earning and saving, and equity that appeared because land prices rose. The Council recommends "both cost and fair market values" for capital assets, shown in two columns, in parentheses or in a supporting schedule.1 Iowa State adds that assets in the ratios should be at fair market value "minus any potential selling costs and income tax payments".7

Earned net worth: the check that catches what the statements miss

Net worth at cost should change by what the farm earned, less what the family withdrew, plus any capital contributed. When it does not, something is missing. The Council's implementation guide notes that the differences "often accumulate in the amount withdrawn for family living", because that figure is the one most often guessed.1

In the example, the corrected statements reconcile within $6,150 against a $10,000 tolerance the example lender set. A borrower who left a $372,000 combine note off the balance sheet would not reconcile: the machine shows up, the debt that bought it does not, and net worth jumps by money nobody earned.

Deferred taxes: the liability most farm balance sheets leave out

If the farm sold its land and machinery at the market values on the balance sheet, it would owe tax on the gain above its tax basis. The Council puts it plainly: "most farm businesses simply ignore that contingent liability, while including all the valuation equity, which misrepresents the equity position of the business", and its guidelines give a step-by-step procedure to calculate it.1

A worked illustration: land bought for $1,000,000 and now worth $3,000,000 carries a $2,000,000 gain; at an assumed combined tax rate of 20%, the deferred tax is $400,000, and market net worth should be $400,000 lower than the simple sum. The rate here is an assumption; use the borrower's own tax position.

Capital debt repayment capacity and term debt coverage, calculated for one Nebraska farm

In shortRepayment capacity starts from accrual net farm income, adds back depreciation (an expense that uses no cash) and interest on term debt (already counted in the loan payments it is measured against), adds off-farm income, and subtracts income taxes and family living. Divide by the year's scheduled term payments for term debt coverage. Each lender sets its own minimum in its credit policy (the example lender uses 1.25x); the Council does not set one.

Fictional example. The 1.25x minimum and the $72,000 family living floor are the example lender's policy.

Two things move the ratio the most. The accrual conversion adds income the cash return deferred. A missing liability removes payments from the denominator: the Halvorsens' $372,000 combine note costs $90,400 a year, and leaving it off would have shown 1.74x. A third, the price used for unsold grain, matters because the grain still has to be sold: each 10 cents a bushel on 168,000 bushels of corn moves income by $16,800.

A trend line matters as much as the year. The Federal Reserve's agricultural credit letter asks banks to review borrower cash flow and to run "a sensitivity analysis that determines a farm operation's ability to withstand risk and uncertainty".13 A price stress on the grain still in the bin is the simplest one.

Family living withdrawals and off-farm income: the household lines that decide coverage

In shortOn a family farm the household and the business share one wallet, so the spread subtracts what the family takes out to live and adds wages earned off the farm. Families often understate living costs. Many lenders set a floor by household size; Illinois farm records put average living costs near $100,000 a year in 2024.

The Council's 1991 report accepted family living withdrawals as a reasonable estimate of the value of unpaid operator labor and management, but notes that most farms "do not keep detailed records on family living expenditures", so the figure ranges from "an admittedly inaccurate, but somewhat informed, estimate to an outright guess".1 Its practical fix is two checking accounts, one for the farm and one for the household, with a regular transfer between them, so the year's living cost can be read from the transfers.1

Lenders handle the gap with a floor: if the stated figure is below a policy amount for the household's size, the spread uses the floor unless someone documents why the lower figure is right. In the example, the Halvorsens wrote $48,000; the lender's floor for a family of four is $72,000, and using the floor cuts capacity by $24,000. Off-farm income works the other way: a spouse's W-2 of $58,400 was missing from the borrower's worksheet and belongs in capacity, provided it is "dependable and likely to continue", in FSA's words for guaranteed loans.6

Benchmarking a farm spread against FINBIN, Illinois FBFM and Iowa farm records

In shortThree public sources let you compare a farm with its peers: FINBIN at the University of Minnesota, the Illinois Farm Business Farm Management Association through farmdoc daily, and the Iowa Farm Business Association through Iowa State's Ag Decision Maker. All publish 2025 results. Compare like with like: farm type, size, and an accrual basis.

Iowa State's guidance sets the scale. Cash grain farms "need to strive for a current ratio higher than 3.0, especially near the beginning of the year", and working capital at the start of the year is "typically equal to about 50–70% of the farm's annual gross revenue".7

Illinois reports that after three years of lower incomes, working cash on the average farm, most of them grain farms, "has decreased almost 40 percent from 2022".20 Set against those, the example farm's corrected current ratio of 1.16 and working capital of 8.6% of revenue are thin, which is why the example spread passes on coverage but flags liquidity.

The errors that tilt a farm spread, which way each pushes coverage, and the tie that catches it

In shortMost errors come from treating the tax return as income, trusting the borrower's balance sheet values, missing a liability, or guessing the household figures. Several make the farm look stronger, which is the expensive direction. Each one is caught by tying one document to another.

When the error is on purpose

The same gaps let fraud through. In October 2023 a Nebraska farmer was sentenced to three years in prison and ordered to pay about $5.1 million after his records "materially overstated his commodity inventory and materially understated and failed to report loans and accounts payable" to obtain about $11 million of loans; the bank lost $3.9 million.21 Overstated grain and missing debts are exactly what a count against a price sheet and a liability cross-check look for.

Farm debt, renewals and repayment problems in 2026: why each spread carries more weight

In shortFarm debt is forecast at a record $605 billion for 2026 while net farm income dips. Lenders report more renewals and extensions and more loans with repayment problems, concentrated in crop farms; cattle prices are at records. Bigger operating loans and thinner crop margins make the accuracy of each spread matter more.

Operating loans are getting larger. In the first quarter of 2026 the volume of non-real-estate farm loans rose nearly 50% from a year earlier, and the share of new operating loans above $500,000 reached a record, according to the Federal Reserve's national survey of terms of lending to farmers, as the Kansas City Fed reported.25

In the Kansas City Fed's own district survey for the second quarter, lenders reported "less than 10% of farm loan balances had major or severe repayment problems" and about 15% with minor ones, with cattle areas doing better and "crop farmers are very squeezed right now".26

In the same survey 27% of lenders reported more loan renewals and extensions than a year earlier and 3% fewer.24 Every renewal is a new spread. The Farm Credit System, the cooperative lending network for agriculture, held $456.9 billion of gross loans at March 31, 2026, up 6.1% in a year; its nonperforming assets were 1.09% of loans and other property owned at June 30, 2026, up from 1.02%, and its regulator lists "Continuing stress on cash grain sector" first among the risks it is monitoring.27,28

Which farm spreading steps software can take over, under SR 26-2, FCA and FSA expectations

In shortMost of a farm spread is reading documents and doing fixed arithmetic. The April 2026 model risk guidance excludes spreadsheet arithmetic and rule-based software from its definition of a model and leaves generative AI to each bank's own governance. The FCA points Farm Credit lenders to its exam manual and warns about bias. Prices, floors, bands and the decision to sign stay with the lender's people.

SR 26-2, issued April 17, 2026 by the Federal Reserve, OCC and FDIC, replaced SR 11-7. It defines a model as a quantitative method that applies statistical, economic or financial theories, and excludes "simple arithmetic calculations, such as those found within spreadsheets, as well as deterministic rule-based processes and software". Generative AI and AI systems that act on their own "are not within the scope of this guidance", which leaves their governance to "a banking organization's risk management and governance practices".11 The letter expects to be most relevant to organizations over $30 billion in assets.11

SR 26-2 does not reach Farm Credit System lenders; they answer to the FCA. The FCA's AI page sends examiners to section 31.1 of its exam manual for model risk and third-party risk, and adds: "Using AI does not absolve any institution from the responsibility of complying with legal requirements."14 For FSA guaranteed loans the lender keeps its own evaluation duty whatever tools it uses.6

Inside a farm lender's spreading desk today: five roles, the hand-offs and the hours

In shortAn ag loan officer gathers the package, an ag credit analyst spreads it, the officer writes the memo, a committee decides and loan review samples the files afterward. The hours go into keying returns and balance sheets and into the accrual and liability work. No public study measures the time; one estimate puts a full farm spread at about half a day.

Templates, farm analysis software or a central spreading team

Whatever the method, the fall renewal window concentrates the work: returns filed on extension in October arrive weeks before the year's last committees.

Halvorsen Farms on screen: from 27 documents to a spread signed at 1.42x

In shortThis is the example from the top of the page, inside the product. Six agents read the package the day it is complete, build a three-year spread with every cell linked to its page, and raise four exceptions. Jenna Kowalczyk, the ag credit analyst, opens the spread on the tax return, pins the six balance sheet changes into the accrual column, confirms the four exceptions and signs. The summary goes to the loan officer's credit memo for Thursday's committee.

1

The fall queue, ranked by committee date

Monday, October 12, Jenna's queue holds seven farm files and $18.14 million of requests. Two are waiting on documents with reminders sent: a dairy's 2025 CPA statements and a seed grower's W-2s. Halvorsen Farms is complete, 27 of 27 documents received Tuesday, October 6, committee Thursday, October 22, with two adjustments named on the row and two more behind them.

2

The package read, document by document

When the last document arrived, the tax return reader mapped 61 lines of the 2025 return and tied Schedule F to the 1040. The balance sheet reader tied December 31, 2024 to the 2025 opening line by line. The inventory and price checker read the pencil grain count, 168,000 bushels of corn and 24,300 of soybeans in eight bins, and flagged corn priced at $4.35 against a $3.95 price sheet.

Here the debt and liability finder is at work with Form 4562 open: a combine placed in service September 9, 2025, cost $465,000, bought from Tolverd Implement, with no matching note on the balance sheet. The whole run took 1 minute 11 seconds.

3

The spread opens on the tax return

Jenna opens the spread laid out like the lender's own form: Schedule F on a cash basis, the balance sheets at two dates, family living and repayment, and the corrected balance sheet. Every cell carries a pin to its source line; clicking net farm profit opens Schedule F line 34 beside the grid.

On the tax return alone, net farm income is $173,500 and term debt coverage 1.11x, below the 1.25x minimum. The six balance sheet changes wait in the accrual column, each with a Pin button.

4

Six pins, and coverage moves

She pins crop inventory first: $778,700 at the end of 2024 to $918,750 at the end of 2025, priced at the lender's sheet. The change of $140,050 alone takes coverage from 1.11x to 1.39x. Then market livestock, receivables, prepaid expenses, accounts payable and accrued interest, each tied to two dated pages.

All six add $154,050. Accrual-adjusted net farm income is $327,550 and coverage 1.42x. Working capital to gross revenue falls from 9.1% to 8.6%, because accrual revenue is larger.

5

Four adjustments confirmed, then the signature

Jenna confirms the four adjustments, each with its pages: corn repriced to the bid (−$67,200 of inventory), the $88,000 CCC loan added as a current liability with its 40,000 bushels taken out of the lender's collateral, the $372,000 combine note added, and family living raised from the stated $48,000 to the $72,000 floor.

She signs with the meaning "Spread reviewed — figures and adjustments confirmed". The summary goes to Travis Lindgren's credit memo with a note: liquidity is thin; consider a marketing plan for the unpledged corn before March 1, 2027.

The solution's design target is about 15 minutes of analyst time from a complete package to a signed farm spread, against an estimated half a day by hand. It is a target, to be measured on your own files.

The cash-to-accrual bridge, the corrected balance sheet, the ratios and the price sheet, screen by screen

In shortOne renewal is the story. These screens show the rest: the single crop inventory pin, the repayment rows of the grid, the four exceptions with their evidence, the bridge from Schedule F, the corrected balance sheet and earned net worth, the ratios, the price stress, the signature, the borrower book and the policy settings.

Select any screen to open it larger. The lender, farms, people, prices and figures are fictional.

What each of the six agents does with a farm package, and which person answers for each figure

In shortEach agent has one job and limits it does not cross. None of them changes a figure the borrower reported, invents a price, removes a liability, rates the credit or decides the loan. The ag credit analyst confirms every adjustment and signs; loan review sees every override; the ag lending manager owns the settings.

Readers, an accrual adjuster and a debt finder

The ag credit analyst signs; loan review sees every override

Signatures record the name, the meaning and the time. Agent steps and human decisions are kept apart on the audit trail, every spread version is kept, and nothing goes to a borrower until a person sends it.

Analyst Jenna Kowalczyk and the rest of the Halvorsen file's cast

What a farm borrower sends, what the lender sets, and the signed accrual spread that comes back

In shortIt reads the documents farm borrowers already send, writes into the lender's own spread form, and leaves behind a three-year accrual spread with every figure linked to its page, the corrected balance sheet, the ratios, repayment capacity and stress, the exceptions with their evidence, and a signed summary for the credit memo. The lender's systems of record stay where they are.

Origination, portal, document and core systems a spread draws on

For each, check whether it has an API, a file feed, or only screens, and who owns it.

Your spread form, price sheet and floors carry over

Page-cited figures, two-balance-sheet accrual, a person's signature

Analyst hours, the October queue and a missed combine note: the price of hand-keyed farm spreads

In shortStart from your own numbers. Nobody publishes the hours a farm spread takes or how often spreads miss a debt, so the case rests on what you measure. Published figures frame it: what an analyst hour costs, how many renewals are coming, and what one overstated balance sheet cost one bank.

Where hand-keyed farm spreads hide their cost

The restructuring missed and the good farm turned down

Putting a dollar figure on faster, accrual-based farm spreads

In shortPut in your own numbers. The calculator starts from a published analyst wage and asks for the rest: how many farm spreads you do, the hours they take now and after, and what the tool and your testing cost a year. Time saved is the part you can count; catching a missing debt or a cash-basis misreading may be worth more, and is harder to put a number on.

Analyst hours freed in the fall renewal window

Spreads a year, hours saved and the analyst wage

Try three cases. At 300 spreads, 4 hours today and the 15-minute target, the time released is worth $64,125 against $40,000. At 120 spreads it is $25,650, below the cost, and the case rests on accuracy. At 600 spreads and 6 hours today it is $196,650.

Score your ag desk's readiness for automated farm spreads: eight questions and one to think about

In shortPick the answer closest to your team today. Eight questions score 0 to 2; the last is for reflection. The meter adds up your score as you go, and each question says why it matters and what a strong answer sounds like.

Five timed spreads, planted errors, or the whole ag desk

What to ask a farm spreading software vendor about Schedule F, accrual, missing debts and proof

In shortAsk every vendor the same questions, us included. The answers show what the tool reads, how it converts cash to accrual, how it finds what the borrower left off, whose prices and floors it uses, and how you would measure it on your own files.

We found no published independent test of any farm spreading tool's accuracy, as of October 2026. A planted-error test on your own files is the fairest comparison, and the same test measures your current process.

Testing farm spreading software on last fall's files, with planted errors, before the next renewal season

In shortMeasure first, test on your own past files with planted errors, then run alongside your analysts and decide on three numbers. Finish before September so the decision is made before the next renewal season.

1. Time five spreads by step: keying, accrual, balance sheet, ratios, summary. That is your baseline.
2. Write down your settings: price sheet, family living floor, coverage minimum, ratio bands, replacement allowance.
3. Gather 40 of last fall's renewal files with their signed spreads. Copy ten and plant known errors: a missing note, a CCC loan, grain at the wrong price, a doubled insurance payment.
4. Run in parallel on live files for six weeks, with your analysts signing every spread.
5. Decide with three numbers: catch rate by error type, false alarms on clean files, and analyst minutes to a signed spread.

Planted-error catch rate and accrual income agreement

Farm financial spreading questions ag lenders search, answered

In shortThe questions ag lenders and farm accountants search for most, each answered on its own.