Multi-Channel Clearing Account Blueprint · Free .xlsx + CLI

eBay & Etsy 1099-K clearing account template & CSV converter.

Eliminate duplicate revenue and broken bank feeds across eBay Managed Payments, Etsy Payment Accounts, TikTok Shop, and Whatnot using a standardized Clearing Account journal template (.xlsx + automated QBO/Xero CSV converter).

Download Free .xlsx Clearing Account Template ($0) Get Automated Multi-Channel Kit — $39.50 (Code EARLY50) Order via Upwork Escrow Catalog Order via Fiverr Multi-Channel Gig

100% deterministic local spreadsheet & CSV conversion software — not CPA, tax, or legal advice.

Deterministic Engineering Architecture

How the Clearing Account method fixes eBay & Etsy 1099-K reconciliation

Stop Recording Net Deposits as Sales

Booking net eBay or Etsy bank transfers straight to Sales understates gross receipts against Form 1099-K Box 1a and hides Final Value Fees, Etsy Offsite Ads, and shipping label deductions.

Isolate Promoted Listings & Label Purchases

eBay Transaction Reports and Etsy Monthly Statements net USPS/UPS label purchases and ad clicks out of seller balances. Clearing journals split marketing and postage into proper expense accounts.

One Workflow Across 4 Marketplaces

Use our free Excel workbook for manual monthly summaries or run the offline ClearStream CLI/browser kit to auto-parse TikTok Shop, eBay, Etsy, and Whatnot CSVs in seconds.

eBay Managed Payments & Etsy Payment Account Clearing Structure

Marketplace Channel	Clearing Asset Account	Gross 1099-K Line	Key Deducted Fee & Label Buckets
eBay Managed Payments	1056 eBay Clearing	Gross Item + Buyer Shipping (excl. Facilitator Tax)	Final Value Fees, International Fees, Promoted Listings, eBay Labels
Etsy Payment Account	1057 Etsy Clearing	Gross Listing Sales + Gift Wrap / Shipping	6.5% Transaction Fee, Payment Processing, Offsite Ads, Etsy Labels
TikTok Shop US	1055 TikTok Clearing	Gross GMV + Seller Shipping	Referral Fee, Creator Affiliate Commissions, FBT & Shipping Subsidies
Whatnot Livestream	1050 Whatnot Clearing	Gross Hammer Price + Buyer Shipping	8% Commission, 2.9%+$0.30 Processing, Giveaways, 45-Day USPS APV

Zero-Install CLI + Multi-Rail Instant Checkout (EARLY50 = 50% Off First 10 Orders)

Run via npx CLI, test free tools, or checkout via Gumroad, Upwork & Fiverr

Run our open-source CLI locally with zero cloud uploads, download the $0+ Open Compliance Starter Kit, or unlock the full offline software ZIP (apply promo code EARLY50 at Gumroad checkout for 50% off the first 10 orders; 30-day money-back guarantee). Prefer marketplace escrow? Order directly on Upwork Project Catalog or Fiverr.

npx --yes --package=https://github.com/hadesloc/pdfua-ada-checker/releases/download/v1.4.0/clearstream-1099k-cli-1.4.0.tgz clearstream-1099k --platform auto ./ebay-etsy-payouts.csv --json

Get Automated Multi-Channel Kit — $39.50 (Code EARLY50) Standard $79 Multi-Channel ZIP Test Multi-Channel CSV Converter in Browser Free Open CLI Starter Kit ($0+) Direct Node CLI (.tgz) GitHub Release v1.4.0 Order via Upwork Escrow Catalog Order via Fiverr Multi-Channel Gig Fiverr Backup Escrow Link Product Hunt Nov 16 Launch ↗ 40% Affiliate Program

FAQ

Frequently asked questions

What is included in the free 1099-K Clearing Account .xlsx download?

The free ZIP includes a formula-driven OpenXML (.xlsx) workbook with pre-built gross-to-net tabs, Chart of Accounts codes, and balanced debit/credit check formulas—no macros and zero email gate.

How do bank feed transfers work once the Clearing Journal is imported?

Import the summary journal into QuickBooks Online or Xero (which debits the Clearing Account for the exact net payout), then categorize incoming eBay/Etsy bank deposits as a Transfer from that Clearing Account so the balance zeroes out.

Does the automated software handle eBay and Etsy CSV exports offline?

Yes. ClearStream auto-detects eBay Transaction Report CSVs, Etsy Payment Account CSVs, TikTok Shop settlements, and Whatnot exports locally in your browser or via npx --yes --package=https://github.com/hadesloc/pdfua-ada-checker/releases/download/v1.4.0/clearstream-1099k-cli-1.4.0.tgz clearstream-1099k.

Need a complimentary sample check or multi-seat agency quote?

Test our free browser validator right now, or email a non-confidential sample CSV / PDF for a complimentary 24-hour engineering verification. (100% deterministic local spreadsheet & CSV conversion software — not CPA, tax, or legal advice.)

Download Free .xlsx Clearing Account Template ($0) Email Engineering Desk Partner Intake Form