# Inventory Tracking Spreadsheet Excel (Free)

> Free Excel inventory tracker: log stock received and sold, see stock on hand and value, get a reorder list with suppliers, and read it all on a dashboard.

Source: https://softwiro.com/templates/inventory-tracker
Language: English
Softwiro, softwiro.com

---

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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-inventory-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-inventory-tracker-blank.xlsx)

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

| Year shown | 2026 | Change the year and currency on the Settings sheet. Stock figures are always live, as of the last movement logged. |  |  |
| --- | --- | --- | --- | --- |
|  |  |  |  |  |
| Items tracked | 14 | Items to reorder |  | 3 |
| Units on hand | 566 | Items out of stock |  | 1 |
| Stock value at cost | 1,697.65 | Estimated cost of reorder |  | 686.00 |
| Stock value at sale price | 3,753.34 | Units sold (all movements) |  | 647 |
| Month | Units received | Units sold | Status | Items |
| Jan | 0 | 0 | OK | 10 |
| Feb | 0 | 0 | Reorder | 3 |
| Mar | 0 | 0 | Out of stock | 1 |
| Apr | 0 | 0 |  |  |
| May | 0 | 0 |  |  |
| Jun | 0 | 0 |  |  |
| Jul | 0 | 0 |  |  |
| Aug | 0 | 0 |  |  |
| Sep | 0 | 0 |  |  |
| Oct | 228 | 431 |  |  |
| Nov | 150 | 216 |  |  |
| Dec | 0 | 0 |  |  |

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](https://softwiro.com/tools/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](https://softwiro.com/templates/stock-count-reconciliation). To follow the money that comes in and goes out, pair this tracker with the [cash book template](https://softwiro.com/templates/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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-inventory-tracker.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-inventory-tracker-blank.xlsx)

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 sheet | In 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](https://softwiro.com/product/accsys) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type each movement | Sales and deliveries are recorded from the till and the supplier invoice |
| One list for one place | Stock by location with transfers between branches |
| Reorder list you read | Purchase orders created and sent to suppliers automatically |
| Unit cost updated by hand | Cost worked out from your real purchase prices |
| Charts in the workbook | A live stock dashboard on the owner's phone |

### Extra features in the app

- Scan a barcode at the till and the sale takes the unit out of stock by itself
- Stock kept in step across several shops and a warehouse, with transfers between them
- An alert to your phone or to the supplier when an item hits its reorder level
- Purchase orders created and sent from the reorder list, then matched to the delivery
- Batch and expiry dates, with the oldest stock sold first
- Several staff recording movements at once, each with their own permissions

[Ask for your custom system](https://softwiro.com/contact)

## 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](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](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Shops and stores

## More free templates

- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Customer Statement Template with Aging (Excel)
- Installment Payment Tracker for Excel
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Multi-Location Inventory Spreadsheet for Excel
- Expense Tracker Template for Excel
- Monthly Household Budget Template for Excel
- Cash Flow Forecast Template for Excel (12 Months)
- Fixed Asset Depreciation Schedule for Excel
- Gym Membership Tracker for Excel
- Freelance Project and Invoice Tracker for Excel
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
