Why Your Payout Report Is Not Your Profit
Open any selling platform and you will find a payout or sales report. It is useful, and it is accurate about what it covers. But it answers a different question than the one you care about. The report says what the platform paid out. It does not know what you paid for the item.
Three numbers get mixed up all the time: revenue, payout and profit. Revenue is what the buyer paid. Payout is what is left after the platform takes its cut. Profit is what is left after you also subtract everything the platform never saw. A 40.00 sale can pay out 32.00 and still leave only 12.00. A 20.00 sale can pay out 20.00 and lose 10.00. Here is how that happens.
One table, four sales
All figures in this article are example data: invented sales with an invented fee table, taken from the Sales Log of our Reseller Profit Tracker. They are not real sales and not any platform's real fees.
In this article, "payout" is a calculation, not a platform report: sale price minus platform fee. In these four rows it matches the Net proceeds column, because the shipping the buyer paid and the shipping you paid are either zero or cancel out.
Read the rows one by one.
The leather bag sold for 120.00. After a fee of 13.48 the payout is 106.52. You bought it for 40.00 and spent 8.00 on other costs, so the profit is 58.52.
The vintage tee sold for 12.00. After a fee of 2.95 the payout is 9.05. It cost 3.00, so the profit is 6.05.
The rain jacket sold for 40.00. After a fee of 8.00 the payout is 32.00. It cost 20.00, so the profit is 12.00.
Get Size Run Studio’s stories in your inbox
Join Medium for free to get updates from this writer.
The low-top sneaker sold for 20.00 with no fee, so the payout is 20.00. It cost 25.00 plus 5.00 in other costs, so the profit is minus 10.00.
The gap is your purchase price
Subtract profit from payout and you get the buy price plus other costs: 48.00 for the bag, 3.00 for the tee, 20.00 for the jacket and 30.00 for the sneaker. That gap is everything the platform does not see: what you paid for the item, packaging, cleaning, repairs, ads. This is why the purchase price has to sit in the same row as the sale.
The sneaker is the point of the whole article. A payout of 20.00 feels like money in. The item cost 30.00 in total, so it was a loss of 10.00 that no payout report would ever show.
Keep resale stock apart from personal items
While you are adding the cost column, add one more. Payout reports mix everything you sold, including things you already owned. A simple "Type" column with the values resale or personal lets you filter later. This is a manual habit, not a feature of any particular sheet, and it is bookkeeping organisation, not tax advice. Rules depend on where you live, so ask a tax professional.
A five-minute weekly check
Once a week, take the new sales since the last check and run four questions. Does every row have a purchase price? Is the fee in the row the fee the platform actually charged? Is there any row where profit is negative, and what caused it? Do the shipping and packaging costs sit in the same row as the sale? Five minutes of this beats a year-end search through reports.
The platform tells you what it paid you. The row in your own sheet tells you what you kept.
Disclosure: I sell the spreadsheet linked below, and every figure in this article is example data from it.
If you want the same columns ready made, the Reseller Profit Tracker for Excel and Google Sheets has them.
