Source: Google Gemini

As a business selling on TikTok Shop, one of the most important tasks you’ll face each month is the month-end reconciliation. This ensures that your financial data aligns perfectly, guaranteeing you have an accurate picture of your revenue, costs, and overall cash flow. Without a proper reconciliation process, discrepancies between your TikTok Seller Balance, payouts, bank deposits, and general ledger (GL) can quickly spiral out of control, leaving you with a mess of incomplete or inaccurate financial statements.

In this article, we’ll walk you through a comprehensive TikTok Seller Balance Reconciliation Checklist, which will guide you step by step through the month-end close process. You’ll learn how to properly reconcile your TikTok Shop reports, match them with your bank deposits, and ensure your GL is accurate for financial reporting and auditing purposes.

By the end of this guide, you’ll have the confidence to complete your month-end close efficiently and accurately, keeping your financials audit-ready.

Why TikTok Seller Balance Reconciliation is Crucial

Reconciliation is the process of ensuring that the amounts shown in your TikTok Seller Balance match the actual payments, transactions, and revenue as reflected in your bank deposits and general ledger (GL). This is important for several reasons:

  • Accuracy: Ensures that the revenue you’ve earned and the payouts you’ve received are accurately reflected in your financial statements.
  • Cash Flow Management: Helps you track net cash flow, ensuring that the amount you expect to receive aligns with the amounts deposited into your bank account.
  • Profitability Assessment: Helps ensure that fees, refunds, and deductions are accurately accounted for, giving you a true picture of your profit margins.
  • Audit-Readiness: Maintaining accurate and organized records makes it easier for your business to pass financial audits and adhere to tax reporting requirements.
  • Compliance: Ensures that all financial data is compliant with local accounting standards, which is critical for tax filings and financial transparency.

Key Components of TikTok Seller Balance Reconciliation

Before diving into the checklist, let’s quickly define the key components that you will be reconciling each month:

1. TikTok Seller Balance

This is the amount TikTok Shop owes you after all fees, refunds, and other adjustments have been made. It’s important to track this because it reflects what TikTok Shop is holding on your behalf before releasing it to your bank account.

2. TikTok Shop Reports

These reports contain the transaction data you need for reconciliation. Key reports include:

  • Order Report: This tracks your sales, including the sale price and any discounts or promotions applied.
  • Settlement Report: This shows what TikTok Shop has paid you, including any fees deducted.
  • Fee Report: This breaks down the various fees charged by TikTok Shop, including transaction fees, platform fees, and shipping fees.
  • Refund and Return Report: This tracks any refunds or returns processed by TikTok Shop that affect your Seller Balance.

3. Bank Deposits

Your bank statement will show the actual deposits made by TikTok Shop, which may not always match the payout amounts due to timing differences or adjustments.

4. General Ledger (GL)

Your GL records all the financial transactions of your business. TikTok-related transactions, including sales revenue, fees, refunds, and payouts, need to be recorded in the appropriate GL accounts.

Step-by-Step TikTok Seller Balance Reconciliation Checklist

Step 1: Collect All Relevant Reports

Before starting the reconciliation process, gather the following TikTok Shop reports for the month:

  • Order Report (for sales)
  • Settlement Report (for payouts)
  • Fee Report (for platform and transaction fees)
  • Refund and Return Report (for any refunds or returns)
  • Bank Statement (for actual deposits)

Make sure the reports cover the exact date range for the month you are reconciling.

Step 2: Match TikTok Shop Sales with Revenue in the GL

Your first task is to ensure that your sales revenue for the month is accurately recorded in your general ledger (GL).

  1. Review the Order Report for the month, which will show the total sales, including any shipping charges and promotions.
  2. Record the revenue in your GL:
    • Dr TikTok Shop Clearing Account (amount owed by TikTok Shop)
    • Cr Sales Revenue (gross sales amount)
    • Cr Shipping Revenue (if shipping fees are charged)

Ensure that you correctly account for:

  • Total sales (product and shipping revenue).
  • Promotions, discounts, and vouchers.
  • Any sales returns or cancellations that may reduce the total revenue.

Why This Is Important:

Accurate sales recording is crucial because it ensures that your gross revenue and the amount TikTok Shop owes you match.

Step 3: Reconcile Fees with TikTok Shop Fee Report

TikTok Shop charges several types of fees:

  • Platform fees (commission for using the platform)
  • Transaction fees (for processing payments)
  • Shipping-related fees (if you are subsidizing shipping costs)
  • Advertising fees (if you use TikTok Ads)
  1. Download the Fee Report for the month.
  2. Match the fees reported to the amounts deducted from your TikTok Seller Balance.
  3. Record these fees in your GL:
    • Dr TikTok Shop Fees Expense (for platform and transaction fees)
    • Cr TikTok Shop Clearing Account (to reduce the amount TikTok Shop owes you)

Why This Is Important:

Fees reduce your overall sales, so ensuring they are correctly recorded allows you to track your net revenue and ensures that the fee amounts deducted from your Seller Balance are accurately reflected in your GL.

Step 4: Account for Refunds and Returns

Refunds and returns can significantly impact your net revenue and need to be recorded correctly.

  1. Download the Refund and Return Report for the month.
  2. For each refunded order, reverse the sale from your GL and adjust the amount in your TikTok Seller Balance.
  3. Record the journal entry for refunds:
    • Dr Sales Returns & Refunds (to reduce revenue)
    • Cr TikTok Shop Clearing Account (to reduce what TikTok Shop owes you)

Why This Is Important:

Properly recording refunds and returns ensures that your net revenue is accurately reflected and matches the final payout amount.

Step 5: Reconcile TikTok Shop Settlement Report with Bank Statement

Now that you’ve recorded all the revenue, fees, and refunds, the next step is to match your settlement report with the actual bank deposit.

  1. Review the Settlement Report for the month and ensure that the payout amount matches the bank deposit for that period.
  2. Compare the settled payout amount from TikTok Shop with the deposit recorded in your bank statement.
  3. Record the payout in your GL:
    • Dr Bank (for the actual deposit amount)
    • Cr TikTok Shop Clearing Account (to clear the amount owed by TikTok Shop)

Why This Is Important:

This step ensures that the cash deposited into your bank account aligns with the payout recorded in your TikTok Shop Seller Balance. Any discrepancies should be reviewed and investigated.

Step 6: Adjust for Any Discrepancies

Discrepancies can arise due to:

  • Timing differences: For example, TikTok Shop may process a payout in one month, but the bank deposit is made in the next month.
  • Missing payments: Sometimes, payouts may be delayed or deducted for various reasons, such as penalties or adjustments.
  • Incorrect fees or refunds: Check if any fees or refunds were processed incorrectly.

If there are discrepancies:

  • Review the timing of payouts and ensure they are recorded in the correct period.
  • Investigate missing payments by checking TikTok Shop’s payment history or contacting support.

Step 7: Ensure the TikTok Shop Clearing Account Balances

After all the sales, fees, refunds, and payouts have been recorded, your TikTok Shop Clearing Account should balance to zero or reflect any outstanding amount that TikTok Shop still owes you.

  1. Review the final balance in the clearing account and compare it with the TikTok Shop Seller Balance for the month.
  2. If there is any remaining balance, ensure it aligns with pending payouts or adjustments for the following period.

Why This Is Important:

This final step ensures that your TikTok Shop Clearing Account reflects the correct outstanding amount. It serves as a safety check to make sure everything has been properly accounted for.

Common Issues in TikTok Shop Reconciliation

Even with the best processes in place, you may encounter some common challenges during reconciliation:

1. Timing Differences

The most common issue in reconciliation is timing differences. For example, a sale might occur at the end of the month, but the payout might not happen until the next month. Make sure to account for these timing differences when reconciling your accounts.

2. Missing or Incorrect Refunds

Refunds and returns can cause discrepancies if they’re not recorded correctly. Always check the Refund Report to ensure that any refunded orders are properly deducted from your revenue.

3. Platform Fees and Adjustments

Shopee’s fees, refunds, and adjustments may sometimes be more complex, especially during promotional campaigns or when affiliate fees are involved. Keep a clear record of all fees and ensure they are correctly deducted from your gross revenue.

Best Practices for TikTok Shop Reconciliation

  1. Reconcile Weekly or Biweekly: Don’t wait until the end of the month. Reconcile regularly to catch discrepancies early and avoid a last-minute scramble at month-end.
  2. Use Accounting Software: Consider integrating TikTok Shop with accounting software to streamline the process. This can save you time and reduce manual entry errors.
  3. Document Everything: Keep a detailed record of all transactions, including refunds, adjustments, and communications with TikTok Shop support.
  4. Audit Your Process: Periodically review your reconciliation process to ensure that it remains efficient and accurate, especially as your business grows.

Conclusion

TikTok Shop Seller Balance reconciliation doesn’t have to be complicated if you follow a structured process. By following this checklist, you can ensure that your revenue, fees, payouts, and bank deposits are always aligned, providing an accurate and transparent financial view for your business.

Proper reconciliation helps you:

  • track cash flow accurately
  • identify issues early before they become bigger problems
  • maintain compliance with tax reporting
  • audit with confidence

By implementing these steps and best practices, you’ll be able to handle TikTok Shop settlements and bank reconciliation without unnecessary stress. With the right process in place, you’ll ensure that your finances stay clean, transparent, and audit-ready.