2026 E-Commerce Bookkeeping Software · 100% Client-Side & CLI

TikTok Shop 1099-K to QuickBooks Online & Xero reconciliation.

Turn raw TikTok Shop US Seller Center settlement CSV exports into penny-exact QuickBooks Online Journal Entries and Xero Manual Journals—reconciling Form 1099-K Box 1a gross GMV against platform fees, affiliate creator commissions, FBT shipping deductions, refunds, and reserve holds.

Open Free TikTok 1099-K Browser Converter Unlock Full Kit — $39.50 (50% Off w/ EARLY50) Order via Upwork Escrow Catalog Order via Fiverr Escrow Gig

100% deterministic local accounting-import formatting software (browser JS + Python 3 Decimal CLI) — not CPA, tax, audit, or legal advice.

Deterministic Engineering Architecture

Why TikTok Shop Form 1099-K Box 1a never matches net bank deposits

Gross GMV vs. Net Settlement Gap

Form 1099-K Box 1a reports unadjusted gross customer payments before TikTok deducts referral commissions, transaction fees, affiliate payouts, and shipping label charges—often 22%–38% higher than ACH bank deposits.

1055 TikTok Clearing Account Architecture

Posting balanced summary journals per settlement ID into a 1055 TikTok Shop Clearing asset account isolates timing cutoffs, negative reserve holds, and Marketplace Facilitator sales tax so bank feeds match to $0.00.

Zero Cloud Uploads for CPA & CAS Firms

Client Seller Center CSVs run 100% locally in browser memory or via our air-gapped CLI—never touching third-party cloud APIs or recurring per-shop SaaS subscriptions.

Standard TikTok Shop US to QuickBooks Online / Xero Clearing Journal Mapping

Account Code & Name	Account Type	Entry Side	TikTok Settlement CSV Source Columns
4010 TikTok Gross Product Sales	Income	Credit	Gross Merchandise Value (GMV) + Seller Shipping Revenue
4090 TikTok Refunds & Discounts	Contra-Income	Debit	Customer Refunds + Seller-Funded Voucher Discounts
5110 TikTok Referral & Payment Fees	COGS / Expense	Debit	Platform Commission + Transaction / Payment Processing Fees
5120 Creator Affiliate Commissions	Marketing Expense	Debit	Affiliate Commission + Shop Ads / TAP Deductions
5130 FBT & Shipping Label Deductions	COGS / Shipping	Debit	Fulfilled by TikTok (FBT) + Prepaid Label Adjustments
1055 TikTok Shop Clearing	Current Asset	Debit (Net Payout)	Exact Net Settlement Payout matched against checking bank feed

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 tiktok ./tiktok-settlement.csv --json

Unlock Full Kit — $39.50 (50% Off w/ EARLY50) Standard $79 License Download Free 1099-K Clearing Workbook (.xlsx) Free Open CLI Starter Kit ($0+) Direct Node CLI (.tgz) GitHub Release v1.4.0 Order via Upwork Escrow Catalog Order via Fiverr Escrow Gig Fiverr Backup Escrow Link Product Hunt Nov 16 Launch ↗ 40% Affiliate Program

FAQ

Frequently asked questions

How do I record TikTok Shop Marketplace Facilitator sales tax in QuickBooks Online?

States with Marketplace Facilitator laws require TikTok Shop to collect and remit sales tax directly. Our converter separates pass-through facilitator tax from gross product sales so it never inflates Schedule C / 1120 gross income while documenting the exact Form 1099-K Box 1a tie-out.

Does this software work offline for multi-client bookkeeping and CAS practices?

Yes. Both the HTML5 browser converter and the Python/Node CLI run 100% locally offline with unlimited client shops under one flat license ($79 list, or $39.50 for the first 10 orders with code EARLY50).

Can I test my own TikTok Shop settlement CSV before buying?

Yes. Open the free browser converter at /tools/tiktok-1099k/ to inspect your live gross-to-net variance and preview balanced journal lines, or download the free .xlsx Clearing Workbook at $0.

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 accounting-import formatting software (browser JS + Python 3 Decimal CLI) — not CPA, tax, audit, or legal advice.)

Open Free TikTok 1099-K Browser Converter Email Engineering Desk Partner Intake Form