Stock Take Sheet (Excel, Printable)
A printable stock count sheet: product, SKU, unit, system stock and a box for the counted quantity. Type the counts back in and the sheet works out the difference and its value at cost, with a total for the shrinkage or gain.
- Published
- Reading time
- 2 min read
Stock take sheet (Excel): counted vs system stock, difference and its value at cost
Excel (XLSX) · 17 KB · free, no sign-up
What is in the file
The Stock count sheet has a header for the shop, date, section and the two people counting, then 150 numbered lines with Product, SKU or barcode, Unit, System stock, Counted, Difference, Cost price, Difference value and Note. The Counted column is shaded so it is easy to fill on paper. The header row repeats on every printed page, and the sheet prints landscape on A4.
Difference is counted minus system stock; Difference value is that difference times cost price, and the total at the bottom is the value of stock missing or found in the count.
Direct link to the file: nafaa-stock-take-sheet.xlsx. Free to use, copy and share.
How to use it
Step 1: Fill the list before you count
Paste or type the products, SKU, unit, system stock and cost price for the section you will count.
Step 2: Print and count
Count one shelf at a time in loose units. One person counts, the other writes.
Step 3: Type the counts in
Difference and its value calculate as you type.
Step 4: Recount large differences, then adjust
Check big gaps again before you correct the stock in your system, and keep the sheet as the record.
Counting with less effort
Counting by section, a few shelves a week, is easier than closing the shop for a full count, and it catches problems sooner. Our stock taking guide covers how to plan it. In Nafaa, a stock count adds products by search, scan or a whole category, shows the system figure, the difference and its value as you type, and books each difference when you confirm, so no figures are typed twice.
Frequently asked questions
How often should a shop do a stock take?
A full count at least once a year, and a rolling count of a few sections every week or month. Count fast-moving and high-value items, and anything that goes missing often, more frequently. Regular small counts find theft, billing mistakes and unrecorded deliveries while they are still easy to trace.
What does a negative difference mean?
A negative difference means fewer items on the shelf than the system expects. Common causes are items sold without a bill, damage or expiry not recorded, theft, or a delivery entered with too high a quantity. A positive difference usually means goods arrived but were never entered. Recount before you adjust.
