How to Track Profit on Each Coin You Sell

To track profit on each coin you sell, record the coin's cost on the day you buy it, record the sale price and the fees of the channel when it sells, and subtract. Profit per coin is the sale price less the coin's cost less the selling fees. Do this for every sale, from every channel, and you can see which coins, categories, and channels make you money.

Most dealers know their total sales. Fewer know which sales made money. A $4,500 Morgan dollar that cost $4,200 and sold on a marketplace with a 13% fee lost money, even though it was the biggest sale of the week. The steps below show how to get to a number you can trust for each coin.

How to track profit on each coin you sell, step by step

1. Record cost when you buy, not when you sell

The cost of a coin is fixed on the day you buy it. If you wait until it sells, you will guess, and guesses drift upward. Record:

• What you paid for the coin.
• Its share of any cost that came with the purchase, such as shipping to you or a grading fee you paid before you listed it.
• Where it came from: the show, the wholesaler, the walk-in seller.

The source matters later. It lets you ask which suppliers and which shows sell you coins that turn into profit.

2. Split group purchases fairly

Dealers often buy a group: a collection, a roll, a box of slabs. You pay one price for many coins. To get a cost per coin, split the total in proportion to what you expect each coin to sell for.

Coin	Expected sale	Share	Cost (of $3,000 paid)
1893-S Morgan dollar, VF-20	$2,400	60%	$1,800
1916-D Mercury dime, G-4	$1,200	30%	$900
1909-S VDB Lincoln cent, VF-30	$400	10%	$300
Total	$4,000	100%	$3,000

An even split ($1,000 each) would show a large loss on the Lincoln cent and an inflated profit on the Morgan. The proportional split keeps each coin's margin close to the margin of the whole purchase.

3. Record the sale price and the fees

When the coin sells, record the price the buyer paid for the coin itself. Leave out:

• Shipping you charged the buyer, which pays for shipping.
• Sales tax you collected, which you pass on.

Then record the fees of the channel. Each place you sell takes something different: a marketplace final value fee, a payment processing fee, an auction platform's seller commission. Fee rates change, so check the current rates on each platform's seller pages rather than relying on a number you remember.

4. Subtract

Here is one coin worked through:

• Sale price: $2,750.00
• Cost (from the split above): $1,800.00
• Channel fee at 13%: $357.50
• Profit: $2,750.00 − $1,800.00 − $357.50 = $592.50
• Margin: $592.50 ÷ $2,750.00 = 21.5%

The same coin sold at your counter for $2,600 with a 3% card fee:

• Fee: $78.00
• Profit: $2,600.00 − $1,800.00 − $78.00 = $722.00
• Margin: 27.8%

The lower price at the counter made $129.50 more. You only see that if you track fees per sale.

5. Handle returns

A return takes the sale back. Take the price off revenue, put the coin's cost back into stock, and count the return on the day it happens, not on the original sale date. If you rewrite last month's numbers each time a coin comes back, last month's report changes after you have already used it.

Compare profit by channel

Once each sale has a cost and a fee, group them by where they sold. A simple monthly table answers the question most dealers argue about:

Channel	Revenue	Coin cost	Fees	Profit	Margin
Counter and direct	$18,400	$13,100	$550	$4,750	25.8%
eBay	$12,480	$8,960	$1,640	$1,880	15.1%
Auction platforms	$9,800	$6,900	$1,470	$1,430	14.6%

The numbers here are an example. The pattern is common, though: online channels bring volume and reach, and they cost more per sale. That can still be the right trade. A coin that sits at the counter for a year ties up money that a 15% margin sale would have freed in a week.

Sell-through and inventory age: profit you have not made yet

Profit per coin tells you about coins that sold. Two more numbers tell you about the coins that did not.

Sell-through rate

Sell-through is the share of coins that sold out of the coins you had to sell in a period:

Sell-through = coins sold ÷ (coins sold + coins still in stock)

If you sold 86 Morgan dollars this quarter and have 214 left, sell-through is 86 ÷ 300 = 28.7%. Compare it by category. If Morgans sell through at 29% and early type coins at 6%, you know where to buy and where to hold back.

Inventory age

Group the coins in stock by how long you have had them: 0 to 30 days, 31 to 90, 91 to 180, 181 to 365, and more than a year. Then add up the cost in each group. If $100,000 of cost has been in stock for more than a year, that is money that is not working. Many dealers set a rule: anything older than a set age gets repriced, sent to auction, or offered to a wholesaler.

Operating expenses: keep them out of profit per coin

Rent, show tables, insurance, software, and travel are real costs. Do not spread them over individual coins. It makes profit per coin depend on how many coins you sold that month, which hides the coin's own result.

Instead, track two numbers:

• Gross profit: revenue less coin cost less selling fees. This is the sum of profit per coin.
• Net profit: gross profit less operating expenses for the period.

If gross profit for October was $8,060 and operating expenses were $5,200, net profit was $2,860. When you look at one channel or one category, look at gross profit only. Operating expenses belong to the whole business, not to eBay or to Morgans.

Common mistakes

• Recording cost at the time of sale. Memory is generous. Record it when you buy.
• Even splits on group purchases. They make cheap coins look like losers and expensive coins look like winners.
• Counting shipping and tax as revenue. Your margin looks higher than it is.
• Ignoring fees on counter sales. Card processing is a fee too.
• Changing old months for returns. Count the return when it happens.
• Looking only at what sold. Old stock is a cost even when nothing happens to it.

Sales tax, inventory accounting, and how you report income are questions for your accountant. The method above is for running the business day to day.

How CoinManagerPro does this

CoinManagerPro keeps the cost on each coin, splits a recorded purchase's cost over its coins, and records every sale with its channel: direct invoices, eBay and Walmart orders, and auction results you import. The reports use those records:

• The Profit report takes coin cost, marketplace and auction fees, and operating expenses off revenue. It leaves operating expenses out when you filter to one channel or one group, as described above.
• The Sold items report lists each coin sold with its price, cost, and profit.
• Revenue groups by channel, category, grading service, coin type, source, consignor, or contractor. A consigned coin is costed at the consignor's share.
• Units sold shows sell-through and slow movers, and Inventory value shows stock at cost and estimate by age.
• Returns come off revenue, units, and cost on the day of the return.
• Every report exports as CSV.

You choose who sees money. A member without permission to see cost sees units and stock age but no cost or profit; see team permissions. The help article on reporting walks through each report.