Every order you accept is a promise made against a number in a spreadsheet. If that number is wrong, the promise breaks somewhere much more expensive than the spreadsheet: at a customer’s back door, with a driver standing there holding four of the six cases they ordered.
That is why an inventory list template matters more for a business that delivers its own orders than for one that sells over a counter. A retailer with a bad count disappoints a shopper who is already in the building and can pick something else. You discover the gap after the van has left.
The good news is that the fix is mostly clerical. Most operators do not need software. They need a list with the right columns, counted on a schedule they can keep. This guide covers what belongs on that list, where to get a decent free one, and how to keep it honest once real orders start moving through it. If manual counting is already the bottleneck, the next step up is scanning, which we cover in detail in how a barcode inventory system cuts same-day picking errors.
The Bottom Line
- In a March 2026 survey of 400 US inventory, warehouse, and operations professionals, 84.8% said they track inventory in spreadsheets, and 44% hit a stockout at least once a month (inFlow Inventory). A spreadsheet is the normal tool, not a failure.
- A usable inventory list needs eight columns, not thirty. Anything you will not update weekly is decoration.
- For delivery work, add two columns most templates leave out: where the item is stored, and how much is already committed to orders that have not gone out yet.
- Accuracy comes from cadence, not from the file. Count a slice of your stock every week rather than everything twice a year.
Boost customer satisfaction with just a few clicks
Most-Loved Features:
- On-demand drivers
- Real-time GPS tracking
- Delivery confirmation photos
- Over 50% of customers report a smoother delivery experience
What Goes in an Inventory List Template
An inventory list is a record of what you hold, how much of it, what it is worth, and where it sits. A template is just that record with the columns and formulas already built, so you are filling in values instead of designing a spreadsheet.
One clarification matters up front. An inventory list is not a full inventory management system: it will not reserve stock when an order comes in, and it will not stop two people from selling the same pallet. It is also not the same document as the legal inventories some situations demand. If you are listing the assets of an estate rather than the stock of a running business, the format, the valuation rules, and the deadlines are entirely different, and that process is covered in what belongs on a probate inventory list and when to file it.
For a business that ships goods, the list has one job: tell you, without a trip to the cooler, whether you can say yes to an order and when it can go out.
The Columns an Inventory List Needs When Orders Go Out the Same Day
Start with eight. Most published templates give you five of them and bury the rest under fields you will never fill.
| Column | What it holds | Why it matters for delivery |
|---|---|---|
| SKU | Your internal code for the item | The one field that must be unique; everything else keys off it |
| Item name | Plain-language description | What a picker reads at 5 a.m. |
| Unit | Case, each, tray, dozen | Prevents ordering 12 when you meant 12 cases |
| On hand | Physical count | The number you’d bet a delivery slot on |
| Committed | Units already sold but not yet loaded | Stops you from selling the same stock twice |
| Available | On hand minus committed | The only number a salesperson should ever see |
| Location | Shelf, cooler, rack, van | Turns a pick into a walk instead of a search |
| Reorder point | Level that triggers a purchase | Catches the shortage days before the route, not that morning |
The two columns that do the heavy lifting here are committed and available, and they are the two that generic inventory spreadsheets almost always omit. A template built for a stockroom assumes stock leaves when someone buys it. In delivery work, stock is sold on Monday, picked Tuesday night, and gone Wednesday morning, so for two days it is physically present and not yours to sell. An inventory list that shows only on-hand quantities will cheerfully let you promise it twice.
Add a par level column if you produce to order. Bakeries, florists, and caterers typically care less about total stock than about whether tomorrow’s standing orders are covered, and a par level answers that in one glance.
Fields worth skipping
Cost, markup, retail price, supplier lead time, and barcode number all belong in a purchasing or pricing file rather than in the list your team touches daily. Every column you add is a column someone has to keep true. The 2026 inFlow survey found 92% of operators satisfied with their current setup while 49.5% simultaneously named inventory accuracy as the thing most needing improvement. That gap usually comes from tracking more fields than anyone keeps up to date.
Where to Get a Free Inventory List Template
Several publishers give away spreadsheet templates that are a reasonable starting point. None of them are built for delivery specifically, so expect to add the committed, available, and location columns yourself.
- Microsoft’s Excel template gallery offers inventory lists that open directly in Excel for the web, which is the shortest path if your team already lives in Microsoft 365 (Microsoft).
- Smartsheet publishes a large library of inventory and inventory-form templates in Excel, Word, and PDF, including retail-oriented versions with reorder fields already in place (Smartsheet).
- ProjectManager and Coefficient both offer free Excel and Google Sheets inventory lists, which matters if your staff are on phones, since Sheets handles shared mobile editing more gracefully than a desktop Excel file passed around by email (ProjectManager, Coefficient).
- QuickBooks provides an Excel inventory template aimed at small businesses, which is convenient if your bookkeeping already sits there (QuickBooks).
Pick on format, not features. The template you will still be using in six months is the one that opens on the device your team already has in their hand on the floor.
How to Set Up Your Inventory List Template in Under an Hour
- Download one template and delete two-thirds of its columns. Keep the eight above. Resist the instinct to keep a field “just in case”, because unused columns are how a list starts looking unreliable.
- Assign SKUs before you enter anything. Short, human-readable, no spaces, no characters that look like each other. One transposed digit between similar codes is enough to split your record of a single product into two half-true ones.
- Enter locations as you count, not from memory. Walk the space with the file open. The location column earns its place only if it reflects where things sit today.
- Add one formula, not five. Available = on hand − committed. That is the calculation that prevents oversold routes.
- Set reorder points from delivery rhythm, not from averages. If your supplier needs three days and you deliver on Tuesdays and Fridays, the reorder point has to cover the gap between those two facts, not a smooth weekly average.
- Decide who owns the file, in writing. One person updates it and everyone else reads it. Shared editing without an owner is the most reliable way to end up with two versions of the truth.
Keeping the Inventory List Accurate Enough to Promise a Delivery Slot
A template does not produce accuracy. Counting does, and the evidence on how far most operations sit from accuracy is unflattering: research from the Auburn University RFID Lab puts average store-level inventory accuracy near 63%, against the roughly 95% that well-run operations achieve (ASCM).
Three habits close most of that gap.
Count a slice every week instead of everything twice a year. Divide the list into four groups by value or turnover and count one group each week. Your highest-movement items get counted monthly without anyone ever scheduling a shutdown.
Reconcile after the route, not before it. The moment stock leaves is when the record should change. Adjusting the file the next morning means every early order that day is quoted against yesterday’s numbers.
Investigate variances instead of overwriting them. When the count says 14 and the file says 17, the useful information is why three went missing, not the corrected number. Damage, an unrecorded sample, a pick against the wrong SKU, and theft all produce the same discrepancy and need different fixes.
The 2026 inFlow survey found 55% of operations running at 95–98% order accuracy and 16.2% at 99–100%, which tells you the achievable range for a small operation using ordinary tools. Getting there is a matter of cadence and discipline rather than spend.
When a Spreadsheet Stops Being Enough
A spreadsheet list is sufficient for a long time. Four signals suggest you have outgrown it:
- The same item shows up under two SKUs because two people added it.
- You are counting more than about 300 active items, at which point a manual count stops fitting in one session.
- Two or more people need to change quantities during the same shift.
- Your errors are happening at the pick rather than in the file: the number was right and the wrong case went on the van anyway.
That last one is the clearest signal, because no amount of spreadsheet hygiene fixes it. Scanning does, by making the physical item confirm its own identity at the moment it is picked. The setup, the label decisions, and the load-out checks are covered in how a barcode inventory system cuts same-day picking errors.
What an Accurate Inventory List Is Worth
Fulfillment error rates in the 1–3% range are common, while the working benchmark for order accuracy sits above 99% (iDrive Logistics). On a hundred deliveries a week, the difference between 97% and 99.5% is roughly two and a half wrong orders a week versus one every two weeks.
The cost of each one is never just the missing item. It is the call, the credit, the redelivery, and a customer who now double-checks everything you send. For local delivery, that redelivery is the part that stings: a second trip across town for one forgotten case can wipe out the margin on the original order, which is exactly why the committed and available columns earn their keep.
Frequently Asked Questions
What should be included in an inventory list?
At minimum: SKU, item name, unit of measure, quantity on hand, location, and reorder point. Businesses that deliver should also track quantity committed to unshipped orders and the available quantity that results, since those two prevent the same stock from being sold twice.
Is Excel good enough for inventory management?
For most small operations, yes. The March 2026 inFlow survey found 84.8% of inventory professionals tracking inventory in spreadsheets, including many at large companies (inFlow Inventory). Spreadsheets fail on concurrency, meaning several people editing quantities at once, rather than on capability.
How often should I count inventory?
Cycle counting beats annual counts for most operators: split the list into four groups and count one group weekly so high-movement items get verified monthly. Reconcile after each delivery run, since that is when quantities change.
What is the difference between on-hand and available inventory?
On hand is what is physically in your building. Available is on hand minus what is already promised to orders that have not shipped. Quoting from on-hand numbers is the most common cause of an oversold delivery route.
Should I use a free template or buy inventory software?
Start free. Move to software when you cross roughly 300 active items, need more than one person changing quantities per shift, or find that your errors are happening during picking rather than in the file.
The Bottom Line
An inventory list template is worth having because it removes a decision from a moment when you cannot afford to make one. When an order comes in, you want to know in one glance whether you can ship it and what is left after you do.
Keep the list to eight columns. Add committed and available quantities if you deliver. Count a quarter of your stock every week and reconcile after the van comes back, not before it goes out. That is a system a two-person operation can maintain, and it is enough to stop the failure mode that costs the most: a promise made against a number nobody had checked since the last time someone had a spare afternoon.
