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
| Business | Harbor Home Supply | Report period | 2026-10-01 to 2026-11-30 | ||||
|---|---|---|---|---|---|---|---|
| Locations in use | 3 | SKUs to reorder | 9 | ||||
| SKUs tracked | 12 | Suggested order cost | 1,865.40 | ||||
| Units on hand, all locations | 1,431 | Negative stock (SKU x location) | 1 | ||||
| Stock value, all locations | 13,016.40 | Unknown-SKU rows | 1 | ||||
| Movement rows logged | 39 | Rows over available stock | 1 | ||||
| Location | Units on hand | Stock value | Share of value | SKUs to reorder | Negative SKUs | Units sent out | Units received |
| Main Warehouse | 1,089 | 10,129.20 | 77.8% | 0 | 0 | 142 | 5 |
| Downtown Store | 185 | 1,572.60 | 12.1% | 5 | 0 | 5 | 120 |
| Online Fulfilment | 157 | 1,314.60 | 10.1% | 5 | 1 | 18 | 40 |
| Movement type | Rows | Units | |||||
| Receipt | 5 | 162 | |||||
| Issue | 21 | 258 | |||||
| Transfer | 11 | 165 | |||||
| Adjustment | 2 | -3 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: Locations in use, SKUs tracked, units and value on hand, SKUs to reorder with the suggested order cost, negative-stock count and the movement rows that need fixing. A table per location (units, value, share of value, SKUs to reorder, units sent out and received) and four charts: stock value by location, units sent out and received by transfer, SKUs to reorder by location, and units moved by type.
- Movements: The one log (1,000 rows): date, SKU, type (Receipt, Issue, Transfer or Adjustment), quantity, From location, To location, reference and note. It adds the item name, value, how much the source location held just before the row, and a Check column that flags unknown SKUs, unknown locations, a transfer to the same place and an issue or transfer bigger than what the source held.
- Items: The item master (200 rows): SKU, description, unit, unit cost, reorder point, order-up-to level, supplier and the opening quantity in each location.
- Stock: On hand by SKU and by location, with a total, the same in value, and a Negative stock alert.
- Transfers: Two location-to-location grids, one in units and one in value, with totals out, totals in and the net for each location.
- Reorder: For each SKU, the quantity to order for each location that is at or below its reorder point, the total and the estimated cost, with supplier.
- Settings: Business name, currency symbol, report period and your stock locations (up to 5).
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most free multi-location sheets either copy the same table onto one tab per location or give you a column per site that you overwrite by hand. This one never asks you to type a quantity on hand: every figure comes from the movement log, so a transfer takes stock out of one location and puts it into another from a single row. It also checks each row as you type it, so an issue or transfer larger than the source location holds is flagged straight away. The sample is a home-goods distributor with 12 SKUs, 3 locations and 39 movements in October and November 2026.
How do I track inventory in multiple locations in Excel?
Keep one item list and one movement log, and put the location on the movement, not on the item. Each row has a SKU, a type, a quantity, a From location and a To location. A receipt only has a To location, an issue (a sale or use) only has a From location, and a transfer has both. Stock on hand for a location is then its opening quantity plus everything that went into it, minus everything that left it, which is a SUMIFS on the log.
This is the layout most guides recommend over one worksheet per location, because totals, transfers and reports all read from one place and adding a location is a new name on the Settings sheet, not a new tab.
How do I record a stock transfer between warehouses?
Add one row on Movements: pick the SKU, choose Transfer, type the quantity, then pick the From and To locations. The sheet takes the units out of the first location and adds them to the second, so the total across locations does not change. In the sample, 102 units were moved from Main Warehouse to Downtown Store, 40 to Online Fulfilment, 18 from Online Fulfilment to Downtown Store and 5 back from Downtown Store to Main Warehouse, 165 units in all.
The Transfers sheet shows these as a grid, in units and in value at unit cost, with the net for each location. If a transfer asks for more than the source location holds at that point in the log, the Check column says Not enough stock and the Source on hand before column shows what was there. In the sample, a transfer of 12 desk lamps from Online Fulfilment, which held 2, is flagged and leaves Online Fulfilment at -10 until you correct the row.
How do I set reorder points for each location?
Each SKU has one reorder point and one order-up-to level, used for every location. When a location holds the reorder point or less, the sheet suggests ordering the gap up to the order-up-to level for that location. The Reorder sheet shows the suggestion for each location and the total, with its cost at unit cost. In the sample 9 of the 12 SKUs need an order somewhere, with a suggested cost of 1,865.40.
Check whether another location already holds surplus before you order: moving stock with a Transfer row is often cheaper than a purchase. Lead times, safety stock and minimum order sizes are yours to apply; the suggestion is a starting point.
How to use it
- On Settings type your business name, currency symbol, the report period, and name your stock locations (up to 5): warehouse, shop, online stock, a van.
- On Items add one row per SKU: description, unit, unit cost, reorder point and order-up-to level (both apply to each location), supplier, and the quantity you hold in each location when you start.
- Log every stock event on Movements, one row each: date, SKU, type and quantity. Receipt: put the location in To. Issue (a sale or use): put it in From. Transfer: From and To. Adjustment: location in To, with a minus quantity to remove stock.
- Watch the Check column. It flags unknown SKUs, unknown locations, a transfer to the same place, and an issue or transfer larger than what the source location held at that point.
- Stock shows on hand and value by SKU and location and marks negative stock. Transfers shows how many units moved from each location to each other one.
- Reorder suggests, per location and in total, how much to order. Dashboard sums it up with charts.
Before you start:
- Capacity: 200 items, 5 locations and 1,000 movement rows.
- Starting quantities go in the Opening columns on Items. Do not log that same stock again as a Receipt.
- Stock on hand for a location = opening + receipts, transfers in and adjustments to it - issues and transfers out from it.
- Log movements in the order they happened: the source-stock check for a row looks only at the rows above it.
- A flagged movement still changes stock, so a shortfall shows up as negative stock on Stock until you correct the row.
- Reorder point and order-up-to are one pair of numbers per SKU, used for every location. A location at or below the reorder point is suggested the gap up to the order-up-to level.
- Value is quantity times the unit cost on Items. The currency symbol on Settings is only a label.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
How many locations can the spreadsheet handle?
Up to five stock locations, 200 items and 1,000 movement rows. You name the locations on Settings and they feed the dropdowns, the Stock sheet, the Transfers grids and the Dashboard.
Do I enter the quantity on hand for each location?
Only once, as the opening quantity on the Items sheet when you start. After that, quantities come from the movement log. Do not log the opening stock again as a Receipt.
What does the sheet do when I ship more than a location holds?
The row is flagged Not enough stock in red, and the Source on hand before column shows how many units the source location held. The movement still counts, so that location goes negative on Stock and the Dashboard shows the negative-stock count until you fix the row.
How do I record damaged or counted-different stock?
Use an Adjustment row. Put the location in To and type a minus quantity to remove stock or a plus quantity to add it, for example -2 for two cracked bins.
Does it work with Google Sheets and in other currencies?
Yes. The formulas are the ones Excel 2016, LibreOffice and Google Sheets all calculate, and the currency symbol on Settings is only a label.
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
- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Clothing Store Inventory Spreadsheet (Size and Color) for Excel
- Customer accounts, credit sales and customer statement sheet
- Cash book and customer accounts sheet
- Installments and collection tracker
- General shop inventory tracker (stock in/out, reorder, slow movers)
- Supplier purchase orders and payables tracker
- Periodic stock count and count-difference reconciliation sheet
- Barcode, batch and expiry inventory sheet
- Grocery store management sheet
- Stationery shop and photocopy management sheet
- Electronics shop sheet: serials, warranty and repairs
- Wholesale clothing trade sheet: traders, stock and collection
- Food wholesale and distribution sheet in Excel: routes, expiry and collection
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Online store orders and profit sheet
- Rental portfolio tracker: properties, units, tenants and contracts
- Pharmacy expiry and stock tracking sheet