Remworth

ProfitHow to read an Amazon
settlement report.

An Amazon settlement report breaks down the money behind a payout, amount by amount. Here is how to read one: the columns that name the settlement period, the four that say what each amount is, how to total them, and why the total is neither your sales nor your profit. Every Amazon rule here comes from Amazon's own pages.

Profit · Published October 5, 2026 · Checked against the sources below on October 4, 2026 · 7 min read

What an Amazon settlement report is

An Amazon staff post on the Seller Forums describes payments reports as "a detailed breakdown of transactions during a given settlement period." The settlement report is that breakdown as a file: each amount sits on its own row, with labels that say what it is.

You don't order one. Amazon's developer documentation says settlement reports "cannot be requested or scheduled"; they are "automatically scheduled by Amazon." Its payments guide says that, in general, Amazon settles seller accounts every two weeks.

Two of the three formats retire on November 11, 2026

Amazon has offered settlement reports in three formats: XML, a flat file, and the Flat File V2, a tab-delimited file (its columns are separated by tab characters). Amazon's developer documentation marks the first two as deprecated, and its developer changelog says they will be removed for sellers on November 11, 2026. The Flat File V2 replaces them, and it is the one this post covers.

Where to download it in Seller Central

An Amazon staff post on the Seller Forums gives these steps:

  1. Go to the All Statements page of the Payments report in Seller Central.
  2. Use the Select Date Range filter to narrow the list to the period you want.
  3. In the Actions column, click Download Flat File V2 for the settlement you want.
  4. Save the file and open it in a spreadsheet program.

The same post says Fulfillment by Amazon (FBA) sellers can use the file with Amazon's Settlement Summary Template to build a pivot table, a spreadsheet summary that totals rows by the labels you choose, for "a simplified display of details by order."

For a quick look without a download, Amazon's payments guide points to the Statement View page of the Payments Dashboard: in Seller Central, hover over Payments in the main menu, then select Payments. Scroll to the bottom for your next disbursement date (a disbursement is a payout), or select the Disbursements tab to review past payouts.

The 24 columns, in four groups

Amazon's documentation lists 24 columns for the Flat File V2. The names are Amazon's; the grouping is ours.

Flat File V2 settlement report columns (Amazon Selling Partner API docs, read October 4, 2026)
GroupColumnsWhat they tell you
The settlementsettlement-id, settlement-start-date, settlement-end-date, deposit-date, total-amount, currencywhich settlement this is, the period it covers, its deposit date, its total and its currency
The moneytransaction-type, amount-type, amount-description, amountwhat kind of transaction a row belongs to, what the money is for, and how much
What it belongs toorder-id, merchant-order-id, order-item-code, merchant-order-item-id, adjustment-id, merchant-adjustment-item-id, shipment-id, fulfillment-id, promotion-id, marketplace-namethe order, item, adjustment, shipment, fulfillment or promotion a row is tied to, and the Amazon store
Product and datesku, quantity-purchased, posted-date, posted-date-timeyour SKU, the quantity, and when Amazon posted the row

The right-hand column is a plain-English reading of Amazon's column names, which Amazon lists in a different order.

Amazon's changelog says the V2 gives posted dates in "two, easily-readable formats": posted-date (MM/DD/YY) and posted-date-time. Check a row that has an order-id against that order, and a row without one against the settlement period as a whole.

Transaction type, amount type and amount description

For the Flat File V2, Amazon condensed the old price columns into three general-purpose ones. With transaction-type, they tell you what every amount is:

  • transaction-type: the kind of transaction the row belongs to.
  • amount-type and amount-description: what the money is for. Amazon says they contain "the type of charge or fee you have incurred," and its changelog says they label the amount in the same row.
  • amount: the money itself. Amazon says amount values "always populate in a single amount column," even if new fees or transaction types are introduced in the future.

Amazon's documentation lists the columns but not the values that fill them, and it allows for new fees and transaction types in the future. So learn the labels from your own file, not from a fixed list.

Total it in a pivot table

  1. Open the Flat File V2 in your spreadsheet and insert a pivot table over all the rows.
  2. Put transaction-type in the rows, then amount-type under it, then amount-description under that.
  3. Put the sum of amount in the values.
  4. Read down the totals. Each label now has one figure, so the period's sales, fees, refunds and other charges sit side by side.
  5. Set the grand total beside total-amount and beside the payout on the Disbursements tab. If they differ, find out why before you rely on the file.

Sales and refunds, by Amazon's fee schedule

Amazon's fee schedule gives this example for a Professional seller: item price, plus shipping and gift wrap charges paid by the buyer, minus the referral fee, equals the total deposited to the seller account. Its example for books, music, video and DVD products subtracts a $1.80 closing fee as well. In the V2, each of those pieces is its own amount, so one order can take several rows.

Refunds don't simply cancel the sale. If you refund a buyer for an order you have already been paid for, Amazon refunds the referral fee you paid minus a refund administration fee: the lesser of $5.00 or 20% of the referral fee. In Amazon's example, refunding the $10.00 total sales price of an item with a 15% referral fee means a $1.50 referral fee and a $0.30 administration fee, so $1.20 of the referral fee comes back.

Why the total isn't your sales, or your profit

Amazon's payments guide says it takes your beginning balance, adds your sales, subtracts expenses and adjusts for refunds, then pays you "after withholding an amount in reserve." That reserve is a portion of your balance Amazon holds for a period of time to cover things like refunds or chargebacks, and it becomes the beginning balance of your next settlement period.

An example with round numbers, not a real account
StepAmount
Beginning balance$200
Add sales+$1,000
Subtract expenses, such as Amazon's fees−$400
Adjust for refunds−$100
Withhold the reserve−$150
Transferred to your bank$550

In this example, $1,000 of sales becomes a $550 deposit, and the $150 held back starts the next period.

Timing moves money too. Amazon defines a deferred transaction as one "that will be paid out to you at a future date," and says that with deliveries it typically reserves funds for seven days, so customers have time to inspect their purchases and get refunds if needed. So money from a recent sale can land in a later payout.

And the total isn't profit. None of the 24 columns holds what you paid for the product. Profit needs your own costs beside Amazon's numbers.

Common mistakes when reading a settlement report

  • Reading the deposit as sales. It starts from your beginning balance and comes after expenses, refunds and the reserve.
  • Reading the total as profit. Your product cost isn't in the file.
  • Matching it to a calendar month. A settlement runs from its settlement-start-date to its settlement-end-date, and deferred money can land in a later one.
  • Hunting for a fee in its own column. In the V2, every amount is in the amount column, and its labels say what it is.
  • Trusting a fixed list of labels. Amazon keeps every amount in the one amount column even when it introduces new fees or transaction types, so a new one turns up under a label you haven't seen. Check each file for them.
  • Building on the old formats. The XML and older flat file settlement reports will be removed for sellers on November 11, 2026.
  • Expecting the money the day the settlement closes. Amazon says a payment can take up to five business days to reach your bank after Amazon starts it. If it has been longer, your bank can use the trace ID from the Disbursements section of your Payments Dashboard to research it.

Where Remworth fits

Remworth builds your books from Amazon's own transaction records and the costs you record, then checks every settlement statement against them, order by order and category by category: revenue, order fees, promotions, refunds, reimbursements and ad spend, each with its own difference. Statements whose lines don't add up to their own total, orders on a deposit that aren't in your books, and line types it has never seen before are flagged. About the last 90 days of statements arrive on their own; older Flat File V2 files can be imported. See settlement reconciliation.

Questions

Settlement report questions

How often does Amazon send a settlement report?

You can't request one: Amazon schedules settlement reports itself. Its payments guide says it generally settles seller accounts every two weeks. Each report covers the period from its settlement-start-date to its settlement-end-date.

Where do I download my Amazon settlement report?

An Amazon staff post on the Seller Forums gives the steps: in Seller Central, go to the All Statements page of the Payments report, use the Select Date Range filter, then click Download Flat File V2 in the Actions column for the settlement you want. Open the file in a spreadsheet program.

Why doesn't my Amazon deposit match my sales?

Because a payout is net. Amazon starts from your beginning balance, adds sales, subtracts expenses, adjusts for refunds and withholds a reserve before it pays you. Some money is also deferred and paid at a later date. Total the amount column by amount-type and amount-description to see what made up the period.

What do amount-type and amount-description mean?

They say what each amount is. Amazon's developer documentation says the two columns contain "the type of charge or fee you have incurred" and show whether different fees are related to a common type. The money itself is always in the single amount column. Amazon's page doesn't list the values, so read them from your own file.

Are the XML and old flat file settlement reports going away?

Yes. Amazon's developer changelog says both will be removed for sellers on November 11, 2026. The Flat File V2 replaces them, and Amazon says it offers the same information in fewer columns.

My Amazon payout hasn't arrived. Where do I look?

Amazon says a payment can take up to five business days to reach your bank after Amazon starts it. If it has been longer, find the trace ID in the Disbursements section of your Payments Dashboard; your bank can use it to research where the money is. Amazon's guide lists common causes of delays, including missing or invalid bank account details, card problems, a negative or zero balance, and account health or performance issues.

Check your next deposit against your books.

Start the 7-day trial and connect your Amazon account. Payouts sync within a day and recent statements over the first few days. Then open the Reconciliation tab and read your last deposit.

Solo $199.99/mo · Pro $349.99/mo · 7 days free, card required

On your phone? Start with just your email. The link we email you works once, on any device, within 7 days, and the app opens once you've picked a plan, added your card and connected your Amazon seller account.

Your Amazon password stays with Amazon. How Remworth connects.

Sources

  1. Amazon Selling Partner API docs: Settlement reports settlement reports cannot be requested or scheduled and are scheduled automatically by Amazon; the three report types, two marked deprecated; the Flat File V2 is tab-delimited, condenses price columns into amount-type, amount-description and amount, its two label columns contain the type of charge or fee, every amount sits in one column even for new fees or transaction types, and it lists 24 columns, none for product cost; read October 4, 2026
  2. Amazon developer changelog: Deprecation of two payment settlement report types the Flat File V2 replaces the XML and flat file settlement reports; amount-type and amount-description in the same row as the amount; posted dates in two formats, posted-date as MM/DD/YY; read October 4, 2026
  3. Amazon developer changelog: Removal of XML Settlement Report and Flat File Settlement Report date changed to November 11, 2026 both older settlement reports are removed for sellers on November 11, 2026; the V2 offers the same information in fewer columns; read October 4, 2026
  4. Amazon: How Amazon seller payments work (July 30, 2025) settlements in general every two weeks; how a payout is worked out; the account-level reserve and the next beginning balance; deferred transactions and the seven-day hold with deliveries; reaching the Statement View page, the next disbursement date and the Disbursements tab; up to five business days; the trace ID; common causes of delays; read October 4, 2026
  5. Amazon staff post (Connor_Amazon), Seller Forums: How to download payment reports payments reports as a breakdown of transactions in a settlement period; the All Statements download steps; Download Flat File V2; the Settlement Summary Template for a pivot table; read October 4, 2026
  6. Seller Central Help: Selling on Amazon fee schedule the Professional and media sale examples, the $1.80 closing fee, the refund administration fee and Amazon's $10.00 example; read October 4, 2026