TikTok Shop 1099-K Reconciliation Guide: Sales Tax, Refunds, Fees, and Settlement Reports

During US tax season, many TikTok Shop sellers run into the same question:

Why is the amount on my 1099-K much higher than what actually landed in my bank account?

Then the next questions arrive:

• Is sales tax included?
• Were refunds deducted?
• Were platform fees, affiliate commissions, and shipping fees deducted?
• How should TikTok Shipping, Seller Shipping, and FBT fees be handled?
• Why does the Seller Center settlement report not match the bank statement?
• Why do Shopify, ERP, and accounting software show a different number again?

This article is not tax advice and it does not replace a CPA or tax professional. It solves the first operational problem: separating TikTok Shop orders, settlements, tax forms, and bank deposits into clean categories.

If the source data is messy, the accounting process becomes painful no matter who prepares the tax return.

Short answer: 1099-K is not a profit report

Many sellers look at a 1099-K and treat it like a revenue or profit statement.

That creates confusion.

A 1099-K is closer to a tax reporting form for gross payments processed through a platform. It is not:

• net profit
• actual bank deposit
• sales after refunds
• income after platform fees
• income after affiliate commissions
• profit after logistics, product cost, payroll, advertising, or warehouse costs

A practical model:

1099-K gross amount = transaction amount reported under the platform's tax form basis
Bank deposit = payout after platform deductions and adjustments
Profit = revenue or payout after product cost, ads, labor, warehouse, and other business costs

So if the 1099-K is higher than your bank deposits, it does not automatically mean the platform is wrong. It usually means you are comparing two different data concepts.

Sales tax needs its own line

Sales tax is one of the most confusing areas for US ecommerce sellers.

TikTok Shop's US Sales Tax FAQ and seller terms discuss TikTok Shop's role as a marketplace facilitator. In many US marketplace scenarios, TikTok Shop may calculate, collect, and remit applicable sales tax.

But that does not mean sellers should ignore tax records.

Sellers should still keep:

• order amounts
• sales tax amounts
• collection and remittance records
• refunds and cancellations
• settlement reports
• monthly summaries
• accounting system sync records

The important point is simple:

whether a marketplace facilitator collects sales tax and whether your team should reconcile sales tax records are two different questions.

Ask a CPA how to treat it for tax filing. But operationally, your team needs to separate item sales, sales tax, and actual payout.

Why 1099-K and bank deposits do not match

There is usually not one single reason.

It is a stack of differences.

1. Gross amount and net payout are not the same thing

A 1099-K is usually not based on final bank deposit.

Example:

Item price: $100
Sales tax: $8
Buyer payment: $108
Refund: $0
Platform fee: $6
Affiliate commission: $10
Shipping or fulfillment fee: $7
Final payout: maybe around $85

If you compare 1099-K gross amount with bank deposit, the numbers will naturally disagree.

The first step is not asking "why are they different?" The first step is confirming what each report is measuring.

2. Refunds and cancellations may not appear the way you expect

Refunds affect actual revenue, but they may not reduce the 1099-K gross amount in the same way you expect.

Separate these items:

• full refunds
• partial refunds
• cancelled orders
• chargebacks
• customer compensation
• platform adjustments

A common reconciliation mistake is only looking at final payout while ignoring when refunds happened.

If an order was placed in March and refunded in April, your monthly sales, refund, and settlement views may cross periods.

3. Platform fees and affiliate commissions are separate costs

TikTok Shop actual payout can be affected by several fee types:

• referral fee
• payment processing fee
• affiliate commission
• campaign or promotion cost
• shipping fee
• TikTok Shipping related fees
• FBT or warehouse fulfillment fees
• other adjustments

These costs usually affect payout, but they should not be used to directly reinterpret the 1099-K gross amount.

The right order is: reconcile gross, then deductions, then payout.

4. Shipping and fulfillment model can complicate reports

If the store uses Seller Shipping, TikTok Shipping, FBT, or third-party warehouse fulfillment, reconciliation gets more complex.

You need to confirm:

• whether the buyer paid shipping
• whether shipping income is included in the order amount
• whether the platform deducted shipping label or logistics fees
• whether FBT created fulfillment, storage, or return processing fees
• whether shipping was refunded when the order was refunded

If fulfillment models are not clear yet, read this first:

• How Has TikTok Shop Shipping Changed in 2026? Seller Shipping vs TikTok Shipping vs FBT

5. ERP, Shopify, and Seller Center may use different date logic

Cross-border teams often look at:

• Seller Center
• Shopify
• ERP
• bank statements
• Payoneer or another receiving account
• accounting software

These systems may use different date logic:

• order creation time
• payment time
• shipment time
• settlement time
• bank deposit time
• refund completion time

If you force different date bases into the same monthly table, the result will be messy.

Choose a primary basis first:

Tax form review: 1099-K and platform report basis
Operations review: order creation or payment time
Cash flow: payout or bank deposit time
Profit review: accounting recognition basis

Do not mix all bases in one sheet.

Which reports sellers should download

Reconciliation should not rely on screenshots.

Prepare these reports.

Seller Center settlement report

This is the core file.

Use it to check:

• payout
• settlement period
• platform deductions
• adjustments
• refunds
• shipping and fulfillment related fees

Order report

Use it to check:

• order ID
• item amount
• sales tax
• shipping
• discount
• order time
• payment status

Refund and after-sale report

Use it to check:

• refunded orders
• refund amount
• refund date
• refund reason
• partial refunds
• customer compensation

Affiliate commission records

If you use TikTok Shop Affiliate, do not skip this.

Check:

• creator or affiliate source
• commission rate
• commission amount
• commission freeze or adjustment
• order attribution

This guide is a relevant next read:

• TikTok Shop Affiliate Creator Violations: Misleading Claims, Prohibited Products, and Commission Risk

Platform invoices and fee records

Use them to check:

• referral fee
• payment processing fee
• promotion cost
• logistics fee
• FBT fee
• other adjustments

If you only look at orders and ignore fees, bank deposits will remain hard to explain.

ERP / Shopify / accounting system data

If orders sync into Shopify, ERP, or accounting software, export those files too.

Do not assume third-party systems are always the final answer. They can differ because of field mapping, time zones, refund sync, tax field logic, or manual changes.

A practical reconciliation workflow

Step 1: Pull monthly order totals

Start with platform reports for the month.

Include at least:

• order ID
• order date
• gross amount
• item subtotal
• sales tax
• shipping
• discount
• refund status
• payout status

Do not calculate profit yet.

First confirm how much transaction volume the platform believes it processed.

Step 2: Separate sales tax

Put sales tax in its own column.

Do not merge sales tax and item sales into one field.

Use columns such as:

Gross buyer payment
Item subtotal
Sales tax
Shipping paid by buyer
Discount

Ask a CPA how to treat sales tax for tax filing. But in your operating data, sales tax must be visible separately.

Step 3: Reconcile refunds and cancellations

Match by order ID:

• full refunds
• partial refunds
• cancellations
• refund date
• cross-month refunds
• whether refund affected commission or platform fee

Many month-end differences come from refunds crossing periods.

Step 4: Reconcile fees and commissions

Break fees into types:

Referral fee
Payment processing fee
Affiliate commission
Shipping fee
FBT / fulfillment fee
Promotion cost
Adjustment

Do not use one generic "platform deduction" field. It looks simpler but becomes useless when numbers do not match.

Step 5: Reconcile payout and bank deposit

Check the bank last.

Use this order:

Order gross amount
- refunds / cancellations / adjustments
- platform fees
- affiliate commissions
- shipping and fulfillment fees
= settlement payout
Then compare with bank deposit

Do not use bank deposits to reverse-engineer 1099-K. Bank deposits are the final cash result, not the tax form basis.

Step 6: Mark differences instead of editing numbers

If you find a difference, do not manually change a field just to make the sheet balance.

Add difference columns:

Platform report amount
ERP amount
Bank amount
Difference
Reason
Owner
Status

This lets the team review the issue next month instead of guessing again from scratch.

Team responsibilities

TikTok Shop reconciliation is not only a finance task.

Finance

Responsible for:

• downloading settlement and tax documents
• checking payout and bank statements
• preparing files for the CPA
• marking differences

Operations

Responsible for:

• explaining orders, campaigns, and discounts
• checking affiliate commissions
• reviewing product and campaign configuration
• explaining abnormal GMV sources

Customer support

Responsible for:

• providing refund and after-sale records
• explaining refund reasons
• preserving buyer communication records
• identifying repeated after-sale issues

Warehouse or logistics

Responsible for:

• providing shipment and logistics cost data
• checking shipping fees, label fees, and fulfillment fees
• explaining returns and reshipment costs

Store admin

Responsible for:

• managing Seller Center access
• keeping report download access stable
• avoiding shared-account data changes
• preserving operation records

If the team still relies on shared accounts, ad hoc screenshots, and manually passed files, reconciliation errors are likely.

These guides are useful next reads:

• How Should a TikTok Shop Team Build Its Network Setup? A Checklist for 3, 10, and 30-Person Teams
• Why Does a Unified Remote Workstation Entry Reduce Troubleshooting Cost?

Common mistakes

Mistake 1: Treating 1099-K as actual income

It is not.

1099-K is a specific tax reporting form basis. It is not a profit report and it is not bank deposit.

Mistake 2: Ignoring sales tax records

Even if a marketplace facilitator collects and remits sales tax, sellers should still preserve order, tax amount, and settlement records.

Mistake 3: Only checking bank statements

Bank statements only show final deposits. They do not explain gross amount, refunds, fees, or tax form basis.

Mistake 4: Assuming ERP data is always more accurate

Not always.

ERP data can have sync delays, mapping errors, time-zone differences, and manual adjustments. Reconciliation should start from platform source reports.

Mistake 5: Waiting until tax season

That is too late.

If orders, refunds, and fees were not archived monthly from January through December, tax season becomes a data recovery project.

Monthly reconciliation checklist

Run this every month:

1. Download Seller Center settlement report
2. Download order report
3. Download refund and after-sale report
4. Download affiliate commission records
5. Download platform fee or invoice records
6. Export ERP / Shopify / accounting system data
7. Reconcile gross amount, sales tax, refund, fee, commission, and payout by month
8. Mark differences and owners
9. Save the final version for finance and CPA

If you do it monthly, year-end is a summary.

If you only do it once a year, year-end is archaeology.

Conclusion

TikTok Shop 1099-K reconciliation is not about forcing all numbers into one total.

It is about separating data layers:

• gross amount
• sales tax
• refund
• platform fee
• affiliate commission
• shipping and fulfillment fee
• payout
• bank deposit

Once these layers are clear, the differences between 1099-K, Seller Center settlement reports, ERP data, and bank statements become much easier to explain.

Tax treatment belongs with a CPA.

But the operating team must prepare clean data first. Without that, tax filing, profit review, and internal accountability all become harder than they need to be.