Farm Bookkeeping Spreadsheet Laid Out Like Schedule F

Quick Answer: Build the farm workbook around Schedule F (Form 1040). Use one transactions tab where every row gets a Schedule F line number, one summary tab that totals income lines 1 to 8 and expense lines 10 to 32 with SUMIFS, and separate tabs for depreciable assets, purchased livestock and breeding stock sold. Fill the transactions tab from your farm bank and card statements, then attach the receipts.

A farm bookkeeping spreadsheet works best when its categories are the Schedule F lines, because that is where every number ends up. Give each transaction from your farm account a line number, total the lines on a summary tab, and keep separate registers for machinery and livestock. At tax time the summary is your Schedule F draft.

Why shape the workbook around Schedule F?

The IRS describes Schedule F simply: "Use Schedule F (Form 1040) to report farm income and expenses." A generic ledger with categories like "supplies" and "misc" forces you to re-sort everything in April. A workbook that already uses the form's lines doesn't.

Publication 225, the Farmer's Tax Guide (2025 edition, read on 27 October 2026), also asks for more than a ledger. It says your system "should include a summary of your business transactions," plus supporting documents "such as invoices and receipts, for purchases, sales, payroll, and other business transactions." The tabs below cover both: the transactions tab is the summary, and a document reference column ties each row to its paper.

If you want a general-purpose layout for a non-farm business instead, our bookkeeping spreadsheet template is the simpler starting point.

The tabs

Setting up the Lines tab

These are the 2025 Schedule F lines. Put the number in column A and the name in column B.

Income (Part I, cash method)

• 1a Sales of purchased livestock and other resale items (1b is their cost or other basis)
• 2 Sales of livestock, produce, grains and other products you raised
• 3a Cooperative distributions (Form 1099-PATR)
• 4a Agricultural program payments
• 5a CCC loans reported under election; 5b CCC loans forfeited
• 6a Crop insurance proceeds and federal crop disaster payments
• 7 Custom hire (machine work) income
• 8 Other income, including fuel tax credits or refunds

Expenses (Part II)

• 10 Car and truck; 11 Chemicals; 12 Conservation; 13 Custom hire
• 14 Depreciation and section 179 (comes from the Assets tab, not from bank rows)
• 15 Employee benefit programs; 16 Feed; 17 Fertilizers and lime; 18 Freight and trucking
• 19 Gasoline, fuel and oil; 20 Insurance (other than health)
• 21a Mortgage interest; 21b Other interest; 22 Labor hired
• 23 Pension and profit-sharing; 24a Rent or lease of vehicles, machinery, equipment; 24b Rent of land, animals and other
• 25 Repairs and maintenance; 26 Seeds and plants; 27 Storage and warehousing; 28 Supplies; 29 Taxes; 30 Utilities
• 31 Veterinary, breeding and medicine; 32 Other expenses (name each one)

Add three non-tax codes as well: XFER for transfers between your own accounts, PERS for personal spending from the farm account, and ASSET for purchases of machinery, buildings or breeding stock that go on the Assets tab. Part II's own heading says "Do not include personal or living expenses," and coding them out is easier than deleting them.

The Transactions tab and its formulas

Columns: Date, Account, Description, Amount (money in positive, money out negative), Line, Enterprise (e.g. corn, cow-calf, hay), Document ref, Notes. Use Data validation on the Line column with the Lines tab as the list so nobody types "feed" on one row and "16" on another.

On the Summary tab, with the line number in A5 and the transaction table named T:

=SUMIFS(T[Amount], T[Line], A5)

Expense totals come out negative; wrap them in =-SUMIFS(...) if you want positive figures to copy onto the form. To break a line down by enterprise, add a second condition:

=SUMIFS(T[Amount], T[Line], A5, T[Enterprise], "cow-calf")

A worked check: if October's rows include −1,840.00 to the feed mill, −315.60 at the vet and −1,210.00 for fertilizer and lime, the Summary shows 1,840.00 on line 16, 315.60 on line 31 and 1,210.00 on line 17. As a completeness check, the sum of every row for one account, XFER and PERS rows included, should equal that account's closing balance minus its opening balance on the statement. If it doesn't, a row is missing or duplicated.

Filling it from bank and card statements

The fastest way to fill the Transactions tab is to start with the account's own records, not a shoebox. Download CSV exports where your bank offers them. Where it only provides PDF statements, QuickBankConvert can convert them to Excel rows with date, description and signed amount, which you paste under the existing rows. Our PDF to Excel page shows the output.

Then code each row. Feed mill, co-op and elevator names repeat, so sort by description and fill the Line column in blocks. Our guide to bank statement categorization has more on building rules for repeat payees. Two farm-specific traps:

• Co-op checks and patronage. A co-op payment can mix grain sales (line 2) and patronage dividends (line 3a). Split the row using the settlement sheet.
• Program payments and loans. Government agricultural program payments such as price loss coverage go on line 4a, while the Schedule F instructions send disaster payments reported on Form 1099-G or CCC-1099-G to line 6a. A CCC loan is line 5a only if you elected to report it as income. Note which in the Notes column.

How do you track machinery and livestock for depreciation?

Bank rows show the purchase, but depreciation needs its own record. Publication 225 lists what your asset records should show:

1. When and how you acquired the asset, new or used
2. Full purchase cost
3. Cost of any improvements
4. Section 179 deduction taken
5. Depreciation and any special depreciation allowance taken
6. Casualty losses, such as fire or storm damage
7. How you used the asset
8. When and how you disposed of it
9. Fair market value of property traded, selling price and expenses of sale

Make each of these a column on the Assets tab, one row per tractor, building or bred heifer you depreciate. Line 14 on the Summary pulls from here, usually via Form 4562 or your preparer's software, rather than from the bank rows. Code the purchase row on the Transactions tab as ASSET so it doesn't land on an expense line twice.

Purchased, raised and breeding livestock

Livestock follows three paths, and the spreadsheet should keep them apart:

• Bought for resale. Sales go on line 1a and their cost on 1b. The Purchased livestock tab records head count, date and cost per lot so you can match the cost when the lot sells.
• Raised for sale. Sales go on line 2 and there is no cost to subtract; the costs of raising them are already on the expense lines.
• Held for draft, breeding, sport or dairy. Publication 225 says these sales are not reported on Schedule F: "Instead, report these sales on Form 4797." The 4797 sales tab holds date acquired, date sold, sale price and basis.

Is cash or accrual right for your farm?

The Schedule F instructions put it in a sentence each. Cash method: "report income in the year in which you actually or constructively received it and deduct expenses in the year you paid them." Accrual: report income when earned and deduct expenses when incurred, "even if you didn't pay them in that year." Publication 225 notes that most farmers use cash because the records are simpler.

The workbook above is a cash workbook: the bank date is the tax date. If you file on accrual, add a Receivables and Payables tab and an Inventory tab, because Part III needs beginning inventory, purchases and ending inventory to work out gross income.

Keeping the records

Publication 225 says you generally keep records "for at least 3 years from when your tax return was due or filed or within 2 years of the date the tax was paid, whichever is later," and asset records until the limitations period ends for the year you dispose of the asset. Save the workbook as a new file each year, keep last year's closing balances on the first row, and store statement PDFs next to it; our article on how long to keep bank statements for taxes covers retention in more detail.

Related guides

• Bookkeeping spreadsheet template
• Bank statement categorization
• How long to keep bank statements for taxes
• Convert PDF statements to Excel