Farm Bookkeeping Spreadsheet Schedule F Income Expense Tracker Livestock Records Breeding Log Excel Google Sheets Ranch Homestead

Every receipt on its Schedule F line. Every animal on its record.

Most farm spreadsheets say "Schedule F" somewhere in the description and then hand you one column called Expenses. This one is built on the form. 54 Schedule F line numbers are mapped — 18 in Part I and 36 in Part II, lettered sub-lines counted separately — and you pick the line from a drop-down as you file the receipt, so January is reading a page instead of sorting a shoebox.

Built for tax year 2026. For 2026 the IRS split Schedule F line 21 three ways: 21a Mortgage, 21b Vehicle loan, and 21c Other. 21b is new this year. A category list built on the 2025 form puts your truck note on the wrong line, and every farm tracker written before this season is still on the old split. This one is not.

Bought or raised is not a detail. A calf you raised is line 2 and its whole price is income. A steer you bought is line 1a, and what you paid for it is line 1b. In the worked sample, 12 feeder steers bought for $14,400.00 and sold for $21,600.00 report $7,200.00 on line 1c — not $21,600.00. Type "Purchased" in one cell on the Livestock tab and the file moves the sale onto the right line and puts the cost basis where it belongs.

The record nobody else keeps. Type the withdrawal days off the product label and the Breeding & Health tab does the date arithmetic: treated October 24 with a 28-day product means clear to sell November 21, and the row reads DO NOT SELL until it is. Breeding dates work the same way, with gestation for cattle, sheep, goats, hogs and horses.

And it tells you which enterprise actually paid. In the sample book the cow-calf enterprise made $40,985.27, the hay made $18,917.97, and the laying hens lost $698.42. That is not an argument for shutting the hens down. It is an argument for knowing.

THE TWELVE TABS

1. Start Here — three steps, and the one rule
2. Setup — your farm, your enterprises, your rules, once
3. Income — what you sold, on the Part I line it belongs to
4. Expenses — every receipt on a numbered Part II line
5. Livestock — every head: what it cost you, what it brought
6. Breeding & Health — bred, treated, and clear to sell, with the date
7. Feed — tons in, tons fed, what a head costs a day
8. Equipment — what you own, what it is worth, what it writes off
9. Mileage — farm miles at the 2026 rate of $0.725
10. Schedule F — lines 1a to 34, per enterprise and in total
11. Dashboard — this month, this year, and which enterprise paid
12. Year View — twelve months, every enterprise

WHAT IS IN THE BOX
• The spreadsheet in four color editions (Colorful, Light, Dark and Editorial)
• A worked sample book — Kestrel Draw Farm, a cow-calf, hay and egg operation in eastern Colorado, January 1 to October 31, 2026: 69 income rows, 143 receipts, 140 head, 40 treatments, 22 assets, 46 trips. Delete the sample rows and type your own
• A full narrated video walkthrough, seven and a half minutes, every screen the real file
• The Pub. 225 recovery-period table and the gestation table, built in
• Free updates

IT WORKS WHERE YOU WORK

Microsoft Excel, Google Sheets and Apple Numbers. Portable formulas only — no macros, no add-ons, no login, nothing to connect and nothing to subscribe to. 7,657 formulas, recalculated in LibreOffice and checked independently 5,810 times with zero failures before this listing went up.

WHAT THIS FILE DOES NOT DO

It does not file a return or compute your tax. It does not decide whether your farm is a business or a hobby. It does not apply the excess farm loss, at-risk or passive-activity rules, and it does not compute MACRS tables, the mid-quarter convention or state depreciation. It does not replace the product label — withdrawal days come from the bottle in your hand, and this page does the date arithmetic on what you type. It does not connect to your bank, your co-op or your vet.

It is a record-keeping tool for you and your tax preparer. Not tax, legal or veterinary advice. Your preparer signs the return.

INSTANT DOWNLOAD — the files are on your account the moment payment clears. Nothing ships.

Questions before you buy? Message the shop. I answer.

WATCH THE FULL WALKTHROUGH before you buy - seven and a half minutes, every screen the real file:
https://youtu.be/YacCLfdvSJw