Importing Transactions from Amazon Settlement Reports in NetSuite

TL;DR Opening

The NetSuite Connector allows you to import transactions such as fees, refunds, and adjustments directly from Amazon settlement reports into your NetSuite account. This process enhances efficiency in managing eCommerce transactions.

Overview of Amazon Settlement Reports

The NetSuite Connector retrieves various reports from your Amazon account based on your report frequency settings. The primary reports include:

• Flat File Settlement Report: Accessed through GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
• Flat File V2 Settlement Report: Accessed via GET_V2_SETTLEMENT_REPORT_DATA_XML
• Flat File V2 Settlement Report: Accessed with GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

If V2 reports are not enabled in your Amazon account, contacting Amazon support is recommended.

Types of Adjustments Imported

NetSuite Connector categorizes adjustments from Amazon as follows:

1. Order Modifications

   • Fees charged per order, such as FBAPerOrderFulfillmentFee, are posted as additional fees or credits to the order's billed record.

2. Non-Order Modifications

   • These are fees or reimbursements applicable across the entire period. Examples include FBA storage fees and reimbursements for lost or damaged FBA stock.
   • Cash transactions are posted based on the net result; a positive outcome indicates Amazon owes you money, while a negative indicates you owe Amazon.

3. Refunds

   • Processed as Refund Authorizations, Cash Refunds, or Credit Memos, depending on the previous order setup.
   • Cash Refunds or Credit Memos are created only if Return Authorizations and Item Receipts are manually inputted.

Important: Syncing your settlement reports is a paid feature and optional. Additionally, combining different fees into a single line item is not supported; each transaction is recorded individually.

Setting Up Order Fees

To set up fee representation in NetSuite, the Connector creates an Other Charge For Sale item type. Follow these steps to configure it:

To Setup Other Charge for Sale Item Type:

1. Visit app.farapp.com and select the Amazon connector.
2. Choose your account from the navigation menu.
3. Navigate to Settings > Other Transactions.
4. Click the Settlement tab and select Create Settlement Items.
5. Choose an Income Account. If distinct accounts are needed for all items, updates in NetSuite are required.

Conditions for Creating Valid Settlement Items

Ensure the following conditions are met to avoid creating invalid settlement items:

• Use a subsidiary with an ID of 1 only.
• Ensure item records utilize the Item Name/Number field as the SKU.

Importing Specific Transactions

The types of transactions imported from Settlement Reports to NetSuite include:

• Refunds: Automatically linked to corresponding orders or can be combined into a single summary transaction if needed.
• Service Fees: Imported as summary transactions. Positive summaries become Cash Sales, while negative become Cash Refunds.
• Other Transactions: Similarly imported as new summary transactions, dependent on whether the summary is positive or negative.

Setting Reporting Cutoff Dates

Manage the report recall timeline with these steps:

1. Log in to NetSuite Connector and select your Amazon account.
2. Access Settings > Other Transactions.
3. In the Settlement tab, go to Advanced Options.
4. Input the desired days in the Days Back To Search For Settlement Reports field.
5. Click Save.

The default is 20 days, in sync with Amazon's bi-weekly reports.

Manual Retrieval of Settlement Reports

To manually fetch settlement reports:

1. Log in to app.farapp.com.
2. Select Amazon connector and the relevant account.
3. Navigate to Data Flows > Settlements.
4. Click Retrieve and input the report ID.
5. Confirm the success message appears, indicating the report is now in view.

Amazon Refund Sync Frequency

The refunds are processed with settlement reports, typically released bi-weekly by Amazon. Ensure the sync is activated for timely updates.

Data Reconciliation

NetSuite Connector utilizes Amazon's API for data replication into your account, ensuring similarities between settlement report totals in both systems. Ensure fees charged by Amazon are correctly applied through this synchronization.

Troubleshooting Delays with Amazon Seller Central

Delays in report availability between Amazon Seller Central and NetSuite Connector can occur. If there's a considerable delay:

• Check that the Amazon Settlement Sync is active.
• Verify the status of the report through Amazon Seller Central directly.

Note: Always ensure the sync is functioning correctly to avoid discrepancies in reporting.