# Multi-warehouse inventory Excel with transfers (free)

> Free Excel multi-warehouse inventory: stock in, out, transfers between branches, balance per warehouse, per-branch minimum alerts and transfer suggestions.

Source: https://softwiro.com/blog/multi-warehouse-inventory-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Multi-warehouse and branch inventory in Excel (free) + online version

See every item's balance in every warehouse, spot the branch that is short, and move stock from where there is a surplus before you buy.

13 November 2026 5 min read

## In short

- List up to 6 warehouses and branches, give each item a minimum level per warehouse, and log everything in one movements log.
- A transfer is one row: the quantity leaves the sending warehouse and enters the receiving one, so the item's total does not change.
- Balance = in + adjustment - out - transfers out + transfers in, per item per warehouse, with negatives in red.
- The sheet suggests the biggest transfer per item from the warehouse with the most surplus to the branch most short, and what is left to buy.

You have a main warehouse and two or three branches, and you want to know without phone calls how much of each item is in each branch, which branch is about to run out while another has too much, and whether to transfer or buy. The free [multi-warehouse and branch inventory sheet](https://softwiro.com/templates/multi-warehouse-inventory) answers this from one movements log you type and a minimum level you set for each branch.

## The problem it solves

When a shop has several storage places, books multiply and each branch's balance lives in its keeper's head. A branch orders batteries from the supplier while the main warehouse has twenty idle. An item is moved between warehouses, the exit is written and the entry is forgotten. One place shows a shortage, another a surplus, the total looks right and nobody knows where the mistake is. The sheet treats a transfer as one movement that leaves one warehouse and enters another.

## How it works, step by step

1. In المخازن (Warehouses) write the names of your warehouses and branches (up to 6).
2. In الأصناف (Items) write code, name, category, unit and unit cost, then a minimum level for each warehouse: a small branch needs less than the main warehouse.
3. In الحركات (Movements) log each operation as one row: stock in, out, transfer or adjustment. The opening balance of each warehouse is a stock-in row dated at the start of the period.
4. For a transfer you pick the sending and the receiving warehouse; the quantity leaves the first and enters the second.
5. الأرصدة (Balances) calculates each item's balance per warehouse = in + adjustment - out - transfers out + transfers in.
6. النواقص (Shortages) works out, per item and branch, the gap under the minimum and the surplus available, which feeds اقتراحات التحويل (Transfer suggestions) and إعادة الطلب (Reorder).

## What each sheet does

- الإعدادات (Settings): the surplus multiplier. Surplus is what exceeds the minimum multiplied by it.
- المخازن (Warehouses): names, with each warehouse's stock value, items under minimum and negative balances.
- الأصناف (Items): basic data and a minimum for each warehouse.
- الحركات (Movements): the single log, with a check column that catches a wrong code, an unknown warehouse or an incomplete transfer.
- الأرصدة (Balances): the item by warehouse matrix with totals and value; negatives in red.
- النواقص, اقتراحات التحويل, إعادة الطلب: what is short and where, what can be transferred, what must be bought.
- الملخص (Summary): the big numbers and four charts.

## A walk-through with the sample numbers

These numbers are sample data inside the sheet, not a real shop: 4 warehouses (a main warehouse in Cairo and three branches), 10 items and 70 movements: 41 stock-in, 24 stock-out, 3 transfers and 2 adjustments.

- Sugar: 280 in the main warehouse, 60 in Nasr City, 32 in Giza and 13 in Alexandria, where the minimum is 20. The shortage is 7 and the main warehouse has a surplus of 80, so the sheet suggests moving 7 from it to Alexandria.
- AA batteries: the Giza branch started with 6 and sold 4 then 4, so its balance is -2. It shows in red as a negative balance and an alert in the summary. Its gap to the minimum (5) is 7, covered by a transfer of 7 from the main warehouse.
- Soap: short by 5 in Nasr City, 20 in Giza and 2 in Alexandria, 27 in all, and nobody has a surplus. So it is not a transfer but a purchase on Reorder: 27 units costing 324.
- Tissues: 5 were moved from Nasr City to Giza, leaving 10 in Nasr City (minimum 12) and 25 in Giza, while the item's total did not change.
- A row with code Z99: typed by mistake; the check column says the code does not exist and it enters no balance.

In total: stock value is 76,341 at cost, of which 56,830 is in the main warehouse, 8,700 in Nasr City, 5,405 in Giza and 5,406 in Alexandria. There are 13 cases of an item under its minimum in a branch, 8 transfer suggestions worth 1,436, and one item that needs buying. The highest-value item is rice at 25,800, then oil at 12,000.

## Common mistakes

- Logging a transfer twice, once as an issue from one warehouse and once as a receipt in another. A transfer is one movement.
- Renaming a warehouse after movements are logged, which turns the old rows into unknown warehouses.
- Typing a negative quantity on a stock-out. Out is positive; negatives are for adjustments only.
- Leaving a branch's minimum empty, so the sheet never warns you.
- Forgetting to log a sale in a branch, so its balance looks higher than reality.

## When it is not enough

The sheet relies on someone typing every movement, and on one file opened by one person at a time. When each branch sells all day, and each keeper should see only his warehouse and confirm receipt of a transfer, a program on your own terms helps, and Softwiro can [build you a custom one](https://softwiro.com/contact). Once balances settle, run a periodic count with the [stock count and reconciliation sheet](https://softwiro.com/templates/stock-count-reconciliation). For a one-warehouse shop the [general shop inventory sheet](https://softwiro.com/templates/general-inventory) is enough.

## FAQ

**How do I log a transfer from the main warehouse to a branch?** Choose "transfer", type the code and quantity, pick the sender in the warehouse column and the receiver in "to warehouse".

**When is a balance a surplus?** When it exceeds the warehouse minimum multiplied by the multiplier in Settings.

**Does it hold more than 6 warehouses?** It holds 6 warehouses, 150 items and 1,500 movements.

## Your next step

Download the sheet, clear the examples, type your warehouse names, then log today's balance of each warehouse as opening stock-in rows. After a week of logging, open the transfer suggestions and see what you can move before you buy.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: multi-warehouse inventory (1/3)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-1.jpg)[![Cheat sheet: multi-warehouse inventory (2/3)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-2.jpg)[![Cheat sheet: multi-warehouse inventory (3/3)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/multi-warehouse-inventory/en-3.jpg)

0 downloads · 3 pages

## 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 |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

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

## Questions this raises

### How do I log a transfer from the main warehouse to a branch?

Choose the type "transfer", type the code and quantity, pick the sending warehouse in the warehouse column and the receiving one in "to warehouse". One row removes it from the first and adds it to the second.

### How do I enter the opening balance of each branch?

Log a stock-in row per item per warehouse dated at the start of the period, noted "opening balance". The sheet calculates every balance from the movements.

### When does the sheet treat a balance as surplus?

Surplus = balance - (the warehouse minimum x the surplus multiplier in Settings), never below zero. A warehouse with a zero minimum counts its whole balance as surplus.

### What happens if I type a wrong item code?

The row shows "code does not exist" in red in the check column and is left out of every balance until you correct it.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
