Settlement Reports
Settlement Reports for the Selling Partner Reports API.
Important
Settlement reports (also known as Payment reports) cannot be requested or scheduled. They are automatically scheduled by Amazon (usually every 14 days) and are tied to the disbursement cycle of a seller account.
You can search for available settlement reports using the getReports
operation. You can also subscribe to REPORT_PROCESSING_FINISHED
to get a notification whenever a new report is available.
A report is available for 90 days after creation. After this time, you must manually regenerate the report in Seller Central.
Note
Disbursements can be manually initiated in Seller Central. This automatically schedules a report and restarts the disbursement cycle.
Attributes for each report type are listed in the order that they are returned.
Flat File Settlement Report
reportType value: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
Roles: Inventory and Order Tracking, Finance and Accounting, Amazon Fulfillment
Availability: Sellers
Report output type: Tab-delimited flat file
A settlement report. For attribute information, refer to Seller Central.
Select to expand list of report attributes.
settlement-id
settlement-start-date
settlement-end-date
deposit-date
total-amount
currency
transaction-type
order-id
order-item-id
merchant-order-id
adjustment-id
shipment-id
marketplace-name
shipment-fee-type
shipment-fee-amount
order-fee-type
order-fee-amount
fulfillment-id
posted-date
order-item-code
merchant-order-item-id
merchant-adjustment-item-id
sku
quantity-purchased
price-type
price-amount
item-price-credit
item-tax-credit
shipping-price-credit
shipping-tax-credit
gift-wrap-price-credit
gift-wrap-tax-credit
item-related-fee-type
item-related-fee-amount
orders-related-fees
other-fees
other-fee-amount
other-fee-reason-description
promotion-id
promotion-type
promotion-amount
item-promotion-discount
item-promotion-id
shipping-promotion-discount
shipping-promotion-id
direct-payment-type
direct-payment-amount
other-amount
XML Settlement Report
reportType value: GET_V2_SETTLEMENT_REPORT_DATA_XML
Role: Finance and Accounting
Availability: Seller Central sellers
Report output type: XML
A settlement report. For attribute information, refer to Seller Central.
Select to expand list of report attributes.
SettlementData
AmazonSettlementID
TotalAmount
StartDate
EndDate
DepositDate
Order
AmazonOrderID
MerchantOrderID
ShipmentID
ShipmentFees
MarketplaceName
OrderFee
Fulfillment
MerchantFulfillmentID
PostedDate
DirectPayment
Item
AmazonOrderItemCode
MerchantOrderItemID
SKU
Quantity
ItemPrice
ItemFees
Promotion
MerchantPromotionID
Type
Amount
Adjustment
AmazonOrderID
MerchantOrderID
AdjustmentID
MarketplaceName
OrderFeeAdjustment
Fulfillment
MerchantFulfillmentID
PostedDate
DirectPayment
AdjustedItem
AmazonOrderItemCode
MerchantOrderItemID
MerchantAdjustmentItemID
SKU
ItemPriceAdjustments
ItemFeeAdjustments
PromotionAdjustment
MerchantPromotionID
Type
Amount
OtherFee
AmazonOrderID
MerchantOrderID
MarketplaceName
MerchantFulfillmentID
PostedDate
Amount
ReasonDescription
OtherTransaction
AmazonOrderID
MerchantOrderID
MarketplaceName
MerchantFulfillmentID
TransactionType
TransactionID
PostedDate
Amount
ReasonDescription
Fees
MiscEvent
PostedDate
Amount
Flat File V2 Settlement Report
This report type is only available to Seller Central sellers.
reportType value: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2
Role: Finance and Accounting
Availability: Seller Central sellers
Report output type: Tab-delimited flat file
An alternate version of the Flat File Settlement Report. Price columns are condensed into three general purpose columns: amounttype
, amountdescription
, and amount
.
For attribute information, refer to Seller Central.
Select to expand list of report attributes.
settlement-id
settlement-start-date
settlement-end-date
deposit-date
total-amount
currency
transaction-type
order-id
merchant-order-id
adjustment-id
shipment-id
marketplace-name
amount-type
amount-description
amount
fulfillment-id
posted-date
posted-date-time
order-item-code
merchant-order-item-id
merchant-adjustment-item-id
sku
quantity-purchased
Updated about 1 month ago