A food pantry's inventory system has to do three things, and none of them needs to be complicated. It has to say what's on the shelves by category, so volunteers know what to put in a box and coordinators know what to ask for. It has to keep dates, so food goes out oldest first and nothing is found expired at the back. And it has to record where food came from, by delivery or donation, so that if a product is recalled you can find it. A spreadsheet with two sheets and a weekly count does all three for most pantries. Below is a system for a made-up community pantry: the stock sheet, the receiving log, the count, and the file.
The short version
- One row for each kind of food, in the unit you hand out.
- A level for each row: below it, ask for more.
- Log every delivery and donation with a date to give it out by.
- New stock behind old, every time, on every shelf.
- Count once a week, on the same day, before distribution.
- TaroStack keeps stock by lot and date and flags what's about to expire. More below.
The stock sheet
| Item | Unit | On hand | Ask for more at | Source | Status |
|---|---|---|---|---|---|
| Canned vegetables, 15 oz | can | 412 | 240 | Donated | OK |
| Canned tuna, 5 oz | can | 96 | 144 | Donated | REORDER |
| Peanut butter, 16 oz | jar | 58 | 72 | Purchased | REORDER |
| Pasta, 1 lb | box | 230 | 150 | Donated | OK |
| Cereal, family size | box | 44 | 60 | Donated | REORDER |
| Frozen chicken, 5 lb bag | bag | 36 | 40 | Regional food bank | REORDER |
Eleven rows in all. Five are below their level: tuna, peanut butter, cereal, frozen chicken and diapers. That list is this week's ask, to donors, to the regional food bank and to whoever does the shopping.
Setting the level. This pantry serves about 120 households a week and puts two cans of tuna in each box: 240 cans a week. Its level for tuna, 144, is under a week's worth, which is why it's flagged so often. A better level is what you give out between deliveries, plus a week. Protein is the row pantries run short of first, so watch it most closely.
Donated food is on the sheet at no cost. The cost column is for what the pantry buys, here $436.80 of peanut butter, rice and bags, which is what a treasurer needs.
The receiving log
| Received | Item | From | Lot or delivery | Quantity | Give out by |
|---|---|---|---|---|---|
| Nov 12 | Shelf-stable milk, 32 oz | Regional food bank | Lot 6B-2291 | 144 cartons | Feb 14, 2027 |
| Nov 14 | Fresh produce, mixed | Grocery rescue | Pickup Nov 14 | 420 lb | Nov 19 |
| Nov 5 | Frozen chicken, 5 lb bag | Regional food bank | Lot FC-0931 | 60 bags | May 1, 2027 |
| Nov 8 | Peanut butter, 16 oz | Purchased | Case lot 25288 | 72 jars | Aug 1, 2027 |
| Oct 30 | Canned tuna, 5 oz | Food drive | Oct 30 | 180 cans | Jan 1, 2028 |
One row for each delivery or donation. Three things on it matter.
The give-out-by date. For a case with one date, that date. For a food drive's mixed tins, the earliest date in the lot, which you find while sorting. The sheet flags anything inside 30 days. What may be given out past a "best by" date, and for how long, is a question for your regional food bank's guidance: follow theirs, not a rule of thumb.
The source. Food bank deliveries come with a slip that has lot numbers. Write them down. If the food bank phones about a recall, "lot 6B-2291, 144 cartons, received November 12" turns a search of the whole building into a walk to one shelf.
Weight, for produce and rescue. Most networks ask pantries to report pounds in and pounds out. Weigh rescue pickups as they arrive.
The shelf rules
A system on paper only works if the shelves follow it.
| Rule | Why |
|---|---|
| New stock goes behind old | So the oldest is what a volunteer's hand reaches |
| Write the give-out-by date on the case, large, in marker | Nobody reads small print while packing |
| One place for each kind of food, labeled | So anyone can restock and count |
| Allergens together, low: peanut butter, nuts | A spill can't fall into other food |
| Fridge and freezer temperatures written daily | Cold food is the food that can hurt someone |
| A "use this week" shelf at the front | For what the sheet flagged |
The produce from November 14 has until the 19th. It goes on the front table on the next distribution day, not into a cooler to be found later.
The weekly count
Count the day before distribution, in shelf order, with the count sheet from the file. Two volunteers: one counts and calls, one writes. Whole cases, then loose units. It takes less than an hour for a pantry this size, and it's what makes the "on hand" column worth reading. The method is in how to count inventory, with a blank sheet in inventory count sheet example. The freezer has its own list, in freezer inventory sheet, and a general sheet for dated stock is inventory list with expiration dates.
Get the sheet
Download the food pantry inventory sheet. Four sheets: stock with a flag for what to ask for, the receiving log with days left, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers, so volunteers can share one copy online.
Where this stops working
A pantry runs on volunteers who come once a week or once a month. The spreadsheet lives on one person's laptop. When that person is away, donations still arrive and boxes still go out, and nothing is written down. Two weeks later the sheet and the shelves have nothing to do with each other, and someone has to start again from a full count.
How TaroStack does it
TaroStack is built for businesses that make and sell things, and a pantry uses the plainer half of it: stock, lots, dates and counts.
Receiving on a phone. Each delivery or donation is received with its source, its lot and its date, by whoever is there.
Stock by lot and date. The soonest to expire is picked first by default, and an alert flags lots close to their date, in the app and by email.
Counting on a phone or a printed sheet, with no signal needed in the storeroom.
Giving out takes stock off. Record a distribution day's totals as one order. Shipping it takes the stock off, soonest-dated lots first.
One report for a recall. Where a lot is now, and the days it went out.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Log a donation | Whoever has the laptop | Whoever is there, on a phone |
| What's about to expire | Open the sheet and sort | An alert, by email |
| Oldest first | Depends on the shelf | By default |
| Find a recalled lot | Search the log | One report |
TaroStack doesn't report to a food bank network or track households served: keep those where you do now. Stock, lots, expiry and counting are on Starter at $9.99 a month, for one person; Growth, at $39 a month, has three. 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.
