Cost basis per item vs per lot — why your profit math is lying to you

Every reseller who sources lots — thrift hauls, estate lots, wholesale pallets — runs into the same spreadsheet problem. You paid $140 for 20 items. What did each item cost?

The easy answer is $7 each. The honest answer is that some of those items cost you $2 and some cost you $25, and if you use the $7 average, your profit math is wrong on every single one of them.

Here's what per-item cost basis looks like, and why per-lot averaging quietly destroys your reporting.

The problem with averaging

Imagine a $140 estate lot of 20 items. When you sort it:

• 1 pair of sneakers worth $180 retail
• 4 designer items worth ~$60 each retail
• 6 mid-tier items worth ~$30 each retail
• 9 items worth $5–$10 retail, mostly donation material

If you divide $140 / 20 and call each item $7:

• The $180 sneakers show $7 cost, so their "profit" on sale looks like
• $173. Your taxes are based on this number. You overpay.
• The $5 t-shirts show $7 cost, so they sell "at a loss." But you
• didn't really pay $7 for them — you paid roughly $0 because they
• came along for free with the lot.

Neither number is honest. Your spreadsheet is telling you a story that doesn't match reality, and you can't tell which items are actually profitable until you fix it.

How resellers who do it right allocate cost

The two accepted methods:

1. Relative-value allocation. Estimate retail value of each item, sum them, then allocate the lot cost in proportion. Lot paid $140, total estimated retail $580. The $180 sneakers represent 31% of the retail, so their cost basis is 31% × $140 = $43.40. The $5 t-shirts represent ~1% each, so their cost basis is ~$1.40.

This is the method most reseller CPAs recommend because it matches cost to value rather than treating a rhinestone vest the same as a luxury watch.

2. Specific-identification. You paid $140 and you decide: "the sneakers cost $50, the designer items cost $15 each, the mid-tier $5 each, the rest cost nothing." Total = $140. This works if you have a clear sense of why you bought the lot — usually you bought it FOR something specific and the rest is bonus.

Both are IRS-acceptable. What is NOT acceptable (in practice) is dividing evenly, because the IRS looks at "reasonable and consistent" methods, and even-split on mixed lots is neither.

The spreadsheet failure mode

You can do this in a spreadsheet — and thousands of resellers do — but it's fragile. The common breakdown:

• You log the lot cost in the month you bought it.
• You list items over the next 6-12 months.
• You sell them over another 6-18 months.
• By the time something sells, you've forgotten which lot it came from.
• Your spreadsheet has one "cost" column, so the recorded cost is
• whatever you wrote down at intake — usually the averaged $7.

To fix it retroactively you'd have to re-derive allocation for every item from your original source receipts. Most resellers don't, so their reported profit diverges from reality the longer they run.

What per-item cost basis requires

A real inventory system tracks:

• Source: which lot / supplier / trip the item came from
• Allocated cost: your computed cost basis per item, not per lot
• Date acquired: separate from date listed and date sold
• Sold price and sold date: for real profit math
• Platform fees collected on that specific sale

The result is that when a $180 sneaker sells for $125, your system shows you $125 – $43.40 cost – $17 fees – $6 shipping = $58.60 real profit. Not the $118 you'd see on an averaged spreadsheet.

Over a year, the average-cost error compounds in one direction: you overpay on taxes because high-value items report inflated profit.

When this starts to matter

• Under 100 items total, averaging is fine. The error is small.
• 100–500 items across multiple lots, averaging is costing you
• real money — probably $500–$2,000 a year in misreported profit.
• 500+ items, averaging is indefensible. Your tax return isn't
• honest and a CPA will tell you.

PalmFlow tracks cost basis per item with relative-value allocation built in. Enter the lot, it proposes allocations based on your estimated retail, and each item gets its own cost number that follows it through to the sale. Free plan, 50 items.

If you're evaluating dedicated reseller bookkeeping tools too, see how PalmFlow compares to My Reseller Genie.

Published by PalmFlow. We build inventory software for resellers.