BooksReady

Amazon settlement report to a QuickBooks Online bank CSV

In short: Amazon's settlement report (Flat File V2) is a tab-separated text file: a summary line with the settlement dates, the deposit total and the currency, then one line per amount (each sale, fee, tax, promotion, refund and reserve). QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Before you start: Upload this into a separate "Amazon" clearing account in QuickBooks, not your checking account: the deposit line moves the money out to your bank. We have not imported the result into a real QuickBooks company.

Convert your file

Amazon settlement report to QuickBooks Online (CSV)

<settlement-id>.txt (tab-separated)

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from Amazon Seller Central

  1. In Seller Central open Reports, then Payments, then All Statements.
  2. Find the settlement period you want and click "Download Flat File V2" next to it. It is a tab-separated .txt file.
  3. Upload that file here as downloaded, without opening and re-saving it in a spreadsheet.

Why a raw Amazon settlement report export fails in QuickBooks Online

QuickBooks Online cannot read the tab-separated settlement file, and its amounts are split across three description columns. Importing it into your checking account would not match the one deposit your bank received.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

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 QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

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 QuickBooks Online receives

After: amazon-settlement-2025-10-17-to-2025-10-17-quickbooks-3col.csv
DateDescriptionAmount
10/17/2025Amazon settlement 90000000001: Product sales64.98
10/17/2025Amazon settlement 90000000001: Sales tax or VAT charged to buyers4.12
10/17/2025Amazon settlement 90000000001: Shipping charged to buyers9.99
10/17/2025Amazon settlement 90000000001: Sales tax or VAT kept by Amazon (marketplace facilitator)-4.12
10/17/2025Amazon settlement 90000000001: Amazon selling fees (referral, refund admin, holdback)-8.10
10/17/2025Amazon settlement 90000000001: FBA fulfillment fees-7.50

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 QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

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.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
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.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Amazon settlement report

Other exports to QuickBooks Online (CSV)

Common import problems