TikTok Shop payouts to QuickBooks Online
Upload the TikTok Shop payout or settlement report and download two things: a bank-style file of the individual lines, and a payout journal that splits each payout into gross sales, fees, refunds, chargebacks and net so the bank line reconciles in QuickBooks Online.
First 5 pages free. No card, no account until you download.
| Description | Account | Debit | Credit |
|---|---|---|---|
| Gross sales | 200 | 1,000.00 | |
| TikTok Shop processing fees | 404 | 29.50 | |
| Refunds | 200 | 50.00 | |
| Net payout to bank | 090 | 920.50 |
Where the report is in TikTok Shop
Finance > Settlements, exported as CSV per statement.
How TikTok Shop fees work
Statements net commission, transaction fees and refunds.
Posting it in QuickBooks Online
QuickBooks accepts a 3 or 4 column CSV for bank transactions. The payout journal is provided as a CSV you can post as a journal entry. The journal PayoutParse produces uses Sales, Fees and a bank clearing line per payout; change the account codes in the file to match your chart of accounts before importing.
The check
For each payout, gross less fees less refunds less chargebacks plus adjustments must equal the printed net. If it doesn't, the file is marked needs review and is not charged.
Other software
TikTok Shop to Xero, TikTok Shop to Sage Accounting, TikTok Shop to FreeAgent.