TikTok Shop Sales to
QuickBooks — Instant CSV Conversion

Why TikTok Shop Exports Need Conversion for QuickBooks

TikTok Shop Seller Center provides several export formats designed to help sellers track orders, settlements, and finances. However, these CSV files aren't directly compatible with QuickBooks. The exports include mixed data — order details, multiple fee types, settlement calculations, and status fields — all in a single file that QuickBooks can't import without transformation. Without a converter, sellers spend hours manually reformatting dates, extracting fees, and mapping columns to match QuickBooks' expected format.

Common TikTok Shop Import Errors in QuickBooks

When attempting to import a raw TikTok Shop CSV export into QuickBooks, sellers commonly encounter these issues:

• “Date format not recognized” — TikTok Shop exports dates in various formats including YYYY-MM-DD HH:MM:SS and local timezone formats. QuickBooks requires MM/DD/YYYY format and will reject files with incompatible date formats.
• Multiple fee columns — TikTok Shop charges commission fees, platform service fees, transaction fees, and shipping fees — each in a separate column. QuickBooks expects a single Amount column, so these fees need to be extracted as individual transactions.
• Mixed transaction types — Settlement reports combine orders, refunds, adjustments, and internal settlement transfers in one file. Importing everything creates duplicate entries and internal transfers that don't belong in your general ledger.
• Order status confusion — Order reports include cancelled and unpaid orders alongside completed ones. Importing all rows overstates revenue with orders that never generated actual income.
• Column name mismatches — TikTok Shop uses column names like “Settlement Amount,” “SKU Unit Original Price,” and “Order Adjustment ID” that don't map to QuickBooks' expected headers (Date, Description, Amount).

How the Converter Fixes These Issues

The TikTok Shop to QuickBooks Converter addresses every compatibility gap between TikTok Shop's export format and QuickBooks' import requirements:

• Automatic date reformatting — Every date is converted from TikTok Shop's various formats to MM/DD/YYYY, the format QuickBooks expects across all versions. Timezone offsets and time components are handled gracefully.
• Smart transaction filtering — Only completed, paid orders are included. Cancelled and unpaid orders are automatically filtered out. Settlement transfers (internal deposit records) are excluded to prevent double-counting.
• Multi-fee splitting — Each TikTok Shop fee type (commission, platform service, transaction, shipping) is extracted and added as a separate negative line item. This creates trackable expense entries for each fee category in QuickBooks.
• Refund handling — Refunds are clearly labeled as “TikTok Shop Refund” with the original order ID, ensuring they're immediately identifiable in your QuickBooks register and don't get confused with regular expenses.
• Column mapping — TikTok Shop column names are mapped to the exact headers QuickBooks requires. QBO and Self-Employed get Date/Description/Amount; Desktop gets Date/Description/Credit/Debit.

Step-by-Step: Converting TikTok Shop Data to QuickBooks

Follow these steps to convert your TikTok Shop sales data into QuickBooks-compatible format:

1. Export from TikTok Shop Seller Center — Log into Seller Center and navigate to Orders > Manage Orders (for order reports) or Finance > Settlements (for settlement reports). Select your date range and click “Export” to download a CSV file.
2. Upload the CSV — Drag and drop your TikTok Shop CSV file into the converter. The tool auto-detects whether it's an Order Report, Settlement Report, or Finance Report.
3. Configure options — Choose your output format (CSV, IIF, or QBO), select your QuickBooks edition, and toggle fee splitting and refund inclusion based on your accounting preferences.
4. Preview and download — Review the converted transactions in the preview table, verify the stats summary, and download your QuickBooks-ready file.
5. Import into QuickBooks — Follow the import steps for your QuickBooks version (detailed below) to bring the converted transactions into your books.

Understanding TikTok Shop Fees

TikTok Shop charges multiple types of fees on each transaction, and understanding how these fees work is essential for accurate bookkeeping:

• Commission fees — TikTok Shop charges a commission on each sale, typically ranging from 5% to 8% depending on your product category and seller tier. New sellers may benefit from introductory commission rates. These fees are deducted before settlement.
• Platform service fees — An additional platform service fee covers TikTok Shop's marketplace infrastructure costs. This fee varies by region and product category.
• Transaction fees — Payment processing fees charged by the payment provider for handling the actual money transfer. Similar to credit card processing fees on other platforms.
• Shipping fees — Shipping costs that may be partially or fully subsidized by TikTok Shop promotions. The actual shipping fee deducted from your settlement appears in the export.
• Net settlement — TikTok Shop settles payments as net amounts (gross revenue minus all fees). The converter can split these into gross payment plus separate fee line items for each category, making reconciliation straightforward.

Importing into QuickBooks Online

After converting your TikTok Shop CSV, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted CSV file from your computer.
4. QuickBooks will display a column mapping preview — verify that Date, Description, and Amount are mapped correctly.
5. Choose the QuickBooks account to import into (e.g., “TikTok Shop Payments” or “Marketplace Revenue”).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Tip: Create a dedicated “TikTok Shop Payments” account in your chart of accounts to keep TikTok Shop transactions organized and easy to reconcile against your settlement deposits.

Importing into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), use the Web Connect import method:

1. Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
2. Browse to and select your converted QBO file.
3. QuickBooks will prompt you to select the account for the imported transactions.
4. Click Continue to import. Transactions will appear in the bank register for review.

Alternatively, you can use our CSV to IIF Converter to generate an IIF file, which can be imported via File → Utilities → Import → IIF Files.

TikTok Shop Fee Accounting Best Practices

Properly tracking TikTok Shop fees is essential for accurate financial reporting and tax preparation. Here are the recommended practices:

• Create dedicated expense sub-accounts — Set up separate sub-accounts under Expenses for “TikTok Shop Commission Fees,” “Platform Service Fees,” and “Payment Processing Fees.” This granular tracking helps you understand your true cost of sales on TikTok Shop.
• Use fee splitting for automatic categorization — Enable the fee splitting option in the converter to generate separate line items for each fee type. This eliminates manual fee entry and ensures every charge is captured accurately.
• Reconcile settlements against bank deposits — TikTok Shop settles payments on a regular schedule. When reconciling, match your bank deposits against the net settlement amounts, and verify that the sum of fee line items accounts for the difference between gross revenue and net deposits.
• Track fee rate changes — TikTok Shop occasionally adjusts commission rates based on seller performance, promotions, or category changes. The converter captures the actual fee amount from each transaction, so your books reflect the true cost regardless of rate changes.

Want to master TikTok Shop finances end to end? Read our comprehensive TikTok Shop Accounting Guide — covering commission fee tiers, platform service charges, settlement cycle accounting, affiliate payout tracking, and tax preparation strategies for TikTok Shop sellers.

Related Free Accounting Tools

The TikTok Shop to QuickBooks Converter is part of our complete suite of free QuickBooks conversion tools:

• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks-compatible CSV with fee splitting.
• Amazon to QuickBooks Converter — Convert Amazon seller reports to QuickBooks-compatible CSV.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• eBay to QuickBooks Converter — Convert eBay seller transaction reports to QuickBooks format.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks-compatible CSV with fee splitting.
• PayPal to QuickBooks Converter — Convert PayPal transaction exports to QuickBooks format.
• Square to QuickBooks Converter — Convert Square payment exports to QuickBooks format.
• CSV to QBO Converter — Convert cleaned bank CSVs into Web Connect (.qbo) files for QuickBooks Online and Desktop.
• CSV to IIF Converter — Convert CSVs into Intuit Interchange Format (.iif) for QuickBooks Desktop import.
• Bank CSV Cleaner — Clean and normalize messy bank CSV exports before importing into QuickBooks.
• Chart of Accounts Generator — Generate a customized chart of accounts for your QuickBooks company file.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.