Skip to content

Reseller Inventory Spreadsheet: Cost, Bin, Days Listed

A reseller inventory spreadsheet: one row for each piece with its cost, source and bin, a haul log, a sold sheet with fees and days to sell, and a free file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

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.

Questions people also ask

How do resellers keep track of inventory?

With one row for each piece: a number, what it is, what it cost, where and when it was bought, and the bin it's in. When it sells, the row moves to a sold sheet with the price, fees and date.

What should a reseller inventory spreadsheet include?

For each piece: an ID, description, cost, source, date bought, date listed and storage location. Plus a log of buying trips and a sheet of sales with fees and what was kept.

How do I organize reselling inventory so I can find things?

Label every bin and shelf, write the location on the piece's row when you put it away, and tag the piece or its bag with its number.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.