A CSA's inventory isn't a shelf of stock. It's a promise made in March, sixty boxes a week, set against whatever the field gives in June. So the sheet a CSA needs has a row for each crop going into this week's share, with how much goes in each share, how many shares, what that comes to, and what's actually harvested or ready. The gap between the last two is the only number that matters on Wednesday night. A second, smaller list covers the things a CSA runs out of without noticing: boxes, pint containers, rubber bands, egg cartons. Below is a week for a made-up farm with 60 shares, what to do with a shortfall, and the file.
The short version
- One row for each crop in this week's share.
- Needed = what goes in each share × the number of shares.
- Count what's harvested, washed and in the cooler, not what's in the field.
- Look at the spare-or-short column the day before packing, not the morning of.
- Add-ons such as eggs have their own number of shares.
- Keep a second list for boxes and containers, in weeks left.
- TaroStack keeps harvests as lots and counts stock by place. More below.
An example week
| Crop | In each share | Shares | Needed | Harvested | Spare or short | Status |
|---|---|---|---|---|---|---|
| Lettuce, head | 1 head | 60 | 60 | 72 | +12 | OK |
| Carrots | 1 bunch | 60 | 60 | 54 | −6 | SHORT |
| Snap peas | 0.75 lb | 60 | 45 lb | 48 lb | +3 | OK |
| Kale | 1 bunch | 60 | 60 | 66 | +6 | OK |
| Strawberries | 1 pint | 60 | 60 | 40 | −20 | SHORT |
| Scallions | 1 bunch | 60 | 60 | 60 | 0 | OK |
| Eggs, add-on | 1 dozen | 22 | 22 | 25 | +3 | OK |
Two crops are short. The carrots are six bunches under, and there are more in bed 4: that's twenty minutes of pulling. The strawberries are twenty pints under, and no amount of walking the rows fixes that by tomorrow.
What to do with a shortfall
A shortfall found the day before has three honest answers.
- Harvest more, if it's in the field. That's the carrots.
- Change the share. Sixty half pints use 30 pints, and there are 40. Everyone gets strawberries, and ten pints are left for the farm stand.
- Swap. Put rhubarb in the box this week and strawberries next week, when the patch catches up.
What doesn't work is finding out at packing. Then the first forty boxes get strawberries and the last twenty get an apology. Write the decision in the note column, so the packers and the newsletter say the same thing.
The spare is worth reading too. Twelve extra heads of lettuce are a farm stand's worth, or a donation, or a sign that the planting was a bed too many. The planting side is in farm production plan.
Shares that aren't all the same
Count shares by kind. A farm with 45 full shares and 30 half shares packs 75 boxes with two different lists. Give each kind its own rows, or its own copy of the sheet. Add-ons work the same way: 22 of this farm's 60 members take eggs, so the egg row's share count is 22.
Supplies
| Item | On hand | Used a week | Weeks left |
|---|---|---|---|
| Share boxes, half bushel | 180 | 60 | 3.0 |
| Pint containers | 300 | 60 | 5.0 |
| Rubber bands, bunching | 1,000 | 180 | 5.6 |
| Egg cartons | 60 | 22 | 2.7 |
Weeks left is on hand divided by what a week uses. This farm reorders boxes at two weeks and everything else at three, because the box supplier delivers faster. Boxes that members bring back count as on hand only once they're back and clean. Egg cartons are under three weeks, so they go on this week's order.
Keeping the harvest record
The harvested column comes from somewhere: a tally in the wash shed of what came in from which bed on which day. Kept as a log, it also tells you next winter what each bed gave. One is in harvest log template, and a list for produce you hold and sell in produce inventory spreadsheet. Eggs are in egg inventory template.
Get the template
Download the CSA share plan and inventory. Two sheets and a read-me: a share plan that works out what the week needs and marks anything short, and a supplies list. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
One week on one sheet is easy. A season is twenty-some sheets, and the questions are across them. How many weeks did carrots come up short? Which bed did Tuesday's lettuce come from, when a member writes that theirs was gritty? And which members got the eggs from the carton lot the hatchery emailed about?
How TaroStack does it
TaroStack keeps what was harvested, where it is and who got it.
Each harvest is a lot, with its date. Stock is held by location: the cooler, the wash shed, the egg fridge.
A share is a recipe. A box of this week's share uses a head of lettuce, a bunch of carrots, three quarters of a pound of peas. "What could I make right now" says how many boxes the cooler can fill.
Packing is a batch. Record it and the lots it used are noted automatically.
Boxes and containers have a reorder list, in days of cover, with each supplier's lead time.
Counting works on a phone with no signal, in the cooler or the field.
| The question | Weekly sheets | In TaroStack |
|---|---|---|
| How many boxes can I fill today | Add it up | What could I make right now |
| What's in the cooler and the wash shed | Walk in and look | Stock by location |
| Which harvest went in Tuesday's boxes | Unknown | The lots on the batch |
| When to order boxes | When they run low | A reorder list |
TaroStack doesn't manage member sign-ups or payments. Recipes, batches, lots and counting are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). 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.
