Free tool

Shop stock register free Excel template

A simple stock sheet for a grocery, minimart or retail shop. It works out closing stock, flags what to reorder and adds up what your stock is worth.

ItemOpeningReceivedSoldDamagedClosingReorder levelReorder?Stock value
Water 1.5 L (carton)40607212730ORDER243.00

Example row only. The file you download is empty and ready to use. Closing stock, the ORDER flag and the value of each item fill in by themselves.

  • •One row per item, room for 200 items.
  • •Enter what came in, what was sold and what was damaged or expired.
  • •Set a reorder level per item and the sheet marks what to order.
Download free Excel template

Works in Excel, Google Sheets and Numbers. No signup, no email.

Want this done for you every day, without a sheet? Ask for a quick demo for your shop on WhatsApp.

Ask for a demo on WhatsApp

How to keep a stock register for a small shop

Running out of a fast-selling item costs a sale today and sometimes a customer for good. Over-ordering is just as expensive: money sits on the shelf, and in a grocery some of it expires there. A stock register is the simplest tool for both problems. It does not need to be clever. It needs to be filled in.

List each item once, with its unit and the stock you have today as the opening figure. When a delivery arrives, add the quantity under Received. Add what you sold, and anything damaged or expired in its own column, because that is a loss you want to see rather than hide inside sales. The sheet calculates closing stock for every item.

Then set a reorder level per item: the quantity at which you need to order so the new delivery arrives before the shelf is empty. A common way to choose it is daily sales multiplied by the supplier's delivery days, plus a few days of safety stock; our free reorder point calculator does that sum. When closing stock reaches the level, the sheet marks the item ORDER.

Add the cost per unit and the sheet values each line and totals your stock. That total is money you have already spent, and seeing it month after month shows whether stock is creeping up faster than sales. Start with your fifty best sellers rather than every item in the shop. When counting and typing becomes too much, Tallium AI updates stock from each sale and each supplier bill and warns you before an item runs out.

Frequently asked questions

Stop juggling spreadsheets. Tallium AI runs invoicing, VAT & corporate tax, POS and inventory in one simple app.

More free tools

See all free tools