Note: The name “SmartConnector” has changed to the “Integration App” as they are built on our Integration Platform as a Service (iPaaS), integrator.io.
Understanding Amazon Settlement reports
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 them 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 total amount earned by the seller.
Payments (Settlement) report displays your account's payment information. With this report, you can:
- View an account summary that includes beginning balance
- View next scheduled date for the transfer of funds
- View order and refund totals.
- View credits, fees, and adjustments for specific orders.
For more information see Payments (Settlement) Reports.
Advantages of integrating Amazon Settlement Reports with NetSuite
- Streamline and speed up account receivables by automatically converting Amazon reported payments into NetSuite digital payments
- Analyze most profitable vs least profitable items on Amazon directly inside of NetSuite.
- Provides a holistic view to your accounting teams for all sales through Amazon & provide visibility into key metrics like total fee charged per SKU or per order, total deposits for a given settlement period.
- Automate syncing refunds from Amazon & create credit memos inside of NetSuite.
- Process up to 100 MBs of Settlement Report in one go. (1 MB ~ 1000 transactions)
How to Download a Settlement Report
Use the following steps to download a settlement report from your seller central account:
- 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.
To see prior settlements, select a date range for the settlement period you are interested in and click Search.
- To open the settlement report, Amazon recommends using a spreadsheet or database program, such as Microsoft Excel or Microsoft Access.
- Settlement reports are available only for the past 60 days.
- If you do not have a positive or zero account balance with Amazon at end of your settlement period, then no settlement takes place and no report is generated.
Settlement Report Integration Flows and Workflow Chart
The Celigo Amazon Integration App helps you import settlement report 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.
The Integration App eliminates the need for manually reconcile the Amazon settlement reports and provides an automated way to generate settlement reports, drill down up to an Item level. The Amazon Integration App leverages Celigo proprietary integration technology to import and export data between Amazon and NetSuite.
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 Report Payment 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 Refund (for Cash Sales) for the refunds generated in the report.
- Settlement Summary Update Flow
Updates Settlement Summary Report.
Note: You can only leverage these flows with the premium (previously "enterprise") edition of the Amazon - NetSuite Integration App.
The following image displays the Settlement Transaction workflow: