Convert TikTok Shop Settlement Report to QuickBooks IIF
Upload your TikTok Shop Settlement Report and download a QuickBooks IIF file ready to import into QuickBooks Desktop.
How to download your TikTok Shop settlement report
- Log in to TikTok Shop Seller Center
- Go to Finance > Settlement
- Select the settlement period you want to export
- Click Download to get the XLSX file
- Upload the downloaded file here to convert
About the QuickBooks IIF Format
IIF (Intuit Interchange Format) is the standard import format for QuickBooks Desktop. Upload your settlement file and download a ready-to-import IIF file with balanced journal entries.
Other Export Formats for TikTok Shop Settlement Report
Frequently Asked Questions
After downloading your QuickBooks IIF file from SettleBooks, open QuickBooks Desktop and use the journal entry import feature. The file is pre-formatted to match QuickBooks Desktop's expected layout.
Yes. SettleBooks categorizes every fee and charge from your TikTok Shop Settlement Report into separate journal entry lines. Each line maps to a specific account so your books stay detailed and accurate.
Absolutely. Every exported journal entry has total debits equal to total credits. If there's a discrepancy in your source data, we flag it with a warning before you export.
Yes. After signing in, go to Settings → Category Mappings to override the default account name and code for any fee category. Your custom mappings are saved and applied to all future conversions.