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:
-
Log in to app.farapp.com.
-
Select Amazon connector and the relevant account.
-
Go to Settings > Other Transactions.
-
Click the Settlement tab.
The Settlement Settings page opens displaying the basic settings.
-
Click Create Settlement Items.
-
Create the vendor fee settlement item.
-
Use the dropdown list to select the Income Account you want to use.
-
Use the dropdown list to select the Expense Account you want to use.
-
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:
-
Log in to app.farapp.com.
-
Select Amazon connector and the relevant account.
-
Go to Mappings > Settlements.
-
Click Add Mapping.
-
In Transaction Type, select Vendor Bill.
-
In NetSuite Field, select Vendor.
-
Click Add Mapping.
-
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.
-
Click Save.
To create the vendor credit mapping:
-
Log in to app.farapp.com.
-
Select Amazon connector and the relevant account.
-
Go to Mappings > Settlements.
-
Click Add Mapping.
-
In Transaction Type, select Vendor Credit.
-
In NetSuite Field, select Vendor.
-
Click Add Mapping.
-
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.
-
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.
Transaction Categorization in Settlement Reports
NetSuite Connector categorizes each Amazon SKU as either For Purchase or For Sale.
|
SKU |
Category |
|---|---|
|
A2ZGuaranteeRecovery |
For Purchase |
|
Adjustment |
For Sale and For Purchase |
|
Amazon Capital Services |
For Purchase |
|
Amazon Shipping Charges |
For Purchase |
|
Amazon Shipping Reimbursement |
For Sale |
|
BalanceAdjustment |
For Purchase |
|
BuyerRecharge |
For Sale |
|
ChargeBackRecovery |
For Sale |
|
COD |
For Sale |
|
COD Tax |
For Sale |
|
CODFee |
For Purchase |
|
Commingling VAT |
For Sale (Positive in Order) |
|
Commission |
For Purchase (Negative in Order and Positive in Refund) |
|
Commission Adjustment |
For Sale (Positive in Order) |
|
Commission IGST |
For Purchase |
|
CommissionCorrection |
For Sale |
|
COMPENSATED_CLAWBACK |
For Purchase |
|
Cost of Advertising |
For Purchase |
|
CouponRedemptionFee |
For Purchase |
|
CRETURN_WRONG_ITEM |
For Sale |
|
CS_ERROR_ITEMS |
For Sale |
|
CS_ERROR_NON_ITEMIZED |
For Sale |
|
Current Reserve Amount |
For Sale |
|
Customer Return |
For Sale |
|
Customer Service Issue |
For Sale |
|
Customs Reimbursement |
For Sale |
|
Damaged:Inbound |
For Sale |
|
Damaged:Outbound |
For Sale |
|
Damaged:Warehouse |
For Sale |
|
Discount Not Applied |
For Purchase (?) |
|
DisposalComplete |
For Purchase |
|
Early Reviewer Program fee |
For Purchase |
|
ExportCharge |
For Purchase |
|
FBA Inventory Storage Fee |
For Purchase |
|
FBA Pick & Pack Fee |
For Purchase |
|
FBA transportation fee |
For Purchase |
|
FBACustomerReturnPerOrderFee |
For Purchase |
|
FBACustomerReturnPerUnitFee |
For Purchase |
|
FBACustomerReturnWeightBasedFee |
For Purchase |
|
FBAInboundDefectFee_BAGGING |
For Purchase |
|
FBAInboundDefectFee_LABEL_ISSUE |
For Purchase |
|
FBAInboundDefectFee_SUFFOCATION_STICKER |
For Purchase |
|
FBAInboundDefectFee_TAPING |
For Purchase |
|
FBAInboundTransportationFee |
For Purchase |
|
FBAInboundTransportationProgramFee |
For Purchase |
|
FBAPerOrderFulfillmentFee |
For Purchase |
|
FBAPerUnitFulfillmentFee |
For Purchase |
|
FBAWeightBasedFee |
For Purchase |
|
Fee correction |
For Sale and For Purchase |
|
Fixed closing fee IGST |
For Purchase |
|
FixedClosingFee |
For Purchase |
|
FREE_REPLACEMENT_REFUND_ITEMS |
For Sale |
|
GetPaidFasterFee |
For Purchase |
|
GiftWrap |
For Purchase – For Order and Refund |
|
GiftwrapChargeback |
For Purchase – For Order and Refund |
|
GiftWrapTax |
For Purchase – For Order and Refund |
|
Grade and Resell Charge |
For Purchase |
|
Goodwill |
For Purchase – For Refund |
|
Imaging Services Fee |
For Purchase |
|
INBOUND_CARRIER_DAMAGE |
For Sale |
|
INCORRECT_FEES_ITEMS |
For Sale |
|
INCORRECT_FEES_NON_ITEMIZED |
For Sale |
|
Inventory Placement Service Fee |
For Purchase |
|
Inventory Storage Overage Fee |
For Purchase |
|
Item Not Received |
- |
|
LightningDealFee |
For Purchase |
|
LightningDealFee Special |
For Purchase |
|
Lost:Inbound |
For Sale |
|
Lost:Outbound |
For Sale |
|
Lost:Warehouse |
For Sale |
|
LowValueGoods-Principal |
For Sale |
|
LowValueGoods-Shipping |
For Sale |
|
LowValueGoodsTax-Principal |
For Sale |
|
LowValueGoodsTax-Shipping |
For Sale |
|
Manual Processing Fee |
For Purchase |
|
Manual Processing Fee Reimbursement |
For Sale |
|
MarketplaceFacilitatorTax-Giftwrap |
For Sale |
|
MarketplaceFacilitatorTax-Other |
For Sale |
|
MarketplaceFacilitatorTax-Principal |
For Sale |
|
MarketplaceFacilitatorTax-RestockingFee |
For Sale |
|
MarketplaceFacilitatorTax-Shipping |
For Sale |
|
MarketplaceFacilitatorVAT-Principal |
For Sale |
|
MarketplaceFacilitatorVAT-Shipping |
For Sale |
|
MiscAdjustment |
For Sale and For Purchase |
|
MISSING_FROM_INBOUND |
For Sale |
|
MISSING_FROM_INBOUND_CLAWBACK |
For Purchase |
|
MULTICHANNEL_ORDER_LOST |
For Sale |
|
NonSubscriptionFeeAdj |
For Sale and For Purchase |
|
Paid Services Fee |
For Purchase |
|
PAYMENT_RETRACTION_ITEMS |
For Purchase |
|
POS_NOSKU |
For Sale |
|
PREPFEE_REFUND |
For Sale |
|
Previous Reserve Amount Balance |
For Sale |
|
Principal_Promotion |
For Sale |
|
Premium Experience Fee |
For Purchase |
|
Premium Placement Service Fee |
For Purchase |
|
RE_EVALUATION |
For Purchase |
|
RefundCommission |
For Purchase |
|
RemovalComplete |
For Purchase |
|
REMOVAL_ORDER_DAMAGED |
For Sale |
|
REMOVAL_ORDER_LOST |
For Sale |
|
RestockingFee |
For Sale |
|
Return Adjustment |
For Sale |
|
ReturnShipping |
For Purchase |
|
REVERSAL_REIMBURSEMENT |
For Sale |
|
SAFE-T reimbursement |
For Sale |
|
SalesTaxServiceFee |
For Purchase |
|
Shipping |
For Sale |
|
Shipping label purchase |
For Purchase |
|
Shipping label purchase for return |
For Purchase |
|
Shipping Reimb. |
For Sale |
|
Shipping tax |
For Sale |
|
ShippingChargeback |
For Purchase |
|
ShippingHB |
For Purchase |
|
ShippingServicesRefund |
For Sale |
|
ShippingTax |
For Sale |
|
Storage Fee |
For Purchase |
|
StorageRenewalBilling |
For Purchase |
|
Subscription Fee |
For Purchase |
|
SubscriptionFeeCorrection |
For Sale |
|
Tax |
For Sale – link to cash refund during refund |
|
TaxDiscount |
For Sale |
|
TCS-CGST |
For Sale |
|
TCS-IGST |
For Sale |
|
Unplanned Service Fee – Barcode label missing |
For Purchase |
|
VariableClosingFee |
For Purchase |
|
WarehousePrep |
For Purchase |
|
WAREHOUSE_DAMAGE |
For Sale |
|
WAREHOUSE_DAMAGE_EXCEPTION |
For Sale |
|
WAREHOUSE_LOST |
For Sale |
|
WAREHOUSE_LOST_MANUAL |
For Sale |
|
Vine Enrollment Fee |
For Purchase |
|
Liquidation Adjustments |
For Sale |