Restaurant Stock Count Sheet Template: Physical Inventory That Reconciles
A location-ordered, blind-count template that connects physical quantity to book stock, variance, value, PAR and corrective action.
Last verified: 2026-08-30
A restaurant stock count sheet should make the physical walk easy and the later reconciliation defensible. It should list items in shelf order, use a fixed count unit, keep the expected quantity hidden during the first count, identify unusable stock separately and capture who counted, who verified and when the cut-off occurred.
This template targets the search intent that a general stock-count guide does not: a copyable sheet structure. Use it with the restaurant's full count procedure, approved inventory costing method and food-safety controls. The count establishes quantity; it does not by itself prove food is safe, usable or correctly valued.
Copyable restaurant stock count sheet
Arrange rows in the path the counter actually walks, not alphabetically. Location IDs prevent the same carton from being counted in the receiving area and again after it is moved to storage. If an item legitimately exists in two locations, use two count rows and one reconciliation total.
Keep quantity and condition distinct. A freezer may physically hold ten packs, but damaged, expired, thawed or quarantined packs may not be usable stock. Mark their quantity and incident or waste reference; do not remove them from the sheet without evidence.
| Location | SKU/item | Count unit | Sealed | Open/partial | Physical total | Unusable | Usable | Verifier |
|---|---|---|---|---|---|---|---|---|
| Dry store A-01 | ____ | kg/bag/each | ____ | ____ | ____ | ____ | ____ | ____ |
| Chiller C-01 | ____ | kg/pack/each | ____ | ____ | ____ | ____ | ____ | ____ |
| Freezer F-01 | ____ | kg/pack/each | ____ | ____ | ____ | ____ | ____ | ____ |
| Kitchen station K-01 | ____ | kg/litre/each | ____ | ____ | ____ | ____ | ____ | ____ |
| Beverage/bar B-01 | ____ | bottle/can/each | ____ | ____ | ____ | ____ | ____ | ____ |
| Packaging P-01 | ____ | pack/each | ____ | ____ | ____ | ____ | ____ | ____ |
Count header and cut-off
Freeze or control stock movement during the count. A delivery received halfway through, a kitchen issue after one shelf was counted, or an unrecorded branch transfer can create variance without any loss. Record all approved movement after the cut-off and bridge it into the reconciliation.
Use the same cut-off for physical count, book-stock export and costing report. Preserve the original blank or blind sheet and the completed signed version. If staff can see expected quantity, they may unconsciously count toward it.
| Header field | Entry |
|---|---|
| Restaurant/branch | ____ |
| Count date and business cut-off | ____ |
| Count started/finished | ____ / ____ |
| Sales stopped or controlled | ____ |
| Receiving and transfer status | ____ |
| Primary counter | ____ |
| Independent verifier | ____ |
| Sheet/export version | ____ |
One SKU and one base unit per row
Define the exact stock item and base count unit. A five-litre oil container and a one-litre bottle may be different SKUs or require a controlled conversion. Chicken counted in kilograms cannot be compared directly with a system balance stored as cartons without the pack quantity and conversion.
Write unit conversions in a master list, not in a counter's memory. Test conversions after supplier pack changes. If the same item has changing pack sizes, count in a stable base unit where practical and preserve the source packaging detail for purchase reconciliation.
| Purchased as | Counted as | Controlled conversion | Risk |
|---|---|---|---|
| Carton | Each | Items per carton | Pack size changed |
| Bag | Kilogram | Verified net quantity | Part-used estimate |
| Bottle/can case | Bottle/can | Units per case | Mixed open case |
| Whole raw item | Usable prepared item | Validated yield process | Do not treat as the same stock state |
How to count open and partial stock
Use a suitable scale, measuring container or documented fraction method. Do not estimate every open bag as half. Tare containers where relevant and use the same method each period. For sauces, oil or beverages, a container-level method may be practical only if it is repeatable and management understands its uncertainty.
Separate raw, prepared, work-in-progress and finished items when the accounting and operating records distinguish them. A pot of prepared sauce is not automatically equal to its raw ingredient quantity. Record production or yield using the restaurant's validated method.
Reconciliation and value sheet
Do not put expected quantity or value on the blind count sheet. Add them in the reconciliation copy after counts are signed. Investigate unit, cut-off, receiving, transfer, waste, production, staff meal, recipe usage and unauthorized movement before posting an adjustment.
IAS 2 provides inventory costing and recognition principles, including cost, net realizable value and recognized expense when inventory is sold. The restaurant's accountant decides the applicable costing method and treatment. A last-purchase price pasted from one invoice is not automatically the correct financial-statement value.
| SKU | Usable physical | Book quantity | Variance qty | Approved unit cost | Variance value | Reason/action |
|---|---|---|---|---|---|---|
| ____ | ____ | ____ | Physical − book | ৳ ____ | ৳ ____ | ____ |
| ____ | ____ | ____ | Physical − book | ৳ ____ | ৳ ____ | ____ |
| ____ | ____ | ____ | Physical − book | ৳ ____ | ৳ ____ | ____ |
Sources for this section: IFRS Foundation: IAS 2 Inventories
PAR and reorder extension
Keep PAR and reorder fields out of the blind physical count, then add them to the purchasing view. A count tells you what exists; a PAR target and confirmed incoming quantity help decide what to buy. Do not order the full difference if a supplier delivery is already confirmed.
Review PAR by branch, season, supplier lead time, storage capacity and product life. A high target can reduce stockout risk but increase cash tied up, crowding and spoilage. Use actual usage and delivery evidence instead of copying another branch's target.
| SKU | Usable on hand | Confirmed incoming | Reorder trigger | PAR target | Suggested order | Buyer approval |
|---|---|---|---|---|---|---|
| ____ | ____ | ____ | ____ | ____ | ____ | ____ |
| ____ | ____ | ____ | ____ | ____ | ____ | ____ |
Food-safety and expiry flags
The counter should flag damaged packaging, contamination, pest evidence, temperature concern, missing label, expired or unidentifiable product and unsafe storage. Move or dispose of product only under the restaurant's food-safety procedure and authority guidance. Preserve the quantity and reference so inventory and incident records agree.
BFSA publishes food-safety laws, resources and operator guidance. Use the current applicable requirements and the restaurant's validated controls for storage, temperature, handling and disposal. A spreadsheet color is not a food-safety decision.
Sources for this section: Bangladesh Food Safety Authority · BFSA food-safety laws and regulations index
Count frequency by risk and value
Set the frequency by item value, movement, perishability, variance history and operational importance. High-value meat, cooking oil, bottled drinks or critical packaging may need more frequent cycle counts than low-value stable supplies. A full month-end count can be supplemented by small daily or weekly counts.
Do not invent one universal schedule. Record why each cycle-count group was selected and review it after repeated variance, supplier change, new menu, festival demand or branch transfer. Count timing should also avoid creating unsafe handling or disrupting service.
Variance investigation and sign-off
Separate count error from process loss. A wrong unit conversion may create a large paper variance, while an unrecorded waste entry is a real but explainable consumption. Theft is one possible cause, not the first conclusion. Preserve facts and use fair HR or legal process for suspected misconduct.
Counter and verifier sign the physical quantity; manager signs reconciliation and adjustment; finance or the authorized owner approves the value under the restaurant's control policy. One person should not count, change the unit, post the adjustment and approve it without review.
- Recount with a second person
- Check item identity and unit conversion
- Confirm the business-date cut-off
- Review receiving and supplier shortage
- Review transfer in and out
- Review production, waste and staff meal
- Compare sales or recipe-related usage
- Check access and unusual movement
- Post only an approved adjustment
- Assign root-cause action and recount date
How we calculated and verified this
The count sheet follows a walk-path method: one item, one base counting unit and one storage location per row; blind quantity first; cost and expected stock added after the physical count. Variance = physical quantity − book quantity, while inventory value uses the restaurant's accountant-approved cost method.
IAS 2 is linked for inventory cost and expense-recognition context, and BFSA for Bangladesh food-safety resources. No stock-loss tolerance, shelf life, storage temperature or count frequency is invented. Food-safety limits come from applicable authority, product and validated restaurant procedures; counting frequency comes from risk, value and operating need.
A strong stock sheet follows the shelves, hides expected quantity during the count, fixes units and locations, separates unusable stock and reconciles every variance before adjustment. That makes the sheet useful for purchasing, food-cost review and operational control.
Copy the templates and customize items, locations and units. Keep food-safety decisions under current BFSA and product requirements, and keep financial valuation under the restaurant accountant's approved policy.
Related guides
- Restaurant Stock Count Process
- Restaurant Inventory Management
- Restaurant Inventory Variance
- PAR Level Restaurant Inventory
See this workflow in Rosuii: Track restaurant stock, purchasing, units and branch inventory in Rosuii
Sources checked
Frequently asked questions
What columns should a restaurant stock count sheet have?
Should expected stock appear on the physical count sheet?
How do I count an open bag or bottle?
How often should a restaurant count inventory?
Does physical count equal usable inventory?
Run your restaurant on Rosuii
POS, menu, inventory, payroll and more — built for Bangladeshi restaurants.
Start free
