WORKFLOW COMPARISON · AUTOMATED WATERFALL VS EXCEL

TikTok Shop Profit Calculator vs. Generic Spreadsheets

Generic gross-margin spreadsheets only subtract product cost and platform fee — missing up to $6.40 per order in battery/magnetic freight surcharges, parcel registration fees, and unrecoverable return write-offs. Audit all 9 cost layers interactively below.

1. Enter SKU & Sourcing Assumptions

2. Live Net-Margin Verdict

GO
+$0.00
Net Profit / Order
0.0%
Net Margin %
0.00x
Break-Even ROAS
1688 SOURCE-FACTORY MANDARIN QUERY
—
—
Landed COGS (Factory + QC + DDP + 6.5% Buffer)$0.00
Platform Referral + Affiliate + Fulfillment-$0.00
Unrecoverable Refund / RTO Loss-$0.00
Open Full Sandbox + 1688 Direct Link →

2026 Cost & Logistics Reference Benchmarks

Cost VariableBasic Excel TemplateTrueMargin Deterministic Engine
China Cargo ClassificationFlat $/kg guessAuto-detects General vs. Battery/Magnet (+30%) vs. Liquid (+41%)
1688 Supplier DiscoveryManual Google Translate (UTF-8 broken)Industrial-belt Mandarin lexicon + native GBK 1688 URLs
Return / RTO AccountingSimple % off revenue (understates loss)Models unrecoverable outbound 3PL packet + 75% COGS write-off
Batch & AI Agent AutomationManual copy-paste row by row200-SKU CSV upload + Claude Desktop / Cursor MCP Server

Frequently Asked Questions

What is the biggest math error in DIY TikTok Shop spreadsheets?

Treating refunds as a simple revenue deduction. When an impulse buyer refunds a $25 gadget, you lose the revenue AND you never recover the ~$5.20 outbound China-to-US air packet or opened-box product cost.

Can TrueMargin export back to CSV for our finance team?

Yes — TrueMargin Pro lets you paste or upload up to 200 SKUs at once and export the complete line-by-line margin waterfall and GO/CAUTION/KILL verdicts to CSV.

Does TrueMargin integrate with AI coding and workflow agents?

Yes — our open-source zero-dependency stdio MCP server (`yixuanrobot/truemargin-mcp`) lets Claude Desktop, Cursor, and n8n workflows audit SKUs programmatically.

TRUEMARGIN PRO WORKSPACE

Auditing 50–200 Competitor SKUs at Once?

Unlock bulk CSV uploads, GBK-encoded 1688 source-factory search URLs, and Claude Desktop / Cursor MCP automation starting at $39/mo.

Start Pro Growth ($79/mo) Compare All Plans

More Cross-Border Profit & Sourcing Calculators