Inventory Spreadsheet Template for Small Businesses
James Walker
Most small shops start their inventory spreadsheet the same way: a list of product names and a quantity column, typed up in an afternoon. It works until the shop gets busy. Then a bestseller sells out without warning, a supplier asks for a SKU you never recorded, and nobody knows whether the "12" in the sheet was counted last Tuesday or last spring. A useful inventory spreadsheet answers three questions at a glance: what you have, where it is, and when to order more. The template below does that with eleven columns.
Direct answer. An inventory spreadsheet template for a small business needs one row per item and these columns: SKU (as text), item name, category, location, on hand, reorder level, reorder quantity, unit cost, supplier, last counted and status. Copy the CSV below into Excel, Google Sheets or Numbers, set the formats, and record a full count.
The Inventory Spreadsheet Template: Columns and Formats
Each column earns its place by answering a question someone in the shop will ask. Here is what goes in each one and how to format it.
| Column | What goes in it | Format |
|---|---|---|
| SKU | Your unique item code, e.g. CND-0412 | Text |
| Item name | Short, specific name including size or color | Text |
| Category | Product group for filtering | Dropdown (your categories) |
| Photo | Product image so anyone can match row to shelf | Image |
| Location | Where the stock sits: shelf, bin, room | Text |
| On hand | Units currently in stock | Number |
| Reorder level | Count that triggers a new order | Number |
| Reorder qty | How many units to order each time | Number |
| Unit cost | What you pay per unit, before shipping | Currency |
| Supplier | Vendor name (contact details on a second tab) | Text |
| Last counted | Date of the most recent physical count | Date |
| Status | Current state of the item | Dropdown: In stock / Low / On order / Discontinued |
Two columns do most of the work. Reorder level turns the sheet from a record into a warning system. Last counted tells you how much to trust the number next to it. A quantity that was counted yesterday is a fact; one last counted in March is a guess.
Copy the Template as a CSV
Paste this block into a text file saved as inventory.csv, or straight into cell A1 of a blank sheet and split it into columns. The sample rows are for a small home goods shop; replace them with your own. The Photo column is left out because images live in cells, not in CSV text.
SKU,Item name,Category,Location,On hand,Reorder level,Reorder qty,Unit cost,Supplier,Last counted,Status
CND-0412,Soy candle 8oz - Fig,Candles,Shelf A2,38,52,96,4.20,Wickline Supply,2026-10-06,Low
CND-0415,Soy candle 8oz - Cedar,Candles,Shelf A2,71,52,96,4.20,Wickline Supply,2026-10-06,In stock
MUG-0108,Stoneware mug - Sand,Ceramics,Bin C4,24,18,36,6.75,Hollow Clay Co,2026-09-29,In stock
TWL-0230,Linen tea towel - Sage,Textiles,Shelf B1,9,15,40,3.10,Northloom,2026-10-06,On order
MUG-0102,Stoneware mug - Speckle,Ceramics,Bin C3,0,0,0,6.75,Hollow Clay Co,2026-09-29,Discontinued
Before pasting, format the SKU column as text. If your SKUs are plain numbers like 00412, most spreadsheet apps will strip the leading zeros and store 412, which then fails to match your supplier's invoices and your store's product feed. Letter prefixes such as CND- or MUG- sidestep the problem and make SKUs readable at a glance.
Build the Formatted Version With a Prompt
If you'd rather skip the formatting, paste this prompt into Playyy's AI spreadsheet generator and it builds the sheet with the column formats, dropdowns and sample rows in place:
Create an inventory spreadsheet for a small home goods shop.
Columns: SKU (text), Item name (text), Category (dropdown: Candles,
Ceramics, Textiles, Gifts with colored labels), Photo (image),
Location (text), On hand (number), Reorder level (number),
Reorder qty (number), Unit cost (USD currency, 2 decimals),
Supplier (text), Last counted (date), Status (dropdown with colored
labels: In stock green, Low amber, On order blue, Discontinued gray).
Bold header row, columns sized to their content, 8 realistic sample rows.
Add a second tab called Suppliers with Supplier, Contact name, Email,
Lead time (days) and Minimum order (currency).
From there you edit by chat: add a Variant column, move Location next to SKU, or restyle the header. The Photo column takes uploaded or AI-generated images, up to 10 per cell, so each row can show the product itself. Clean shots on a plain backdrop from a white background tool read best at thumbnail size. You can also ask questions of the data, such as "which items are marked Low?" or "who supplies the linen towels?", and when you need a stock value total, the Playyy agent works out totals from the data and writes them in as values. When you're done, export to Excel (.xlsx) or CSV, or import an existing workbook and have each tab become its own sheet.
How to Set Reorder Levels That Actually Work
A reorder level is the stock count at which you place an order, set high enough that new stock arrives before the shelf empties. The math takes two numbers you already have:
- Average daily sales. Units sold over the last 30 or 60 days, divided by the number of days.
- Lead time. Days between placing an order and having the stock on your shelf, including shipping and the day it takes you to unpack it.
Multiply them, then add a safety buffer for the weeks when sales spike or the supplier runs late. The fig candle in the template sells about 4 a day and Wickline takes 10 days to deliver: 4 × 10 = 40 units of lead time demand, plus a buffer of 12, gives a reorder level of 52. At 38 on hand, it's already past the line, which is why its status reads Low.
For a more rigorous buffer, ShipCalm's reorder point guide gives a safety stock formula of maximum daily sales × maximum lead time, minus average daily sales × average lead time. It uses your own worst-case history rather than a rounded guess, which makes it a better fit for seasonal items.
If you work in Excel or Google Sheets, two formulas make the sheet flag itself. Add a Stock value column with =E2*H2 (on hand × unit cost), and set Status automatically with =IF(E2<=F2,"Low","In stock"). A conditional formatting rule that shades the row when E2 is less than or equal to F2 makes low items visible from across the room. Microsoft's free Excel inventory templates include an inventory list with reorder highlighting built on the same idea, if you'd rather start from a file.
Reorder quantity is the other half. Order enough to cover the time until your next likely order, rounded to the supplier's case size or minimum order. For the candle, 96 units is two cases and roughly three weeks of sales.
Keep the Numbers Accurate After Week One
A template only stays useful if the counts in it stay true. Three habits do most of the work.
Give the sheet one owner. One person approves changes to on-hand counts, reorder levels and SKUs. Others can read it and report problems, but when five people edit quantities from memory, nobody can tell which edit was wrong.
Run cycle counts instead of one big count. After a full baseline count, count a slice of the inventory each week. Fast sellers and expensive items get counted weekly; slow movers go on a monthly rotation. Update Last counted every time. Counting before opening, when nothing is moving, avoids the classic error of counting a shelf while a sale is half rung up.
Record stock the day it moves. Receive deliveries against the sheet the day they arrive, and note damaged, sampled or returned units with a short reason in a Notes column. Drift between the sheet and the shelf usually starts with small, unrecorded adjustments like these.
Template Variations by Business Type
The core eleven columns work almost everywhere. A few swaps tailor the inventory template to how your business actually holds stock.
Retail and ecommerce. Add Variant (size, color), Barcode and Channel (store, Shopify, Etsy, Amazon) columns, and keep one row per variant since each one runs out on its own schedule. If you also sell online, the same product photos can feed your listings and ecommerce catalogs.
Apparel brands with many sizes per style often split each collection into its own tab; starting a clothing brand covers how small batch runs shape those reorder decisions.
Restaurant and cafe supplies. Replace Reorder level with Par level, the amount you want on hand at the start of each service, and add Unit of measure (case, kg, each), Storage (dry, fridge, freezer) and Use by date. Count perishables at the same point every week, usually before the delivery arrives, so the order you place reflects what's really there.
Small warehouse or equipment. For tools and assets you lend out rather than sell, swap reorder columns for Asset tag, Serial number, Assigned to, Condition (dropdown: Good / Needs repair / Retired), Checked out (checkbox) and Last service date. This version tracks where each item is and who has it rather than when to buy more.
Common Inventory Spreadsheet Mistakes
- Mixing units. One row counted in cases and the next in single units makes every total wrong. Write the unit into the item name or add a Unit column.
- Numeric SKUs without text formatting. Leading zeros vanish and lookups break.
- Several copies of the file. A copy on the laptop, one in email and one on the shop iPad means three versions of the truth. Keep one shared file.
- Reorder levels set once and forgotten. Sales change with the season. Revisit reorder levels every quarter and before your busiest month.
- Typing totals by hand. Typed stock values go stale the moment a count changes. Use a formula in Excel or Sheets, or recalculate when you update counts.
Start With the Columns, Then the Habits
An inventory spreadsheet earns its keep through two things: columns that answer real questions (where is it, how many, when to reorder) and a counting routine that keeps those answers true. Copy the CSV above, set SKU to text, record one full count, and set reorder levels from your own sales and lead times. For the formatted version with dropdowns, colored status labels and product photos ready to fill, paste the prompt above into Playyy, then send each product shot through the background remover so every row gets a clean thumbnail.
Keep Reading
- Ecommerce Product Photography: The Complete Guide — product shots that work in listings and in your inventory sheet.
- How to Remove Backgrounds from Product Photos for Free — clean thumbnails for every SKU.
- How to Look Like a Real Brand on Shopify — the storefront side of a growing product catalog.
- A Simple Project Tracker Template for Excel — the same row-per-item approach applied to tasks.
James Walker
I help Shopify and Amazon sellers improve product images, promotional banners and ad creatives. I focus on practical visual improvements that help products look more credible and conversion-ready — no design jargon, just what works.
Frequently asked questions
Start with one row per item and these columns: SKU, item name, category, location, on hand, reorder level, reorder quantity, unit cost, supplier, last counted and status. Format SKU as text, quantities as numbers, cost as currency and status as a dropdown. Enter a full physical count once, then update the sheet every time stock arrives or leaves.
