• Amazon provides the Settlement/Payment Reports to view information about the seller’s payments related to sales and operational activity for your Amazon account. 
• Settlement reports can provide a detailed breakdown of the seller’s account activity for a given settlement period like orders, refunds, reimbursements & Amazon fees, etc. 
• In the connector, the user can fetch their Amazon settlement report from Amazon and process that report in their books of accounts.

Note

​Amazon provides settlement reports in 3 formats. viz. XML, Flat file & Flat file V2, out of which the module supports ​Flat file V2 ​format only. So before proceeding with settlement report processing in Odoo please check Amazon seller central settings and make necessary changes if required.

How this process works: 

• Whenever the user imports orders and refunds from Amazon to Odoo, the system creates invoices and credit notes but those are not marked as paid.
• When the user imports a settlement report and processes it, the invoices and credit notes will be marked as Paid. Sometimes it happens that some of the orders are not imported in Odoo so at the time of processing settlement reports these order lines will not get reconciled and the user will be able to identify such order lines. 
• In case of reimbursement which has been performed by Amazon, the system will create an invoice and Amazon will be set as a customer.

Configurations to be ensured Before processing Settlement Report:

• Before processing a settlement report, the user has to set below 2 fields. These fields are Settlement report journal and ending balance account.

• To set fields Go to ​Amazon ↣ Configuration ↣ Settings ↣ Amazon Marketplace ↣ Select Seller ↣ then Select Marketplace ↣ Settlement Report.

• All the Amazon fees such as Amazon subscription, commission fees, or other transaction types will be reconciled automatically with the accounts you have configured under Amazon ↣ Configuration ↣ Settings ↣ Settlement Report ↣ Click on Configure Amazon seller transactions type.
• Once all the statement lines are properly reconciled, all of the related Amazon invoices will be automatically marked as Paid.

---

The user can process the settlement report in 2 ways.

1.Manually through Operations:

• Settlement reports are generated regularly by Amazon at the seller central account, and the seller can download them from Odoo.

Step-1: Go to ​Amazon ↣ Operations​.

Step-2: Select the respective Amazon Seller

Step-3: Select FBA & FBM Operation

Step-4: Select FBA & FBM Operation for Download Settlement Report

Step-5: Here the user needs to set a date range.

Step-6: Click on the Execute button

• If the user does not specify the date range then the system by default will request a report for the past 90 days.
  

• The user can see all of your settlement reports from the menu ​Amazon ↣ Sales ↣ Invoices & Settlement ↣ Settlement Reports​. The user can see all the settlement reports marketplace-wise.
• Once Amazon generates and returns a settlement report to Odoo, it will be in the Done stage. The done stage indicates that the report has not yet been updated in Odoo.
• After clicking on the Process statement button, any unprocessed statement will automatically create the Amazon/bank statement in Odoo. All the lines will be imported in Odoo and the stage will be set to Imported.
• After all, lines are imported, if there are any missing fees to be configured then a new tab Configure Missing Fees will be visible. 
• In the Imported state Reconcile Button will be visible when a user clicks on the Reconcile button,
• The system will Reconcile statement lines. Here, the important thing to note is if all the statement lines are not reconciled with proper accounts, the Amazon bank statement will not be able to be closed.
• If any lines in the settlement report have not been reconciled due to missing fees, then the user can configure those missing fees from this screen itself.

2.Automatically through scheduler:

The user can set a scheduler in the system to download and process settlement reports automatically. The user can set the scheduler by navigating to Amazon ↣ Configuration ↣ Sellers ↣ FBA & FBM Schedulers.

Note

*Sometimes seller may receive Fatal or cancel status of this reports.

Fatal status: Seller can get Fatal status for two reasons.

1. The seller has made the same request too many times in a row.
2. There is no data available for the date range specified.

Cancel status: When Seller already has data in your Odoo environment, the connector will cancel any duplicate reports.

---