How to reconcile Whatnot payouts with your report

Because a deposit and a week of sales are two different quantities measured on two different clocks. The deposit is a withdrawal of whatever was available in your balance at the moment you asked for it.

Your sales are what you sold, before fees, before the shipping you paid, before refunds, and before the delay between selling something and the earnings becoming available at all. Those two numbers are not supposed to match, and the job is to trace one to the other.

The trace has two halves: the arithmetic, which walks the Weekly Order Report from gross down to what hit your balance, and the timing, which explains why that total still is not the deposit. Do them in that order.

Download the week from Seller Hub under Finances, then Statements & Reports. Our guide to the Weekly Order Report covers every column and where the file lives; this is the subset that reconciles, in the order it comes off.

• Start with Post Coupon Price across the sale rows. That is your real gross: the price after your own coupons, and the number commission is charged on.
• Take off Commission Fee and Payment Processing Fee, then Tax on Commission and Tax on Payment Processing Fee, which are real costs wherever tax lands on the fees and you are charged it.
• Take off Shipping Fee, the shipping you paid. Giveaway shipping is in this column too.
• Net the refund rows, summing every row that carries the same order id.
• Add the tips. Show tips carry a Livestream ID; profile tips do not belong to any show, so they are real money that no show total will ever account for.
• Take off any Shipping Charge rows. These are shipment-level costs such as label adjustments, matched by Shipment ID rather than by order.

Now check your work the short way: sum the Transaction Amount column across every row in the file. That column is signed and is exactly what hit your balance, so it is the file's own answer to the same question. If it disagrees with your line-by-line walk, re-check the walk first; Transaction Amount is the column Whatnot documents as what actually moved.

The report carries completed transactions only, and a transaction completes when your earnings for it are processed into your balance, not when the hammer fell. Without Early Payout that usually follows confirmed delivery; with it, earnings become available when you generate the label. So an item sold on Friday that was still in transit on Sunday night sits in next week's file, not this one. The clocks by country are in when do Whatnot sellers get paid.

Then the payout itself is a separate event on a separate schedule. You request it, it takes business days to land, and it empties whatever balance existed at that moment, which is routinely made of parts of two different report weeks. One more boundary: payouts, referral bonuses and promotional spend are not in the Weekly Order Report at all. Those live on the Ledger page, which has its own export, and a deposit you cannot find in the report is often sitting there.

In roughly the order that finds it fastest:

• Refunds. Check these first, because they are the easiest to miss: a refund on a sale from three weeks ago comes out of this week's money, and if you are reading only sale rows you will never see it.
• The week boundary. Compare the report's date range against the days your payout actually covered. A new report appears every Monday at 6am UTC for the week just ended, also in UTC, which is not the week your local calendar shows.
• Tips counted as sales. Tips inflate a gross that you then compare against a payout, and profile tips are not attached to any show.
• Shipping charges. Label adjustments arrive later than the sale they belong to and reduce a payout without touching any sale row.
• Slow-completing sales. Shipping methods without standard tracking run on fixed timers, so those earnings can sit in processing for over a week by design.
• The Ledger. If the arithmetic reconciles and the deposit still does not, the difference is an event the order report does not carry.

Five minutes, once a week, in this order:

1. Download the week's report and note its date range.
2. Sum Transaction Amount across every row. This is the week's money.
3. Group by order id and confirm no order has an unexpected second row.
4. Separate the four row types so tips and shipping charges are not mistaken for sales.
5. Compare against your balance movement, not against a single deposit, and expect the edges of the week to fall outside it.
6. Only then put costs against the lots that sold, and read the net profit.

Doing this weekly rather than annually is the entire trick. A discrepancy found inside seven days is one file and one memory; the same discrepancy found in January is an archaeology project.

A perfect reconciliation tells you the money is accounted for. It says nothing about whether the week was worth it, because the largest number in the business, what the inventory cost you, is in none of these files. That gap is covered in why your Whatnot profit is lower than expected.

BreakCount reads this exact file, nets the refunds, separates the tips and shipping charges, spreads each lot's cost across the sales it produced, and hands every show a verdict with a real net profit. The reconciliation stops being a Monday ritual and becomes an import.

Start free