Settlement reports

When an Amazon customer places an order, Amazon collects the funds from the customer and holds them. Roughly every two weeks, the money collected from customers is paid to the merchant, less fees and other deductions.

While all the funds are transferred in one lump sum, Amazon issues a report detailing the individual transactions making up the amount. This report, called a settlement report, or sometimes disbursement report, is used to mark the orders as paid in Brightpearl.

The settlement report lists:

  • The total amount of each order
  • The taxes relating to the order
  • The fees related to the order
  • Any other fees

... among other things.

By default, Brightpearl will only automatically post:

XML format

For the payments to be successful, the report provided by Amazon must be in XML format. You may need to contact Amazon to request the report be provided in the correct format.

Note: Amazon will not provide past payment reports in XML. If your report was not in XML format at the point of being issued you will have to enter the payments into Brightpearl manually.

Requesting settlement reports from Amazon

You may need to send a request to Amazon to have your settlement report scheduled automatically. To do that, go to the Seller Central help page here, then go to Get support > Your account > Amazon fees.

You can use the following template:

Contact Reason: Please turn on the automatic settlement report for my account.

Please describe your issue:

I would like to request that the following settlement reports be automatically scheduled for integration to Brightpearl ERP:

Flat File Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
XML Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_XML
Flat File V2 Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

contact_amazon_support.png

Have more questions? Submit a request