How to track a returned item that sells again

A refund is not always the end of an item's story. If it comes back into stock and sells again, you need both sales to see what you actually made.

Here is a fictional USD example you can follow in a spreadsheet or in our Resale Lot & Returns Tracker. All results are before overhead, labour and tax.

Watch the example

Illustrated guide using actual tracker screens and fictional records. The steps and calculations are also explained below.

One item, two sale attempts

You bought an item for $25. The first buyer paid $40. You paid $4 in fees and $5 shipping.

Then the buyer returned it. You refunded $40, received a $3 fee credit and paid $5 return shipping. That sale attempt left you $11 out of pocket:

$40 − $40 − $4 + $3 − $5 − $5 = −$11

The item is back in stock. Its $25 purchase cost stays with it; it has not disappeared, and it should not be deducted twice.

Later, the same item sells for $55, with $5 fees and $4 shipping. This final sale contributes $21 after its original purchase cost:

$55 − $5 − $4 − $25 = $21

Across both attempts, the item contributed −$11 + $21 = $10. Looking only at the second sale would miss the return costs.

How to keep this straight in a spreadsheet

Give the physical item one SKU. Keep a row for each sale attempt, with the amount received, refund, fee credit, fees, shipping and return costs. Link every attempt to that SKU. Keep the purchase cost in the item's stock record and recognize it once when the item is finally sold or written off.

Check the whole item: receipts after refunds, less all selling and return costs, less its purchase cost. Here that is $55 − $20 − $25 = $10. Use actual credited fees rather than assuming a marketplace refunds everything.

How to do it in the tracker

1. Record the purchase and the first sale against the item's SKU.
2. In Sales & returns → View / adjust, enter the total-to-date refund, fee credit and return shipping, then choose Returned to stock.
3. Record the next sale against the same item after its return date.
4. Open Stock → Item history to see both attempts and the combined result.
5. Choose Download backup and keep the JSON file.

The built-in worked example includes this item as DEMO-002, so you can explore it without using your own business records.

Want the linked history already set up?

The Resale Lot & Returns Tracker keeps purchases, sales and returns together in an offline workspace. It is a one-time download for Windows desktop Chrome or Edge, with manual entry and JSON backups.

Watch the demo

Buying mixed lots? Read Has this resale lot paid for itself?