What is an Amazon settlement report?

How to read your biweekly payout, what each line means, and how to reconcile it

Definition

What it is

An Amazon settlement report is a biweekly financial summary that Amazon generates when it disburses funds to your bank account. It itemises every transaction in the settlement period: product sales, refunds, FBA fees, referral fees, advertising charges, reimbursements, and adjustments. The "settlement amount" — the number that hits your bank — is the net of all these items. Settlement reports are the authoritative record of what Amazon actually paid you and why.

Formula

Settlement Amount Formula

Formula

Settlement = Product Sales − Refunds − Referral Fees − FBA Fees − Advertising − Other Fees + Reimbursements + Adjustments

Settlement periods are approximately 14 days. Amazon typically initiates the transfer 3–5 business days after the period closes. The "beginning balance" in each settlement carries forward any reserve Amazon held from the prior period.

Business impact

Why it matters

The settlement report is the only source of truth for what you were actually paid. Order revenue in Seller Central reflects gross sales; settlement amounts reflect what you received after all fees. Reconciling the two — verifying that settlement revenue matches order revenue minus expected fees — is the process that catches overcharged fees, missing reimbursements, and unexplained deductions. Many sellers find 1–3% of revenue in recoverable discrepancies through regular settlement reconciliation.

The challenge

How most teams track this today

Amazon provides settlement reports as downloadable flat files in the Payments section of Seller Central. Each report is a long transaction-level CSV with dozens of fee type codes. Reconciling it against the Orders report requires matching on order ID, grouping by fee type, and comparing totals — a process that takes an experienced accountant 30–60 minutes per settlement period.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Amazon Seller Central account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Amazon net margin by SKU using settlement data →Connect Amazon Seller Central →Try Free — $29.99/mo

FAQ

Common questions

How often does Amazon send settlement reports?

Amazon generates settlement reports on a biweekly (every 14 days) cycle by default. The report is generated when the settlement period closes, and the bank transfer typically arrives 3–5 business days later. You can view all historical settlement reports under Reports → Payments → Settlement Reports in Seller Central.

What is the difference between settlement revenue and order revenue?

Order revenue is the gross product sales value — what customers paid. Settlement revenue is what Amazon actually disbursed to you after subtracting all fees, refunds, and adjustments. For a healthy FBA business, settlement revenue is typically 60–75% of order revenue, with the remainder going to Amazon fees.

What should I check when reconciling my Amazon settlement?

Four main checks: (1) Does total product sales in the settlement match your Orders report for the same period? (2) Are the fee amounts consistent with your expected fee rates? (3) Are there any "Adjustments" lines that are unexplained? (4) Are there reimbursements for lost/damaged FBA inventory that you have claimed?

Does Taptic import Amazon settlement data?

Yes. Taptic imports the full settlement report via the SP-API, including all transaction types and fee codes. The settlement tables join automatically with the orders and returns tables so you can write queries that reconcile settlement payouts against order revenue in a single SQL statement.

Analytics hub

All Amazon queries, use cases, and SQL examples in one place.

Amazon Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Amazon Seller Central to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo