Sell on Amazon Sign in
This article applies to selling in: United Kingdom

Download payment reports

Payment reports help you understand your account activity by providing a detailed breakdown of transactions during a given settlement period.

The top of the Payments Report Statement View shows you when and how much you will be paid on your next settlement date. We update this information automatically.

For your seller account to be settled, it must have had activity during the settlement period and either a positive or zero account balance. Referral fees and refunds can affect your balance. When your account is settled, a report for the settlement period is posted on the All Statements page, and you can download this information.

Download a report

To download a statement report:

  1. Go to the All Statements page of the Payments report in Seller Central.
  2. Use the Select Date Range filter to narrow the results to the time period of your choice, if desired.
  3. Click one of the Download buttons in the Actions column for the settlement period you're interested in.
    • Download XML: An XML file that you can open in a program such as Microsoft Excel
    • Download Flat File: A tab-delimited text file
    • Download Flat File V2: Fulfilment by Amazon sellers can use this file with the Settlement Summary Template to build a pivot table that provides a simplified display of details by order. Learn more about the Settlement Summary Report.
  4. Save the file to your local computer, and open it using a spreadsheet or database program.

To learn how to pull reports for custom date ranges, see Date Range Reports.

Read your report

Your Payments report contains a separate line for every product in an order, as well as every product in an order that you refund, whether in whole or in part. The report also contains other events, such as subscription fees or account adjustments.

The fields that you see in your report will depend on your selling plan and the Release Package of your inventory file templates. You might not see all of the fields listed in the table below.

Field Name Description Example
settlement-id Amazon's unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number of digits is 20. 236628501
settlement-start-date The start date of the settlement period. This is an alphanumeric value. Total number of characters is 25. (Greenwich Mean Time) 2003-10-03T16:00:00-07:00
settlement-end-date The end date of the settlement period. This is an alphanumeric value. Total number of characters is 25. (Greenwich Mean Time) 2003-10-10T16:00:00-07:00
deposit-date The date that the fund transfer for the settlement period will be sent to the seller's bank account. This is an alphanumeric value. Total number of characters is 25. (Greenwich Mean Time) 2003-10-15T16:00:00-07:00
total-amount The sales amount to be deposited into the seller's bank account. 1113.54
currency The currency for the transaction. All order, adjustment, fee and event data will have the same currency.

GBP

transaction-type Text description of transaction type. Order No.
order-id Amazon's unique, displayable identifier for an order. This is an alphanumeric value. Go to Manage Orders to search for an order ID that includes letters, as they are not searchable in all tools. 058-7987646-0553626
order-item-id Amazon's unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14. 63043395314814
merchant-order-id ID assigned by Amazon or sellers

adjustment-id Transaction ID for Adjustments

shipment-id Order transaction type ID

marketplace-name The name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters.

Amazon.co.uk

shipment-fee-type The type of Delivery Fee as "Order", "Adjustment" or "MiscEvent". Order No.
shipment-fee-amount The amount of the delivery fee
order-fee-type The type of fee charged in the order-fee-amount column. Commission
order-fee-amount The amount of a particular fee charged for this order. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.

0.34

fulfilment-id Fulfilment type such as Merchant (MFN) or Amazon

MFN

posted-date The date that the item (order, adjustment, misc or other) was debited or credited to the seller's account. This is an alphanumeric value. Total number of characters is 25. 2003-10-03T21:11:10-07:00
order-item-code Amazon's unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14. 63043395314814
merchant-order-item-id

merchant-adjustment-item-id

SKU A seller-defined unique identifier for a product. This is an alphanumeric value. The minimum number of characters is 1 and the maximum number of characters is 40. 1012
quantity-purchased The number of these items that were purchased. This is a numeric value. The maximum number of digits is 12. 1
price-type The type of price specified in the price-amount column. GiftWrapTax
price-amount The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 5.36
item-price-credit The amount that the buyer paid for the item. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 39.99
item-tax-credit The amount, if any, that the buyer paid for tax on the item. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 2.40
delivery-price-credit The amount that the buyer paid for delivery. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 28.99
delivery-tax-credit The amount, if any, that the buyer paid for tax on delivery. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 1.74
gift-wrap-price-credit The amount that the buyer paid for gift wrap. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.

gift-wrap-tax-credit The amount that the buyer paid for tax on gift wrap. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.

item-related-fee-type The type of fee charged in the item-related-fee-amount column. Commission
item-related-fee-amount The amount of a particular fee charged in relation to this item. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 5.68
order-related-fees The amount of fees charged for this order, usually commission. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. -8.62
other-fees The amount of miscellaneous charges/credits to the account. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.

misc-fee-amount No longer used

other-fee-amount The amount of miscellaneous fees charged to your seller account.

other-fee-reason-description Miscellaneous fees that are not related to the monthly selling plan.

promotion-id Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. 90103summer
promotion-type The type of promotion referred to by the values in the promotion-id and promotion-amount columns. Delivery
promotion-amount The amount of promotional discount applied to the item due to the promotion specified in the promotion-id column. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. 5.16
item-promotion-discount The amount of promotional discount applied to the item's principal. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. -6.50
item-promotion-id Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. 90103summer
delivery-promotion-discount The amount of promotional discount applied to delivery. This is a numeric value with a maximum of 18 digits to the left of the decimal point and 2 digits to the right of the decimal point. -4.25
shipping-promotion-id Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. 100103freeship50
direct-payment-type

direct-payment-amount

other-amount Additional charges or credits that do not fall under the Order or Adjustment transaction types. The transaction type for this amount will be specified in the transaction-type column. 5.99

Fields in the Settlement Report V2 flat file

Fulfilment by Amazon sellers can use this file. The individual price and fee columns have been condensed into type, description and amount columns. The following fields replace the corresponding fields in the Settlement Report flat file:

Settlement Report Flat File Settlement Report Flat File V2
  • price/fee type name (e.g. item-related-fee-type)
  • price/fee type value (e.g. Commission)
  • price/fee amount (e.g. item-related-fee-amount)
  • amount-type
  • amount-description
  • amount

The following table defines the amount-type and corresponding amount-descriptions.

amount-type amount-description Definition
ItemFees Commission Fee charged against the value of the item sold.
FBAPerUnitFulfilmentFee Per-unit fee charged to compensate Amazon for the cost of fulfilling.
FBAWeightBasedFee Fee assessed for FBA sellers on a per-item basis to compensate Amazon for the cost of delivery per order.
GiftwrapChargeback Giftwrap charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as revenue (see Giftwrap) and charge you a GiftwrapChargeback fee equal to the amounts charged to the customer.
RefundCommission When a refund is issued, the fee is charged against the original fee amount being refunded.
DeliveryChargeback Delivery charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as revenue (see Delivery) and charge you a DeliveryChargeback fee equal to the amounts charged to the customer.
VariableClosingFee Variable closing fee charge for the sale of an item. Refer to the Selling on Amazon Fee Schedule for more details.
ItemPrice GiftWrap Giftwrap charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as Giftwrap revenue and charge you a fee (see GiftwrapChargeback) equal to the amounts charged to the customer.
Goodwill Customer refund, not applied against a specific charge.
Principal Amount charged (or refunded) to customer for item.
RestockingFee Customers may be charged a RestockingFee for returns that are not eligible for a full refund. This adjustment to the customer's refund is reported as a seller credit.
Delivery Delivery charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as Delivery revenue and charge you a fee (see DeliveryChargeback) equal to the amounts charged to the customer.
Current Reserve Amount The reserve amount is the amount held back in a settlement period to cover potential expenses such as returns and refunds.
other-transaction Previous Reserve Amount Balance The Reserve Amount from the previous Settlement Report.
Refund Reimbursal Reimbursal of amount charged to seller for customer refund.
Storage Fee Storage fee for seller's items stored in Amazon's warehouse.
Delivery Delivery promotion applied to qualifying orders.
Promotion FBAPerOrderFulfilmentFee Per-order fee charged to compensate Amazon for the cost of fulfilling per order.
DispatchFees FBATransportationFee Fee charged for FBA Multi-Channel Fulfilment to compensate Amazon for the cost of delivery per order.
Sign in to use the tool and get personalised help (desktop browser required). Sign in


Was this article helpful?
Thank you for your feedback
How can we improve this help page? Note: This form doesn’t create a support case. Please specify what you think is wrong with the content itself.
1000
What was helpful?
1000
Thank you again for your help!
Thank you for your feedback. If you have more questions, please Contact Us.

Reach Hundreds of Millions of Customers

Start Selling on Amazon


© 1999-2019, Amazon.com, Inc. or its affiliates