Softwiro
Free Excel template

Inventory Tracking Spreadsheet for Excel

A free Excel inventory tracking spreadsheet for a shop, workshop, small warehouse or online store. You list your items once with their reorder level, unit cost and sale price. After that you only log what moves: stock received, stock sold, customer returns and count corrections. The sheet works out what you hold, what it is worth, which items are low or out, and what to order from which supplier. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 400 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Year shown2026Change the year and currency on the Settings sheet. Stock figures are always live, as of the last movement logged.
Items tracked14Items to reorder3
Units on hand566Items out of stock1
Stock value at cost1,697.65Estimated cost of reorder686.00
Stock value at sale price3,753.34Units sold (all movements)647
MonthUnits receivedUnits soldStatusItems
Jan00OK10
Feb00Reorder3
Mar00Out of stock1
Apr00
May00
Jun00
Jul00
Aug00
Sep00
Oct228431
Nov150216
Dec00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Items tracked, units on hand, stock value at cost and at sale price, items to reorder and out of stock, the estimated cost of the reorder, and four charts: units received and sold by month, items by stock status, stock value by category, and on hand against reorder level.
  • Inventory: One row per item (300 rows): SKU, name, category, unit, supplier, opening quantity, reorder level, reorder quantity, unit cost and sale price. It adds received, sold, returns and adjustments, stock on hand, stock value, a status of OK, Reorder or Out of stock, and the quantity to order.
  • Movements: The stock log (3,000 rows): date, SKU, type (Received, Sold, Returned or Adjustment), quantity, reference and note. It shows the item name, the change in stock, its value at cost and a Check column for unknown SKUs, missing quantities and missing types.
  • Reorder: Every item that is at or below its reorder level or out of stock, with supplier, on hand, order quantity and estimated cost, plus the total. Up to 60 lines.
  • Lists: Your item categories (up to 20). They feed the category dropdown and the stock-value-by-category chart.
  • Settings: Business name, currency symbol and the year shown in the monthly table.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free inventory sheets are a single list where you overwrite the quantity, so you never know why a number changed. This one keeps a log of every movement and derives the quantity from it, so each figure can be traced to a delivery, a sale or a count. It then turns the figures into a reorder list you can send to suppliers. The sample is a small hardware shop with 14 items and 46 movements in October and November 2026.

How do I track inventory in Excel?

List each item once on the Inventory sheet with a unique SKU and the quantity you hold when you start. Then log every change on the Movements sheet: pick the SKU, pick the type and type the quantity. Received and Returned add stock, Sold takes it away, and Adjustment adds or removes the amount you type, so use a negative number for loss or damage.

The Inventory sheet adds up the log for each SKU, so you never type a balance. In the sample, the claw hammer starts with 24, receives 24 and sells 23, so 25 are on hand. Because every change is a row, you can filter the log by SKU to see why a quantity moved.

How do I set a reorder level?

A reorder level is the stock at which you place a new order, so it should cover the sales you expect while the supplier delivers. A simple way is to take the units you sell in a typical week, multiply by the supplier's delivery time in weeks, and add a small safety margin. The reorder point calculator does that arithmetic for you.

Type the result in the Reorder level column. When on hand reaches that number the status turns to Reorder, and at zero or below it turns to Out of stock. In the sample, four items are flagged: three are at or below their level and one, the extension cord, has run out. The Reorder sheet lists them with a total of 686.00 for the suggested order quantities.

How do I check that my stock records match the shelves?

Count a few items on the shelf and compare the count with the On hand column. If they differ, log the difference as an Adjustment with a note, for example -3 for three missing. The sample does this for the tape measure. The count then matches and the reason is recorded.

For a full periodic count with tolerances and recounts, use the stock count reconciliation sheet. To follow the money that comes in and goes out, pair this tracker with the cash book template.

How to use it

  1. On Settings type your business name, currency symbol and the year to report on. On Lists enter your item categories.
  2. On the Inventory sheet add one row per item: SKU (a unique code), name, category, unit, supplier, the quantity you hold now (Opening qty), the reorder level, the usual reorder quantity, unit cost and sale price.
  3. From then on, log every stock movement on the Movements sheet: date, SKU, type (Received, Sold, Returned or Adjustment) and quantity. Type sold and received quantities as positive numbers.
  4. Use Adjustment for a count correction, damage or loss; type the change as a negative number to remove stock and a positive number to add it.
  5. The Inventory sheet works out stock on hand, stock value and a status for each item: OK, Reorder or Out of stock. The Reorder sheet lists what to order, grouped with supplier and estimated cost.
  6. Open Dashboard for stock value, items to reorder, monthly received and sold units, and charts.

Before you start:

  • Capacity: 300 items, 3,000 movements, 20 categories and 60 lines on the reorder list.
  • Opening qty is what you hold when you start using the sheet. Do not log that stock again as Received.
  • Stock value is quantity on hand times the unit cost on the Inventory sheet. Update the unit cost when your supplier price changes; the value of all stock updates with it.
  • Sales value is the units sold times the sale price on the Inventory sheet, so it uses today's price for every past sale.
  • A movement whose SKU is not on the Inventory sheet is flagged Unknown SKU and does not change any stock.
  • The Dashboard monthly table and chart show the year typed on Settings. The currency symbol is only a label.

Excel file (.xlsx) · 400 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet needs someone to type in every transaction. Accsys deducts the quantity at every sale and works across all the shop's devices at once, even without internet.

In this sheetIn Accsys
You type in every sale and every purchase by hand.Each color and size combination has its own barcode, which is deducted from stock at the sale and returned to stock on a return.
The e-invoice for the tax authority lives in a different system.It issues e-invoices compatible with the Egyptian Tax Authority's ETA system, and sends the invoice on WhatsApp with a payment link.
The sheet sits on one device, and whoever edits it last wins.It works offline, then syncs data across all the shop's devices when the connection returns.
Total sales doesn't tell you how much you earned.A tiered income statement from revenue down to net profit, plus profit and margin for each item.

See Accsys · Ask for a demo

Frequently asked questions

Is this inventory tracking spreadsheet really free?

Yes. Download it, use it in your business and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

How many items and movements can it hold?

300 items, 3,000 movements, 20 categories and 60 lines on the reorder list. When the log is full, save a copy, enter each item's current on hand as its new opening quantity and clear the Movements sheet.

How is stock value calculated?

On hand times the unit cost on the Inventory sheet, and the retail value uses the sale price. It is not a cost-flow method such as FIFO or average cost, so update the unit cost when your supplier price changes. Ask your accountant which method your reports need.

Why does an item show negative stock?

More units were logged as sold than were received or counted. Check for a missing delivery or a wrong quantity; the Check column flags it, and the status shows Out of stock until you fix it.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Shops and stores

More free templates

All templates · Free tools