How to track your profit on Whatnot
The numbers worth tracking per show and per lot, three honest ways to keep them, and where each method runs out of road.
The short list of numbers that matter
Tracking profit on Whatnot comes down to three levels.
- Per show: gross, the fees, the shipping you paid, and what you gave away, which together leave show profit.
- Per purchase lot: what it cost you and how much of it has sold, so each sale carries its fair share of the cost.
- Per month: the other costs, supplies, subscriptions and equipment, that no single show owns.
Take all three away from gross and what is left is net profit, the only number that tells you whether the hours were worth it.
Where the numbers come from
The revenue side arrives weekly. The Weekly Order Report lists every completed transaction with the commission and payment processing fees as separate columns, refunds as their own rows sharing the original order id, and giveaways as small negative amounts whose cost is the shipping you paid. Everything the money did on its way to you is in that file.
The cost side never arrives anywhere. What you paid for the case, the collection or the pallet lives in your bank statement and your memory, and it is the half of the ledger every tracking method below stands or falls on. We wrote about why the platform cannot show this half in does Whatnot show your profit.
Three ways to keep them
A notebook, or a sales tracker in a phone note, works at one show a week: write down gross, costs and what you paid for inventory, and you are ahead of most sellers. It fails silently as volume grows, because refunds, giveaways and part-sold lots stop fitting in a margin note.
A spreadsheet is the honest next step, and done well it can carry a real business. We wrote a full walkthrough of turning the report into a P&L in Excel, and our free profit and loss template has the same logic prebuilt. The spreadsheet road's limits arrive on schedule: netting refund rows, spreading one lot's cost across sales that land in different shows and different weeks, and the discipline of doing the import ritual every Monday, forever.
The rule for that spreading, pro rata by gross with the cents reconciled exactly, is worked in full in how to split a lot's cost across Whatnot sales.
BreakCount is the third way and the reason this site exists. Import the same weekly file, add one cost per purchase lot, and it allocates costs across the lot's sales, reconciles every fee, and gives each show a verdict with its real net profit, plus the per-lot view: cost, gross profit, net profit and days held.
The habits that make any method work
Log a lot's cost the day you buy it, not the week something from it sells; memory rounds numbers down. Reconcile against the report weekly, because an untracked refund flatters every total that follows. And never call a show profitable while a cost is still missing: a net computed over a blank is not a small error, it is a guess wearing a number's clothes.
If a show's total already looks wrong, why your Whatnot profit is lower than expected walks the leaks in the order the money leaves.
One more: judge shows by percent of gross kept and by net profit per live hour, not by gross. Those two ratios are what make a profit tracker worth keeping, because they are the ones that change your next show.
And keep the bank balance as its own number, because a profitable month can still leave the account empty: Whatnot profit vs cash flow works through why.
Start with this week's report
Whichever method you pick, the starting point is the same: download this week's report, put a cost against every lot that sold, and look at the net. If you would rather the arithmetic ran itself, BreakCount does it from the same file.