Reseller profit tracker
A reseller's profit is decided when you buy, not when you sell. Tracking each item from purchase to sale shows which buys actually pay.
Track each item, not just each month
Monthly totals tell you whether the business made money. An item-level tracker tells you which sources, categories and price points make money, so you buy more of those. Give every item an ID (a sticker or a code in the listing) and one row.
The columns
- Item ID and description
- Date bought, source and cost (thrift store, estate sale, clearance, wholesale lot)
- Date listed and platform
- Date sold and sale price
- Shipping charged and shipping label cost
- Platform fees (final value, payment processing, promoted listing)
- Profit = sale price + shipping charged − cost − fees − label
- Days to sell
Example with made-up numbers
Jacket · bought 7 at a thrift store · sold 48 + 9 shipping · fees 7.40 · label 8.10
Profit: 48 + 9 − 7 − 7.40 − 8.10 = 34.50 · 22 days to sell
Lot of 10 books · bought 15 → cost 1.50 each · sold 6 so far
Splitting the cost of a lot
When you buy a box or a lot for one price, split the cost across the items. Dividing evenly is simplest; splitting by expected resale value is more accurate when items differ a lot. Whatever you choose, use it consistently.
The numbers to watch
- Profit per item and per hour spent sourcing, listing and shipping.
- Sell-through rate: items sold ÷ items listed in a period. Low sell-through means money stuck on shelves.
- Days to sell by category: slow categories need a lower buy price.
- Unsold inventory at cost: what is sitting in your storage, at what you paid.
Fees differ by platform
Each marketplace charges differently and changes its fees: some take a percentage of the total including shipping, some charge a flat fee under a certain price, some add payment processing. Put each platform's current rates in a small table in your tracker and update it when they change. The free Etsy fee calculator shows how the fee math works for one platform.
Taxes for resellers
If you resell for profit regularly, it is a business: you report gross sales on Schedule C and deduct the cost of goods sold (what you paid for the items you sold that year), fees, shipping and supplies. Items still unsold on December 31 are inventory, not an expense yet. Selling your own used belongings for less than you paid is generally not taxable, but a 1099-K may still include those sales, so keep records showing what they were. Platforms send 1099-Ks above the federal threshold, see 1099-K threshold 2027.
Year-end count
On December 31, count what is unsold and total its cost from your tracker. That ending inventory is next year's beginning inventory and part of the cost of goods sold calculation explained in cost of goods sold for sellers.
Frequently asked questions
How do resellers track profit?
One row per item with cost, source, sale price, shipping charged, label cost and platform fees. Profit is sale plus shipping charged minus cost, fees and label.
How do I split the cost of a bulk lot?
Divide the total evenly across items, or in proportion to expected resale value when items differ a lot. Use the same method every time.
Do I pay tax on items I resell?
If you resell for profit regularly, yes: report gross sales and deduct cost of goods sold, fees and shipping. Selling personal items at a loss is generally not taxable, but keep records.
General information, not financial, tax or legal advice. Examples use made-up numbers.
Handmade & Reseller Bookkeeping 2027
Fees, payouts, cost of goods and inventory across Etsy and your other channels, mapped to Schedule C.