Free Food Pantry Inventory Spreadsheet

A ready-made inventory template for a food pantry: one sheet for what is on the shelf, one for what came in, one for what went out, and a monthly total of pounds by source for your food bank report. Download it, track your stock online right on this page, or print a blank count sheet below.

The Excel file has drop-downs, the formulas and five sheets. The CSV is the inventory columns only, for any spreadsheet or for importing elsewhere. Google Sheets: File → Import → Upload, and choose the .xlsx.

What is in the template

The columns, and why each one is there

• Item, Category, Unit. Use your food bank’s categories if it reports by category; it makes the monthly report a copy job.
• Qty on hand and Lbs per unit. Food banks and TEFAP reports count in pounds, so record a weight per case or unit once and let the sheet multiply.
• Received date and Best-by / use-by. These drive rotation: sort by best-by and pull the earliest first. Most dates on shelf-stable food are quality dates, not safety dates (see can a pantry give out food past the date?), but they still tell you what to move first.
• Source. TEFAP (USDA Foods), food bank, food drive, grocery rescue, purchased. Keep USDA Foods on their own rows: they carry federal recordkeeping and your food bank will ask about them separately (what TEFAP records a pantry keeps).
• Lot / barcode. The one field you will wish you had the day a recall notice arrives (what to do in a food recall).
• Storage location. Which shelf, cooler or freezer, so a volunteer can find it and you can check a unit’s contents if it fails.
• Reorder level. The quantity at which you order more from the food bank. Leave it blank for things you only get by donation.

How to use it week to week

1. On delivery: add a line to the Received log, then add the quantity to the matching Inventory row (or a new row if the date or lot is different).
2. After each distribution: record what went out in the Out log and subtract it on the Inventory sheet. Do it the same day; a week later nobody remembers.
3. When you throw something out: log it in the Out log with the reason. Discards are a number your food bank may ask for, and a pattern in them is how you cut waste (tracking food waste).
4. Once a month: do a physical count with the printed count sheet, correct Qty on hand, and read the Monthly totals sheet for your report.

For the numbers you send the food bank each month (households, individuals by age, pounds by source, volunteer hours), use the monthly report template.

Keep fridge and freezer readings on a separate temperature log; that record is checked differently and lives better on paper by the unit.

Prefer not to open a spreadsheet? Keep a running inventory right here. Add items as they arrive, change the count after each distribution, and the tracker flags anything at or below its reorder level and anything with a best-by date in the next 14 days, with totals by category and by source. Export to CSV at any time: the columns match the template, so the rows paste straight into the Inventory sheet.

Where your data is kept: only in this browser, on this device. Nothing you enter is sent to PantryPOS or anyone else, and no sign-up is needed. Clearing your browser data, or a private window, will erase it, so export a CSV after each session.

“Best-by soon” means the date is today or within the next 14 days; “past date” means it has gone by. Most dates on shelf-stable food are quality dates rather than safety dates, so a past date is a prompt to check, not automatically to throw away (can a pantry give out food past the date?). Units and pounds are added up as entered; rows without a weight count as 0 lbs.

For the monthly physical count: one page per storage area, with the columns you will copy back into the spreadsheet. Built in your browser; nothing is sent anywhere.

When a spreadsheet stops working

A spreadsheet is the right tool for a lot of pantries, and this one will carry a small monthly distribution for a long time. It tends to break down in a few predictable places:

• More than one person edits it. Two copies drift, or a shared sheet gets a row deleted and nobody notices until the count is off.
• Stock moves faster than typing. On a busy distribution day the Out log is filled in from memory afterwards, so Qty on hand is a guess.
• A recall arrives. A spreadsheet can tell you whether you received a lot. It cannot tell you which households took it home.
• You need visit records, not just stock. A spreadsheet tracks food. It does not tell you which households came this month, how many people they feed, or what they took.
• The monitor asks for TEFAP stock reconciled. Received minus distributed minus discarded should equal what is on the shelf, by lot, and finding the gap by hand takes an afternoon.

PantryPOS is food pantry software that does the inventory part as you work: donations and deliveries received by barcode and lot with their dates, a FIFO pull list so the oldest stock goes first, a client-choice register that draws stock down as households shop, discards logged with a reason, TEFAP stock reconciled by lot, and a lookup of which households received a recalled lot. Each volunteer signs in with their own account (admin or clerk), so several people can work at once without passing a file around. Each visit is recorded against the household with the items they took, and the monthly report shows pounds distributed from TEFAP lots separately from other sources and counts TEFAP households by eligibility basis. What your own State asks for is on its TEFAP state page. Everything exports to CSV, so nothing is locked in.