Skip to content

Farm Bookkeeping Spreadsheet: One Ledger, by Category

A free farm bookkeeping spreadsheet for a small farm: one row for every payment in or out, a category for each, totals by category, and a receipt habit.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A small farm's books can be one sheet. Every time money comes in or goes out, it gets a row: the date, who, what for, a category, and the amount. The category is the part that does the work. At the end of the year a tax return, a loan application and your own curiosity all ask the same kind of question (how much on feed, on seed, on fuel; how much from the market, from wholesale, from the CSA), and a column of categories answers all of them with one sum. The discipline is small and daily: enter it the day it happens, use the same category words every time, and keep the receipt. Below is a ledger for a made-up market garden with laying hens, a starter list of categories, what the totals are for, and the file.

The short version

  • One row for every payment, in or out, on the day.
  • A category on every row, from a short fixed list.
  • Money in and money out in separate columns.
  • Keep every receipt. A photo will do.
  • A separate bank account for the farm makes all of it easier.
  • TaroStack keeps the stock and lot side: what was harvested, packed, sold and to whom. More below.

A month's ledger

Date Paid to or received from What for Category In Out
Nov 2 Saturday market Vegetables and eggs Sales: market $612.00
Nov 3 Feed store Layer feed, 20 bags Feed $358.00
Nov 5 Corner Pantry Market Eggs, 30 dozen, invoice 114 Sales: wholesale $135.00
Nov 6 Seed company Seed order for spring Seeds and plants $286.40
Nov 9 Saturday market Vegetables and eggs Sales: market $548.00
Nov 10 Fuel station Diesel for the tractor Fuel $94.20
Nov 12 CSA members Winter share payments, 6 Sales: CSA $1,500.00
Nov 14 Market association Stall fee, November Market fees $120.00
Nov 17 Farm supply Row cover and drip tape Supplies $211.75
Nov 20 Insurance agent Farm liability, quarterly Insurance $240.00

By category so far: $2,795.00 in, $1,310.35 out, $1,484.65 to the good.

That last figure isn't November's profit. The $1,500 from CSA members is for boxes they'll collect from December to February, and the $286 of seed is for next spring. A ledger records when money moved, which is what most small farms report on. Your tax preparer will tell you whether that's right for yours.

Categories

Start with fifteen and change as little as you can.

Money in Money out
Sales: market Feed
Sales: wholesale Seeds and plants
Sales: CSA Fuel
Supplies
Market fees
Insurance
Repairs
Hired labor
Utilities
Rent or lease
Vet and animal health
Other

Ask whoever prepares your tax return for the list of categories on the form they file, and make yours match theirs. Then the year-end totals go straight onto the return and nobody re-sorts a shoebox in March.

Split sales by channel. It costs nothing and it's the most useful thing on the sheet: you'll see that the market brings in the most and takes every Saturday, while the wholesale account is small and steady.

Equipment is different. A tractor or a walk-in cooler isn't an ordinary expense: its cost is usually spread over years. Enter it with a note and let your tax preparer deal with it.

"Other" should stay small. If it's more than a few rows a month, one of them wants its own category.

Habits that make it work

Enter it the day it happens. Five rows a week takes five minutes. Two hundred rows in March takes a weekend and is half guesswork.

Market days. Don't enter every customer. One row for the day's takings, from a tally sheet or the card reader's total plus the cash counted. The tally sheet is in market vendor inventory template.

Receipts. For every row in the money out column, keep the receipt. Photograph it the same day, into one folder, named by date. Thermal paper fades.

A farm bank account. If farm money and household money share an account, the ledger has to untangle them every month. A separate account and card makes the bank statement a check on the ledger: every line on one should be a row on the other.

Mileage and home use. Farm use of a personal truck or a share of home utilities have rules of their own. Keep a mileage note and ask.

What the totals are for

Question Where
The tax return Totals by category for the year
A loan or grant application Sales by channel; total expenses
Is the hen flock paying? Egg sales against feed, supplies and the hens' share of everything else
What should next year's CSA share cost? This year's costs, divided by the shares you can grow

The third question needs more than a ledger: it needs to know how many eggs. Production records are in egg production log template, prices in how to price eggs, and selling at a market in how to sell eggs at a farmers market.

This is general information, not tax or accounting advice.

Get the spreadsheet

Download the farm bookkeeping spreadsheet. A Ledger sheet with the example rows and blank ones below, and a By category sheet that totals money in and out for each category. Type a category exactly as it's spelled on the second sheet, or add your own there. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The ledger knows the farm sold $135 of eggs to the Corner Pantry. It doesn't know which day's eggs they were, how many dozen are in the cooler now, or how many were cracked and fed back to the hens. Money is one record. What was grown, packed and sold is another, and the second is the one a buyer or an inspector asks about.

How TaroStack does it

TaroStack isn't an accounting system and doesn't post journal entries. It keeps the other record: the goods.

Stock by lot and date. Each day's eggs or each harvest is a lot, with the date packed.

Sales orders and delivery notes say which lots went to which customer. The soonest date goes first by default.

One report for a recall, and a timed drill to show a buyer that it works.

Counting on a phone, in the cooler or the field, with no signal.

Every adjustment carries a reason: cracked, unsold, donated. Waste is a figure.

The record The ledger TaroStack
Money in and out, by category Yes No: keep the ledger
Which eggs went to which customer No Lots on the delivery note
What's in the cooler, and how old No Stock by lot and date
Cracked, unsold, donated No Adjustments by reason

Every list exports to CSV. Stock, lots and recalls are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do I keep books for a small farm?

Record every payment in and out on one ledger, the day it happens, with a category from a fixed list, and keep the receipts. Total by category for the year.

What categories should a farm use for bookkeeping?

Sales by channel, and expenses such as feed, seeds and plants, fuel, supplies, repairs, hired labor, utilities, rent, insurance and fees. Match them to the categories on the tax form your preparer files.

Do I need accounting software for a small farm?

Not to start. A spreadsheet ledger with categories is enough for many small farms. Software earns its place when you have employees, loans, or many invoices to track.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.