How to Record TikTok Shop Transactions in QuickBooks

If you sell on TikTok Shop, you have probably noticed one confusing issue:

Your bank deposits never match your sales.

The good news? That’s completely normal.

TikTok Shop deducts various charges before sending your payout. If you record only the amount deposited into your bank account, your financial reports won’t tell the full story.

This guide explains how to properly record TikTok Shop sales, fees, and refunds in QuickBooks Online so your books stay accurate.

Why TikTok Shop Deposits Don’t Match Sales

TikTok Shop deducts several items before transferring funds to your bank account, including:

• TikTok selling fees
• Affiliate commissions
• Customer refunds
• Advertising and promotional charges

As a result, the amount deposited into your bank account is your net payout, not your total sales revenue.

The Most Common TikTok Shop Accounting Mistake

Many sellers simply record the bank deposit as sales revenue.

Although this seems easier, it creates major bookkeeping problems:

• Revenue is understated.
• Expenses are missing.
• Refunds are ignored.
• Profit reports become inaccurate.
• Tax reporting may be affected.

The Best Way to Record TikTok Shop Transactions in QuickBooks Online

The easiest solution is to use a TikTok Clearing Account.

A TikTok Clearing Account acts as a temporary holding account that tracks all TikTok activity before matching the final bank deposit.

At the end of the process, the clearing account balance should be zero.

Example: Recording TikTok Shop Sales in QuickBooks Online

Let’s say you have:

• Total TikTok Shop sales: $1,000
• TikTok fees: $150
• Customer refunds: $100
• Bank payout received: $750

Here’s how to record it correctly.

Step 1: Record Gross TikTok Shop Sales

Always record the full sales amount.

Journal Entry:

• Debit: TikTok Clearing Account — $1,000
• Credit: Sales Revenue — $1,000

This ensures your revenue is reported accurately.

Step 2: Record TikTok Shop Fees. Track all selling fees separately.
Journal Entry:

• Debit: TikTok Fees Expense — $150
• Credit: TikTok Clearing Account — $150

This captures the true cost of selling on TikTok Shop.

Step 3: Record Customer Refunds

Refunds should reduce your income appropriately.

Journal Entry:

• Debit: Sales Returns and Allowances — $100
• Credit: TikTok Clearing Account — $100

This keeps your financial reports clean and transparent.

Step 4: Record the TikTok Bank Deposit

Now record the actual payout received.

Journal Entry:

• Debit: Bank Account — $750
• Credit: TikTok Clearing Account — $750

Step 5: Reconcile the TikTok Clearing Account

Review the TikTok Clearing Account balance.

It should equal zero.

If it doesn’t:

• A transaction may be missing.
• A report may not tie out.
• The payout details may need review.

This reconciliation step helps ensure accurate bookkeeping.

Monthly TikTok Shop Bookkeeping Process

You don’t need a complicated system.

Follow these simple steps:

1. Download your TikTok Shop settlement report.
2. Separate the transactions into:
   • Sales
   • Fees
   • Refunds
3. Record each category individually in QuickBooks Online.
4. Match the remaining amount to your bank deposit.
5. Reconcile the TikTok Clearing Account.

That’s it.

When Should You Automate TikTok Shop Accounting?

Manual bookkeeping works well when sales volume is low.

You can use:

• Excel spreadsheets
• QuickBooks Online journal entries

However, as your business grows:

• Order volume increases.
• Refunds become more frequent.
• Fees become more detailed.
• Reconciliations take longer.

At that stage, automation tools that connect TikTok Shop with QuickBooks Online can save significant time and reduce errors.

Final Takeaway

Remember this important principle:

TikTok Shop does not pay you your sales.

It pays you what’s left after deductions.

To keep your books accurate:

• Record gross sales.
• Track TikTok fees separately.
• Record refunds correctly.
• Reconcile payouts using a TikTok Clearing Account.

Following this process will help you maintain clean books, accurate financial reports, and better business decisions.