Settlement reports provide a detailed breakdown of a merchant’s account activity for a given settlement period. Settlement reports are generated regularly and can be downloaded from the Amazon Seller Central. Settlement Report also provides very detailed information about the different types of fees charged by Amazon for providing various marketplace services offered to the seller.
Settlement reports can be generated weekly and bi-weekly. After a settlement report is generated by Amazon, the seller receives payment for all the goods sold in their Amazon account. Each report has a breakdown of Item Price, Amazon commission fees, shipping fees, and the total amount earned by the seller.
Download an Amazon settlement report
- Login to your Seller Central Account.
- Go to Reports > Payments > All Settlement.
- Click Download Flat File V2 against Settlement Period.
- Save the file on your hard drive.
Settlement Flows
The Celigo Amazon Integration App helps you import settlement reports from Amazon into NetSuite and automatically generate reports that help you analyze most profitable items, Amazon fees, net profit, and so on.
Note: The Integration App only supports the .txt and tab-separated CSV file format of the settlement report.
In the Amazon – NetSuite Integration App, the Settlement section consists of the following flows that you can use to process different information in NetSuite using the settlement report.
- Settlement Report Import Flow
- Imports the Settlement report from Amazon Seller Central to NetSuite.
- You can use one of the below two options to sync your settlement report and process the settlement reconciliations:
- Automatically pull the settlement report
- Upload the settlement report manually
- The “Request Amazon Settlement Report List” and “Amazon Settlement Report to NetSuite Custom Settlement Records” flows can import settlement reports up to a size of 100MB.
- When you run the “Request Amazon Settlement Report List” and “Amazon Settlement Report to NetSuite Custom Settlement Records” flows, the Integration App performs the following action in NetSuite:
- Creates a Settlement Summary Report
- Creates Settlement Transactions
- Settlement Payment Import Flow
The payment import flow identifies the sales orders (MFN), searches for the invoices, and creates customer payments for amounts that Amazon sends. For FBA, orders are directly imported as invoices, so payments are directly created.
- Settlement Refund Import Flow
Creates Credit Memo and Refunds (for Invoices) or customer refunds for the refunds generated in the report.
- Settlement Summary Update Flow
Updates Settlement Summary Report.