Ecommerce reconciliationAmazon Seller settlements
Guide

Amazon Seller settlement reconciliation

The short answer

The short answer: Amazon Seller settlement reconciliation is the process of matching each Amazon Seller settlement (payout) to the underlying orders and to the many fees, refunds, reimbursements, and reserves Amazon Seller nets out before depositing, then booking the correct entries to your general ledger. Because Amazon Seller bundles roughly two weeks of activity into one net deposit, the settlement never equals your sales, so it must be decomposed and reconciled.

Why Amazon Seller settlements are hard to reconcile

Amazon Seller pays on a 14-day settlement cycle, and the deposit is a single net number that combines: revenue, refunds, referral fees, FBA fulfillment and storage fees, advertising, reimbursements, sales tax, and settlement reserves. A finance team can't see which orders or fees drove the number without breaking the settlement report apart line by line, and Amazon Seller also issues settlement restatements that change prior periods after the fact.

Two timing quirks make Amazon Seller especially tricky:

How to reconcile an Amazon Seller settlement

  1. Order: units sold, recorded in Seller Central.
  2. Payment: Amazon Seller's settlement detail, revenue less each fee, refund, and reserve.
  3. Payout / bank deposit: the net cash Amazon Seller deposited.

Tie order → settlement → bank, categorize every fee type to the right account, and post the entry to your GL. Then handle restatements and late refunds in the correct period.

How Blue Onion automates Amazon Seller settlement reconciliation

Blue Onion decomposes every Amazon Seller payout back to the underlying orders, fees, refunds, and reserves, including FBA, advertising fees, and settlement reserves, and performs the order → payment → payout three-way match automatically. Its Close module posts daily summary journal entries to NetSuite, QuickBooks, or Xero, and Smart Adjustments auto-detects and books Amazon Seller settlement restatements and late returns to the correct month, so prior periods stay accurate without manual rework.

FAQ

Why doesn't my Amazon Seller payout match my sales?

Amazon Seller nets referral, FBA, advertising fees, refunds, reimbursements, and reserves out of each settlement, so the deposit is well below gross sales and must be broken down to reconcile.

How do I handle Amazon Seller settlement restatements?

Restatements change a prior period after it closed. Blue Onion auto-detects them and books the adjustment to the correct month automatically, so you avoid surprise corrections at close.

Can Amazon Seller settlement reconciliation be automated?

Yes. Blue Onion reconciles Amazon Seller settlements to orders at the transaction level and posts ERP-ready entries, replacing manual settlement-report matching.

See it on your own data

Blue Onion reconciles every order to every payout automatically, so your close runs faster and your numbers are trustworthy from the first order to the final close.

Book a demo →