HomeDocumentationCode SamplesAnnouncementsModelsRelease NotesFAQGitHubVideos
Developer HubAPI StatusSupport
Documentation
Developer HubAPI StatusSupport

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 2 months ago