Seller Weekly Orders Report Seller Weekly Orders Report

Seller Weekly Orders Report

Whatnot Support Whatnot Support

Note: This feature is currently in beta mode, and only available to a select group of test sellers. It will be rolled out to all sellers soon.

Overview

Whatnot provides sellers with a weekly orders report summarizing your order-level completed transactions and tips. This report can help you learn more about the revenue and costs associated with orders and tips, empowering you to develop a greater understanding of your business.

The recent week’s report is available every Monday at 6am UTC (Universal Coordinated Time). In EST (Eastern Standard Time), this would be 1:00am or 2:00am on Monday, depending on daylight savings time. The report includes all relevant transactions that were completed* from Monday 12:00:00 am UTC to the following Sunday at 11:59:59 pm UTC. 

*Important note: This report contains only completed orders, meaning your earnings for this order have been processed and are available for payout.

  • Sellers with Early Payout: your orders are “complete” after you've generated labels for your orders
  • Sellers without Early Payout: your orders are typically “complete” within 4 hours after the order is confirmed as delivered

What’s included in the report?

  • A. Your completed orders earnings, broken out by sale price, costs (i.e., Whatnot commission, payment processing fees, and seller-paid shipping), and your resulting earnings
    • If an order was sold in a live show, you’ll see the name and ID of that show appear in respective columns
  • B. Tips from shows or from your profile (learn more)
  • C. Order refunds, which will include all complete refunds - whether they’re partial or full, and initiated by Whatnot or the seller 
  • D. Additional shipping costs, such as shipping label adjustment fees (including BYOL cost) as applicable 

Each of the above transaction types will appear as a separate row in the exported CSV. For example, if you sold an item on Monday but that item was refunded on Friday, you’ll see two rows associated with that order ID – one for the original order earnings, and one for the cost of the refund.

Please note that the report only contains transactions related to orders and tips, for the sake of tracking revenue and costs associated with your inventory and shows. Transactions that are not included in the weekly orders report include: seller referral bonuses, spend on promotional tools, affiliate referral bonuses (not an exhaustive list). For a complete view of every transaction impacting your account balance, please view the Ledger page, which you can also export into a CSV.

This report is not an official document to be used for regulatory reporting purposes. For official financial statements, please select “Monthly Statements” or “Annual Statements” from the Financials page in the Seller Hub.

Accessing your weekly orders report

To access this report:

  1. Log into your seller account whatnot.com on your desktop browser 
  2. Open your seller menu by clicking your icon in the top right corner
  3. Select “Financials”
  4. Select the “Statements” tab
  5. Identify the week’s report you would like to download, and click “download”

This report will download as a CSV file. If you’d like to perform an analysis on this report, we recommend uploading or copying and pasting the data from this CSV into a program like Excel or Google Sheets. 

Metric Definitions

  • Report Start Date: The first day of the week captured in this report. Please note this time is in UTC (Coordinated Universal Time).
  • Week Number: Weekly report sequence within the calendar year
  • Order Placed At UTC: The date and time (in UTC) at which the buyer purchased your product. This column may be blank for rows where the “Transaction Type” is not Order Earnings.
  • Transaction Completed at UTC: The date and time (in UTC) at which the funds from this transaction impacted your account balance – i.e., when the transaction became “complete." 
    • Note: the transactions in this report are sorted chronologically by this timestamp
  • Transaction Type: A transaction type will be one of the following options:
    • Order Earnings: A transaction that resulted from the sale of an item. This number is calculated by taking the sale price for a completed order, and subtracting the commission fee, payment processing fee, and any seller-paid shipping fees (including giveaway shipping). 
    • Order Refund: The value of returned funds to a buyer after an order has been completed. Please note this only includes refund requests you accepted or Whatnot issued on your behalf; pending or rejected refund requests are not included.  
    • Tips: Tips you accrued from users through Whatnot’s tipping feature, either from a live show or from your profile.
    • Shipping Charge: Additional shipping costs that you owe Whatnot. These include shipping label adjustments (outside of your weekly allowance) and BYOL costs. This does not include any seller-paid shipping charges that originally occurred at the time of order.
  • Transaction Message: The information that appears in the Ledger message for the corresponding Ledger transaction.
  • Order ID: unique identifier Whatnot assigns to an order (the sale of an item or completion of a giveaway).
  • Listing Title: The title of the listing at the time of this order.
  • Listing Description: The description of the listing at the time of this order.
  • Product Category: The Whatnot product category of this listing at the time of order. This will be shown as the most detailed category available within our product taxonomy.
  • Buy Format: The buy format for the listing at the time of order. This will be Auction, Buy-it-Now, or Giveaway.
  • Sale Type: if a BIN order was sold as a flash sale, you’ll see “FLASH” in this column; otherwise, this column will be blank
  • Quantity Sold: The quantity of items sold in this order. Only Buy-it-Now orders can have a quantity greater than 1. 
  • SKU: If you entered the optional field of SKU when creating this listing, that information will appear in this column. Otherwise, the column will be blank.
  • Cost of Goods: If you entered the optional field of COGS when creating this listing, that information will appear in this column. Otherwise, the column will be blank.
  • Livestream ID: unique identifier of live show where this order occurred. If the sale occurred outside of a live show, this column will be blank.
  • Livestream Title: The title of the show where this order occurred. If the sale occurred outside of a live show, this column will be blank.
  • Buyer Name: The username of the user who purchased this order.
  • Buyer State: The state of the shipping address for this order.
  • Buyer Country: The country of the shipping address for this order.
  • Shipment ID: unique identifier Whatnot assigns to a package or shipment. Please note this is different from a shipment tracking number that may be generated by the carrier. 
  • Transaction Currency: The currency in which the order was paid. See here for more information on seller location and currency requirements.
  • Transaction Amount: the amount that you are paid (if transaction is positive) or charged (if transaction is negative). This is the amount that impacts your Whatnot account balance and will show up on your ledger. 
    • When the Transaction Type is “Order Earnings,” the Transaction Amount represents how much money you earned from this order.
  • Buyer Paid: The total order value paid by the buyer. This is the sum of the final sale price (after any seller-generated coupons applied), buyer-paid taxes, and buyer-paid shipping.
  • Original Item Price: The sale price for an item, before any seller-generated coupons are applied. This does not include shipping or taxes. 
  • Coupon Cost: The value of any seller-generated coupons applied to the order. This does not include any Whatnot-generated coupons or Whatnot-issued credit that buyers may use.
  • Shipping Fee: The value of any seller-paid shipping costs, including giveaway shipping. If the buyer paid all shipping costs, this value will be 0.
  • Commission Fee: The commission amount Whatnot deducted from your sale. Learn more about our fees here.
  • Payment Processing Fee: fee charged by the payment processor for the order. In the US and CAN, this is 2.9% + $0.30 of the total order value (i.e., the “Buyer Paid” amount). Learn more about our fees here.
  • Tax on Commission: In some geographies, Whatnot is required to charge sales tax on the commission amount. Learn more
  • Tax on Payment Processing Fee: In some geographies, Whatnot is required to charge sales tax on the payment processing amount. Learn more
  • Ledger Transaction ID: This is the unique transaction ID number that you will see in your ledger. You can lookup this ID to check on the status of your earnings from the ledger. 

FAQs

Q: Why do I have more than 1 row in this report with the same order ID?

Multiple transactions may pertain to the same order. For example, if the sale for an order occurred on Monday and a refund was issued on Friday, you would see two rows in the weekly export – one for the original “order earnings,” and then one for your adjusted “order refund” amount. 

To understand the net financial impact of this order, you should sum up the “transaction amount” of all rows with the same order ID.

Q: Why do I have a negative “Transaction Amount” value for some of my “Order Earnings” transactions?

Your earnings are likely negative because this order is a giveaway. If the giveaway is not a local pickup order, your earnings for this order will always be negative given seller-paid shipping costs are deducted from the $0 price. 

Q: Can I have this report on a more frequent basis? For example, right after a show ends?

Right now, we are only offering this report on a weekly basis. 

If you need immediate information on orders from a recent show, you can access the livestream report from the Shipments page. While this does not contain detailed earnings information, it does contain product and shipping details on orders sold that you can use for fulfillment purposes. 

Q: In what time zone are the timestamps in this report?

The transaction time appearing in this report is in UTC – Coordinated Universal Time. 

Please note that UTC is 4-5 hours ahead of EST and 7-8 hours ahead of PST, depending on daylights savings time. If you would like to convert UTC to your local time, there are a number of free time zone converters available online.

Q: What transaction types are not included in this report?

This report includes all completed order-related transactions and tips, which should encompass the vast majority (if not all) transactions that impact a seller’s account balance. However, there are some transaction types that are not related to orders, and are thus not captured in this report. 

Transaction types not in this report include: payouts, seller referral bonuses, affiliate referral bonuses, promotional spend.

For a complete view of every transaction impacting your account balance, please view the Ledger page.

Q: Are incomplete and/or cancelled orders included as “Order Earnings” in this report?

No. This report does not include:

  • Pending (incomplete) orders: Your earnings for this order have not yet been processed. In most cases, an order is pending because it is still in transit and has not yet been delivered to the buyer (for non-Early Payout sellers).
    • Once the order is confirmed as delivered to the buyer, it will become “complete” on the date of delivery and appear in that week’s orders report.
  • Orders with failed payments: The transaction could not be completed due to buyer payment failure. This can happen when a buyer’s payment method needs verification or if there's an issue with the payment process. 
  • Cancelled orders: The transaction was successfully completed, but the order was then voided by the buyer, the seller, or Whatnot Support before the buyer could receive the item. Cancellations will result in adjusted earnings of $0 for sellers and are not included in this report.
    • If you would like to see a history of your cancelled orders, please access the Orders page and select the “Cancellations” filter. 

Q: I sold an item during a given week, but I’m not seeing the corresponding “Order Earnings” in that week’s report. Why is this information missing?

This order is likely not included in that week’s report because the order was not completed during that week. An order becomes “complete” once the earnings from that order have processed and are available in your account balance.

 If you’re a seller without Early Payout, your orders are typically not “complete” until 4 hours after the order has been confirmed as delivered to the buyer. If you’re a seller with Early Payout, your orders are “complete” as soon as you generate the shipping label.

For example, let’s say a seller without Early Payout sold an item in a show on Friday, April 4. That item was confirmed as delivered to the buyer on Tuesday, April 8. The earnings for that order would then appear in the seller’s weekly report from Sunday April 6 through Saturday April 12, given the order was completed on April 8. 

Q: What types of refunds will appear in this report?

You will see all completed, seller-funded refund transactions that occur during this time period. This includes any refunds you accepted, or Whatnot issued on your behalf. This includes both partial refunds and full refunds. 

This does not include rejected refund requests or pending refund requests. Additionally, this report does not include any refunds where Whatnot covered the full cost of the refund for the buyer.

See here for more information on seller-managed refunds. 

Q: I’m looking for an order that was refunded, but I’m not seeing the refund transaction appear in this report. Why?

The reason this refund transaction is missing is likely because the refund occurred outside of this week. For example, let’s say an order was completed on Jan 8 2025, and that order was refunded on Jan 16 2025. The transaction for the order earnings would appear in the Jan 5 - Jan 11 weekly report, but the transaction for the refund would appear in the Jan 12 - Jan 18 weekly report.

Q: I have a “Shipping Charge” transaction type on my report. How can I figure out which orders were included in this shipment associated with the charge?

Shipping fees are charged at the shipment level, meaning this transaction connects to one Shipment ID. A shipment can contain multiple orders (i.e., multiple Order IDs). 

If you want to know which orders are associated with a given Shipping Charge, we recommend copying the Shipment ID appearing in the report. You can then paste this Shipment ID into the Shipments page search bar, and you should see the resulting orders contained in this Shipment.

Q: Is my activity as a buyer captured in this report?

No, the transactions in this report only pertain to your activity as a seller, not as a buyer. For example, if you purchased an item from another seller’s live show, that will not appear in this report.

If you would like to download information on your purchase history as a buyer, please refer to the steps outlined in this article.