← All posts
Published September 25, 2026 · Updated October 18, 2026

How to Track Reseller Inventory and Profit

Revenue isn't profit. Learn a simple inventory system that records what each item cost, what it sold for, and what you actually kept.

A vintage portable typewriter in an open case on a wooden chair at an outdoor flea market, with a stop sign, a wooden tennis racket, and tables of secondhand goods behind it
Photo Credit: Annette Dawm on Pexels

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

To connect your per-item records to an income goal, see how much resellers actually make after fees, shipping and acquisition costs.

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 = Item revenue + Shipping credited to you − Marketplace fees − Actual postage − 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

If you're choosing where to keep these records, our best app for resellers guide compares the jobs different tools do.

A usable reseller inventory system needs only a handful of fields. Whether resellers work from a spare room or a dedicated storage space, the same two moments matter: when they buy and when they sell. Record the fields below at each step.

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. If the marketplace sends the buyer's label payment directly to the carrier and never credits it to you, that pass-through is neither seller revenue nor seller postage. If shipping money is credited to you, include it in seller revenue and deduct the actual postage you pay once. Seller-funded shipping discounts and packaging still reduce what you keep; do not record the same charge twice.

A worked example: one item

Here's the typewriter from the opening, tracked properly.

The flea market typewriter
  • 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

See how to track reseller lots and partial sales when one purchase sells in several transactions.

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.

For similar-value units using equal cost allocation, the reseller lot tracker connects one purchase to several partial sales and keeps remaining inventory cost separate from realized profit. It does not support proportional allocation, returns or disposal of unsellable units.

Splitting a box of books

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:

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.

Start with the free reseller inventory spreadsheet to connect individual items to their sales, track unsold inventory at cost, and check profit after selling costs.

If most of what you sell is on eBay, our guide on eBay inventory management walks through the same system with eBay-specific details: SKUs in the Custom label field, tracking listing status, and eBay's exact fee formula on completed sales.

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?

Only when the shipping money was actually credited to you. Include that receipt in seller revenue, then deduct the actual postage you paid once. A buyer-paid label amount sent directly to the carrier without being credited to you is pass-through, not seller revenue or seller postage. Record seller-funded shipping deductions once.

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.

Let Upcyclist do the math

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. Our guide on profit margin vs. ROI walks through the difference, which denominator each one uses, and how to use both to decide what's worth buying.

Inventory trackingProfit and margins
Share this postLinkedInXFacebook

Know your numbers on every flip.

Track purchases, sales, fees, and profit in one place — free to start.

Start Free

Get New Posts by Email

One email when a new post goes up. No spam, unsubscribe anytime.