How to download and read the Whatnot Weekly Order Report

Whatnot publishes a Weekly Order Report for every week your account had completed transactions. To download one, sign in at whatnot.com in a desktop browser, open your Seller Hub, and go to Finances, then Statements & Reports. Each week is one row with its own download, and the file arrives as a CSV you can open in Excel or Google Sheets. The file itself downloads with a name ending in earnings.csv.

A new report appears every Monday at 6am UTC and covers Monday through Sunday of the week just ended, also in UTC. Everything in this guide matches Whatnot's public seller documentation as of August 2026; if something looks different in your file, check Seller Hub for the latest.

The report lists completed transactions only. An order counts as complete once your earnings for it have been processed into your balance. With Early Payout that happens when you generate the shipping label; without it, typically a few hours after delivery is confirmed. The timing matters: an item you sold on Friday can land in the following week's report if it was still in transit on Sunday night. The payout side has its own clocks, covered in when do Whatnot sellers get paid.

Payouts, referral bonuses and promotional spend are not in this file. Those live on the Ledger page, which has its own export.

Tracing a bank deposit back through this file is its own walk, covered in how to reconcile Whatnot payouts.

Every row carries a Transaction Type, and there are four. Order Earnings is a completed sale: the price, the fees taken out, and what you kept. Order Refund is a full or partial refund you accepted or Whatnot issued on your behalf. Tips are what buyers tipped you in a show or on your profile. Shipping Charge is extra shipping cost you owe, such as a label adjustment.

One order can produce more than one row. Sell an item on Monday and refund it on Friday, and that order id appears twice: once for the sale, once for the refund. The true result for any order is the sum of the Transaction Amount column across every row that shares its order id.

The file has 36 columns. They make much more sense in groups.

When: Report Start Date, Week Number, Order Placed At UTC (blank on rows that are not sales) and Transaction Completed At UTC, which is what the report is sorted by. Every timestamp is UTC, not your local time.

What sold: Order ID, Listing Title, Listing Description, Product Category, Buy Format (Auction, Buy-it-Now or Giveaway), Sale Type (marked FLASH for flash sales), Quantity Sold, and SKU and Cost of Goods if you filled those optional fields when listing.

Where and who: Livestream ID and Livestream Title (blank when the sale happened outside a live show), Buyer Name, Buyer State, Buyer Country, and Shipment ID.

The money: Transaction Currency, Transaction Amount (signed, and exactly what hit your balance), Buyer Paid, Original Item Price, Coupon Cost, Post Coupon Price (the price after your own coupons, and the number commission is charged on) and Shipping Fee, which is seller-paid shipping including giveaway shipping.

The fees: Commission Fee, Payment Processing Fee, and Tax on Commission and Tax on Payment Processing Fee. In some countries, Australia included, tax is charged on the fees themselves, so those two columns are real costs rather than curiosities.

Refund bookkeeping: Ledger Transaction ID, Order Refund Shipping Costs, Appealed Order Refund and Appealed Shipping Refund, which record money coming back to you when an appeal goes your way.

First, one order is often several rows. If you count rows you overcount sales, and if you read only the sale row you miss the refund. Group by order id and sum Transaction Amount.

Second, giveaways show negative earnings. A giveaway sells for nothing and you pay its shipping, so its Transaction Amount sits below zero. That is a marketing cost doing its job, not an error in the file.

Third, the two fees are charged on different bases. Commission is a percentage of the post-coupon item price. Payment processing is a percentage of everything the buyer paid, including their shipping and tax, plus a fixed amount. Two fees on the same sale, two different starting numbers.

The Weekly Order Report is honest about revenue and fees, but it cannot know what your inventory cost you. That gap is the difference between feeling profitable and knowing it.

If you want to build the profit view yourself, our free profit and loss template has it prebuilt, and we wrote a step-by-step walkthrough of turning the report into a P&L in Excel, and how to track your profit on Whatnot compares the honest ways to keep the numbers.

BreakCount reads this exact file, asks you for one cost per purchase lot, and spreads that cost across the lot's sales, so every show ends with a real net profit instead of a guess.

Start free