Skip to content

CSA Inventory Template: Shares, Harvest, Supplies

A CSA inventory template: what goes in each share, how many shares, what the week needs against what's harvested, and the boxes and pints you run out of.

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 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.

Questions people also ask

How do you plan a CSA share?

List each crop, how much goes in one share and the number of shares. Multiply for what the week needs, and compare it with what's harvested and ready the day before packing.

What do you do when a CSA crop comes up short?

Harvest more if it's in the field, give a smaller amount to every member, or swap in another crop and make it up in a later week. Decide the day before, and tell members.

How many boxes should a CSA keep on hand?

Enough to cover the weeks it takes to get more. This example uses 60 a week and reorders when fewer than two weeks' worth are clean and on hand.

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.