Skip to content

Food Pantry Inventory System: A Sheet, Dates and a Count

A simple inventory system for a food pantry: what's on the shelves by category, donations and deliveries with give-out-by dates, a weekly count, and a file.

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 20, 2026 · 7 min read

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.

Questions people also ask

How do food pantries keep track of inventory?

With a stock list by category, a log of every delivery and donation with its date, and a regular count, usually weekly before distribution.

What should a food pantry track for each donation?

What it is, how much, who it came from, the date it arrived, a lot number if there is one, and the date to give it out by.

Can a food pantry give out food past its best-by date?

That depends on the food and on your regional food bank's guidance. Follow theirs, and record the dates so the decision can be made.

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.