Stock register format
Type your products and sizes, then fill in opening stock, stock in, sold and returned. Closing stock is worked out for you and low items are flagged. Print the register on A4 landscape or download it as a CSV for Excel or Google Sheets.
These rows are an example and cannot be printed. Change them, or press Clear rows to start your own. Print blank register gives empty ruled lines to fill by hand.
Paste a list of products
- Count the shelves at the end of the month and fix any row marked “Sold more than you had” before you start the next month.
- Returned (RTO) is for parcels that came back and went back on the shelf in good condition.
- Making SKUs for each size? Use the SKU generator, then print labels with the barcode generator.
Want stock kept next to your orders?
Storelala keeps a stock count for each product and size with your orders, on a store with cash on delivery built in. Free to start, no card needed.
Start your storeQuestions
How is closing stock worked out?
Closing stock is opening stock, plus stock in, plus returned, minus sold. If you opened the month with 12, bought 20 more, sold 9 and had 1 parcel come back, you close with 24. Every row is worked out as you type.
What do I put under Returned (RTO)?
Put the parcels that came back to you from the courier and that you put back on the shelf. Count a returned parcel only once you have opened it and checked the item. A damaged piece that you can’t sell again should not go back into stock.
What do Low, Out and Sold more than you had mean?
Low means closing stock is at or below your low-stock level. You set one level for everything and can change it for a single row. Out means nothing is left. Sold more than you had means closing stock is below zero, so a number is wrong or an entry is missing.
How do I start the next month?
Press Start next month. Closing stock becomes the new opening stock and stock in, sold and returned are cleared. Do this after you have counted the shelves and corrected any row marked Check.
Can I use the CSV in Excel with a formula?
Yes. The CSV opens in Excel and Google Sheets with Urdu names intact. Columns run Item, Variant, Opening, In, Sold, Returned, Closing. To keep working in a sheet, put =C2+D2+F2-E2 in the closing column and copy it down.
Are my rows saved?
They are kept in this browser, so they are still here after you refresh or come back tomorrow. Clearing your browser data removes them, so download the CSV now and then as a backup.