Inventory Spreadsheet Sample: A Practical Template

How-to basics · Updated November 21, 2026

An inventory spreadsheet sample is a ready-made layout for tracking what you stock, where it is, how many units remain, and when to reorder. The example below works in Excel for Microsoft 365: copy its columns, enter your own items, and use the included formulas to calculate stock value and flag items at or below their reorder points.

Inventory Spreadsheet Sample

This illustrative sample uses one row per product. The quantity and cost figures are examples, not recommended stock levels or prices. The value column is calculated as quantity on hand multiplied by unit cost; the final status column shows whether an item has reached its reorder point.

SKU Item Category Location Qty on hand Reorder point Unit cost Inventory value Supplier Last counted Status
MUG-12 Ceramic mug Kitchen A-01 24 8 $5.00 $120.00 Northstar Oct 28, 2026 OK
CAB-04 USB-C cable Electronics B-02 9 10 $3.50 $31.50 Brightline Oct 28, 2026 Reorder
NOTE-A5 Notebook Stationery C-01 45 12 $1.20 $54.00 Paper Trail Oct 29, 2026 OK
LMP-09 Desk lamp Electronics B-05 6 4 $18.00 $108.00 Brightline Oct 29, 2026 OK
BOX-M Mailing box Packaging D-03 100 25 $0.40 $40.00 Shipshape Oct 30, 2026 OK

In this example, the listed inventory values total $353.50. “Reorder” means the recorded quantity is at or below the entered threshold; it does not place an order or account for incoming shipments. A spreadsheet is only as current as the transactions and counts entered in it.

What Each Column Is For

A useful sheet gives each product a stable identifier and separates identifying details from quantities and costs. A SKU (stock keeping unit) is a practical identifier when item names are similar or change over time. Avoid using the row number as an identifier, because sorting the sheet changes row positions.

  • SKU and item: Identify the product consistently. Keep one SKU per distinct size, color, or other variant if those variants need separate stock counts.
  • Category and location: Help users filter the list and find stock. Use a consistent location scheme, such as aisle and shelf codes, rather than several spellings for the same place.
  • Quantity and reorder point: Record the count currently on hand and the level that should prompt a review. The threshold is a planning aid, not a guarantee that replenishment will arrive in time.
  • Unit cost and inventory value: Make it possible to estimate the value represented by the listed quantities. The sample uses a simple quantity-times-cost calculation; accounting valuation can follow more specific rules.
  • Supplier and last counted: Provide a useful contact reference and help readers judge how recently the physical stock was checked.

Do not add fields just because they sound useful. For a home pantry, a category, quantity, expiration date, and location may be enough. A small retailer might also need SKU, supplier, purchase cost, and reorder threshold. The best design is the smallest one that supports the decisions users actually make.

How to Customize the Sample

Before entering records, decide what one row represents. It might be one product, one product at one location, or one individual asset. If the same product is stored in two places and you need separate counts, use a separate row for each location, with the same SKU and a distinct location value. Otherwise, a single total can hide the fact that one shelf is empty while another still has stock.

Choose consistent units. A quantity of 12 could mean 12 individual pieces, 12 boxes, or 12 cases; mixing those meanings makes totals misleading. If products are tracked in packs, record the pack as the unit or add a clearly defined conversion field. Similarly, label whether cost is per item, pack, or case. Keep dates as actual date values in Excel rather than typed phrases if you plan to sort or filter by date.

Separate inventory records from transaction history when stock changes frequently. A simple sheet can be maintained by directly updating its quantity, but that overwrites the previous count. A transaction log with dates, SKUs, quantities received, quantities issued, and reference notes preserves a trail and can support a more auditable running balance. It takes more setup, so it may be unnecessary for a short list with infrequent changes.

Formulas for Value and Reorder Status

In the sample layout, columns E and G contain quantity on hand and unit cost, respectively. With the first item on row 2, enter this in H2 to calculate its inventory value:

=E2*G2

For the ceramic mug, 24 multiplied by $5.00 returns $120.00. Copy the formula down the value column for the other items. With quantities in E2:E6 and unit costs in G2:G6, the corresponding values are $120.00, $31.50, $54.00, $108.00, and $40.00.

With inventory values in H2:H6, enter this in H7 to calculate the sample total:

=SUM(H2:H6)

The result is $353.50. Format the value cells as Currency or Accounting using the Number group on the Home tab; formatting changes how the number appears, not the underlying calculation. If you add rows, extend the sum range to include them. Converting the range to an Excel table can make formulas and formatting easier to extend as you add records.

To flag stock at or below its threshold, the sample has quantity in E and reorder point in F. With the USB-C cable on row 3, enter this in K3:

=IF(E3<=F3,"Reorder","OK")

Because the example has 9 cables and a reorder point of 10, the formula returns “Reorder.” Copy it down the status column. The comparison uses less than or equal to, so a quantity exactly at the threshold is flagged too. The rule is only a prompt: a manager should check open purchase orders, lead times, demand, and any reserved stock before deciding what to buy.

Build and Use It in Excel

In Excel for Microsoft 365 on Windows, put the headers in the first row and the sample records below them. Select the full range, choose Insert > Table, confirm that the table has headers, and select OK. A table adds filter controls to the header row and generally carries formatting and calculated-column formulas into new rows. On Mac, use the Insert tab and choose Table; the dialog may look different, but the data layout is the same.

  1. Replace the illustrative products with your own items, keeping each field in its designated column.
  2. Enter quantities and costs as numbers, and use one consistent currency and unit convention.
  3. Enter the value and status formulas in the first data row, then fill them down. Check a few results manually before relying on the sheet.
  4. Use the header filters to show a category, supplier, location, or reorder status. Clear filters when you want to see the full list again.
  5. Save the workbook in a location accessible to the people who maintain it, and set a clear owner for updating it.

For visual alerts, select the quantity cells and use Home > Conditional Formatting > Highlight Cells Rules to highlight values below a chosen threshold. A separate conditional-formatting rule can flag low stock, but the formula-based status column is often easier to filter and explain. Keep the rule aligned with the reorder-point values; a hard-coded color threshold can become inaccurate when individual products have different thresholds.

Keeping Counts Reliable

Decide when changes get recorded. If a receipt arrives, update the quantity when it is accepted into stock, not merely when someone expects it. If goods are sold, used, transferred, damaged, or returned, define which events change the count and who records them. A consistent process matters more than a complicated workbook: delayed updates create a gap between the spreadsheet and the shelf.

Schedule physical counts at a frequency suited to the value, turnover, and importance of the items. A count can reveal data-entry errors, loss, damage, or transactions that were never recorded. When the physical count differs from the sheet, investigate and document the correction instead of silently changing a number if the difference matters to operations. For a shared workbook, agree on how simultaneous edits and corrections are handled.

Keep a backup or version history and restrict editing where accidental changes would be costly. Protecting a worksheet can discourage casual edits, but it is not a substitute for access controls or a backup. Avoid storing unnecessary sensitive information in a broadly shared inventory file. For a small list, a dated copy before a major count may be adequate; organizations with formal recordkeeping requirements should follow their own retention and control policies.

Common Spreadsheet Problems

  • Duplicate products: Slightly different names can create separate records for the same item. Use a consistent SKU and check for duplicates when importing or adding products.
  • Numbers stored as text: A quantity that looks like a number but is stored as text may not behave as expected in calculations. Use numeric entries and check the cell alignment or formula results when a total looks wrong.
  • Overwritten formulas: Typing a value into a calculated cell removes its formula. Keep calculated columns distinct, and periodically check that formulas continue through the full list.
  • Unclear units or locations: “12” and “Shelf 2” are not meaningful without shared definitions. Use labels that coworkers can interpret consistently.
  • Stale quantities: A tidy spreadsheet can still be wrong if receipts and sales are not recorded. Displaying a last-counted date helps users assess how much confidence to place in a figure.
  • Confusing stock on hand with available stock: Stock physically present may be reserved, damaged, or awaiting inspection. If those distinctions matter, add separate fields rather than treating every unit as available to promise.

One common misconception is that an inventory spreadsheet automatically tells you how much to buy. A reorder flag only compares two entered values. It does not know future demand, delivery time, minimum order sizes, or supplier availability unless those factors are separately recorded and used in a defined process.

When a Spreadsheet Is Enough

A spreadsheet is often a reasonable starting point when the item list is manageable, transactions are not too frequent, and a small group can maintain one shared source of truth. It is flexible, easy to adapt, and useful for sorting, basic calculations, and simple reporting. It can also serve as a planning tool before a business knows what features it needs from a dedicated system.

As complexity grows, the weaknesses become more important: simultaneous edits can conflict, manual updates can be missed, permissions may be limited, and a basic sheet does not inherently create a reliable transaction audit trail. Inventory software may be a better fit when multiple locations, barcode scanning, order processing, lot or serial tracking, or integrations with sales systems are essential. Compare products against actual requirements, including export options and ongoing subscription or implementation costs; a more advanced tool is not automatically the better choice for a small, simple list.

Frequently Asked Questions

What should an inventory spreadsheet include?
A basic sheet usually needs an item identifier, name, quantity, and location. Add fields such as reorder point, unit cost, supplier, and last-counted date when they support a real task.

Can I use this sample in Google Sheets?
Yes. The columns and basic multiplication, SUM, and IF formulas are also supported in Google Sheets. Menu names and table features differ, so follow Sheets’ own interface rather than Excel’s setup steps.

How do I calculate total inventory value?
Calculate each line as quantity multiplied by unit cost, then sum the line values. In the sample, the total is $353.50; this simple estimate does not define an accounting method for every business.

How often should I update inventory?
Update it when stock-affecting events occur, such as receipts, sales, usage, or transfers, and periodically compare recorded quantities with a physical count. The right counting frequency depends on how quickly items move and how consequential errors are.

Is an inventory spreadsheet the same as an inventory management system?
No. A spreadsheet is a flexible grid that people maintain, while dedicated systems may provide workflow controls, scanning, transaction histories, and integrations. Which is appropriate depends on the scale and control needs of the operation.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.