Retail Arbitrage Inventory Tracking: Know Your Profit on Every Item

Q: How do I track items that I bought at one price but sold at a different price?

Use the FIFO accounting method or weighted average cost. The key is to be consistent. pick one method and stick with it.

Retail arbitrage seems simple: buy something cheap, sell it for more. The problem is that "more" is harder to calculate than it looks. Platform fees, shipping costs, prep fees, storage fees, and return handling eat into your margins in ways that aren't obvious until you do the math carefully.

Sellers who don't track properly often think they're profitable until they calculate their actual net at the end of the year and realize they barely broke even or actually lost money. Good inventory tracking eliminates this problem.

Why most retail arbitrage sellers don't actually know their profit

There are three reasons retail arbitrage sellers overestimate their margins:

They only calculate gross margin

Gross margin is sale price minus purchase price. If you buy something for $10 and sell it for $25, gross margin is $15. This feels great. But it ignores platform fees (usually 8-15%), shipping to the customer ($5-15), shipping to FBA or from your house ($3-8), prep and labeling fees if applicable ($0.50-2 per item), and your time.

They don't track costs consistently

You buy 10 items at Target. You pay with a card, don't keep the receipt, and when you're trying to calculate margin weeks later you're guessing at the cost. This is especially a problem when you buy the same item at different prices on different sourcing trips. your average cost per unit is different each time.

They don't account for items that don't sell

Not every item sells for the price you expected. Some items need to be discounted to move. Some never sell and have to be donated or trashed. If you're calculating average margin based only on items that sold at full price and ignoring the write-offs, your actual ROI is lower than you think.

The honest test

Can you tell me, right now, what your actual net profit per unit was on the last 10 items you sold? Not revenue, not gross margin. net profit after all fees, all shipping, all prep costs. If you can't answer this without guessing, your tracking system needs work.

Calculating the true cost per unit

True cost per unit includes everything you spend to get the item to the point where it's available for sale:

Purchase price: What you paid at the store
Sales tax: If you're not tax-exempt, include this. In most states, tax applies to retail purchases.
Transportation cost: Your driving time and gas to sourcing trips. You can simplify this as a percentage of your total buy. many sellers use 2-5% of purchase price as a transportation estimate.
Prep costs: Label removal, cleaning, reboxing, poly-bagging, bubble wrap
Labeling costs: FNSKU labels for FBA, your own stickers, inkjet or laser printing costs
Inbound shipping to FBA: If shipping to Amazon FBA, include the cost per unit to get it there. For a box of 20 items that costs $15 to ship, that's $0.75/unit.
FBA prep service costs: If you use a third-party prep service, include their per-unit fee

This total is your landed cost. the true amount invested per unit before any sale.

Practical example

You find a toy clearanced at $12 at Target. Sales tax in your state is 8%. add $0.96. You estimate $0.60 for transportation allocation. Poly bag and label costs: $0.30. Inbound FBA shipping allocation: $0.80.

Landed cost: $14.66

If you were only tracking the $12 purchase price, you'd think this item's margin is 25% higher than it actually is.

The retail arbitrage profit formula

Net profit per unit = Sale price - Landed cost - Platform fee - Outbound shipping

For an Amazon FBA sale:

Net profit = Sale price - Landed cost - Amazon referral fee (8-15%) - FBA fulfillment fee ($3-8 per unit depending on size/weight) - Storage fee allocation

For a self-fulfilled eBay or Mercari sale:

Net profit = Sale price - Landed cost - Platform fee (13% eBay, 12.9% Mercari) - Shipping to buyer - Packaging materials

ROI calculation

Return on investment (ROI) tells you the profitability relative to what you invested:

ROI % = (Net profit / Landed cost) × 100

If your landed cost is $14.66 and you net $6 after all fees and shipping, your ROI is 40.9%. Whether that's good depends on how quickly the item sells. a 40% ROI on an item that sells in 7 days is excellent. A 40% ROI on an item that takes 6 months to sell is poor, because your capital was tied up for 6 months.

Tracking systems: from spreadsheet to software

The spreadsheet approach (free, requires discipline)

A Google Sheet with consistent data entry works well at lower volumes. Required columns:

Date sourced, Store, Product name, SKU (yours), ASIN (Amazon) or item number
Units purchased, Purchase price per unit, Tax paid
Prep cost per unit, Shipping cost per unit (inbound)
Landed cost per unit (calculated)
Listed price (per platform), Platform fee %, Platform fee $ (calculated)
Outbound shipping cost
Net profit per unit (calculated), ROI % (calculated)
Date sold, Days to sell

The critical discipline: enter data at source, not later. When you're at Target and scanning items, make note of what you're buying. Don't try to reconstruct your purchase list from memory three days later.

Amazon Seller Central reports

If you're selling primarily on Amazon FBA, Amazon's Business Reports and Payments Reports include detailed fee breakdowns per item. Export these monthly and reconcile against your sourcing records. Amazon's reports are authoritative for your Amazon channel. use them as ground truth rather than trying to calculate fees manually.

Dedicated reseller tracking apps

Apps built specifically for resellers (SellerAmp, Profit Bandit, ScoutIQ) can scan barcodes while sourcing and show you estimated profitability in real time based on current Amazon prices and fees. These are valuable for the sourcing decision but usually still require manual reconciliation against actual sales data.

Multi-channel inventory management

If you're selling on multiple platforms. Amazon plus eBay, plus Mercari. a tool like Commerce Kitty tracks inventory across all channels and gives you a unified view of what's sold and what's remaining. This is particularly valuable for retail arbitrage sellers who are constantly acquiring new inventory and need to know exactly how much of each item they have left across all active listings.

Setting ROI targets and minimum thresholds

Every retail arbitrage seller needs a minimum ROI threshold. a cutoff below which you don't buy. Without this, you'll accumulate low-margin inventory that clogs your pipeline and ties up capital.

Common benchmark targets

Platform	Minimum ROI	Minimum profit $/unit	Notes
Amazon FBA	30-50%	$3+	Higher threshold needed due to FBA fees and competitive pricing pressure
Amazon FBM	25-40%	$4+	Lower fees but you handle shipping; include your time cost
eBay	30-50%	$5+	Higher minimums because individual item management takes more time
Mercari	25-40%	$4+	Lower minimums acceptable due to lower fees

These are benchmarks, not rules. Your specific costs (local wages, gas prices, storage situation) affect your actual minimum threshold. Calculate yours based on your real numbers, not industry averages.

The maximum days-to-sell rule

ROI alone doesn't tell the full story. A 50% ROI on an item that takes 180 days to sell is worse than a 25% ROI on an item that sells in 14 days, because the latter frees capital 13 times faster. Many experienced resellers add a maximum days-to-sell threshold. if an item doesn't sell within 60 or 90 days, they lower the price to move it regardless of margin impact.

Tracking across Amazon, eBay, and other platforms

When you sell the same item on multiple platforms, inventory tracking gets more complex but also more powerful. You can route items to whichever platform is currently getting the best price.

The multi-platform retail arbitrage workflow

Source items at retail stores with a minimum ROI threshold in mind for your primary platform (usually Amazon)
List on your primary platform at your target price
After 30 days with no sale, reduce the price 10% or delist from primary and relist on a secondary platform (eBay, Mercari) where the item might sell faster
Track cost basis throughout the item's life regardless of where it's listed
Record final sale price, final platform, and net profit regardless of where it sold

This approach maximizes sell-through rate and ROI by routing each item to its best-performing channel. See our guide on how to sell on Mercari and eBay for platform-specific guidance.

Frequently asked questions

Do I need to track every item individually or can I batch by product type?

For accurate profit tracking, individual SKU tracking is best. When you batch by category, costs get averaged and you lose visibility into which specific items are profitable. At minimum, track by product/ASIN, not by category. If you buy 10 units of the same item at the same price on the same trip, one row per product is sufficient. but when you buy the same item at different prices on different trips, track each lot separately to know your true average cost per unit.

How do I track items that I bought at one price but sold at a different price?

Use the FIFO (first in, first out) accounting method. assume the first units you bought are the first ones sold. Or use weighted average cost: if you have 10 units of a product with different purchase prices, calculate the average cost per unit. Most reseller tracking spreadsheets and apps default to one of these methods. The key is to be consistent. pick one method and stick with it.

Should I track my time as a cost?

Yes, especially if you're evaluating whether retail arbitrage is worth it as a business. Estimate your time per sourcing trip, time per item for prep and listing, and time per item for customer service. Assign a dollar value (what would you pay someone else to do this work?). Include this in your cost calculation. Many sellers find that when they include their own time, their effective hourly rate is lower than they realized.

What's the best free tool for tracking retail arbitrage?

Google Sheets with a well-designed template is the best free option. Build your own with the columns described in this guide, or search for "retail arbitrage tracking spreadsheet" to find templates others have shared. The best spreadsheet is the one you actually use consistently. simple and disciplined beats complex and neglected.

Related: see inventory management 101 for foundational concepts, and how to sell on Mercari and eBay for cross-platform reseller strategy.

Retail Arbitrage Inventory Tracking