The bank sees a net payout, but one deposit may contain sales, refunds, discounts, Sales Tax, processing, advertising, reserves and timing differences. Posting cash as revenue distorts income, expense, tax liabilities and channel margin together.

1. Separate order, settlement and deposit layers

Order data describes purchases, fulfillment, returns, discounts and tax. A settlement explains how a platform groups a period of activity into the amount payable to the seller. The bank proves cash received. Their dates frequently differ, so deposit date cannot replace order or settlement period.

For every platform, retain source order exports, settlement ID, beginning and ending dates, currency, bank reference and journal. Preserve prior versions when a platform republishes data. An automated connector transports information; the company must still prove completeness, mapping and absence of duplicate batches.

  • Order, fulfillment, return and tax facts
  • Settlement period, ID and components
  • Bank date, amount and reference
  • Data version, connector logs and duplicate checks

2. Build a gross-to-net waterfall

Begin each settlement with gross sales and separately show discounts, refunds, Sales Tax, shipping, gift cards, marketplace fees, payment processing, advertising, chargebacks, reserves and other adjustments through net payout. Map every line to an approved ledger account and tax dimension; total debits and credits must equal the settlement exactly.

Sales Tax treatment depends on who has collection and remittance responsibility; it is not universally revenue or expense. Reconcile marketplace-collected amounts to state-level platform reports, while company-collected direct-channel tax generally enters a liability. A fee netted from cash still needs contract or invoice support.

  • Gross sales, discounts and refunds
  • Seller-collected and marketplace-collected tax
  • Platform, processing, advertising and fulfillment fees
  • Chargebacks, reserves and timing adjustments
  • One-to-one net payout and bank match

3. Analyze gross versus net presentation

A platform fee alone does not justify net revenue, and gross presentation is not automatic in every model. For the applicable reporting purpose, analyze whether the company controls the good or service before transfer, who has fulfillment responsibility, and pricing and inventory risk, and document the principal-agent conclusion under current FASB revenue guidance.

Distinguish owned-inventory DTC, third-party drop shipping, marketplace models, an independent Shopify store and digital services. Reassess after contract or fulfillment changes or when a platform becomes merchant of record. Tax returns, Sales Tax and Form 1099-K may use different reporting concepts, which need reconciliation rather than forced equality.

4. Use Form 1099-K as evidence, not a revenue substitute

IRS guidance explains that Form 1099-K reports gross payment transactions and generally does not net refunds, fees, cash equivalents, discounts or other adjustments. Reconcile it by payer, TIN, platform and month to settlement gross activity and the ledger. Do not post Box 1a as a second revenue entry.

Differences may reflect year-crossing settlements, several stores under one TIN, refunds outside gross, Sales Tax, delivery charges, currencies, duplicates or an incorrect form. Retain a 1099-K bridge and payer contacts. A business still reports income from complete books and applicable tax law even if no form arrives.

  • Payer, platform account, legal entity and TIN
  • 1099-K amount to settlement gross activity
  • Refund, fee, tax, delivery and other non-net items
  • Cross-year, currency, duplicate and corrected forms
  • Final ledger-to-income-tax-return reconciliation

5. Make settlement reconciliation a close control

By platform, roll opening receivable or reserve through gross activity, deductions and payouts to ending balance. Route open settlements, stale reserves, negative payouts, unusual refund rates and unmapped fee codes to an issue log. The close owner explains above-threshold differences before reports are issued.

Control chart mapping and effective dates, testing new fee codes or report formats before production. Quarterly, compare platform sales to Sales Tax, inventory, channel margin and income-tax revenue; complete the 1099-K bridge annually. Automation should improve evidence quality, not merely entry speed.

  • Monthly platform receivable and reserve roll-forward
  • Open-settlement and unknown-fee exception queue
  • Cross-check to Sales Tax, inventory and channel margin
  • Tested and approved mapping effective dates
  • Annual Form 1099-K to return bridge