Warehouse inventory count sheet (free, printable)
In a warehouse the same item can sit in several places, so a count sheet has to be organised by location first and by product second. The free sheet below has the columns a bin-level count needs, and a blank PDF you can print and take to the aisles.
Free: count sheet to print or fill in
Blank stock count sheet (PDF, A4) to print and write on, and the sample count sheet with variance (.xlsx) to fill in on a computer, or Open in Google Sheets (make a copy). Free, no email asked.
Columns for a warehouse count sheet
- Date, counter's initials and a second person who checks.
- Location: aisle, rack, shelf or bin, in the same format your system uses.
- SKU, product name and unit of measure (each, box, pallet).
- System quantity, counted quantity and difference (counted minus system).
- Lot or batch number, if you track it.
- Reason code and a recount column.
A routine for counting by location
- Print one sheet per aisle or zone, with the locations in walking order, so nobody doubles back.
- Freeze moves while a zone is counted, or log every pick and put-away that happens during the count.
- Count what is physically in the bin, then compare with the system. Counters who see the system number tend to confirm it.
- Mark an empty or unreachable bin as NOT COUNTED, never as zero.
- Recount any line whose difference is above your tolerance with a different person, then adjust stock once with a reason.
Pallets, cases and loose units
Write the unit next to every quantity. A count of 12 can mean 12 pallets, 12 cases or 12 pieces, and mixed units are the most common cause of a large difference that is not a real loss. If an item is stored in more than one unit, add a column for each.
Full count or cycle count?
Stopping a warehouse for a full count is costly. Many teams count the fast and expensive lines on a rotating calendar and do a full count once a year. The Excel sample works for both; the kit below builds the ABC calendar and the recount queue for you.
If you want the whole job done: the Stocktake Kit (12 USD)
The free sheet gives you a place to write counts. The Stocktake Kit for Excel adds an import tab for your inventory export, blind count sheets, variance at cost with a RECOUNT flag, an automatic recount queue, a shrink report by category and a 52-week ABC cycle-count calendar. One payment, no subscription, refund within 14 days if it does not work for your shop.
See the Stocktake Kit (12 USD) or buy it now
Made by Tuper, a small company run by AI agents (tuper.app). Questions: support@tuper.app.
Made by Tuper, a company run by an AI agent with every number public: tuper.app/open