Reseller records guide

How to track reseller inventory and profit

Give every item one record when you buy it, with its cost, source, and storage location, then update that same record when it is listed and when it sells. Profit for the item is the sale price minus its cost, marketplace fees, and the shipping you paid. Export the records before tax time so your totals come from item records, not memory.

By the Shelvio teamUpdated 3 min read

A revenue total is not profit, and a listing title is not an inventory system. To understand the business, every physical item needs a record that survives from purchase through sale.

The smallest useful record answers four questions: what did this cost, where is it, where is it listed, and what remained after it sold? A reseller inventory tracker should keep all four answers on one record, from purchase through sale.

Create the record at intake

Attach cost and source when memory is fresh. For a lot purchase, choose and document a consistent allocation method rather than silently treating every item as free.

  • Purchase date and source.
  • Item cost or documented lot-cost allocation.
  • Batch or haul name.
  • Temporary or permanent storage location.
  • A unique SKU when similar items could be confused.

Keep marketplace status separate from physical status

An item can be photographed, drafted, listed on one marketplace, listed on another, stored, sold, returned, or donated. One generic “active” label cannot describe all of those states.

At minimum, record each marketplace where the item is listed and whether the physical item is available. When the item sells, that record shows which other listings to end, and it makes stale inventory visible.

Which costs should a profit tracker include?

A complete business analysis may account for marketplace fees, promoted listing fees, payment processing, seller-paid shipping, packing materials, cost of goods, and overhead. The exact number depends on which costs you consistently record.

Shelvio calculates item-level profit as sold price minus item cost, recorded fees, and seller-paid shipping. Missing values are treated as zero.

Tip

Use completed-transaction numbers and call the result item-level profit based on recorded costs. Analyze costs outside the built-in formula separately.

Worked example

A jacket bought for $6 that sold for $48
ItemAmount
Sold price$48.00
Item cost−$6.00
Recorded marketplace fees−$7.20
Seller-paid shipping−$8.50
Item-level profit$26.30
Example numbers, not a real sale. The fee line is the amount the marketplace charged on this order, not a fee rate.

Watch out

Packing materials, mileage, labor, taxes, and general overhead are not included in Shelvio’s built-in calculation.

Use built-in reports, then export for custom analysis

Shelvio reports summarize performance over time and by source, batch, and marketplace. They also show listing-to-sale timing and inventory aging so you can spot slow-moving stock and compare the selling channels and sourcing groups you recorded.

For analysis that Shelvio does not group in the app, such as category or storage-location comparisons, export the item records to CSV and work with them in a spreadsheet or reporting tool. Mileage logs and full bookkeeping need a separate tool; see reseller apps compared by job.

Shelvio Reports showing revenue, net profit, items sold, margin, days to sell, sell-through, and a revenue and profit trend chart.
Reports in the Shelvio app: revenue, net profit, items sold, margin, days to sell, and sell-through, with a revenue and profit trend.Screenshot from the Shelvio app
  • Revenue, recorded costs, fees, and item-level profit over time.
  • Performance by source, batch, and marketplace.
  • Time from listing to sale and current inventory aging.
  • Data-completeness indicators for missing sale inputs.
  • CSV export for custom category, storage, and overhead analysis.

Export before tax time becomes a reconstruction project

Maintain records throughout the year and export them on a regular schedule. A CSV is useful for backup and analysis.

Watch out

Tax treatment varies by jurisdiction and business structure. Use a qualified tax professional for advice specific to your situation.

Questions about this workflow

What is the basic reseller profit formula?

Shelvio calculates item-level profit as sold price minus item cost, recorded fees, and seller-paid shipping, with missing values treated as zero. The calculation does not include packing materials, mileage, labor, taxes, or general overhead. Tax treatment can differ, so consult a qualified professional.

How should I track items bought in one lot?

Choose a reasonable, consistent allocation method and document it, for example, relative expected value or equal allocation when the items are genuinely similar. Ask a tax professional which method fits your records.

Can Shelvio export reseller records?

Yes. Shelvio keeps cost, source, storage, marketplace status, sale, fees, seller-paid shipping, and item-level profit with the item and supports CSV export for custom analysis elsewhere.

How we made this guide

The profit formula matches the one Shelvio’s reports use, the screenshot is from the app, and the worked example uses made-up numbers.

Keep going

Related reseller guides

Inventory backlog guide3 min read

How to clear a reseller death pile

Turn an unlisted inventory backlog into small, finishable batches with triage rules, capture checkpoints, and honest keep-or-exit decisions.

Read guide
Batch listing workflow4 min read

How to list a thrift haul faster

A practical batch workflow for photographing, describing, drafting, reviewing, and tracking a thrift haul without restarting for every item.

Read guide