Kayabyte

How to import an Amazon settlement report into QuickBooks Online (or Xero)

By Kayabyte · Last updated 29 October 2026

To import an Amazon settlement report into QuickBooks Online, download the Flat File V2 from Seller Central (Payments, then All Statements), group its rows by category (sales, shipping, fees, refunds), and import the result as one journal entry per settlement through a clearing account, because QuickBooks does not read the raw report. Keep the bank deposit out of income so sales are not counted twice. You can build that journal by hand in a spreadsheet, or let Balanced, a Mac app, categorise the file and export a QuickBooks Online journal entries CSV or a Xero manual journal. Menu names change, so treat them as a guide.

1. Download the settlement report

  1. In Seller Central open Payments, then All Statements (the Reports Repository has the same reports).
  2. Pick the settlement period and request the report if there is a request button.
  3. Download the Flat File V2. It is a tab-delimited text file, one row per amount, with columns for the order, the amount type, the amount description and the amount.

Amazon keeps these reports for a limited time, so download them each period. Check how long in your account.

2. Read it in a spreadsheet

Open the file in Excel (choose tab as the delimiter). The amount type and amount description tell you what each row is: principal (the item price), shipping, tax, a commission or referral fee, FBA fees, promotion discounts, refunds. Add a Category column, sum with a pivot table, and check that the sum of all rows equals the total deposit shown on the first row of the file.

3. Journal entries

Accounting software wants a few summary lines, not thousands of rows. Make one journal per settlement: credit sales and shipping, debit fees by type, and the deposit to the bank with a clearing account balancing. Xero and QuickBooks Online both import journals from CSV, with their own column headings.

4. Where Balanced helps

Balanced reads the Flat File V2 on your Mac, gives each row a category by rules and checks that the lines add up to the settlement total. Export a categorised CSV, Excel with a summary sheet, a Xero manual journal or QuickBooks Online journal entries CSV (the platform balance goes through a clearing account you name), or Beancount or Ledger. Change a category once and it is remembered for that amount description.

Honest limits: report layouts change, so check the preview and the category totals; Balanced does not log in to your account or fetch anything, you download the file yourself; the Schedule C worksheet is a suggested grouping, not tax advice, so check it with your tax professional or accountant. Some settlement reports use older formats; if your file does not open correctly, tell us the version in the file name.

Download Balanced and try it free: the free version reads and checks everything and exports the first 10 lines per file, so you can test your own report before paying. Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. See pricing and the help page. macOS 14 or later.