FREE TEMPLATE Excel · Google Sheets · Numbers · 6 sheets
Inventory and warehouse spreadsheet template.
Free, and ready to become an app.
Track items, stock levels, reorder points and bin locations alongside the orders, shipments, suppliers and warehouse moves that change them. Download the workbook free. When the counts need to be right for everyone at the same time, describe it to Tadabase AI and it builds the inventory app, with low-stock alerts that actually fire.
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
WHAT'S INSIDE
6 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Inventory
Every item with its category, current stock, reorder level, storage location and status.
Item ID · Item Name · Category · Stock Level · Reorder Level · Location · Status
-
Orders
Customer orders against items, with quantities and order and shipping dates.
Order ID · Customer Name · Item ID · Quantity · Order Date · Shipping Date · Status
-
Shipments
Carrier, tracking number and delivery date for every order that left the building.
Shipment ID · Order ID · Carrier · Tracking Number · Shipping Date · Delivery Date · Status
-
Suppliers
Supplier directory with contact person, email, phone and address.
Supplier ID · Name · Contact Person · Email · Phone · Address
-
Warehouse Operations
Receiving, packing and restocking moves, who did them and their status.
Operation ID · Type · Item ID · Quantity · Date · Responsible Person · Status
-
Dashboard & Reports
At-a-glance totals: inventory items, pending shipments and low-stock items, plus a report log.
Metric · Value · Description
WHERE THE SPREADSHEET STOPS
Fine for one person. Hard for a team.
The template works well while one person keeps it. These are the places it starts to cost you time once more people depend on it.
-
Stock does not move by itself
An order or a receipt in one tab does not change the stock level in another. Someone has to remember to update both.
-
Reorder alerts are a colour, not a message
A cell turns red when stock drops below the reorder level, but nobody is told unless they open the file.
-
The floor and the office see different files
Warehouse staff on a phone and buyers at a desk end up with copies that disagree by lunchtime.
TURN IT INTO AN APP
Same structure, with logins and automations.
Pick the prompt closest to how you work. The builder opens with it pre-filled; edit it to match your business, and Tadabase AI builds the tables, roles, screens and workflows. Then import the rows you already have from the spreadsheet.
-
Inventory & warehouse
Inventory and warehouse app
An inventory and warehouse app — items with category, bin location, stock level and reorder point; receiving, picking and restocking moves update stock automatically; when an item falls below its reorder point the buyer gets an email with the supplier's details. Warehouse staff use a phone view to log moves, buyers manage suppliers and purchase orders, and managers see a dashboard of low stock and pending shipments.
-
Inventory & warehouse
Inventory & purchase orders
An inventory system that tracks products and stock by warehouse and bin, alerts the buyer when stock falls below a per-item re-order point, and lets staff raise purchase orders to suppliers with an approval step above a spend threshold. Receiving posts against the PO and updates stock automatically, and every product shows a full movement history — receipts, transfers, adjustments, and sales.
-
Inventory & warehouse
Orders and shipments tracker
An order fulfilment app — orders reserve stock when placed, warehouse staff pack and ship them with carrier and tracking number, the customer gets an email when the order ships and when it is delivered, and managers see late shipments on a dashboard.
Questions about this template.
Straight answers before you download or build.
Is the spreadsheet template really free?
Can stock update automatically when an order ships or a delivery arrives?
Can I bring the data I already have in the spreadsheet?
When should I move from the spreadsheet to an app?
More free spreadsheet templates
- School management Students, teachers, classes, schedules and a parent sheet.
- Order management Orders, customers, products, vendors and shipments.
- Property management Units, tenants, lease applications and work orders.
Keep the structure.
Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can start free.