Inventory Sheet Generator
Count stock on a printable inventory sheet: SKU, location, quantity and reorder level, with a SKU and quantity total.
Count the shelf, then keep the sheet
An inventory sheet is a count you can read back later. This page gives you one row per stocked item: the SKU, a description, where it sits, how many there are, and the level at which it should be reordered.
The two totals
There is no money on this sheet. The summary counts what the rows prove: the number of SKUs with an identifier, and the total quantity across them. A row with an empty SKU is not counted as a SKU, which is why the two figures can differ.
Header fields
The location owner and the inventory sheet number sit in the header, with the count date and the next review date. The warehouse and the person who checked the count are optional fields.
Layout and printing
The sheet uses the denser layout: the table leads, the party block follows, and the rows are tighter than a full document's. It prints on A4 like everything else here, with the editor and navigation removed.
What it does not do
It does not connect to stock software, scan barcodes, or update a catalogue. Nothing is uploaded and nothing is stored; the count lives in the tab until you print it, so print before you close the page.
An inventory sheet is a count you can read back later. Each row is a stock item: its SKU, a description, where it sits, how many there are and the level at which it should be reordered.
There is no money on the sheet. The summary counts what the rows prove — the number of rows with an SKU and the total quantity across them — so a row with an empty SKU is a location note rather than a counted item.
It does not connect to stock software, scan a barcode or update a catalogue. The count lives in the tab until you print it, so printing before you close the page is part of the job.
The two counts
The SKU count is the number of rows whose SKU field is not empty, and the total quantity is the sum of the quantity column. Those two figures answer different questions: how many distinct items are recorded, and how many units they add up to.
The header names the location owner, the sheet number, the count date and the next review. The warehouse and the person who checked the count are optional extras, useful when a count is repeated across sites.
- SKU, description, location, quantity and reorder level
- SKU count and total quantity as the summary
- Count date and next review in the header
What a paper count cannot know
A reorder level is a number you type, not a rule the page applies. The sheet does not flag a low line, raise a purchase order or subtract what has been sold since the last count.
It also does not value stock. Two identical rows with different costs would still contribute only their quantities, which is why a valuation belongs in an inventory system rather than on this sheet.
How to use the count rows
Name the location owner, the sheet number, the count date and the next review in the header, then add one row per stock item with its SKU, description, location, quantity and reorder level. The summary reads the SKU count from rows with an identifier and the total quantity across all rows, so give every counted item an SKU.
Press Print document before closing the tab, since the count lives only in the page until printed. Reorder levels print as written reminders; no flag or order is raised from them.
What to Expect
Best for
- A physical stock count at one location
- A shelf-by-shelf audit sheet
- A printable list of SKUs and quantities
Not ideal for
- Live stock levels or automatic reordering
- Stock valuation, which needs costs
- Barcode scanning or catalogue updates
What this tool keeps
- Each SKU, location and quantity as typed
- A SKU count that excludes rows with no identifier
- A total quantity across the rows
What may need cleanup
- Rows with a location but no SKU, which are not counted as items
- Reorder levels, which are recorded rather than enforced
- Any valuation, which the sheet does not carry
Common errors
- Expecting an empty-SKU row to count toward the SKU total
- Looking for a low-stock warning the page does not raise
- Closing the tab before printing the count
Example use cases
- A quarterly stocktake
- A parts-room audit
- A stock transfer checklist
Sample input
A count at the main warehouse on 7 November with six rows, one of which has a location but no SKU.
Sample output
A sheet showing six rows, a SKU count of five and the total quantity across all six, with the warehouse and checker in the header.
Who this is for
- Warehouse teams running a stocktake
- Store managers checking a shelf
- Operations staff recording a transfer
Frequently asked questions
What does an inventory sheet record?
Each stock item's SKU, description, location, quantity and reorder level, with a SKU count and a total quantity across the rows.
Does it track live stock or reorder automatically?
No. It is a paper count you can read back, not a stock system.
Does it value the stock?
No. Stock valuation needs costs, which the sheet does not carry.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.