Skip to main content
Free template

Free stock record book template for your shop

Track what came in, what went out and what is really on your shelf. Print it, or save it as a PDF.

Download for Excel (CSV)

How to use it

  1. 1Write each product on its own line, and fill in the opening stock at the start of the day or week.
  2. 2Add any new stock that arrives in the 'Stock in' column, and the quantity sold in 'Sold'.
  3. 3Expected closing = opening stock + stock in − sold.
  4. 4Count what is actually on the shelf and write it in 'Counted'. Any difference is stock you need to explain.
  5. 5Count your ten fastest-selling items every day, and the rest over the week. Have the person who counted sign the last column.

Read more: How to prevent attendant theft and stock leakage in your shop

Stock record book

Shop name: ______________________________   Page: ______

kasuwa360.com

DateProductOpening stockStock inSoldExpected closingCountedDifferenceChecked by

Done with paper? Let the app keep the record

Kasuwa 360 takes stock off the shelf count the moment you sell, warns you before items run out and records who changed what. No adding up by hand. Try it free for 30 days, no card needed.

Start free trialSee how it works