A spreadsheet is the right first inventory system. It costs nothing, and building one teaches you what you actually need to know about each item. This template has the columns that answer the three questions a reseller asks every day: where is it, where is it listed, and did it make money.
The columns, and why each is there
| Column | What goes in it |
|---|---|
| SKU | Your own code for the unit, the same one on its label |
| Item name, Brand | Enough to recognize it and to start a listing title |
| UPC or ASIN | The product identifier, when it has one |
| Condition | One of a fixed list: New, Like New, Used - Good, Used - Fair, For Parts |
| Bin | Where it is stored |
| Lot | The pallet or load it came from |
| Date in | When you received it, to spot stale stock |
| Cost | What the unit cost you, or the load cost divided by units |
| List price | The current asking price |
| Listed on | Every marketplace it is live on |
| Status | In stock, Listed, Sold, or Removed |
| Sold on, Sold date, Sold price | Where and when it sold, and for how much |
| Fees, Shipping cost | What the sale cost you |
| Profit | Sold price minus fees, shipping and cost |
For the SKU column, see a SKU system for resellers.
How to set it up
- Open the file in Excel or Google Sheets and delete the three example rows.
- Freeze the top row and turn on filters, so you can show only Listed or only one lot.
- In the Profit column use a formula: sold price minus fees, shipping cost and cost.
- Make Status and Condition dropdowns, so nobody types a variation.
- Give every unit a code before it goes on a shelf. The SKU generator makes a run of them.
Print each code with the free inventory label maker, so the sheet and the shelf match.
Selling on Whatnot? Its upload file has its own columns. See the Whatnot bulk upload CSV template.
Three habits that keep it true
- Add the row at intake, not when you list. Unrecorded stock is stock you forget you own.
- Update Listed on every time you post or end a listing. It is the column that prevents a double sale.
- Mark it Sold the moment it sells, then end its other listings. See how to avoid overselling.
When a spreadsheet stops being enough
- More than one person adds rows, and they overwrite each other.
- You list on three or more marketplaces and Listed on is often wrong.
- An item sold while nobody was watching, and sold again somewhere else.
- Typing the row takes longer than photographing the item.
At that point the spreadsheet is doing a job it cannot do: reacting to a sale. Resale Champ keeps the same record, filled in by a barcode scan on the phone, and takes an item's other listings down when it sells. It also exports everything back to a spreadsheet with photos whenever you want it. See what to look for in inventory software.
Hiring help? See reseller software for teams. Listing on more marketplaces? See crosslisting apps compared.
Common questions
Is the reseller inventory spreadsheet free?
Yes. It is a plain CSV file with no sign-up. It opens in Excel, Google Sheets and Numbers.
What columns should a reseller inventory spreadsheet have?
At least a SKU, item name, condition, storage bin, cost, list price, where it is listed, status, and the sold price, fees and shipping cost needed to work out profit.
Can I use it for Whatnot, eBay and Poshmark together?
Yes. The Listed on column records every marketplace an item is live on, and Sold on records where it sold, so one row covers the item everywhere.
How do I calculate profit per item?
Profit is the sold price minus marketplace fees, your shipping cost and what the item cost you. For a pallet, divide the load cost by the number of sellable units to get a cost per item.