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:
- Go to the All Statements page of the Payments report in Seller Central.
- Use the Select Date Range filter to narrow the results to the time period of your choice, if desired.
- 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.
- 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 |
|---|---|
|
|
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 Shipping Chargeback) 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. |