Your Amazon settlement report shows $22,000 in sales for the period. The deposit that lands in your bank account is barely $14,000. Your bookkeeping software, which dutifully imported the bank feed, records $14,000 of revenue — and now your profit looks thinner than it is, your expenses are missing thousands of dollars in deductible fees, and your tax return is quietly drifting away from what the IRS expects to see. All three numbers came from the same two weeks of selling.
This is the payout reconciliation gap, and it is the single largest source of misstatement on ecommerce books. Every marketplace pays you a net figure — gross sales minus its referral cut, fulfillment fees, advertising charges, refunds, reserves, and adjustments — but your books need the gross figure and every deduction as its own line. Record only the deposit and your financials are wrong in half a dozen ways at once. This guide breaks down what each platform's payout actually contains, why booking net deposits corrupts your margins, cash forecasts, and tax filings, and the reconciliation routine that closes the gap.
What a Payout Actually Contains
A marketplace settlement is never just "your sales money." It is a net settlement: everything buyers paid, minus everything the platform kept, adjusted for refunds, reimbursements, and timing holds. Take a typical two-week Amazon settlement:
- Gross sales of roughly $22,000
- Less referral fees of about $2,800
- Less FBA fulfillment fees of about $2,400
- Less storage fees of about $400
- Less advertising charges of about $1,500
- Less returns and refunds of about $600
- Plus reimbursements for lost or damaged inventory of about $100
- Net deposit: roughly $14,400
If you book that $14,400 deposit as revenue — which is exactly what a default bank-feed import into QuickBooks or Xero will do — revenue is understated by nearly $8,000, several thousand dollars of deductible fees never hit your expense accounts, and returns are invisible. Multiply that across twelve months and three sales channels, and your year-end books describe a business that does not exist.
Each platform assembles its net figure differently, which is why multi-channel sellers feel the gap most.
Amazon: the longest receipt
Amazon settles roughly every two weeks, and its settlement report is the most granular of the three. Beyond the headline referral commission (typically 8 to 15 percent depending on category) and per-unit FBA fulfillment fees, sellers absorb monthly storage fees, inbound placement fees, low-inventory-level fees, fuel and inflation surcharges, advertising spend deducted directly from the settlement, refunds, and an account-level reserve that Amazon holds back — often around two weeks of sales — and releases on a rolling basis. Reimbursements for lost or damaged FBA inventory flow back in as credits. The settlement flat file lists every one of these by transaction type, fee type, order ID, and SKU, which makes it reconcilable but far too detailed to enter by hand.
Shopify: closer to gross, with its own traps
Shopify Payments pays out on a rolling schedule (daily by default in most regions), so deposits track sales more closely than Amazon's biweekly batches. The payout deducts card processing fees, refunds, and chargebacks before the money moves. The traps are different: sellers running multiple gateways (Shop Pay, PayPal, Klarna, a third-party processor) get separate payout streams on separate schedules with separate fee structures, and PayPal passes no fee data to Shopify at all. Shopify Capital loans and cash advances add another layer — repayments are withheld as a percentage of daily sales, which looks like a fee in the payout but is actually loan repayment. Book it as an expense and you overstate deductions while the loan balance never shrinks on your balance sheet.
TikTok Shop: commissions on commissions
TikTok Shop settles each order roughly two weeks after delivery to cover the return window, then batches settled orders into payouts. The deduction stack includes a referral commission, a transaction fee, refund administration fees, shipping and logistics operation fees (deducted from the seller's settlement and non-refundable even when the buyer returns the item), and — the line most sellers miss — affiliate commissions. If creators promote your products, their commission and any affiliate partner or shop-ads commission come out of the same settlement. A seller running an active affiliate program can watch several hundred dollars per payout evaporate into commission lines they never budgeted because the sales dashboard shows gross merchandise value, not net settlement.
Why Booking Net Deposits Breaks More Than the P&L
The obvious damage is an income statement that understates both revenue and expenses. The less obvious damage compounds from there.
Your margin analysis is fiction
If referral fees, fulfillment fees, and affiliate commissions never appear as separate line items tied to SKUs, you cannot compute SKU-level contribution margin. You can compute an average — total deposits divided by total units — but an average conceals which products earn money and which are subsidized by your winners. The product you keep reordering because it "sells well" may be losing money on every unit after its true fee load. Sellers who reconcile at settlement level routinely discover that their bestseller by revenue ranks near the bottom by margin.
Your cash forecast uses the wrong inputs
Books built on deposit dates record revenue when cash arrives, not when sales happen. Amazon sales from the last week of March settle in mid-April; TikTok Shop orders sit in "not settled" status for two weeks after delivery. A working-capital model fed on deposit timing systematically misplaces revenue by two to four weeks, which is exactly the horizon where inventory purchase decisions get made. Every projection built on that data inherits the same lag in the same direction.
Your tax filings drift from your real numbers
The IRS and every state where you have nexus tax you on gross sales minus deductible expenses — not on net deposits. File from deposit data and you underreport revenue while simultaneously forfeiting the fee deductions that would have offset it; the net tax effect is unpredictable, but the return no longer matches the gross-payment figures marketplaces report about you. When the platform's 1099-K shows $180,000 in gross payments and your return shows $120,000 of revenue with no reconciling schedule, the IRS matching program does not assume you had $60,000 in fees — it sends a notice. Gross revenue on the return must tie to marketplace settlement reports, with fees deducted as ordinary business expenses.
Reserves and holds create phantom swings
Amazon's rolling reserve, TikTok Shop's delivery-plus settlement window, and Shopify's occasional payout holds for risk review all mean that some of each period's sales have not settled when the month closes. Without month-end accruals — sales earned but not yet received booked as a receivable from the marketplace — revenue lurches with payout timing instead of tracking actual selling activity. December looks soft because settlements straddle the holiday; January looks heroic for the same reason.
The Fix: Reconcile Settlements, Not Deposits
The professional solution is a clearing account: a temporary balance-sheet account per platform that holds gross sales from the moment revenue is recognized until cash arrives and every fee is accounted for. The workflow has three steps.
Step 1: Record gross sales when they happen. From each platform's sales or settlement report, post the period's gross sales as revenue and the offsetting debit to the platform's clearing account (an asset — money the marketplace owes you). Do this per settlement period, not per order; nobody needs 4,000 journal lines a month.
Step 2: Split each payout into its components. When the deposit lands, clear it against the clearing account and book every deduction to its own expense account:
- Debit: Cash (net deposit amount)
- Debit: Marketplace Fees — Referral/Commission
- Debit: Marketplace Fees — Fulfillment/Transaction
- Debit: Marketplace Fees — Storage/Logistics
- Debit: Advertising Expense
- Debit: Refunds and Returns (contra-revenue)
- Credit: Platform Clearing Account (gross sales for the period)
Each line maps to a consistent account, every settlement period. Sales tax the marketplace collected and remitted as facilitator stays out of both revenue and liability — but verify that treatment against your actual nexus footprint rather than assuming the platform handled everything.
Step 3: Reconcile the clearing account to zero (plus in-transit sales). After posting, the clearing account should hold only sales made but not yet settled — your deposits in transit. Compare that balance to the platform's pending-settlement or reserve figures. If the clearing account carries a growing unexplained balance month after month, something is leaking: unrecorded refunds, miscategorized Capital repayments, or affiliate commissions booked nowhere.
The monthly routine that keeps it honest
Run this once a month, per channel, and the gap stays closed:
- Download each platform's settlement or payout reports for the month.
- Post gross sales and the full fee split per settlement period.
- Match every bank deposit to its settlement report total — exact match, no plugs.
- Book month-end accruals for earned-but-unsettled sales and outstanding reserves.
- Tie gross sales per the books to gross sales per the platforms within a percent or two; investigate anything larger before closing the month.
- Once a quarter, spot-check fee rates against the platform's current schedule — referral percentages, FBA dimensional tiers, and TikTok commission rates all change, and an outdated template silently misstates every period it touches.
How sellers actually get this done
Three approaches cover most of the market. Settlement-parser tools sit between the marketplace and the general ledger, pull settlement-level detail, and write properly split journal entries into QuickBooks or Xero — accurate and audit-ready, at the cost of another subscription per channel. Ecommerce-native accounting platforms bundle payout parsing with bookkeeping, bill pay, and inventory in one system — tighter integration, harder to leave. Or a CPA fluent in ecommerce builds the chart of accounts and journal templates in your existing ledger — cheapest in software, most dependent on the firm's expertise. Whichever route you take, the acceptance test is the same: ask for gross sales, total fees by type, and net deposit for one settlement period, and check that the three reconcile. Books that cannot produce that in under a minute are not reconciled.
The One Check to Run This Week
Pull your last three marketplace payouts and your last three monthly P&Ls. Ask one question: does the gross sales figure on each P&L match the gross orders on the settlement reports for that period, within a percent or two? If yes, your reconciliation is working. If there is a material gap — or if answering takes an hour of digging through bank feeds — you have a payout reconciliation problem, and every month it runs, your margins, forecasts, and tax filings drift further from reality. Fix the current month first with the clearing-account workflow above, then work backward one quarter at a time until the clearing accounts reconcile clean.
Keep Your Settlement Accounting Audit-Ready
Accurate payout reconciliation is ultimately a recordkeeping discipline: gross sales recorded when earned, every fee in its own account, every deposit tied to its settlement report, and a paper trail an auditor — or a buyer doing due diligence on your business — can follow from bank statement back to order. Systems that keep that trail in plain, reviewable text make the monthly routine faster and the year-end review far less painful. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.
