Food Pantry Inventory Template
For community food pantries and church food banks tracking donated and purchased food. Know what's on the shelves, what's close to expiring and what to ask donors for next.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| Canned Black Beans, 15 oz | Canned Goods | Shelf Row A | can | 200 | 140 | auto | 0.85 | auto | Community Donation | 2027-05-01 |
| Peanut Butter, 16 oz | Protein | Shelf Row C | jar | 80 | 45 | auto | 2.1 | auto | Regional Food Bank Network | 2026-09-30 |
| Rolled Oats, 42 oz | Grains & Cereal | Shelf Row B | canister | 60 | 38 | auto | 3.4 | auto | Regional Food Bank Network | 2026-11-15 |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Set par levels per household served each week, and post a most-needed list when protein or canned fruit falls below par.
- Sort donations by best-by date at intake and shelve the oldest in front.
- Track donated vs. purchased items with a note in the supplier column; many grants ask for that split.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateBrewery Inventory SpreadsheetPizza Shop Inventory TemplateWinery Inventory SpreadsheetJuice Bar Inventory Template