ClearStream Ledger
Whatnot to Xero & QuickBooks Online · 100% local browser engine

Whatnot payouts reconciled to Xero & QBO — to the cent.

Convert Seller Hub CSVs into balanced payout-batch clearing journals and flag 45-day USPS weight adjustments locally in your browser. Zero Chrome extensions and zero buyer PII uploaded.

Client-side bookkeeping & dispute formatting tool — not legal, tax, or accounting advice.

whatnot-clearing-scanner.local 0 bytes uploaded
Drop Whatnot CSV files here, or click to browse
Weekly Orders, Ledger Statements, or Carrier Adjustments CSVs
Batch variance
$0.00 exact
USPS appeal guard
45-day window
Target ledger
1050 Clearing

Ready — drop a Seller Hub CSV or click “Load sample CSV” to inspect balanced journals.

Sample output

Test with a realistic Q4 Seller Hub dataset

Inspect raw input rows alongside balanced double-entry Xero and QuickBooks Online clearing journals before loading client files.

10 rows · 3 payout batches

Q4 Whatnot Seller Hub Sample CSV

Includes auction sales, prepaid buyer shipping pass-through, giveaway shipping, a cross-batch refund, and 5 USPS carrier weight adjustments.

$0.00 batch variance

Xero & QBO Clearing Journal Preview

Click “Load sample CSV” in the scanner above to generate and download Batch #1 Xero Manual Journal and QBO Journal Entry CSVs free.

Clearing architecture

Why e-commerce bookkeepers use a clearing account for Whatnot

Pushing thousands of $5 livestream auctions individually into QuickBooks or Xero bloats the ledger, while Whatnot’s public API omits settlement-level fee and APV breakdowns. ClearStream applies the standard clearing-account workflow in three steps:

Step 1

Export official CSVs

Download your Weekly Orders Report (Seller Hub → Financials → Statements) and Carrier Adjustments CSV. No browser scraping extensions required.

Step 2

Audit fees & 45-day APV

Separates prepaid-label buyer shipping from seller revenue, checks dynamic 28-day commissions + 2.9%+$0.30 processing fees, and strips livestream slang from USPS appeal notes.

Step 3

Match bank deposits to $0.00

Import the balanced summary journal into Xero or QBO. Match incoming bank transfers directly against 1050 Whatnot Clearing with zero variance.

Transparent pricing

Flat passes with zero per-order penalties

1,500 fast $5 livestream auctions shouldn’t cost $389/month to reconcile. Choose a one-time 2026 catch-up pass or flat monthly workspace.

High-volume sellers

Seller Pro Unlimited

$45 / month

Unlimited auction orders for 1 Whatnot shop, full Xero & QBO clearing CSV exports, custom SKU+box tare table, and ongoing 45-day USPS dispute packet export.

Bookkeepers & CPA firms

CPA Practice Desk

$129 / month

Manage up to 15 Whatnot client shops, reusable Chart of Accounts templates across Xero & QuickBooks Online, reconciliation proof sheets, and 1 complimentary client pilot.