Stock and Profit Tracker (Excel Template)

Know exactly what is on your shelf, what to reorder, and what you earn on every sale.

This Excel workbook is built for shops, kiosks, market traders and online sellers. Enter your products once, then record each restock and each sale. Stock levels, stock value, profit and margin update on their own.

What you get:

Products sheet: space for 200 items with cost price, selling price, reorder level and a live status (OK, REORDER, OUT OF STOCK).

Purchases sheet: record stock coming in, with a product drop-down list.

Sales sheet: record stock going out. Leave the price blank to use your list price.

Summary sheet: total sales, total profit, stock value and a month-by-month chart.

A filled-in example copy, so you can see how it works before adding your own items.

A Start Here sheet with step-by-step instructions.

Works in Microsoft Excel 2010 or later, LibreOffice and Google Sheets. Amounts show in Ghana cedis (GH₵). Instant download after payment.