Stock Count Sheet
Physical count against system quantity, with variance.
Details
stock count sheet formatUploads
Your logo
A photo or picture
Goes on this page only. Drag it anywhere and pull its corner to resize it.
Your signature
Draw it with a finger, a mouse or a trackpad, and it goes on the page like a picture.
Pictures and signatures stay on this device. Nothing is uploaded to a server.
Red highlights mark what is still blank. Click anything on the page to change it. Your draft is kept on this device as you work.
Dear Sir / Madam,
A physical stock count was carried out at [location] as at [date].
No variances were found between system and physical quantities.
The counter and the checker must be different people, and neither should be the person responsible for the stock day to day.
What is a Stock Count Sheet?
A stock count sheet is what a counter carries round the shelves: location, item, counted quantity, and the variance against the system figure. It is the document that turns an inventory number from an assumption into a measured fact. Without a controlled count sheet, differences get adjusted straight into the system with no record of what was found where, and next year's discrepancy has nothing to be compared against.
Retailers, warehouses, restaurants, pharmacies, workshops, construction stores and manufacturers all count stock — some annually for the accounts, some by rolling cycle counts through the year, some daily on high-value or fast-moving lines. External auditors attend and observe counts at year-end and often test-count a sample themselves. The sheet is also used after a suspected theft, when an incoming manager takes over a store, and whenever the system quantity has drifted far enough that ordering has stopped being reliable.
Counting at year-end and the treatment of the resulting adjustment follow the reporting framework you file under, and your auditor will have expectations about count procedures, cut-off and whether they need to attend in person. Controlled substances, alcohol, fuel, precious metals and pharmaceuticals often carry additional statutory record and reconciliation duties set by the relevant regulator. Confirm what your auditor and your sector regulator require before designing the count, because a count run the wrong way may simply have to be repeated.
The sheet records what is physically present. It does not say whether the stock is sellable — damaged, expired and obsolete items count as units on hand until somebody assesses them, which is a separate review. It also does not explain a variance: a difference is a symptom, and the causes range from miscounts and unrecorded issues to receiving errors and theft. And a count is only as good as its cut-off. Stock moving during the count makes the numbers meaningless however carefully each line was tallied.
What to put in a Stock Count Sheet
These are the details this template asks for. Anything left blank is marked in red on the preview so you can see what is still missing.
| Field | What goes in it |
|---|---|
| Issuing organisation | For example: Maple Grove Homeowners Association |
| Organisation address | For example: 1420 Kinnear Road, Columbus, OH 43212 |
| Location counted | For example: Barton Road warehouse, bay 1 to 6 |
| As at date | Free text |
| Count lines | One per line: Item | System qty | Counted qty |
| Signatory name optional | For example: K. Srinivasa Rao |
| Signatory designation optional | For example: Honorary Secretary |
| Issued to (full name) | For example: James Whitfield |
| Their address | For example: 588 Kinnear Road, Columbus, OH 43212 |
How to write a Stock Count Sheet
Freeze movement and fix the cut-off
Stop receipts and issues during the count, or if that is impossible, quarantine anything moving and record it separately. Note the exact time the count starts. Deliveries arriving mid-count go to a marked area and are excluded. Almost every unexplained variance traces back to something that moved while it was being counted.
Number every sheet and control issue
Pre-number the sheets and record who took which, so none go missing and none get counted twice. An area is not finished until its sheets come back. Unnumbered loose sheets are how a whole aisle disappears from the total, and the difference then gets written off as shrinkage that never actually happened.
Print location and description, blank the quantity
Give counters the bin location, code and description, and leave the count column empty. Pre-printing the system quantity invites confirmation rather than counting — people see the expected number and write it down. Where a supervisor needs a comparison during the review, use a second, separately controlled copy that counters do not see.
Count in one unit and say which
State the unit of measure on every line: each, box of 24, metre, kilogram, litre. Half the variances in a first count are unit errors, where a counter records six cases and the system holds singles. If items are packed in mixed cases, count the loose units separately rather than estimating a fraction of a case.
Recount variances before adjusting anything
Anything over an agreed threshold, in value or percentage, goes back for a blind recount by a different person before it touches the system. Then record a reason code against each accepted variance — miscount, damage, unrecorded issue, receiving error, unknown. Adjustments posted without a reason turn a diagnostic exercise into bookkeeping.
Common mistakes
- Pre-printing the system quantity on the counter's sheet produces confirmation instead of counting, so the count agrees with the system and tells you nothing.
- Letting goods in and out during the count guarantees variances that nobody can explain afterwards, and the whole exercise may need repeating.
- Failing to number and control the count sheets means a missing sheet becomes a phantom shrinkage figure that gets written off as a loss.
- Recording quantities without the unit of measure turns cases into singles somewhere in the total, usually on the most valuable lines.
- Posting adjustments without a reason code against each one destroys the only evidence you had about whether the problem is counting, receiving or theft.
Frequently asked questions
What is the difference between a stock count sheet and a stock ageing report?
A count sheet establishes how much is physically there, line by line, against the system figure. An ageing report takes the quantities you already believe you hold and sorts them by how long they have been sitting. One answers whether the number is true, the other answers whether the stock is any use. Most businesses need both.
Should the count sheet show the system quantity?
Not on the counter's copy. A blind count — the counter records what they find with no expected figure in front of them — is the only version that tests the system rather than confirming it. Supervisors can hold a separate comparison copy for the variance review, and any recount should also be blind and done by a different person.
How often should stock be counted?
At least once a year for the accounts, and more often where value or turnover justifies it. Cycle counting — counting a small set of lines every week so everything is covered over the year — is generally more effective than one annual shutdown, because errors are caught while their cause is still traceable. High-value and fast-moving lines earn the most frequent counts.
What is an acceptable stock variance?
That is a policy decision, and it should be set in value and percentage terms per category rather than as one number, because a percentage that is trivial on fasteners is serious on jewellery. Set the recount threshold below the level you would consider material, and agree the tolerance with your accountant if the result feeds the year-end accounts.
Who should count the stock?
Not, ideally, the person responsible for that stock working alone — a second counter or a supervisor from outside the area gives the result credibility. In practice small businesses pair people up and rotate areas. At year-end your auditor may attend and test-count independently, so ask what they expect before you plan the day.
This page explains general practice and is not legal advice. Requirements differ between countries and, in some cases, between states — check what applies where the document will be used.