Resource · Updated May 2026
Whatnot spreadsheet
How sellers track Whatnot in Google Sheets / Excel, the columns you need, and when a spreadsheet stops scaling.
No credit card. $19/mo if you keep going.
Short answer
Spreadsheets work up to ~50 sales/week. Past that, refunds, shipment-level shipping, and tax reconciliation eat too many hours. Most $5K+/mo sellers switch to a tool.
The columns you need
Open your Weekly Orders Report from Seller Hub. Add these columns. The formula columns work in Google Sheets and Excel without modification.
| Column | Where it comes from |
|---|---|
| Order date | Weekly Orders Report column 'Order Placed At UTC' |
| Show ID + title | 'Livestream ID' + 'Livestream Title' |
| Item name | 'Item Name' |
| Category | 'Category' (or assign manually) |
| Sale price | 'Original Item Price' |
| Buyer-paid shipping | 'Shipping Fee' |
| Commission (formula) | = sale price × 8% (10% sneakers) |
| Processing (formula) | = (sale + shipping) × 2.9% + $0.30 |
| Refund flag | True if 'Transaction Type' = 'Order Refund' |
| Cost of goods | Manual: what you paid for the item |
| Profit (formula) | = sale - commission - processing - cogs - refund |
| Buyer username | Cross-reference Order History Export |
Skip the formulas?
Drop your weekly CSV in. We compute fees, profit, and per-show breakdowns automatically.
Where spreadsheets break down
Refunds break your weekly totals
Whatnot reports refunds in the week they're processed, not the week of the original sale. Spreadsheets don't reconcile this without complex VLOOKUPs.
Tips and shipping charges are SHIPMENT-level
Order ID can be blank. Multiple Order IDs share one Shipment ID. Spreadsheets need conditional joins, which most sellers skip.
Per-show profit requires GROUPBY math
Pivot tables get fragile fast. One wrong filter and your show profit is off by hundreds.
Buyer retention needs joining 2 CSVs
Weekly Orders Report has no buyer username. You have to export Order History separately and match by Order ID. Tedious weekly.
Tax season takes 4-6 hours
Reconciling 52 weeks of statements, categorizing fees, separating COGS, generating Schedule C-ready totals. Every spring.
Spreadsheet vs tool
Stick with spreadsheet if
- Under 30 sales/week
- Side hustle, not paying yourself yet
- 1-2 shows/week max
- You enjoy spreadsheet work
Switch to AfterShows if
- 100+ sales/week
- 3+ shows/week
- You want per-show profit not a row dump
- Tax season is eating weekends
- You can't tell repeat from one-time buyers
FAQ
FAQ
Can I track my Whatnot sales in a spreadsheet?⌄
Yes. Most sellers start in Google Sheets or Excel. Download your Weekly Orders Report from Seller Hub and add columns for cost, profit, category. Works fine up to ~50 sales/week.
When should I stop using a spreadsheet?⌄
Around 100+ sales/week or when you're running 3+ shows weekly. Manual cost entry, refund handling, and per-show breakdowns get unwieldy. Tax-season reconciliation alone eats a weekend.
What columns should be in my Whatnot spreadsheet?⌄
Order date, item name, sale price, commission (8%), processing fee (2.9% + $0.30), shipping, refund flag, cost of goods, profit (formula), show ID, buyer username, category. Reuse columns from the Weekly Orders Report.
Will AfterShows replace my spreadsheet?⌄
Yes for reporting, profit, and tax prep. Many sellers keep a spreadsheet for inventory + sourcing notes and use AfterShows for the analysis. They complement each other.
Outgrow the spreadsheet
Skip the VLOOKUPs. See real profit.
Per-show profit, COGS-aware margin, fee breakdown, lapsed-buyer alerts. All from your weekly Whatnot CSV.
No credit card. $19/mo if you keep going. Cancel anytime.