Skip to main content

Sync your Amazon Settlement report

Dev Chidipi
  • Updated
Follow

Note: The name “SmartConnector” has changed to the “Integration App” as they are built on our Integration Platform as a Service (iPaaS), integrator.io.

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

Automatically pull the settlement report

Group_5011.png

When you enable the “Request Amazon Settlement Report List” flow, the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow is a sequenced flow that automatically runs on the completion of the first flow. This option first requests Amazon and automatically gets the Amazon settlement reports generated after the previously scheduled run. The second flow imports the settlement report to NetSuite and creates custom settlement records.

Upload the settlement report manually

Group_5063.png

When you disable the “Request Amazon Settlement Report List” flow, the run button is enabled for the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow. This option allows you to manually upload the Amazon settlement report and it creates the custom settlement records in NetSuite.

Notes:

  • When a settlement report is requested from the backend via API, Amazon generates a consolidated report for all the marketplaces of a region. If a settlement report consists of only non-order or non-refund related records, it is difficult for the flow to identify the exact marketplace. When the flow is unable to identify the marketplace, an error is displayed and you can process your settlement report by uploading it manually (Option 2). 
  • 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.

Understand the grouping logic of the custom settlement records

When you run the “Request Amazon Settlement Report List” and “Amazon Settlement Report to NetSuite Custom Settlement Records” flows, you may find a variance in no of records in the Amazon settlement report and no of successful record processed by the integration app.1.jpg

This could be due to the integration app grouping logic to organize content based few parameters in the settlement report while importing the information to NetSuite.

To understand more about the grouping logic, refer here.

Before you set up the flow

Prerequisite:

Ensure to raise a support ticket with Amazon to change the frequency of the settlement report generation as per your business needs appropriately. The Amazon default frequency of the settlement report is one report every 15 days. The supported format for the settlement report is “Flat File V2”.

Note: If the volume is high and if you are linking all orders against a single default customer, it is recommended to keep the settlement report window lower. This is to ensure that there are no open invoices.

Configure and run the flow

Option 1: Automatically pull settlement report from Amazon

  1. In integrator.io, click Amazon - NetSuite Integration App tile.
  2. Go to Settings > Integration flows > Settlement.
  3. Enable the “Request Amazon Settlement Report List” flow. The “Amazon Settlement Report to NetSuite Custom Settlement Records” is an auto-triggered sequenced flow that runs on the completion of the first flow.
  4. Click Run.
    Note: Using this flow, you can also import historical settlement reports.

Option 2: Upload the settlement report manually

Prerequisite: Download the settlement report from your Amazon account. Refer here on how to download the settlement report from Amazon.

  1. In integrator.io, click Amazon - NetSuite Integration App tile.
  2. Go to Settings > Integration flows > Settlement.
  3. Run the “Amazon Settlement Report to NetSuite Custom Settlement Records” flow. This flow is automatically enabled when the “Request Amazon Settlement Report List” flow is disabled.

Notes:

  • After you run the "Amazon Settlement Report to NetSuite Custom Settlement Records" flow successfully, the integration app automatically triggers the "NetSuite Settlement Transaction to NetSuite Payment Add" flow.
  • Any transaction other than following transaction type is grouped under “Miscellaneous”:
    • Order
    • Refund
    • Other Transaction
    • Order Retro Charge
    • Refund Retro Charge
    • Lightning Fee
  • Orders (AFN and MFN) must be billed as Invoices.
  • Limitation: Cash Sales are not supported.

Find your records in NetSuite

After you run the “Request Amazon Settlement Report List” or “Amazon Settlement Report to NetSuite Settlement Records” flows, the following happens in NetSuite:

A new tab, Amazon is added in NetSuite. This tab can be used for gaining quick access to the customs records that are created from importing the settlement report into NetSuite. To access these custom records, click Amazon > Settlements.

In_NetSuite_How_to_find.png

Celigo Amazon Settlement Summary

The Summary option navigates you to the Celigo Amazon Settlement Summary List page. Every summary record on this page represents a settlement report that was imported by you. Every record on this page provides a high-level summary related to the settlement report imported by you. The following screen displays the information available in an individual record immediately after the settlement report import:Celigo_Amazon_Settlement_Summary.png

Celigo Amazon Settlement Transaction

The Transaction option navigates you to the Celigo Amazon Settlement Transaction List page. The page displays every transaction imported from the settlement report as an individual record. For example, assume a settlement report with Settlement ID: 118267561 is imported into NetSuite and the Dashboard page displays a total of 34 successful records. This means that 34 transaction records will be created in the Celigo Amazon Settlement Transaction List page. Every record on this page provides details related to an individual transaction imported by you. The following screen displays the information available in an individual transaction record immediately after the settlement report import:
Celigo_Amazon_Settlement_Transaction.png

Note: All records created in the Celigo Amazon Settlement Transaction List page are supported with NetSuite Global Search. In the following example, you can see how Order Id can be used to find associated records in NetSuite using the global search box:

You can ask questions and get tips about settlement reports in our community forum.

Related articles

Comments

0 comments

Please sign in to leave a comment.