Skip to content
Warehouse Inventory cover: a sample sheet with bins, pallets stored and space in use and a column chart, beside the Dashboard, Bins and Movements tabs

Warehouse Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (6)

Overview

This template is for a small warehouse, fulfillment room or storage yard that keeps stock on pallets. The Bins tab lists each location with its zone, capacity in pallets, pallets stored, the main SKU and a status that changes to Full, Partial or Empty on its own. The Movements tab logs receipts, shipments, transfers and adjustments by date, bin and operator. The Aisle map grid sketches the layout, and the Dashboard shows space used by zone.

Set the capacity of each bin in pallets, then update pallets stored whenever a movement happens. Keep one SKU per bin where you can, so the main SKU column stays meaningful. Record each movement in the log on the same day, then match the Bins tab to it. When you plan where new stock should go, look at the Full status first, and use the Returns zone for items waiting to be checked.

Useful for

  • Keeping track of pallet space in a small warehouse
  • Logging receipts and shipments by bin and operator
  • Planning where new stock can go before a delivery

What's included

  • 5 tabs: Dashboard, Bins, Movements, Aisle map, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bins: a table
  • Movements: a table
  • Aisle map: a grid
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bins tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I show a bin that is only partly full?

Enter a decimal in Pallets stored, such as 0.5 for half a pallet. The Space used column gives the percent of capacity taken, and the status reads Partial when stock sits between empty and full. Loose stock on the floor can go in its own bin row.

Do shipments reduce the count on the Bins tab?

No. The Movements log is a record only. Update Pallets stored on the Bins tab at the same time you log a shipment, so the space figures stay right.

How do I plan a warehouse layout in this file?

Use the Aisle map tab to sketch each aisle and bay, with a bin code or Free in each space. Keep the labels simple, like A and then a bay number. Match the codes to the bin names on the Bins tab, so the map and the list describe the same places.

  • #inventory
  • #warehouse-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…