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

Download payment reports

Payments 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 the date and the amount of pay you can expect on your 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.

A settlement report can include the Federal Automated Clearing House Trace ID assigned to your fund transfer. If it has been more than five business days since Amazon initiated the transfer, your bank can use the Trace ID to research the status of your deposit.

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: Fulfillment 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 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.

USD

transaction-type Text description of transaction type Order
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 This is the ID that Amazon or sellers assign.

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.com

shipment-fee-type The type of shipping Fee as "Order," "Adjustment," or "MiscEvent." Order
shipment-fee-amount The amount of the shipping fee

1.99

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

fulfillment-id Fulfillment 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
shipping-price-credit The amount that the buyer paid for shipping. 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
shipping-tax-credit The amount, if any, that the buyer paid for tax on shipping. 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 total amount of fees for this order, usually with a 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 and 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. Shipping
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
shipping-promotion-discount The amount of promotional discount applied to shipping. 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

Fulfillment 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 (for example, item-related-fee-type)
  • price/fee type value (fo example, Commission)
  • price/fee amount (for example, 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.
FBAPerUnitFulfillmentFee Per-unit fee charged to compensate Amazon for the cost of fulfilling.
FBAWeightBasedFee This is the fee that we assess for FBA sellers on a per-item basis to compensate Amazon for the cost of shipping 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 charged against the original fee amount being refunded.
ShippingChargeback Shipping charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as revenue (see Shipping) and charge you a ShippingChargeback fee equal to the amounts that you charged 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 that you charged the customer.
Goodwill Customer refund, not applied against a specific charge.
Principal Amount that you charged (or refunded) to the customer for an item.
RestockingFee We might charge customers a RestockingFee for returns that are not eligible for a full refund. We report this adjustment to the customer's refund as a seller credit.
Shipping Shipping charges for Amazon Fulfilled units are part of your gross sales proceeds. We report them to you as Shipping revenue and charge you a fee (see ShippingChargeback) 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.
Shipping Shipping promotion applied to qualifying orders.
Promotion FBAPerOrderFulfillmentFee Per-order fee charged to compensate Amazon for the cost of fulfilling per order.
ShipmentFees FBATransportationFee This is the fee that Amazon assesses for FBA Multi-Channel Fulfillment to cover the costs of shipping per order.
Sign in to use the tool and get personalized help (desktop browser required). Sign in


Was this article helpful?
Thank you for your feedback
What can we improve? (Optional)
1000
What was helpful?
1000
Thanks 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