A reseller's inventory is the opposite of a shop's. Nothing repeats: every piece is bought once, listed once and sold once. So the spreadsheet has one row for each piece, and each row answers three questions. What did it cost, so you know what you made when it sells and what your stock is worth at tax time. Where is it, a bin or a shelf, so a sale doesn't start a search. And how long has it been listed, because a piece that has sat for six months is money that isn't coming back at that price. Around the rows sit two more sheets: a haul log, one line for each buying trip, and a sold sheet. Below is a spreadsheet for a made-up part-time reseller, and the file.
The short version
- One row for each piece: what it is, cost, where you bought it, date, bin.
- Give each piece a number and write it on a tag or the bag.
- Log each haul: date, place, what you paid, how many pieces.
- When a piece sells, move the row to Sold with price, fees and date.
- Watch two numbers: pieces not yet listed, and days listed.
- Count shipping supplies the ordinary way, with a reorder level.
- TaroStack keeps stock by place, counted on a phone. More below.
An example sheet
| Item | Unit | On hand | Unit cost | Bought | Where kept |
|---|---|---|---|---|---|
| Levi's 501 jeans, 34 × 32 | each | 1 | $6.00 | Thrift store, Oct 12 | Bin A3 |
| Pyrex mixing bowl set, primary colors | set | 1 | $22.00 | Estate sale, Oct 18 | Shelf B1 |
| Patagonia fleece, men's M | each | 1 | $9.00 | Thrift store, Oct 12 | Bin A4 |
| Vintage Polaroid camera | each | 1 | $15.00 | Garage sale, Oct 19 | Shelf B2 |
| Poly mailers, 10 × 13 | each | 140 | $0.09 | Online | Desk |
| Boxes, 12 × 9 × 6 | each | 22 | $0.85 | Online | Garage |
Ten rows in all: eight pieces that cost $89.00, and $31.30 of shipping supplies, with boxes to reorder. A real sheet has hundreds of rows. The columns don't change.
Cost. Write what the piece cost on the day you buy it, while the receipt is in your hand. For a box lot, divide: four board games for $10 is $2.50 each if you'll sell them separately, or one row at $10 if you'll sell them together.
The bin. Label every bin and shelf. Put the bin on the row when the piece goes into it, and never move a piece without changing the row. This is the column that saves forty minutes.
The haul log
| Date | Where | Pieces | Paid | Listed so far |
|---|---|---|---|---|
| Oct 12 | Thrift store | 14 | $62.00 | 9 |
| Oct 18 | Estate sale | 8 | $74.00 | 8 |
| Oct 19 | Garage sales | 11 | $41.00 | 7 |
| Nov 2 | Thrift store | 9 | $48.00 | 0 |
| Four hauls | 42 | $225.00 | 24 |
Forty-two pieces bought, 24 listed. The other 18 are in bags by the door. The four hauls cost $225, and those 18 pieces are earning nothing. Resellers have a name for that pile. The haul log is how you see it growing: when "listed so far" falls behind, stop buying and start photographing.
It also shows which sources pay. If estate sale pieces cost more and sell faster, the log says so after a few months, and a feeling doesn't.
The sold sheet
| Piece | Cost | Sold for | Fees | Kept | Days listed |
|---|---|---|---|---|---|
| Canvas work jacket | $12.00 | $68.00 | $9.18 | $46.82 | 9 |
| Glass mixing bowl | $4.00 | $30.00 | $4.05 | $21.95 | 31 |
| Nylon windbreaker | $8.00 | $24.00 | $3.24 | $12.76 | 64 |
| Three sales | $24.00 | $122.00 | $16.47 | $81.53 |
Fees are 13.5% in this example. Use what your platform really charges, and put shipping you paid in a column of its own if the buyer didn't cover it.
Days listed is the column to sort by on the unsold sheet too. This reseller's rule: at 60 days, drop the price; at 120, bundle it or donate it. A shelf of things that might sell someday is the business's cash, tied up.
For taxes. What you paid for pieces you still hold at year end is stock, and what you paid for pieces you sold is a cost of the sales. The cost column and the sold date are the records for both. Ask a tax preparer how it applies to you.
What to charge for shipping is in how much to charge for shipping. Tags for bins and pieces are in inventory tag template, and numbering pieces in how to create SKU numbers.
Get the spreadsheet
Download the reseller inventory spreadsheet. Four sheets: inventory with a row for each piece, its cost and bin; hauls; a count sheet that works out each difference and what it's worth; and a read-me. Add a Sold sheet with the columns above. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Four hundred rows in, the sheet depends on one habit: changing the bin when a piece moves. It gets skipped once, on the night a shelf is reorganized, and then thirty rows are wrong. A count, bin by bin with the sheet on a laptop, takes a Sunday. And the sheet can't tell you that you've sold a piece on one site that's still listed on another.
How TaroStack does it
TaroStack is built for businesses that make things or stock the same items again and again. For one-of-a-kind pieces it does part of this job, and it's fair to say which part.
Stock is held by place. Each bin and shelf is a location, and each piece an item with what it cost.
Counting works on a phone, bin by bin, with no signal in the garage. A count shows what a difference is worth.
Every adjustment carries a reason, so a piece donated or damaged is recorded as that.
Shipping supplies get a reorder list in days of cover.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Which bin a piece is in | A cell someone has to update | Stock by location |
| Counting the bins | A Sunday with a laptop | On a phone, bin by bin |
| What the unsold stock cost | Add up a column | Stock value at cost |
| Mailers and boxes | When they run out | The reorder list |
TaroStack doesn't list on marketplaces, sync a sale between sites or track days listed. Every piece counts as an item: Starter at $9.99 a month holds 50, and Growth at $39 a month holds 3,000. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
