SalesHero

Free Inventory List Templatefor Excel & Google Sheets,with a Stock Count Sheet

Keep track of every item you stock: item code, location, quantity, reorder level and cost. The template works out your stock value, flags items to reorder and shows the variance after a stock take. Free, no sign-up.

  • Excel, Google Sheets & PDF
  • Formulas set up
  • No sign-up
The free inventory list template open in Excel: item code, name, category, unit, location, quantity, reorder level, unit cost, stock value and status columns, with a summary of 5 items, RM 1,230.30 stock value and 2 items to reorder

Download the inventory list template

One file, three sheets: Inventory List, Stock Count and How to Use.

Recommended

Excel template.xlsx · Excel 2010 or later

The full template with formulas: stock value, reorder status, the summary at the top and the stock count variance. Ready for 300 items.

Download Excel

Google Sheetsthe same file, opened in Google Sheets

  1. Download the Excel file.
  2. Upload it to Google Drive.
  3. Open it with Google Sheets. The formulas keep working.
Download for Google Sheets

Printable PDFA4 landscape · 2 pages

A blank inventory list and a blank stock count sheet, to fill in by hand on a clipboard while you walk the shelves.

Download PDF
  • Free for business use
  • No sign-up or email
  • Change it as you like
Made in Malaysia by SalesHero · amounts in RM
  • Stock value in RM
  • Reorder alerts
  • Stock count sheet
  • Variance by item
  • Bin locations
  • 300 rows ready
  • Prints on A4
  • Free, no sign-up

Inventory List sheet

What Your Inventory ListShould Include

Every column in the template, what to type in it, and an example. The columns marked "Auto" are worked out by formulas.

ColumnWhat to enterExample
Item code (SKU)The code you use for the item in your accounting or POS system. One code per item, never reused.SKU-10023
Item nameA name anyone in the warehouse would recognise, with size or pack where it matters.Paint thinner 1L
CategoryA group for filtering and totals, such as product line or brand.Paint & solvent
UnitHow you count it. Pick from the drop-down: PCS, BOX, CTN, PKT, KG, L and more.BTL
Location / binWhere it is kept, as zone-aisle-rack or a bin code, so anyone can find it.A-01-03
Qty in stockHow many units you have now. Update it the day stock comes in or goes out.48
Reorder levelThe quantity at which you need to order again.20
Reorder qtyHow much you usually order from the supplier.60
Unit cost (RM)What one unit costs you, for the stock value.6.50
Stock value (RM)AutoNothing: quantity × unit cost, added up in the summary at the top.312.00
StatusAutoNothing: shows Reorder in red when the quantity is at or below the reorder level.OK
SupplierWho you buy it from, so the reorder list tells you who to call.Kim Hin Trading
Last countedThe date the item was last physically counted.03/11/2026

4 steps

How to Use theInventory List Template

  1. 1

    Download the template

    Download the Excel file. It also opens in Google Sheets. Print the PDF if you count on paper.

  2. 2

    Add your items

    Replace the five example rows with your items: one row per item, with the same item code as in your accounting system.

  3. 3

    Set reorder levels

    Enter the reorder level for each item. When stock falls to it, the status turns to Reorder in red.

  4. 4

    Update and count

    Update quantities the day stock moves, and use the Stock Count sheet to count and see the variance by item.

Real screenshots

See Inside theInventory Spreadsheet

One Excel file with three sheets, plus a printable PDF. These are the real files you download; the stock count shows example counts.

Stock Count sheet

A stock take sheet that fills itself in

Item codes, names, locations and system quantities come straight from the Inventory List. Type what you count; the variance and its value in RM are worked out, and the total at the top shows what is missing.

The Stock Count sheet in Excel: system quantity and counted quantity for each item, with variances of -3 shown in red and a net variance value of RM -17.40

How to Use sheet

Instructions anyone can follow

Hand the file to a new storekeeper: the third sheet explains every step in plain words.

The How to Use sheet in Excel with five steps: set up your items, set reorder levels, keep it up to date, count your stock and add more rows

Printable PDF

For counting on a clipboard

Two A4 landscape pages: a blank inventory list and a blank stock count sheet, 25 rows each.

Page 1 of the printable PDF: a blank A4 landscape inventory list with columns for item code, item name, category, unit, location, quantity, reorder level, unit cost and supplier Page 2 of the printable PDF: a blank stock count sheet with columns for location, item code, item name, unit, system quantity, counted quantity, variance and notes

Label every item and shelf on your list

Turn the item codes and locations in this template into Code 128 barcode labels: paste the rows from Excel into our free barcode generator and print a whole label sheet at once.

Free barcode generator

Inventory management tips

How to Keep YourInventory List Accurate

An inventory list only helps if people trust it. These six habits keep the numbers in your spreadsheet close to what is on the shelf, and they are the same habits a warehouse management system builds into every scan.

Location labels such as A-01-01 and A-01-02 with barcodes along a pallet rack beam
  • One code per item

    Use the item code from your accounting system, and never give two items the same code or one item two codes.

  • Count in one unit

    Decide whether an item is counted in pieces, boxes or cartons, and stick to it. Mixing units is the quickest way to a wrong number.

  • Give every item a location

    Label racks and bins with codes like A-01-03 and record them on the list, so stock is found, not searched for.

  • Record movements the same day

    Update quantities when goods arrive and when orders leave, not at the end of the week from memory.

  • Count a little, often

    Count a few locations every week (a cycle count), with fast movers more often, instead of one big stock take a year.

  • Check variances before you adjust

    When a count doesn't match, recount and look for unrecorded receipts or returns before you change the number.

A spreadsheet records your stock. It can't see your warehouse.

Every number in an inventory list is typed in by someone, after the fact. That works for a small store room. It stops working when many people receive, pick and pack all day.

StoreHero WMS

When Your Inventory SpreadsheetStops Being Enough

  • The sheet never matches the shelf

    Every stock take ends in a long list of variances nobody can explain.

  • Several people keep their own copy

    Office, storekeeper and sales each have a version, and none is up to date.

  • Wrong items get shipped

    Pickers work from printed lists, and mistakes are found by the customer.

  • A stock take takes the whole weekend

    Counting on paper and typing it in again keeps the warehouse closed.

  • You find out stock ran out when a customer orders

    The reorder alert only works if the quantity was updated in time.

A car paint wholesaler's storekeeper picking orders with the StoreHero warehouse management system
Fewer picking mistakes with StoreHeroCustomer story: car paint wholesaler · 1:29

With StoreHero, your team scans to receive goods, picks from a guided list, scans again before packing and runs stock takes on a PDA, smart scanner or Android phone. Stock is tracked down to each bin, the office sees every step live, and stock stays in sync with SQL Accounting and AutoCount.

See how the StoreHero warehouse management system keeps stock right without anyone retyping a spreadsheet.

FAQ

Inventory List Template FAQ

Questions about inventory lists, stock counts and the template.

Download the template
01

What is an inventory list?

An inventory list is a record of every item a business keeps in stock: its item code, name, unit, where it is stored, how many are on hand and what they cost. It tells you what you have, where it is and when to order more.

02

What should an inventory list include?

At least an item code (SKU), item name, unit of measure, storage location, quantity in stock, reorder level and unit cost. This template adds category, reorder quantity, supplier, last counted date and notes, and works out the stock value and reorder status for you.

03

How do I make an inventory list in Excel?

Make one column for each detail (item code, name, unit, location, quantity, reorder level, unit cost), one row per item, and add formulas for stock value and reorder status. Or download this free template, where all of that is already set up for 300 items.

04

Can I use this inventory template in Google Sheets?

Yes. Upload the Excel file to Google Drive and open it with Google Sheets, or use File > Import in a new sheet. The formulas, drop-down list and reorder colours keep working.

05

How does the reorder alert work?

Each item has a reorder level. When the quantity in stock falls to that level or below, the Status column shows Reorder in red, and the summary at the top counts how many items need ordering. Filter the Status column on Reorder to get your buying list.

06

How do I do a stock take with this template?

Open the Stock Count sheet: it already lists every item with its location and system quantity. Count one location at a time, type the counted quantity, and the sheet shows the variance and its value in RM. Check each variance before you change the quantity on the inventory list.

07

How often should I update my inventory list?

Every day that stock moves: record goods received and goods sent out on the same day. Count fast-moving items every week or month, and do a full stock take at least once a year, before your financial year end.

08

What is the difference between an inventory list and a stock count sheet?

The inventory list is your running record of what should be in stock. The stock count sheet is what you fill in when you physically count, so you can compare the two and find the variance: stock that is missing, damaged or was never recorded.

09

Can I add barcodes to my inventory list?

Yes. Use the item codes and locations from your list to make Code 128 barcode labels with our free barcode generator: paste the rows straight from Excel and print a whole label sheet at once.

10

When should I move from a spreadsheet to an inventory system?

When several people pick, receive and count every day, the spreadsheet is always behind, wrong items get shipped, or a stock take takes a whole weekend. Then a warehouse management system like StoreHero WMS records every receipt, pick and count by barcode scan as it happens.

11

Is this inventory list template free for business use?

Yes. It is free to download with no sign-up or email, and you may use and change it for your business as you like.

Free demo

Stock Listed.Now Keep It Right.

See how wholesalers and distributors receive, pick, pack and count stock by scanner instead of updating spreadsheets. Book a free online demo or a free consultation.

Three smiling warehouse staff in orange shirts and caps handing over packed boxes

Ready to modernize your B2B sales workflow?

Cut down on manual labor and reclaim your time with our automated ordering system. Built for the modern wholesaler.