← Inventory Management

Free Google Sheets Inventory Template, Ready to Use

A free Google Sheets inventory template with items, suppliers, stock in, stock out and a stock tab that updates itself. Get it in your own Drive in two minutes.

6 min read

The quickest way to get a working Google Sheets inventory template is to let Fixeets Inventory create it for you. It is free: open the web app or the Google Sheets add-on, sign in with Google, and Fixeets creates an inventory spreadsheet in your own Google Drive with the tabs already set up: Items, Suppliers, Inbound, Outbound / Returns, Stock and a stock count tab. You then record each delivery and each withdrawal as a movement, and the Stock tab works out what you have on hand.

If you would rather build your own sheet from scratch, the second half of this page gives you the columns and formulas to do it.

Key takeaways

  • A good inventory template separates the item list from the movements. Stock on hand is calculated, never typed.
  • Fixeets creates that structure for free in your own Google Drive, and adds the web app, the phone app and barcode scanning on top.
  • The free plan covers 1 user, 10 items and 30 stock outs and returns a month. Paid plans are priced per warehouse, not per user.

What is in the Fixeets inventory template

Every tab has a header row and named columns, so the file stays readable even if you never open the app. These are the tabs in the English version of the file:

TabWhat it holdsMain columns
ItemsYour item list, one row per itemItem ID, Item Name, Description, Category, Unit Price, Currency, Unit of measure, Barcode, Supplier ID, Safety Stock
SuppliersWho you buy fromSupplier ID, Company, Email Address, Phone, Address, City, Postal Code, Country
InboundEvery stock in (deliveries, production, corrections)ID Inbound, Date, Item ID, Quantity, Unit Price, Supplier ID, Location, User
Outbound / ReturnsEvery stock out and every returnID Out / Return, Out / Return, Date, Item ID, Quantity, Location, User
StockQuantity on hand per item and location, calculated by the appItem ID, Item Name, Category, Quantity, Unit of measure, Location
Inv-TemplatePhysical counts: counted quantity and the correction to applyInventory Quantity, Correction to be made

Two more tabs appear when you turn the matching option on: Orders, for purchase orders to your suppliers, and Kit, for items sold or used as a bundle.

The Stock tab is the one rule to remember: the app writes it, so you never edit a quantity by hand. You record what happened (20 boxes received, 3 taken out for a job) and the stock follows. That is what keeps the history honest when several people use the same file.

How to get the template in your Google Drive

  1. Open the Fixeets Inventory web app, or install the add-on from the Google Workspace Marketplace and open it from a blank Google Sheets file.
  2. Sign in with your Google account and create your inventory file.
  3. Add your items: type them in, or import the item list you already keep in Excel or Google Sheets.
  4. Record your starting quantities as stock in, then record movements as they happen, from a computer or from the iPhone and Android apps.

The file belongs to you. You can open it in Google Sheets, filter it, build charts on it or share it like any other spreadsheet.

Why not just copy a blank spreadsheet?

A blank template works well for one person and a short item list. The friction shows up later, and it is always the same:

  • Quantities get typed over. Someone corrects a number directly in the stock column, and nobody can say afterwards why it changed.
  • Two people edit the same row. The last save wins, and a withdrawal disappears.
  • Low stock is noticed too late. A formula can colour a cell red, but someone still has to open the file to see it.
  • Nobody records from the shelf. Typing into a spreadsheet on a phone is slow, so movements get written on paper and entered at the end of the day, or not at all.

Fixeets keeps the same Google Sheet and adds what a template cannot do on its own: forms that record movements one at a time, a phone app with barcode and QR code scanning, safety stock alerts, physical counts that show the gaps before you apply them, and per-person permissions on the paid plan.

Build your own Google Sheets inventory template

If you prefer to start with a plain spreadsheet, keep the same logic as the Fixeets file: one list of items, one log of movements, and stock calculated from the log.

Tab 1, Items. Columns: Item ID (A), Item Name (B), Category (C), Unit (D), Safety Stock (E), On Hand (F), Status (G).

Tab 2, Movements. Columns: Date (A), Item ID (B), Type (C, either In or Out), Quantity (D), Who (E), Note (F). Never delete a row here: if a movement was wrong, add a correcting movement.

Stock on hand. In Items, cell F2:

=SUMIFS(Movements!D:D, Movements!B:B, A2, Movements!C:C, "In") - SUMIFS(Movements!D:D, Movements!B:B, A2, Movements!C:C, "Out")

Reorder status. In Items, cell G2:

=IF(F2<=E2, "Reorder", "OK")

Add a data validation list on the Type column (In, Out) and on Item ID (a range from the Items tab) so nobody types a reference that does not exist. Then add conditional formatting on column G to highlight "Reorder" in red.

This sheet will serve a small, stable item list well. When you need several people recording at the same time, phone scanning or more than one warehouse, that is the point where inventory management software built on Google Sheets saves more time than it costs. Our guide on when an inventory template stops keeping up goes through the signs.

What the free plan includes

Free (Standard)Enterprise
Users1Unlimited
Items10Unlimited
Stock outs and returns30 a monthUnlimited
Stock inUnlimitedUnlimited
Barcode and QR codesYesYes
Physical countsYesYes
PriceFreePer warehouse, see pricing

Stock in never counts toward the free limit, and reservations are not counted until they become a real stock out.

FAQ

Is there a free Google Sheets inventory template?

Yes. Fixeets Inventory creates a free inventory template in your own Google Drive, with Items, Suppliers, Inbound, Outbound / Returns, Stock and a count tab already set up. The free plan covers 1 user, 10 items and 30 stock outs and returns a month.

Can I use the template without the Fixeets app?

Yes, it is a normal Google Sheets file you can open, filter and share. The Stock tab, though, is calculated by the app from your movements, so record stock in and stock out through Fixeets if you want the quantities to stay right.

Can I import my existing Excel inventory?

Yes. Add your items by importing the list you already have, instead of typing them one by one. You can also ask Claude to import a file for you through the Fixeets Inventory connector.

Does the template work on a phone?

The file opens in the Google Sheets app, but recording from a phone is easier with the Fixeets Inventory app for iPhone and Android, which adds barcode and QR code scanning. Every movement saved on the phone lands in the same Google Sheet.

How do I get low stock alerts in Google Sheets?

Give each item a safety stock. When the quantity on hand drops to that level, Fixeets flags the item as low so you can reorder in time. It is an alert, not an automatic order: you decide what to buy, and you can turn the list into a supplier purchase order.

Is my data stored by Fixeets?

No. Your inventory lives in the Google Sheet in your own Drive. Fixeets reads and writes that file when you use the app.


We use cookies to see how visitors use fixeets.com and to measure our advertising, so we know what to build and fix next. Learn more