Prepare one count for one location
Use the same unit for the recorded and counted quantity of each item. Keep each location on a separate worksheet so you can review differences before making any adjustment.
How to use the stocktaking worksheet
- Choose a location and count date.
- Write the item name and unit, then enter the quantity in your records.
- Count the physical items using the same unit and enter the result.
- Review the difference and note possible causes before adjusting your records.
- Download CSV to keep your entries, or print the worksheet to count on paper.
Worked example: 100 recorded, 96 counted
For a training example with one item measured in pieces: 96 − 100 = −4 pieces. A negative difference means the count is lower than the recorded quantity; a positive difference means it is higher. The worksheet shows the arithmetic difference, not its cause.
What should I review before adjusting stock?
Check the unit, location and transactions that have not yet been recorded. A difference alone is not enough to identify loss or decide on an adjustment.
Is this CSV a Sonbola import file?
This is a general stocktaking worksheet. It does not connect to Sonbola or update your stock. Do not treat it as a Sonbola import format without checking the supported fields and procedure with the team.
Free Excel product lists for your shop
Explore furniture and clothing starter lists in Excel and CSV. Preview the items, edit your copy and read the preparation guide before importing into Sonbola.