Inventory basics for small shops

You do not need expensive software to keep stock under control. A clear spreadsheet answers the three questions that matter.

What do I have?

Count opening stock, add what comes in, subtract what goes out. The template does the arithmetic for every product.

What is selling?

Sort by units sold over the month. Your top sellers deserve the best shelf space and the most reliable reorder plan.

When do I reorder?

Set a reorder point for each item. The sheet flags anything that drops below it so you never run out of a best seller.

Start with the Retail Inventory Tracker template, then add the Daily Sales Tracker to see what sells each day.

Get the templates behind this post

Join free and download 3 items every month, or upgrade for the full library. See plans