Per Transaction: TikTok Statement Clearing Account Reconciliation Guide

Synder syncs sales, refunds, payouts, and fees from TikTok. With TikTok statements integration, transactions are recorded in your accounting platform as summarized journal entries. Refer to this guide to understand more about TikTok Statements.

This guide explains how to:

• Identify the ending balance of your TikTok Statements account
• Reconcile your clearing account
• Compare TikTok Statements and accounting data to identify discrepancies

QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations.

Use this guide if:

• You use TikTok Statements with Synder
• Your clearing account does not reconcile or zero out automatically
• You want to verify that TikTok Statements and accounting records match

After completing the steps, your TikTok Statements clearing account will reconcile with sales, payouts, and fees reflected accurately in your books.

TikTok Statements clearing account reconciliation flow

To reconcile your TikTok Statements clearing account, compare its ending balance with TikTok’s ending balance for the same period.
Here’s how you can find the TikTok Statements balance by downloading the Settlement report:

1. Navigate to TikTok → Finances→Overview
2. Click on Statements.
3. Click on Export.
4. Select the required time period and click Export.

6. Open the Excel file and calculate the sum of the Total settlement amount column.

The result is the TikTok Statements ending balance for the reconciliation period.

Next, compare this amount with the ending balance from your clearing account report in QuickBooks Online for the same date:

1. Navigate to Reports → Standard Reports.
2. Select Balance Sheet.

3. Select column display to Months.
4. Locate the TikTok clearing account for the reconciled month.
5. Subtract the previous month’s balance.

The result is the clearing account balance for the selected period.

The amounts you will see in the QuickBooks Online clearing report will match your TikTok Settlement report transactions report amount, meaning the reconciliation was successful. Congratulations!

If your clearing account does not reconcile

If the balances between your TikTok and QuickBooks Online reports don’t match, it is often due to unsynchronized transactions. Follow the steps below to make sure that Synder has successfully synced your TikTok data.

1. Go to Synder and filter transactions by status. Make sure that all the transactions within your reconciliation period are in statuses: Synced or Skipped on the Platform transactions page.
   All the other statuses indicate that the transaction is not in your books or needs additional checking. As long as such transactions are present, your books won’t reconcile.
2. Make sure you are comparing the right numbers (sales might not equal cash, for example). It’s important to use the right numbers for reconciliation and comparison.
3. If your platform was disconnected within the reconciliation period, make sure you run a Historical Import on the Platform transactions page to retrieve any missing transactions.

If after that your balances still don’t match, follow the steps below to identify discrepancies by comparing TikTok and QuickBooks Online data in Excel.

Download required reports

You should already have a report from TikTok if you’ve followed the main reconciliation flow. If not, please download it by following the steps above.

We will also need a report of the TikTok clearing account from your accounting software.

Follow this link to find the exact steps on how to generate a clearing account report in QuickBooks Online

Note: If your QuickBooks clearing account has tens of thousands of transactions, it might not download the full dataset. After downloading one of the reports above, check for data completeness. If the report is missing data, try the alternative download method.

Method of comparison

Each step follows the same approach: pull the relevant data from both reports into a single Comparison sheet, then use VLOOKUP to match entries by ID and flag any differences.

Set up your Comparison sheet

Create a new sheet in your Excel file. Copy your TikTok IDs and amounts into columns A and B, and your QuickBooks Online IDs and amounts into columns C and D. Each step tells you exactly which columns to use.

Match amounts with VLOOKUP

In the Lookup column (E), enter this formula to find the matching QuickBooks Online amount for each TikTok entry:

=VLOOKUP(A2,C:D,2,FALSE)

Then in the Difference column (F), subtract the Lookup result from the TikTok amount: =B2-E2.

Read the result as follows:

• 0 — amounts match, no action needed

• Positive or negative number — there is an amount difference between the two reports

• N/A — the ID exists in TikTok but is missing from QuickBooks Online

Step 1: Reconcile Payouts

Sales and refunds sync to QuickBooks Online as Sales Receipts and Refund Receipts.

Required columns

Compare

Place TikTok columns in A–B, QuickBooks Online columns in C–D. Apply VLOOKUP and Difference as described above.

Step 2: Reconcile sales and refunds

Payouts sync to QuickBooks Online as Transfer transactions.

Required columns

Compare

Place TikTok columns in A–B, QuickBooks Online columns in C–D. Apply VLOOKUP and Difference as described in Method of Comparison.

Step 3: Reconcile reserves

Reserves are amounts TikTok temporarily holds back from payouts and later releases. They appear in QuickBooks Online as Expense and Deposit entries.

Required columns

Multiple reserve rows can exist per payout. Before comparing, sum Reserve Amount by Payment ID using:

=QUERY(A:B,

 “select A, sum(B)

  group by A

  label sum(B) ””,

 0)

Compare

Place the consolidated TikTok columns in A–B, QuickBooks Online columns in C–D. Apply VLOOKUP and Difference as described in Method of Comparison.

Step 4: Address common discrepancies

1. Missing transactions in QuickBooks Online

Possible causes:

• Transaction failed to sync due to network issues
• Transaction filtered out by Synder settings
• Unsupported transaction type

Actions to take:

1. Check Synder’s sync logs for failed transactions.
2. Force a manual sync in Synder for the missing period.
3. Confirm timezone settings match between TikTok reports (PST/UTC) and Synder.

2. Amount differences

Possible causes:

• Currency conversion differences between marketplaces
• Partial refunds not properly matched to original orders
• Difference in fee calculations between TikTok reports and Synder processing

Actions to take:

1. Check for currency conversions if selling in multiple countries.
2. Look for reserve balance movements in the same period.
3. Check for related adjustment entries in subsequent periods.

3. Extra transactions in QuickBooks Online

Possible causes:

• Manual entries created by your accounting team
• Duplicate syncing from multiple sync attempts
• Journal entries or adjustments made outside of Synder
• Starting balance entries when first setting up clearing accounts

Actions to take:

1. Check if descriptions indicate manual entry.
2. Verify transaction source in QuickBooks Online (look for “Synder” in descriptions).
3. Check for duplicate TikTok connections in Synder.
4. Review any manual clearing account adjustments.

When to reach out  to support

Get in touch with support when you’ve identified specific transactions causing issues but can’t resolve them.

What to include in your support request:

• Reconciliation period (start and end dates)
• Specific transaction IDs
• Screenshots of problematic transactions in both TikTok and QuickBooks Online
• Summary of your findings (e.g., “Found 5 missing fulfillment fees totaling $47.50”)
• Currency/marketplace information if applicable
• Steps already taken to resolve the issue

Best practices for ongoing reconciliation

Staying on top of your clearing accounts requires consistency. Here are key practices to help you keep your books accurate and your reconciliation process smooth over time:

1. Reconcile monthly rather than waiting for quarter-end.
2. Monitor multiple currency clearing accounts if selling internationally.
3. Keep an eye on alerts in Synder for failed sync transactions.
4. Maintain timezone consistency across TikTok, Synder, and reconciliation periods.
5. Document any manual entries made to clearing accounts.
6. Review unsupported transaction types periodically as Synder adds support.

A consistent reconciliation routine saves time, reduces errors, and keeps your financials audit-ready. By following these best practices, you’ll avoid surprises down the line and ensure your clearing accounts stay clean and reliable month after month.