Sonbola SONBOLA

Free stocktaking template for shops and warehouses

Record items and physical counts, check the difference, then print your worksheet or download CSV.

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.

Stocktaking worksheet — counted quantity minus recorded quantity
Item codeItem nameUnitRecorded quantityCounted quantityDifferenceNotes

Enter quantities such as 1.5 without thousands separators. Blank is different from zero: the difference appears only when both quantities are filled. Results are rounded to six decimal places. There is no total across different items and units. Download your work before leaving or refreshing; the worksheet does not save your entries.

Download a blank CSV template

How to use the stocktaking worksheet

  1. Choose a location and count date.
  2. Write the item name and unit, then enter the quantity in your records.
  3. Count the physical items using the same unit and enter the result.
  4. Review the difference and note possible causes before adjusting your records.
  5. 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.