AIStatements

Farm Profit and Loss Statement and Balance Sheet for Your Ag Lender

AIStatements turns a farm's year-end trial balance into a profit and loss statement, balance sheet and cash flow statement in about 60 seconds. Grain and livestock inventory, prepaid inputs, operating lines and term debt land on the balance sheet where a Farm Credit or bank loan officer looks for them, and the income statement shows net farm income on the same accrual basis as your books, ready for the annual loan renewal.

Upload the year-end trial balance from QuickBooks, Xero or any ledger as a CSV or Excel file and get a farm income statement, a classified balance sheet and a cash flow that tie to each other, from $24 a month billed yearly.

From $24/mo · cancel anytime
Sample company

Generate statements from your own books · sample CSV

Software, not advice · Files parse in your browser, nothing is uploaded

Why the Schedule F is not the farm income statement your lender wants

Most farms keep their books for the tax return. Grain is sold in January when that suits the tax year, seed and fertilizer for next season are paid in December, and Schedule F reports the cash that moved. That is legal and sensible tax planning, and it produces a profit figure that swings by hundreds of thousands of dollars from one year to the next for reasons that have nothing to do with how well the farm ran. Ag lenders know this. Farm Credit associations, commercial ag banks and the Farm Service Agency all ask for a balance sheet and an income statement that account for what was produced and owed, not only what was deposited.

The Farm Financial Standards Council calls the corrected figure accrual-adjusted net farm income: cash income, plus the change in crop and livestock inventory, receivables and prepaid expenses, minus the change in payables and accrued interest. The FSA uses the same building blocks on its own farm loan program forms. The point is simple. A year in which you stored $185,000 more grain than you started with was a better year than the cash says, and a lender reading only the Schedule F will price the loan as if it were not.

A worked year for a grain and cattle farm

Here is one year for a family operation running corn, soybeans and a backgrounding cattle enterprise. Cash receipts were $1,438,000: crop sales $1,140,000, cattle sales $260,000 and government program payments $38,000. Cash operating expenses were $1,082,000, interest paid $64,000 ($52,000 on term debt, $12,000 on the operating line) and book depreciation on machinery and buildings $118,000. On a cash basis, net farm income is $174,000.

Now the year-end entries. Prices were weak at harvest, so the farm stored more grain: inventory went from $410,000 to $595,000, an increase of $185,000. Market cattle on hand fell by $22,000. Receivables for grain delivered on contract but not yet paid rose $12,000. Seed and fertilizer prepaid for next season rose from $95,000 to $160,000, so $65,000 of December spending belongs to next year. Against that, accounts payable to the co-op rose $18,000 and accrued interest $6,000. The adjustments add up to $216,000, and accrual-adjusted net farm income is $390,000, more than twice the cash figure.

The balance sheet at year end shows current assets of $1,027,000 (cash $84,000, grain $595,000, market livestock $148,000, prepaid inputs $160,000, receivables $40,000) against current liabilities of $641,000 (operating line $420,000, payables $58,000, accrued interest $21,000 and $142,000 of term debt due within twelve months). Working capital is $386,000 and the current ratio 1.60. Machinery at $1,240,000 net and land at a cost of $2,600,000 bring total assets to $4,867,000; with $1,480,000 of long-term debt, total liabilities are $2,121,000, a debt to asset ratio of 43.6 percent.

Those are the inputs a loan officer works through on the renewal. Value of farm production on the accrual basis is $1,613,000, so working capital is 23.9 percent of gross revenue. Term debt coverage, using accrual income plus depreciation and term interest less $95,000 of family living and income taxes, is $465,000 against $194,000 of scheduled principal and interest, or 2.40 times. On the cash figures alone the same farm would look barely able to cover its payments. The ratios here are worked from the statements by hand; the generator gives you statements that tie, which is what every one of those ratios depends on.

What goes in, and what comes out

The input is the year-end trial balance from the farm's ledger: QuickBooks Desktop or Online, Xero, or whatever your accountant uses, exported as CSV or Excel. If the books are kept on a cash basis through the year, book the year-end inventory count, prepaid inputs, receivables and accrued interest first (most farm accountants already do this for the lender package), then export. Upload last year's trial balance for the same company first, and the balance sheet shows both year ends side by side with the cash flow built from the change between them, which is how the lender compares them. If you are working from a raw account list rather than a finished trial balance, trial balance to financial statements explains what the file needs.

The output is a pack: income statement with revenue and expense groups, a classified balance sheet with current and noncurrent assets and liabilities, a statement of cash flows that reconciles to the change in cash, and a written read of the year built from the figures. It exports to PDF for the loan file and to Excel for the accountant. Lenders who use the three-tier farm format (current, intermediate, long-term) will move machinery and breeding livestock into the intermediate column themselves; the pack keeps the GAAP current and noncurrent split and the accounts are listed underneath so that step takes minutes. For the balance side alone, the balance sheet generator page shows the layout.

Who uses it on a farm

Owners renewing an operating line every winter, families applying for a land or equipment loan, farms bringing in the next generation and needing a clean starting balance sheet, and farm bookkeepers who prepare the same lender package for several clients each spring. A bookkeeper with up to five farm clients covers them on the Growth plan; larger rosters use Firm. The financial statements for a business loan page covers what a lender checks in any industry, and GAAP versus cash basis accounting walks through why the two profit figures differ with another worked example.

Fuel and chemical shrink is one of the gaps that shows up when the year-end count is booked: the ledger says one quantity, the tank or the shed says another. Operations that already have cameras on the shop, fuel tanks and chemical storage sometimes add video analytics for cameras they already own to catch after-hours movement, and the reconciliation gets easier when the count and the footage agree.

What it does not do

AIStatements builds historical statements from your ledger. It does not do crop accounting by field, enterprise budgets per acre, marketing plans or grain contract tracking, and it does not prepare Schedule F or replace your CPA. It does not value land or machinery at market; statements show the cost basis from your books, and a lender who wants a market value column adds it from an appraisal. It does not count your grain bins either, so the inventory figure is whatever your year-end entry says. For accrual adjustments the farm has to book them, or the accountant does; the pack then reflects them correctly on every statement.

The same farm year, cash basis against accrual-adjusted
Line Cash basis (Schedule F style) Accrual-adjusted Why it moved
Gross farm revenue $1,438,000 $1,613,000 grain inventory +$185,000, cattle -$22,000, receivables +$12,000
Operating expenses $1,082,000 $1,035,000 prepaid inputs +$65,000, payables +$18,000
Interest $64,000 $70,000 accrued interest +$6,000
Depreciation $118,000 $118,000 no change
Net farm income $174,000 $390,000 adjustments total $216,000
Term debt coverage about 1.28 times 2.40 times same payments, different income

Common questions

What is included in a farm profit and loss statement?

Crop, livestock and government program revenue, then operating expenses such as seed, fertilizer, chemicals, feed, fuel, repairs, labor, rent and insurance, followed by interest and depreciation, ending in net farm income. Lenders want it accrual-adjusted, meaning changes in inventory, receivables, prepaid expenses, payables and accrued interest are included, not only cash in and out.

What financial statements does a farm lender require?

Usually a current balance sheet, an income statement for the last year or three, and a projected cash flow for the coming year, plus tax returns. Farm Credit associations and banks compare the balance sheet and income statement to compute working capital, debt to asset and term debt coverage. FSA asks for the same through its own forms.

Can I make farm financial statements from QuickBooks?

Yes. Export the year-end trial balance from QuickBooks as CSV or Excel, after booking inventory, prepaid inputs and accrued interest, and upload it. AIStatements returns the income statement, balance sheet and cash flow with a written read of the year in about a minute, ready as PDF or Excel. Plans start at $24 a month billed yearly.

More from the statement pack

Walk into your next board meeting with the pack already done

Upload your bookkeeping export. Get the P&L, balance sheet, cash flow and the written analysis in about 60 seconds.

Encrypted in transit · We never sell your data