You come home from a Saturday flea market with a vintage typewriter, a box of paperbacks and three wool sweaters. Two weeks later the typewriter sells for $85 and it feels like a win. But what did it cost you? What did the marketplace take? Did you pay for the box and the label? If you can't answer those questions in ten seconds, you don't know whether you made money. You only know money moved.
That's the problem good inventory management for resellers solves. It isn't about fancy software or a warehouse. It's about recording a few facts for every item so you can see the true profit on each sale, not just the total that landed in your account.
This guide shows you a simple system that works whether you sell five items a month or five hundred.
Revenue is not profit
Most new resellers track one number: sales. Sales feel good because they're big. But a $85 sale might put $20 in your pocket, or $60, or less than nothing, depending on what happened before and after the sale.
True profit per item is:
Profit = Sale price − Marketplace fees − Shipping you paid − Supplies − Item cost
Every part of that formula is something you either paid or gave up. If any piece is missing from your records, your profit number is wrong, and it's almost always wrong in the flattering direction.
Inventory management for resellers: what to record
A usable reseller inventory system needs only a handful of fields. Record them at two moments: when you buy, and when you sell.
At purchase
| Field | Why it matters |
|---|---|
| Item name or short description | So you can find it later |
| Date bought | Shows how long items sit unsold |
| Where you bought it | Tells you which sources pay off |
| Cost | The number everything else depends on |
| Quantity | For multiples of the same item |
| Storage location (bin or shelf) | So a sale doesn't turn into a search |
Record cost the day you buy. A week later you won't remember whether the sweater was $4 or $7, and that gap is often your whole margin on a low-priced item.
At sale
| Field | Why it matters |
|---|---|
| Date sold | Lets you measure how fast things move |
| Marketplace | Fees differ by platform |
| Sale price | What the buyer paid for the item |
| Marketplace fees | The platform's cut |
| Shipping you paid | Only the part that came out of your pocket |
| Supplies | Mailers, boxes, tape, tissue |
Be careful with shipping. On some platforms the buyer pays for the label; on others you do, or you offered a discount that you absorbed. Record only what you actually paid. Shipping the buyer paid isn't income or expense to you.
A worked example: one item
Here's the typewriter from the opening, tracked properly.
- Bought for $20
- Sold for $85
- Marketplace fee: $17.00 (an example 20% fee; check your marketplace's current fee page for the real rate)
- Shipping you paid: $14.50 (heavy item, and you offered free shipping to close the sale)
- Supplies: a box and padding for $3.50
Profit = $85.00 − $17.00 − $14.50 − $3.50 − $20.00 = $30.00
That's still a good flip. But it's $35 less than the "$65 profit" you'd see if you only compared sale price to what you paid.
The shipping line did most of the damage. That's exactly the kind of lesson you only learn when every cost is written down next to the item it belongs to.
Tracking items bought in a lot
Resellers often buy in bundles: a box of books for one price, a bag of clothes, a whole table's worth at the end of an estate sale. You still need a cost for each item, so you have to split the lot.
The simplest fair method is to divide the lot cost evenly across the items you plan to sell. If some items are clearly worth more, you can instead split the cost in proportion to what you expect each to sell for. Either way, pick one method and use it consistently.
You pay $24 for a box of 12 paperbacks. Split evenly, each book carries a cost of $24 ÷ 12 = $2.00.
Later, one book sells for $16. The example fee is $3.20, you pay $4.00 for shipping and $0.60 for a mailer.
Profit = $16.00 − $3.20 − $4.00 − $0.60 − $2.00 = $6.20
If three books in the box turn out to be unsellable, the lot still cost $24. Their share of the cost doesn't disappear. It's money you spent that the other nine books have to earn back.
That last point matters. When you add up the whole lot at the end, you'll see whether the box as a whole was worth buying, not just whether one book did well.
Put it together: a simple inventory ledger
Once you record items this way, a month of sales becomes a clear picture instead of a guess. Here's what a small ledger might look like:
| Item | Cost | Sale price | Fees | Shipping paid | Supplies | Profit |
|---|---|---|---|---|---|---|
| Typewriter | $20.00 | $85.00 | $17.00 | $14.50 | $3.50 | $30.00 |
| Paperback | $2.00 | $16.00 | $3.20 | $4.00 | $0.60 | $6.20 |
| Wool sweater | $6.00 | $38.00 | $7.60 | $0.00 | $1.00 | $23.40 |
| Wooden tennis racket | $5.00 | $22.00 | $4.40 | $9.00 | $2.00 | $1.60 |
| Total | $33.00 | $161.00 | $32.20 | $27.50 | $7.10 | $61.20 |
Look at the totals. Sales were $161, but profit was $61.20, which is about 38% of revenue. And look at the racket: it sold, it felt like a success, and it made $1.60. Without per-item tracking you'd probably go buy another one.
This is where a ledger stops being bookkeeping and starts being a buying guide. The items that consistently leave you real profit after every cost are the ones to look for next time.
Keep the system small enough to use
The best inventory system for resellers is the one you'll actually keep up. A few habits help:
- Log purchases before you unpack. Cost goes in while the receipt or price tag is in your hand.
- Give every item a location. A bin number or shelf label saves you from digging when something sells.
- Log the sale when you print the label. That's when fees and shipping are right in front of you.
- Review once a month. Sort by profit, not by sale price, and notice what rises to the top.
- Watch the dates. Items that have sat for months are tying up cash and space.
A spreadsheet works fine when you're starting. As your item count grows, the columns multiply and the formulas get fragile, and that's usually when resellers start looking at inventory software for resellers.
Common questions
What is the best way to track reseller inventory?
Record each item's cost and details the day you buy it, then record the sale price, fees, shipping and supplies the day it sells. Whether you use a notebook, a spreadsheet or an app matters less than recording both moments every time.
Should I count shipping the buyer paid as income?
No. If the buyer paid for the label, it passed through to the carrier and isn't part of your profit. Only record shipping costs that came out of your own pocket, including any shipping discount you offered.
How do I track profit on items bought in bulk?
Split the lot's total cost across the items, either evenly or in proportion to expected sale prices. Each item then carries its own cost, so every sale shows a real per-item profit, and you can judge the lot as a whole when it's sold through.
Upcyclist was built for exactly this kind of tracking. You log what you paid when you buy, record the sale price, fees, shipping and supplies when it sells, and Upcyclist shows the true profit on every item and across your inventory. No formulas to maintain, and your records stay with you wherever you source.
Next: turn profit into a margin you can compare
Once you're tracking true profit per item, the next question is whether that profit is good. A $30 profit on a $20 typewriter and a $30 profit on a $200 jacket are very different results. In our next guide, we'll explain the difference between profit margin and ROI, which denominator each one uses, and how to use both to decide what's worth buying.