Farm Bookkeeping in QuickBooks: Schedule F Setup
Jul 10, 2026
PDF, JPG, PNG, BMP, HEIC, TIFF
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
TL;DR: Set up your QuickBooks chart of accounts so each expense account matches a line on Schedule F (Form 1040), the form a materially participating farmer files for profit or loss from farming. Most farms elect the cash method, booking income when the deposit clears and expenses when you pay. Keep income accounts separate for raised products, resale livestock, co-op distributions, USDA program payments, and crop insurance, because Schedule F reports each on its own line. Split combined statement lines (one co-op ACH covering both fertilizer and seed) into the right accounts, and code loan payments so only the interest hits an expense. Do that, and year-end tax prep becomes a report you print, not a shoebox you dread.
Last updated July 2026.
What Schedule F is, and who actually files it
Schedule F (Form 1040), Profit or Loss From Farming, is where a farmer reports the income and expenses of a farm business and arrives at a net profit or loss that flows onto the 1040. You file it if you materially participate in running the farm, meaning you are in the operation, making the decisions, and carrying the risk. Sole proprietors and single-member LLCs use it directly; farm partnerships report through Form 1065.
Here is a distinction that trips people up. A landowner who rents ground for a fixed cash amount and does not materially participate generally does not file Schedule F; flat cash rent usually goes on Schedule E. Take a crop or livestock share instead of cash without materially participating, and the income goes on Form 4835. Schedule F is for the person actually doing the farming, so confirm you are the operator, not just the landlord.
Cash method versus accrual
Most family farms file on the cash method, and the form is built for it: Part I is labeled Farm Income, Cash Method. Cash basis means you record income when you receive the money and expenses when you pay them. Sell grain in January, get the check in February, and it is February income. That timing is a planning tool: farmers prepay next season's inputs before year end to pull a deduction forward, or defer a grain check into January to push income back.
Accrual accounting instead matches income and expenses to the period they belong to, using inventories, payables, and receivables, for a truer picture of a single year's profit. That is why lenders and larger operations keep accrual management books even while filing taxes on cash. In QuickBooks, run day-to-day books on cash basis to match how you file, and switch a report to accrual only when a banker asks.
Build a chart of accounts that mirrors Schedule F
The single highest-value thing you can do is name your expense accounts after Schedule F lines. When your QuickBooks Profit and Loss reads the same as Part II of the form, tax prep stops being a translation job: your preparer runs one report and copies the numbers straight across. Part II has around twenty expense lines; build an account for each one you use. A starter map:
| Schedule F line | QuickBooks account name | Account type |
|---|---|---|
| 10. Car and truck expenses | Car and Truck Expenses | Expense |
| 11. Chemicals | Chemicals | Expense |
| 13. Custom hire (machine work) | Custom Hire | Expense |
| 14. Depreciation and section 179 | Depreciation Expense | Expense |
| 16. Feed | Feed Purchased | Expense |
| 17. Fertilizers and lime | Fertilizers and Lime | Expense |
| 19. Gasoline, fuel, and oil | Gasoline, Fuel, and Oil | Expense |
| 20. Insurance (other than health) | Farm Insurance | Expense |
| 21a / 21b. Interest | Interest Expense (Mortgage / Other) | Expense |
| 22. Labor hired | Labor Hired | Expense |
| 24a / 24b. Rent or lease | Rent or Lease (Equipment / Land) | Expense |
| 25. Repairs and maintenance | Repairs and Maintenance | Expense |
| 26. Seeds and plants | Seeds and Plants | Expense |
| 31. Veterinary, breeding, and medicine | Veterinary and Medicine | Expense |
Do the same on the income side and for fixed assets and loans. If you run multiple enterprises like row crops and a cow herd, add classes so one Feed account splits by enterprise while rolling up to a single Schedule F line.
Keep these income accounts separate
Schedule F does not lump farm income into one number; Part I breaks it onto separate lines. If your books do not, someone pulls the deposits apart at tax time. Set up a distinct income account for each stream:
- Sales of livestock and other items bought for resale (line 1), tracked against their cost basis.
- Sales of livestock, produce, grains, and other products you raised (line 2), the big one for most farms.
- Cooperative distributions (line 3), patronage dividends reported on Form 1099-PATR.
- Agricultural program payments (line 4), USDA and FSA payments usually reported on Form 1099-G.
- Commodity Credit Corporation (CCC) loans (line 5), which you can treat as income by election.
- Crop insurance and federal crop disaster proceeds (line 6).
- Custom hire income (line 7), from running your equipment on someone else's ground.
- Other income (line 8), including the federal and state gasoline or fuel tax credit or refund.
The USDA and co-op deposits land on a statement as a descriptor like FSA TREAS 310, with no hint of which line they belong on. Splitting them into named income accounts as they arrive beats reverse engineering them in the spring.
Splitting one bank line into two Schedule F accounts
Here is the situation that breaks a naive import. Your co-op statement itemizes $6,400 of fertilizer and $1,850 of seed, then bills it as a single ACH pull. The bank statement shows one line: COOP ACH DEBIT 8250.00. Code the whole $8,250 to one account and both your Fertilizers and Lime line and your Seeds and Plants line come out wrong, and no report catches it because the total is right.
The fix is to split the transaction. Open the $8,250 payment and use the split (or Category details) grid to enter two lines: $6,400 to Fertilizers and Lime and $1,850 to Seeds and Plants. They add back to $8,250, so the bank still reconciles to the penny while Schedule F line 17 and line 26 each carry the correct number.
Loan payments: only the interest is an expense
Say the note on your tractor costs $1,240 a month. That payment is not all expense. Suppose $1,058 pays down principal and $182 is interest. Only the $182 is deductible (Schedule F line 21a or 21b). The $1,058 reduces the loan balance, so it hits the equipment note liability account, not the Profit and Loss statement.
Code the full $1,240 to an expense and two things go wrong: you overstate the deduction by $1,058, and your balance sheet never shows the loan paying down. Split every payment, principal to the liability and interest to expense. Your lender's amortization schedule gives the breakdown, and QuickBooks can hold it as a recurring split.
Prepaid supplies bought in December
Buying next year's seed, feed, or fertilizer before December 31 to claim the deduction now is a classic cash-basis move, and it is legitimate. There is a catch. The deduction for prepaid farm supplies you have not yet used can be capped in the year you pay, generally to no more than 50% of your other deductible farm expenses, with the excess deductible in the year you use the supplies. Exceptions exist. Read the details in IRS Publication 225, the Farmer's Tax Guide, and confirm with your CPA before writing a large December check.
Assets versus expenses
Anything with a useful life beyond one year is a fixed asset: purchased breeding livestock, machinery and equipment, grain bins, and drainage tile all go on the balance sheet and get depreciated. Feed, fuel, repairs, seed, and vet supplies get consumed inside the year, so they are straight expenses. Miscoding a $40,000 grain bin as repairs blows up one year's deduction and hides an asset you own.
Why bank feeds let farmers down
Farm banking has a data problem most small businesses do not. Plenty of ag lenders, Farm Credit associations, and small rural banks offer no QuickBooks bank feed at all. Even where a feed exists, it typically reaches back only about 90 days, useless when you are reconstructing a full crop year or catching up two seasons before a loan renewal. The transactions that do come through arrive with cryptic descriptors that say nothing about which Schedule F line they belong on.
Converting the PDF statement into a .qbo file closes the history gap. Download the bank's PDF statements, run them through a converter, and import clean, dated transactions straight into QuickBooks, feed or no feed. Our page on how to convert bank statements to QuickBooks for farms and agriculture walks through the workflow, and the general PDF to QBO converter handles any statement. For older years, you can import old bank statements into QuickBooks the same way, past the 90-day window a live feed gives you.
Statements only tell half the story. A lot of farm spending happens at the co-op counter, the parts window, and the fuel pump, landing as a drawer of paper receipts that never touch the bank feed cleanly. To keep that paper trail matched to the right expense account, you can pull the line items off scanned receipts into a spreadsheet and reconcile them against the bank transactions. Between clean statement imports and captured receipts, your farm bookkeeping in QuickBooks ends up complete instead of approximate.
Frequently asked questions
Can QuickBooks be used for farm accounting?
Yes. QuickBooks handles farm accounting once you set up a chart of accounts that mirrors Schedule F and add classes for enterprises like crops and livestock. It manages cash-basis reporting, loan splits, and fixed assets. There is no farm-specific template out of the box, so the value is in the setup.
What is Schedule F?
Schedule F (Form 1040), Profit or Loss From Farming, is the IRS form a materially participating farmer uses to report farm income and expenses and figure net profit or loss for the year. Part I lists income by source, Part II lists expenses by category, and the result flows onto Form 1040. Cash-rent landlords generally use Schedule E instead.
How do I categorize farm expenses in QuickBooks?
Create an expense account for each Schedule F line you use, such as Feed, Fertilizers and Lime, Seeds and Plants, Fuel, Repairs, and Labor Hired. Code each transaction to the matching account, and split any bank line that covers more than one category (a co-op draft covering both fertilizer and seed) so every Schedule F line carries the correct total.
Do farmers use cash or accrual accounting?
Most farmers file on the cash method, recording income when they receive payment and expenses when they pay. It matches how the money moves and allows year-end planning through prepaying inputs or deferring grain checks. You can keep cash-basis books and produce an accrual report when a lender asks for one.
How do I record a USDA payment in QuickBooks?
Deposit it to a dedicated income account for agricultural program payments, which maps to Schedule F line 4. USDA and FSA payments are usually reported to you on Form 1099-G and are taxable. On the bank statement they often appear as a code like FSA TREAS 310, so code the deposit to that account rather than lumping it with crop sales.
Is QuickBooks Desktop or Online better for farms?
Both work; the choice depends on how you operate. QuickBooks Online suits farmers who want cloud access, mobile receipt capture, and an accountant logging in remotely. Desktop appeals to those who prefer a local file and heavier inventory features. Either way, the setup matters more than the edition: a Schedule F chart of accounts drives clean tax prep on both.
Convert your first statement free.
Upload a PDF bank statement, get a QuickBooks-ready .qbo back in seconds. No card to try it.