Template
Food inventory count sheet
Count full packs and loose stock by storage location while keeping purchase units, count units, and verified pack conversions separate.
Overview
An inventory count sheet preserves quantities at a defined location and cutoff. A case, bag, bottle, and loose amount may use different units; record the verified pack relationship rather than silently converting the count. This worksheet does not total quantities or apply an inventory valuation method. Its purpose is to make the physical count and unit basis reviewable before values are used in a period calculation.
How to prepare and record a count
- Set the cutoff. Record the count date, time, storage area, counters, and the treatment of receipts, transfers, or production movements during the count.
- Choose a route and count locations. Work shelf by shelf or bin by bin. Identify the item and supplier code so the same product is not counted twice under different names.
- Record full packs and loose stock separately. Enter the purchase unit, count unit, and verified conversion. Record full-pack counts and measured loose quantities in their own fields.
- Capture the product state. Note recipe version, opened state, drained state, or other condition when it affects which quantity basis applies.
- Review exceptions before valuation. Recount uncertain quantities and document movements or estimates. Use the reviewed count with the chosen accounting basis; this sheet does not select that method.
Your worksheet
Fill in your own records, then print or download them. Fields are optional. No costs, quantities, percentages, or totals are calculated. Entries stay in this page and are not saved by this site. Keep a downloaded or printed copy if you need the record later.
Food inventory count sheet
- Kitchen / storage area
- ________________
- Count date and cutoff time
- ________________
- Counted / verified by
- ________________
- Movement freeze / exceptions
- ________________
Entry 1
- Shelf / bin / storage location
- ________________
- Item / supplier code
- ________________
- Purchase unit
- ________________
- Count unit
- ________________
- Verified pack-to-count relationship
- ________________
- Full packs counted
- ________________
- Loose quantity and unit
- ________________
- Food state / recipe version
- ________________
- Recount / movement / exceptions
- ________________
Convert the physical count without hiding pack structure
- Set Count cutoff
Date, time, location, and movement notes.
- Count Full packs
Record package count and verified inner structure.
- Measure Loose stock
Record a separate quantity and count unit.
- Review Inventory basis
Reconcile the quantity record before applying a valuation method.
Keep count units and valuation fields distinct
A physical quantity record can support several accounting workflows, but it does not choose how the inventory is valued.
| Entry | Example | Purpose | Separate decision |
|---|---|---|---|
| Purchase unit | Case containing two 5 lb bags | Identifies the supplier pack. | What unit receives an inventory value. |
| Full-pack count | Three cases | Counts intact packages at the cutoff. | Whether a partial package is counted by estimate or measurement. |
| Loose stock | Four measured lb | Records opened quantity separately. | How its value is assigned. |
| Total physical quantity | 3 × 2 × 5 lb + 4 lb = 34 lb | Checks the quantity conversion. | FIFO, average cost, or another valuation basis. |
Prepare a consistent count
Set the cutoff and storage route before recording quantities. Note receipts, transfers, production, or other movements that occur during the count.
- Use a stable item identity and a stated count unit for every location.
- Record whole packs and loose quantities in separate fields. The sheet does not add unlike units.
- Keep raw ingredients and prepared components identifiable so their costs are not counted twice.
Verify the pack relationship
A case and an individual bag are different count units. Verify the number and quantity of inner packs from the actual specification, and record partial-pack estimates explicitly.
Keep pack counts and loose stock separate
At one storage location, a counter finds three full cases. The specification confirms two 5 lb bags per case, plus 4 lb of loose stock.
Inputs
- Full cases
- 3
- Bags per case
- 2
- Weight per bag
- 5 lb
- Loose stock
- 4 lb
- Full-case quantity = 3 cases × 2 bags/case × 5 lb/bag = 30 lb.
- Add the separately counted 4 lb loose stock.
- Physical quantity check = 30 lb + 4 lb = 34 lb. The worksheet records the pack structure and loose amount; it does not value the inventory.
Result: 34 lb physically counted
Keep package count, package conversion, and loose quantity visible. This example checks quantity only; no inventory value or accounting method is inferred.
Quantity record, not an inventory valuation policy
This sheet records quantities. It does not choose FIFO, average cost, inventory prices, reorder levels, or accounting treatment.
Finish the count before applying value
A count is traceable when it identifies a cutoff, storage location, item, package relationship, and loose quantity. Reconcile movement and unit exceptions first. Apply the operation's reviewed valuation method separately when the count is used in a period food-cost calculation.