Managing Amazon Settlement Sync with NetSuite Connector

The Amazon Settlement Sync is a functionality within the NetSuite Connector that allows users to process various adjustments from Amazon seamlessly. It is essential for businesses that rely on Amazon for sales, as it automates the integration of settlement data, ensuring financial records are up-to-date and accurate. This article covers how these adjustments are categorized and processed within NetSuite.

What Types of Adjustments are Processed?

Amazon adjustments can be classified into three main types:

Order Modifications

These consist of fees that Amazon charges per order. NetSuite records these modifications by adding the respective fees or credits to the billed record of the corresponding order.

Non-Order Modifications

These encompass fees or reimbursements applicable to a certain period rather than individual orders, such as storage fees or reimbursement for losses. The settlement sync consolidates these non-order modifications and creates a record that indicates whether money is owed to you or to Amazon:

• If payment is due to Amazon, a cash refund summary transaction is created.
• Conversely, if Amazon owes money, a cash sales summary transaction is generated.

Refunds

Refunds for orders are reflected using return authorizations, cash refunds, or credit memos as applicable to their original orders. Users have the option to manually create return authorizations and item receipts while configuring the sync to only post cash refunds or credit memos.

Accessing the Amazon Settlement Sync Dashboard

You can view the Amazon Settlement Sync dashboard through the Settlements tab in the Data Flows section. Here's how:

1. Log in to app.farapp.com.
2. Select the Amazon connector and the relevant account.
3. Navigate to Data Flows > Settlements.

Dashboard Layout

The dashboard includes several columns displaying important information related to settlement transactions, such as:

• Account: Shows the account linked with the settlement report.
• Report ID: The Amazon-assigned ID for each report.
• Settlement ID: An ID unique to each settlement report row.
• Status: Indicates whether the syncing process is complete, in progress, or encounters errors.

Configuring Amazon Settlement Sync Settings

To adjust the Amazon settlement sync settings:

1. Log in to app.farapp.com.
2. Select the Amazon connector and the relevant account.
3. Navigate to Settings > Other Transactions.
4. Click the Settlement tab to view and modify the settings as needed.

Basic Settings

You can manage a few settings to control the behavior of the sync:

• NetSuite SKU Field: Matches the SKU used in your orders to facilitate the sync.
• Customer Internal ID: Identifies the customer associated with fees and credits that do not link to specific orders.
• Create Settlement Items: Allows for item creation in NetSuite to represent fees and credits.

Advanced Options

Advanced settings should be modified cautiously and include options like:

• Days Back to Search for Settlement Reports: How many past days to retrieve reports.
• Merge All Refunds on Report Into a Single Summary Refund: A useful setting for consolidating refund transactions.

Following these practices ensures that your Amazon settlements are smoothly integrated within NetSuite, providing improved accuracy in financial reporting and ease of management.