10 minutes
If you're staring at a TikTok Shop or Amazon settlement and trying to figure out where the money actually went, the short answer is fees came out before the deposit ever formed. The longer answer is that each of those deductions belongs in a different account, and collapsing them into one line is what breaks your books at month-end.
TLDR:
Amazon and TikTok Shop both pay net of fees, so your bank deposit will never match your gross sales figure.
Use a clearing account per channel: post gross sales and fees separately, then zero it when the deposit arrives.
The revenue-weighted median listed TikTok Shop affiliate commission rate was 9%, with health best-sellers at a median 18%, each needing its own GL line.
Recognize revenue on ship date, not settlement date, or December shipments bleed into January books.
Iris Finance matches each order against its actual deposit, fees, refunds, and ad spend to produce true delivered gross profit per order.
Why Marketplace Payouts Never Match Your Bank Deposits
Net deposits are the single largest source of material misstatement on ecommerce P&Ls. It is a structural problem baked into how every major marketplace pays you.
Amazon and TikTok Shop both settle net of fees. What lands in your bank account is gross sales minus referral fees, fulfillment charges, affiliate commissions, and promotional subsidies. The deposit is a compressed, opaque number that will never equal the revenue figure in your order management system. Each channel you add makes the gap wider.
How Amazon Settlements Work
Amazon pays on a bi-weekly cycle. Every 14 days, a deposit hits your bank account representing everything Amazon collected and deducted on your behalf during that period. The number is net of everything, which is why a month showing $200,000 in Seller Central gross sales might produce $142,000 in actual deposits. For a full breakdown of how Amazon reconciliation works, the process involves matching each settlement report line against your internal records.
The settlement report bridges that gap. A settlement combines sales, fees, and other transactions. It is not a simple revenue summary. The key line items to account for:
Gross product sales
Referral fees, a percentage of each sale that varies by category
FBA fulfillment fees covering per-unit pick, pack, and ship charges
Monthly inventory storage fees
Advertising charges across Sponsored Products and Sponsored Brands
Refund administration fees
Marketplace facilitator tax collected and remitted on your behalf
Each line maps to a different account in your general ledger. Referral fees are merchant fees. FBA fulfillment belongs in cost of goods or fulfillment expense. Storage is a separate operating cost. None of them belong lumped together as a single "Amazon expense."
How TikTok Shop Settlements Work
TikTok Shop settlements follow a net-payout structure similar to Amazon, but the fee stack is deeper and less standardized. TikTok bundles multiple deductions into a single deposit, and the gap between your sales dashboard and your bank account can be substantial once every layer is accounted for.
Most US categories carry a 6% referral fee, though selected categories use 5% or special rules. On top of that, TikTok deducts affiliate commissions, FBT (Fulfilled by TikTok) fees, and shipping before anything hits your bank. Each deduction needs its own GL account.
Affiliate commissions are where things get complicated. The revenue-weighted median listed commission rate on top-selling products is 9%, with three-quarters of revenue falling in the 5-15% range. Health category best-sellers listed a median of 18%. Rates can reach 80% for certain products. TikTok Shop affiliate commission rates vary widely by category, with beauty and supplements regularly sitting at the high end.
Promotions add another layer. Seller-funded promotions reduce recognized revenue. Platform-funded subsidies, where TikTok covers part of a discount, flow through differently. They are easy to misclassify as lost revenue instead of booking as a separate line item. Getting that wrong overstates your discount expense and understates your true margin.
Chart of Accounts Setup for Multi-Channel Fee Reconciliation
Before touching a single settlement file, your chart of accounts needs to be structured correctly. Trying to match settlements against a poorly built GL is like doing math on a napkin and transcribing it into a spreadsheet that uses different units.
There are four distinct account types you need for each channel:
A gross sales account covering revenue before any deductions
A fees account broken out by fee type, not lumped together
A refunds and returns contra-revenue account
A clearing account to hold funds between sale date and settlement date
That clearing account is the piece most brands skip, especially once they're trying to connect Shopify and Amazon data cleanly. Marketplace clearing accounts function as current assets: the payout amount sits there until the deposit arrives and is matched, at which point the account returns to zero.
Why Channel-Level Separation Matters
Collapsing Amazon FBA fees and TikTok affiliate commissions into one "merchant fees" line makes it impossible to see which channel is actually profitable. A 6% TikTok referral fee plus a 9% affiliate commission is a very different cost structure than Amazon's referral fee plus FBA fulfillment, and your P&L should reflect that difference explicitly.
Amazon FBA fees should be categorized by the type of cost they represent, with fulfillment, referral, storage, and returns each in separate accounts. The same logic applies to TikTok: affiliate commissions, fees, FBT charges, and shipping should never share a single GL line.
Account | Amazon | TikTok Shop |
|---|---|---|
Gross Sales | 4000-AMZ | 4000-TTK |
Referral Fees | 5100-AMZ | 5100-TTK |
Fulfillment/FBT Fees | 5110-AMZ | 5110-TTK |
Affiliate Commissions | N/A | 5120-TTK |
Refunds | 4100-AMZ | 4100-TTK |
Clearing Account | 1200-AMZ | 1200-TTK |
The Clearing Account Method
A clearing account is the mechanical fix that stops you from booking net deposits as revenue.
When a settlement posts, you record two entries: gross revenue into your sales account (debit clearing, credit revenue) and each fee category as a separate expense (debit expense, credit clearing). When the actual bank deposit arrives, you match it against that clearing balance, and the account zeros out.
Marketplace clearing accounts function as current assets in QuickBooks Online until each deposit is matched to its corresponding bank transaction. A clearing account that never zeros out signals something was missed: a fee unrecorded, a deposit not yet matched, or a refund without a corresponding entry.
Skipping this and recording the net deposit directly as revenue compresses fees and gross sales into one line, understates costs on your profit and loss statement, and makes period-end work nearly impossible.
How to Match Amazon Fees to the General Ledger
Pull your settlement report from Seller Central under Reports > Payments > Transaction View. Download it for the settlement period, not the calendar month. Amazon's 14-day cycle rarely aligns with your month-end, so a single calendar month will typically contain parts of two separate settlements.
Work through the report in this order:
Post gross product sales as a debit to your clearing account and a credit to your Amazon gross sales account
Post referral fees as a debit to your merchant fees expense account and a credit to clearing
Post FBA fulfillment fees to fulfillment expense, credited against clearing
Post storage fees to a separate warehousing or inventory holding account
Post advertising charges to your Amazon advertising expense account
Post refund administration fees to your refunds contra-revenue account
Once every line is posted, your clearing account balance should equal the deposit amount. When the bank deposit hits, debit your bank account and credit clearing. If it zeros, you're done.
For orders spanning two accounting periods, recognize revenue in the period the order shipped, not when the settlement closed. Keep a log of open orders at month-end and accrue the associated fees even if the settlement hasn't posted yet. The settlement report will confirm those figures when it arrives so you can true up any variance against the accrual.
How to Match TikTok Shop Fees to the General Ledger
Pull your TikTok Shop settlement statement from Seller Center under Finance > Bills & Payments. Download at the settlement level, not by calendar date, since TikTok's payout timing rarely aligns with your month-end close.
Work through deductions in this order:
Post gross GMV as a debit to your TikTok clearing account and a credit to your TikTok gross sales account
Post referral fees to merchant fees expense, credited against clearing
Post affiliate commissions to a separate creator/affiliate expense account, not the same line as referral fees
Post FBT fees to fulfillment expense
Post shipping fees to your shipping cost account
Separate seller-funded discounts from subsidized promotions: seller discounts reduce gross revenue, while subsidy payments post as other income or a contra-expense depending on your accounting policy
Once all lines are posted, your clearing balance should match the bank deposit. Debit bank and credit clearing when the deposit arrives. If it doesn't zero, the gap is almost always an unbooked affiliate commission or a promotion misclassified as a revenue deduction.
One issue specific to TikTok Shop: if your store also runs on Shopify with both connections live, TikTok orders flow through Shopify as well, creating duplicate transactions that overstate revenue. The fix is to suppress TikTok order data at the Shopify level so only one source of record captures each sale.
Revenue Recognition Timing Across Both Channels
Under accrual accounting, revenue recognition on marketplace sales has one trigger: the point at which control of the goods transfers to the buyer. For physical products, that's the ship date, not the order date, and not the settlement date.
Amazon and TikTok Shop both pay on settlement cycles that lag actual fulfillment by days or weeks. If you recognize revenue when cash lands, December shipments bleed into January books and your period-end numbers are wrong before you've started closing.
The three dates to track per order:
Order date: when the customer placed the order
Ship date: when control transfers, the accrual recognition trigger
Settlement date: when cash hits your clearing account
Fees belong in the same period as the revenue they're tied to. An FBA fulfillment fee on a December shipment belongs in December, even if Amazon's settlement cycle closes in January. Book a month-end accrual entry, debit your clearing account, credit gross sales for all shipped-but-unsettled orders, and record estimated fee lines against that same clearing balance. When the settlement posts, true up against actuals and release the accrual. The variance is usually small, but the entry has to be there.
Handling Refunds and Returns in the General Ledger
Refunds from Amazon and TikTok Shop arrive on their own schedule. A return processed in January might trace back to a December order, and both channels post the refund credit independently of the original settlement period.
The correct entry reverses each component of the original sale. Debit your gross sales account to reduce recognized revenue, then credit clearing for the refund amount net of any fees the channel retains. Do not net the refund directly against gross sales as a single line. That obscures your true return rate and makes it impossible to see which fee lines are being clawed back.
Amazon Refund Fee Handling
Amazon charges a refund administration fee: 20% of the original referral fee for the refunded portion, up to $5 per SKU type per refund. Post this separately to your merchant fees expense account. Amazon does not return FBA fulfillment fees on refunded orders, so that cost stays in fulfillment expense as originally recorded, which is why accurate COGS calculation depends on tracking these fees at the SKU level.
TikTok Shop Clawbacks
When a TikTok Shop clawback occurs, debit your creator/affiliate expense account for the recovered amount and credit clearing. If no clawback materializes, the commission stays a realized cost.
Your clearing account should reflect actual cash movement. Gross sales and fee accounts each carry their own adjustments, separately.
Common Reconciliation Errors and How to Fix Them
Five errors account for the majority of multi-channel reconciliation failures. Each one is fixable, and each one carries a cost if left alone.
Recording the net deposit as gross revenue is the most common and the most damaging. When you book a $14,000 Amazon deposit as $14,000 in revenue, every fee disappears from your P&L, margin looks better than it is, and the numbers fall apart under any real scrutiny.
Lumping all fees into a single expense line loses all diagnostic value. "Amazon fees: $3,200" tells you nothing about whether fulfillment costs are rising or storage charges are accumulating, and it makes SKU and channel profitability analysis impossible.
Failing to match refunds to their originating orders breaks return rate analysis. A lump contra-revenue entry with no tie back to the original order makes December look cleaner than it was and January worse than it is.
Misclassifying TikTok-funded promotions as lost revenue overstates discount expense and understates true contribution margin. The fix is a clear accounting policy distinguishing seller-funded from subsidy-funded promotions before any entry gets posted.
Duplicating TikTok Shop orders that also run through Shopify inflates revenue without an obvious trigger. The fix is suppressing TikTok order data at the Shopify level so each order has exactly one source of record.
Multi-Channel Reconciliation at Scale: When Manual Processes Break Down
Managing one channel's settlement manually is tedious but survivable. Two channels with misaligned payout cycles, affiliate commission clawbacks, and duplicate Shopify orders running in parallel is where spreadsheets start failing in ways that are hard to catch until month-end.
In Iris Finance's experience across the brands it works with, the breaking point for most finance teams is around 500 monthly orders per channel. Below that, a disciplined spreadsheet process works. Above it, the volume of line items in each settlement file outpaces what a person can review accurately, and errors compound across periods faster than they get caught.
What teams automate first is usually settlement parsing: pulling the raw Amazon or TikTok Shop settlement file and mapping each line to a GL account without manual intervention. After that comes ERP write-backs, pushing journal entries directly into QuickBooks, Xero, or NetSuite instead of keying them by hand. Those two steps eliminate the majority of booking errors.
The trade-off between approaches:
Purpose-built settlement tools handle the mechanical mapping well and are affordable, but they stop at the GL entry and won't connect fee data to SKU-level profitability or forecasting.
Having a CPA configure reconciliation in QuickBooks or Xero is reliable if that person understands marketplace settlement structures, but it's time-billed and needs maintenance every time TikTok or Amazon changes its fee categories.
A full FP&A solution that ingests settlement data at the order level gives you matched, accurate GL entries and the financial visibility of a true cash machine in one place, though the investment is higher.
If you only need clean books, a settlement parser plus a CPA works fine. If you need order-level margin visibility, channel-level contribution margin, or forecasting built on verified actuals, you need something that connects the settlement layer to the financial model.
How Iris Finance Handles TikTok Shop and Amazon Fee Reconciliation
At Iris, reconciliation is the foundation every other number is built on.
For both Amazon and TikTok Shop, we pull order-level data and match each sale against its actual deposit, fees, discounts, refunds, COGS, and ad spend. The output is true delivered gross profit per order, not a settlement-level estimate. That number feeds directly into the daily P&L, the contribution margin view, and the 13-week cash flow forecast. If the fee-matching layer is off, everything downstream will be off too, including your 13-week cash flow model.
TikTok Shop
We capture literal order-level fee data including FBT fees, affiliate commissions, TikTok merchant fees, and shipping charges per order. That granularity lets you see actual margin on a TikTok sale instead of backing into an estimate from a net deposit. For brands doing meaningful TikTok volume, that visibility changes how you price products and structure affiliate programs.
Amazon
A former Amazon engineer on our team identified what appears to be a Prime account identifier embedded inside the 26-character order ID. That finding allows cohort tracking across Amazon settlements that standard reconciliation tools cannot replicate, giving you LTV-to-CAC by cohort on a channel most brands treat as a black box.
Across roughly 500 brands and approximately $20B in GMV handled, the reconciliation layer is what separates a real financial picture from a confident-looking guess.
Final Thoughts on Matching Marketplace Fees Across Amazon and TikTok Shop
Your bank deposits from Amazon and TikTok Shop will never equal your gross sales, and that gap only gets wider as your volume grows. The structure covered here, clearing accounts, channel-level fee separation, and accrual-based revenue recognition, is what turns a confusing settlement file into a P&L you can actually trust. The work is not glamorous, but the visibility it creates is worth it. If you want that reconciliation layer set up and connected to your broader financials, get started with the Iris team.
FAQ
How do I match TikTok Shop and Amazon fees to the general ledger when payout cycles don't align with my month-end close?
Work from settlement files, not calendar dates. Both Amazon's 14-day cycle and TikTok Shop's payout timing will cut across your month-end. Post gross sales and each fee category separately to a clearing account when the settlement arrives, then match the bank deposit against that clearing balance when it hits. For orders that shipped in one period but settle in the next, book a month-end accrual entry with estimated fee lines and true up against actuals once the settlement posts.
How do I know if my TikTok Shop margins are actually profitable after fees and affiliate commissions?
You cannot know from a net deposit alone. A 6% referral fee plus a median 9% affiliate commission already pulls 15 points off gross revenue before FBT fulfillment and shipping touch the number. Health category products often list affiliate rates at 18% or higher. The only way to see true margin is to separate each deduction into its own GL account and track realized contribution margin at the order level, not the settlement level.
Does Iris Finance write back journal entries to QuickBooks, Xero, or NetSuite, or is it read-only?
Iris is read-only and does not write back to your ERP. The platform pulls order-level data across channels, matches each sale against actual deposits, fees, discounts, refunds, COGS, and ad spend, and produces verified financials that feed your daily P&L and contribution margin view. Your accounting system remains the system of record for posted entries.
Why does my Amazon gross sales figure in Seller Central never match my bank deposits, and what's the right way to account for the difference?
Amazon settles net of referral fees, FBA fulfillment charges, storage fees, advertising costs, and refund administration fees. A month showing $200,000 in Seller Central gross sales might produce $142,000 in actual deposits. The settlement report bridges that gap line by line. Each deduction maps to a separate GL account: referral fees to merchant fees expense, FBA fulfillment to fulfillment expense, storage to a warehousing account, and advertising to your Amazon ad spend line. Booking the net deposit as revenue collapses all of that into one number and makes your P&L unreadable.
How do I stop TikTok Shop orders from duplicating in Shopify and inflating my revenue figures?
If your store runs both a TikTok Shop connection and a Shopify connection simultaneously, TikTok orders flow through Shopify as well, creating two records for the same sale. The fix is to suppress TikTok order data at the Shopify level so each order has exactly one source of record. Otherwise your gross revenue is overstated and the error has no obvious trigger until you start tracing deposits against expected totals.
Related posts
Actionable data, proven strategies, and clear forecasts, empowering you to make smarter decisions and scale with confidence.





