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:
- Payments related to orders
- Order-related fees
- Other fees, if the fee mapping has been configured
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