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.
