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. Whether that shipping should be yours at all is covered in does the seller pay shipping on Whatnot.
• 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.

Because a payout is your balance, and a balance can go the other way. Whatnot charges costs against the same balance it pays earnings into, so a week whose costs beat its completed sales leaves you owing rather than owed.

Four charges do it in practice: refunds billed back to you, the shipping you paid on orders and on giveaways, shipment-level shipping charges such as label adjustments, and spend on promotional tools, which is charged to the balance but never appears in the Weekly Order Report.

Find it in that order. Sum Transaction Amount across the week's report: if that total is already negative, the report itself explains the week, and the refund and shipping rows are where to look. If the report's total is positive and the balance still is not, the difference is an event the order report does not carry, so open the Ledger page and its own CSV export. Boost and promote spend, seller referral bonuses and cancellation fees live there, and a bonus challenge payout is the same shape again: what the goal actually counts covers the lock rule and the forfeit rule that decide whether one lands at all. Who ends up paying for a refund or a cancellation, and what each one takes out, is in what a Whatnot refund or cancellation costs.

Ads credit is Whatnot credit spendable only on promote tools, so it lifts what your Ledger shows without ever reaching your bank. Whatnot's Ledger help article, dated 13 May 2026, says ADS transactions are ads credit and REWARD and REWARD_DEBIT are general Whatnot credit spendable only on purchases, and that both should be excluded from any account balance calculation.

This is the gap that runs the other way. Everything above explains a balance that looks too small; credit explains one that looks too big. Add up your Ledger rows by hand with credit included and you will expect more money than the Payouts page will ever release, because part of that total can only be spent back inside Whatnot. Neither kind of credit is a sale and neither is a fee, so neither belongs in a show's numbers either. Whatnot seller reports explained sets the Ledger beside the other seven surfaces and says what each one leaves out.

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. If you are wondering whether any of this can arrive on its own, does Whatnot have an API answers that, and the short version is that the fee detail you just walked is not in it.

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