Turn the Whatnot Weekly Order Report into a P&L in Excel

Starting point: one Weekly Order Report CSV, downloaded from Seller Hub. If you have not met the file yet, read the report guide first; this walkthrough assumes its column names. End point: a sheet that answers two questions honestly in Excel or Google Sheets. What did each order really pay me, and what did each show really earn.

Open a blank workbook and import the CSV rather than double clicking it, so nothing gets auto-mangled: Data, then From Text/CSV in Excel, or File, then Import in Google Sheets. Check that Transaction Amount came in as a number and that the two timestamp columns survived as dates. Keep one week per tab and remember every timestamp is UTC, so a show streamed on your Saturday evening can carry a Sunday date.

The file's one iron rule: an order is every row that shares its Order ID, summed on Transaction Amount. A refunded sale is two rows, the sale and the refund, and only their sum is what you kept. Count rows and you overcount sales; read only sale rows and you miss the refunds.

The formula shape is a SUMIF: with Order ID in column G and Transaction Amount in column W, where Whatnot's documentation places them today, an order's true result is =SUMIF(G:G, G2, W:W). Put that on a deduplicated list of order ids (Data, Remove Duplicates on a copy of the column) and you have the per-order ledger.

Build a pivot table with Livestream Title as rows and three values: sum of Transaction Amount, sum of Commission Fee, and sum of Payment Processing Fee. That is each show's payout with its fee lines visible. Rows with a blank Livestream Title are marketplace sales that happened outside any show; give them their own bucket rather than deleting them. You can sanity-check any single order's fees against the free fee calculator.

Giveaways need one extra column: they carry their cost in Shipping Fee (the buyer paid nothing, you paid the postage), so sum Shipping Fee where Buy Format is Giveaway to see what each show's giveaways cost.

First, refund rows, covered above and in the report guide: group by Order ID or every total flatters you. Second, giveaway rows are negative on purpose, a marketing cost rather than dirty data to filter out. Third, the file holds two more transaction types worth respecting: Tips, which lift a show's total (show tips carry the Livestream ID, profile tips do not), and Shipping Charge rows, label adjustments that join to orders by Shipment ID and can span more than one order, so they belong at the week level unless you enjoy pain.

Everything above is revenue and fees, and Excel handles it well. What the sheet still cannot tell you is profit, because the report has no idea what your inventory cost. The moment one case feeds thirty spots across two different shows, or a collection buyout sells over six weeks, you are hand-allocating one purchase across dozens of rows, every week, forever. We wrote about that gap in does Whatnot show your profit.

If you want this built for you, our free profit and loss template ships these formulas ready to paste into. BreakCount picks up exactly where the pivot table gives out: import the same CSV, add one cost per purchase lot, and every show gets a verdict with its real net profit, refunds netted and fees reconciled for you.

Start free