How to download and read the Whatnot Weekly Order Report

The Weekly Order Report is the CSV Whatnot issues every Monday, listing each of the week's completed sales, refunds, tips and shipping charges with the exact fees per transaction. To download one, sign in at whatnot.com in a desktop browser, open your Seller Hub, and go to Finances, then Statements & Reports. Whatnot publishes one for every week your account had completed transactions. Each week is one row with its own download, and the file opens in Excel or Google Sheets; it 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. Because each week is its own download, exporting your Whatnot sales history means taking one file per week, and that page collects the window every Whatnot surface documents. 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.

Because the report carries completed transactions, not sales, and a sale completes when its earnings reach your balance. With Early Payout that is when you generate the shipping label; without it, typically about four hours after delivery is confirmed. So a Friday show whose parcels arrive on Tuesday lands in next week's file.

No, and Whatnot says so on the report's own help article, dated 6 May 2026: it is not an official document for regulatory reporting, and it points at Monthly or Annual Statements instead. The weekly file is still the one with every order's fees itemised, which is why you reconcile and import from it.

The two files are built for different jobs rather than ranked against each other. A statement is a monthly or annual summary of income, fees, costs and payouts with no individual sales in it; the weekly report is every sale with its fee columns and no summary at all. Whatnot names Seller Statements, Form 1099 and the Ledger together as the source of truth for tax and reporting. Whatnot seller reports explained sets all eight surfaces side by side with what each one leaves out.

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. It is charged per shipment rather than per order, and it can arrive weeks after the show that produced the parcel.

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. Those first two are what let you rebuild one show out of a week's file, which the Whatnot show report compares against, alongside Seller Analytics.

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. Why that column has anything in it when buyers pay by default is covered in who pays shipping on Whatnot.

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