1. Export the file from Amazon Seller Central
- In Seller Central open Reports, then Payments, then All Statements.
- Find the settlement period you want and click "Download Flat File V2" next to it. It is a tab-separated .txt file.
- Upload that file here as downloaded, without opening and re-saving it in a spreadsheet.
Why a raw Amazon settlement report export fails in Excel, Google Sheets or LibreOffice
Opened in Excel, the settlement file is hundreds of lines with the money described by three code columns (transaction-type, amount-type, amount-description), and euro files use a decimal comma. There is nothing to sum by kind without a pivot table.
Excel and Google Sheets open a CSV directly, but only if it is a simple table. A bank statement file has to be turned into one first.
What is unusual about the Amazon settlement report file
- Tab-separated text, not CSV. The second line is a summary with the settlement id, dates, total-amount (the deposit) and currency; every other line is one amount, described by transaction-type, amount-type and amount-description.
- Dates are written 2024-10-25 14:28:39 UTC in US files and 25.10.2024 14:28:39 UTC in UK and European files. Euro files use a decimal comma (95,00).
- Every row is added up and compared with total-amount. If they differ, you get a warning with the difference; it is never hidden.
- Each settlement becomes its named lines (product sales, shipping, refunds, promotions, selling fees, FBA fees, advertising, sales tax or VAT, reserve) plus the deposit, all dated on the deposit date.
- Marketplace facilitator tax shows as tax charged to buyers on one line and the same amount kept by Amazon on another, so it nets to zero. Reserve amounts go to a clearing account, not income.
- Amounts of a kind the converter does not know are kept on their own line, named after Amazon's description, and listed in a warning. One settlement and one currency per output; a file with several settlements gets a menu.
- The Date Range "Transaction" CSV report and the older Flat File (V1) settlement report are different files and are refused by name: download Flat File V2 instead.
- Bank-style files (.qbo, .qfx, .ofx, QuickBooks Online CSV, Xero CSV) go into a separate Amazon clearing account, not your checking account: the last line moves the deposit to your bank.
What Excel, Google Sheets or LibreOffice requires
- One row per transaction: Date, Value date, Amount, Currency, Debit/Credit, Counterparty, Counterparty account, Description, Reference, Balance.
- Comma style: commas between columns and 1234.56 amounts. Semicolon style: semicolons and 1234,56 amounts.
- Dates are written as YYYY-MM-DD unless you choose another format.
- Text that starts with = + - or @ gets an apostrophe in front so a spreadsheet does not run it as a formula.
2. Before and after
Before: the Amazon settlement report (Flat File V2) as downloaded
settlement-id settlement-start-date settlement-end-date deposit-date total-amount currency transaction-type order-id merchant-order-id adjustment-i... 90000000001 2025-10-01 08:00:00 UTC 2025-10-15 08:00:00 UTC 2025-10-17 08:00:00 UTC 35.58 USD 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemPrice Principal 39.98 AFN 2025-10-03 2025-10-03 14:02:11 UTC 70000000000001 ... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemPrice Tax 3.30 AFN 2025-10-03 2025-10-03 14:02:11 UTC 70000000000001 SKU-M... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemPrice Shipping 5.00 AFN 2025-10-03 2025-10-03 14:02:11 UTC 70000000000001 ... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemWithheldTax MarketplaceFacilitatorTax-Principal -3.30 AFN 2025-10-03 2025-10... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemFees Commission -6.00 AFN 2025-10-03 2025-10-03 14:02:11 UTC 70000000000001 ... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemFees FBAPerUnitFulfillmentFee -7.50 AFN 2025-10-03 2025-10-03 14:02:11 UTC 7... 90000000001 Order 111-0000001-0000001 DSynth0001 Amazon.com ItemFees ShippingChargeback -5.00 AFN 2025-10-03 2025-10-03 14:02:11 UTC 7000000...
After: what Excel, Google Sheets or LibreOffice receives
| Date | Value date | Amount | Currency | Debit/Credit | Counterparty | Counterparty account | Description | Reference | Balance |
|---|---|---|---|---|---|---|---|---|---|
| 2025-10-17 | 64.98 | USD | Credit | Amazon settlement 90000000001: Product sales | 90000000001:1 | ||||
| 2025-10-17 | 4.12 | USD | Credit | Amazon settlement 90000000001: Sales tax or VAT charged to buyers | 90000000001:2 | ||||
| 2025-10-17 | 9.99 | USD | Credit | Amazon settlement 90000000001: Shipping charged to buyers | 90000000001:3 | ||||
| 2025-10-17 | -4.12 | USD | Debit | Amazon settlement 90000000001: Sales tax or VAT kept by Amazon (marketplace facilitator) | 90000000001:4 | ||||
| 2025-10-17 | -8.10 | USD | Debit | Amazon settlement 90000000001: Amazon selling fees (referral, refund admin, holdback) | 90000000001:5 | ||||
| 2025-10-17 | -7.50 | USD | Debit | Amazon settlement 90000000001: FBA fulfillment fees | 90000000001:6 |
Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.
3. Import the converted file into Excel, Google Sheets or LibreOffice
- Open the downloaded file in Excel, Google Sheets or LibreOffice.
- If every value lands in one column, use the semicolon style (for European Excel) or import it with Data > From Text/CSV.
Questions
- Does the journal entry match my Amazon deposit?
- Yes, when the file is complete. The converter adds every line and compares the result with the settlement's total-amount. The bank line is always Amazon's total. If the lines add up to something else, a warning names the difference and the gap goes to the clearing account, so you can see it.
- Why does everything land in one column in Excel?
- Excel uses the list separator of your computer's region. In much of Europe that is a semicolon and the decimal mark is a comma. Choose the semicolon style and download again, or open the file through Data > From Text/CSV and pick the separator there.
- How are marketplace facilitator tax and reserves booked?
- Where Amazon collects and pays sales tax or VAT itself, the report adds the tax to the sale and takes it back on a marketplace facilitator line, so the two lines net to zero. Tax Amazon did not keep is named in a warning, because you may owe it, and in the journal it goes to a "Sales Tax / VAT Payable" account, not to income. Reserve held back or released is your own money, so it goes to the clearing account, never to income or expense.
- Are accents and umlauts kept?
- Yes. The file is UTF-8 and starts with the marker Excel looks for, so names such as Müller or Société open correctly.
Other ways to convert Amazon settlement report
- Amazon settlement report to QuickBooks
- Amazon settlement report to Xero
- Amazon settlement report to a QuickBooks Online bank CSV