Vendor Bills in Amazon Settlement Sync

Expenses recorded against a sales order in Amazon settlement reports are posted as bills in NetSuite. As vendor bills, these expenses can be properly claimed from tax departments.

The Amazon Settlement sync processes settlement adjustments from Amazon into NetSuite as any of the following types:

• Order modifications – Fees that Amazon charges per order. To reflect the adjustment, order modifications are posted by adding fees or credits to the billed record of the order in NetSuite when available.
• Non-order modifications – Fees or reimbursements that apply to a period instead of specific orders, such as storage fees or reimbursement for loss or damage. To reflect the adjustment, the settlement sync sums up all non-order modifications that do not apply to specific orders. The record created by the sync depends on whether the total results in you owing Amazon money or Amazon owing you money.
• If you need to pay Amazon, the settlement sync creates a cash refund summary transaction.
• If Amazon needs to pay you, the settlement sync creates a cash sales summary transaction.
• Refunds – Orders that have been refunded. The sync posts refunds as return authorizations, cash refunds, or credit memos where appropriate against the original orders. If you prefer to create the return authorizations and item receipts manually, you can configure the sync to only post the cash refund or credit memo.

The Amazon Settlement sync creates a vendor bill for the group of transactions with negative amounts linked to a sales order.

• For order modifications on cash sales, all positive items are posted to the order and all negative items are posted to the vendor bill.
• For cash refunds, all positive items are posted to the cash refund and all negative items are posted to the vendor bill.
• For non-order modifications, all positive non-inventory items are posted as cash sales while negative non-inventory items are posted as a vendor bill.

Creating the Settlement Items

When setting up Amazon Settlement Sync, you need to create the settlement items for the non-inventory settlement items that are for purchase.

To create the vendor fee settlement items:

1. Log in to app.farapp.com.
2. Select Amazon connector and the relevant account.
3. Go to Settings > Other Transactions.
4. Click the Settlement tab.
5. The Settlement Settings page opens displaying the basic settings.
6. Click Create Settlement Items.
7. Create the vendor fee settlement item.
8. Use the dropdown list to select the Income Account you want to use.
9. Use the dropdown list to select the Expense Account you want to use.
10. Click Create Items.

Configuring Vendor Bill and Vendor Credit Mappings

You need to create the mapping for the vendor bill and vendor credit items.

To create the vendor bill mapping:

1. Log in to app.farapp.com.
2. Select Amazon connector and the relevant account.
3. Go to Mappings > Settlements.
4. Click Add Mapping.
5. In Transaction Type, select Vendor Bill.
6. In NetSuite Field, select Vendor.
7. Click Add Mapping.
8. The new mapping is added as a new row in the Settlement Mappings table. On the vendor bill mapping that you created, select the appropriate value in the NetSuite Field/Fixed Value dropdown list.
9. Click Save.

To create the vendor credit mapping:

1. Log in to app.farapp.com.
2. Select Amazon connector and the relevant account.
3. Go to Mappings > Settlements.
4. Click Add Mapping.
5. In Transaction Type, select Vendor Credit.
6. In NetSuite Field, select Vendor.
7. Click Add Mapping.
8. The new mapping is added as a new row in the Settlement Mappings table. On the vendor credit mapping that you created, select the appropriate value in the NetSuite Field/Fixed Value dropdown list.
9. Click Save.

You can use the available mappings to map your other items as needed. To create settlement item mappings for the created vendor bill and vendor credit mappings, go to Mappings > Settlement Items.

Viewing Vendor Bills and Credits in NetSuite and NetSuite Connector

You can process the posted bills, credits, and other modifications in NetSuite. You can also view the details of the settlement report in NetSuite Connector.

Viewing Vendor Bills and Credits in NetSuite Connector

You can use the available Vendor Bills and Vendor Credits tabs when viewing settlement details to see the vendor bills and credits of the report. The relevant transactions are automatically segregated into the appropriate tabs.

To view settlement details, click the pencil icon on the settlement report row, then select View Settlement Details.

Viewing Vendor Bills and Credits in NetSuite

Vendor bills posted to NetSuite have the reference number prefixed with other-transaction followed by the settlement ID. You can then process the vendor bills and cash refunds in NetSuite accordingly.