Settlement Reports

Settlement reports provide a detailed breakdown of your account activity for a given settlement period. For Checkout by Amazon, settlement reports are generated daily and made available from Seller Central. Settlement reports contain item prices, promotion amounts, fees, adjustments, refunds, reserves and claims. You can understand your account activity by reviewing your settlement reports.

Generally, Amazon Payments first settles your account 14 days after you register with Seller Central. Subsequently, the settlement process repeats daily. If you modify your bank account information, your settlements are suspended for 3 days; on the 4th day regular settlements will resume.

Please make sure you have provided us with a valid UK bank account. For more information, please see Bank Account Information.

When settlement completes, we post a settlement report under the Reports section in Seller Central, and initiate a funds transfer to your bank account. It usually takes 1-2 business days for the funds to arrive in your account.

There are three versions of settlement reports available:

By default, your account is set up to generate Flat File Settlement Reports. Contact the Seller Support team to request to enable Flat File V2 or XML Settlement Reports.

1. In Seller Central, on the Reports tab, click Payments, and then click the All Statements link.
   The All Statements page appears, showing the last ten settlement reports.
2. Click the report you want to download.
   Your web browser might prompt you to either open or save the report file.
3. If prompted, save the file to your computer. If the file opens automatically in another application, save the file to your computer using the File > Save As command.

Flat-File Settlement Reports are tab-delimited text files. These can be difficult to read in a text editor, such as Notepad or Text Edit, but you can easily open them in most spreadsheet applications (such as Microsoft Excel) or database software.

The easiest way to read a Flat-File Settlement Report is to save it to your computer and then open the document in your favorite spreadsheet or database application. With a spreadsheet program you can easily summarize, manipulate, or reformat the data the way you want.

If you download the Settlement Report in the XML format, you or your developers can create scripts or programs to parse the information available in the report and store it in your database.

The following table compares the information provided in each version of the settlement report available to you.

The following table provides Type, Description and Explanation of various amounts and fees.

1. Download a copy of your settlement report as described above.
2. Open Microsoft Excel; then, Excel, click File > Open.
3. Locate and open your settlement report.
   Because your settlement report is in tab-delimited text format, you might need to look for all file types and not just Microsoft Excel worksheets.
4. When you find the file, select it, and click Open, Microsoft Excel should start the Text Import Wizard.
   This tool allows you to specify how Microsoft Excel formats the file data.
5. In the Original Data Type section, select Delimited, and then click Next.
6. In the Delimiters section, make sure that Tab is the only box selected, and then click Next.
   Now Microsoft Excel will begin a new column whenever it comes across a tab character in the report file.
7. In the Data Preview section, use the scroll bars to locate the order-item-id column and then click the General heading.
8. In the Column Data Format section, select the Text option.
   This prevents Microsoft Excel from converting the settlement-id values to an exponential format. That is, this prevents Microsoft Excel from converting 66522216496654 to 6.65222E+13.
9. Apply the same format to the order-item-id and SKU columns.
10. Click Finish.
    The report opens in Microsoft Excel.
11. Apply the same format to any other columns that show numbers formatted exponentially.
12. Click Finish.
    The report opens in the Microsoft Excel window.

1. Select the data on the spreadsheet.
2. In MS Excel, click Data > Subtotal.
3. Select the column that you want to aggregate by (example, Orders or Refunds), and then put this column in "At each change in" field.
4. Use the function "Sum".
5. Add subtotal to price-amount (column Y), item-related-fee-amount (column AA), misc-fee-amount (column AB), promotion-amount (column AG), other-amount (column AJ).

1. Select the data on the spreadsheet.
2. In MS Excel, click Data > Subtotal.
3. Select the column that you want to aggregate by (example, shipment_id or order_id), put this column in "At each change in" field.
4. Use the function "Sum".
5. Add subtotal to In Flat File V1: price-amount (column Y), item-related-fee-amount (column AA), promotion-amount (column AG), other-amount (column AJ). In Flat File V2: amount field (column O).

1. Select an empty cell at the end of the transaction list.
2. Enter a SUM formula in the selected cell then press Enter to total the row or column. For example, if the last transaction is on Row 9 and then enter: =SUM(Y2:Y9, AA2:AA9, AG2:AG9, AJ2:AJ9)