Step 9 - Setting Up Amazon Fees and Settlement Report Processing For NetSuite

FarApp can import your fees, refunds, and other transactions from the Amazon settlement reports. These reports are usually generated by Amazon weekly or bi-weekly (the frequency depends on your account at Amazon). Please let us know if you want us to process settlement reports for you. Please reference farapp.com for pricing on this feature: https://www.farapp.com/connector/amazon/ Not all our customers connected to Amazon choose to use FarApp to sync their Settlement Reports to NetSuite.

Unfortunately, the fees, refunds and other transactions from the Amazon settlement reports are not something that FarApp can access through the Amazon Reports API. Your reports will have to be released for external access on a weekly or bi-weekly basis. If this has not already been set up for your account, you will need to ask Amazon to set up your account to release the reports on a scheduled basis.

To request this, please open a ticket with Seller Support and ask Amazon to automatically run the reports. Doing this will cause the report to automatically generate each time they close a settlement and send you payment. The only drawback to this is that this will only generate reports moving forward. No prior reports will be generated.

Scheduling Reports

  1. Go here (FarApp login required).
  2. Click on Your Account and then select Make changes to your account.
  3. Enter the following information into the contact form:
    • Contact Reason:  Please turn on automatic settlement report for my account.

    • Changes:  I would like to request that the following settlement reports be automatically scheduled for my account: 

      Flat File Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
      XML Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_XML
      Flat File V2 Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

  4. Once Amazon has responded to this request and confirmed that your reports have been scheduled, you can continue with the sections below (please note: because Amazon will only start generating reports going forward, you may have to wait some time before a report gets generated that FarApp can work with.

Order Fees

Order fees unfortunately are not part of Amazon's order data, so we don't import them at the same time as we import the order. But once a new settlement report is generated, we will update the corresponding orders in NetSuite with the fees.

In order to support this, you'll need to create a "Other Charge For Sale" type item in NetSuite for each fee type in Amazon. When setting up these items, make sure the "Can be Fulfilled" checkbox is not flagged (under the basic properties tab). Here is a list of SKUs that you'll need to create:

Note: Please make sure you don't have trailing spaces in the names when you make the SKUs.

  • BalanceAdjustment
  • BuyerRecharge
  • Commission
  • COMPENSATED_CLAWBACK
  • CS_ERROR_ITEMS
  • Current Reserve Amount
  • Customer Return
  • Customer Service Issue
  • Customs Reimbursement
  • Damaged:Inbound
  • Damaged:Outbound
  • Damaged:Warehouse
  • Discount Not Applied
  • DisposalComplete
  • FBA Inventory Storage Fee
  • FBA transportation fee
  • FBACustomerReturnPerOrderFee
  • FBACustomerReturnPerUnitFee
  • FBACustomerReturnWeightBasedFee
  • FBAInboundDefectFee_BAGGING
  • FBAInboundDefectFee_LABEL_ISSUE
  • FBAInboundDefectFee_SUFFOCATION_STICKER
  • FBAInboundDefectFee_TAPING
  • FBAInboundTransportationFee
  • FBAPerOrderFulfillmentFee
  • FBAPerUnitFulfillmentFee
  • FBAWeightBasedFee
  • Fee correction
  • FREE_REPLACEMENT_REFUND_ITEMS
  • GiftWrap
  • GiftwrapChargeback
  • GiftWrapTax
  • Goodwill
  • INCORRECT_FEES_ITEMS
  • INCORRECT_FEES_NON_ITEMIZED
  • Inventory Placement Service Fee
  • Item Not Received
  • Lost:Inbound
  • Lost:Outbound
  • Lost:Warehouse
  • Manual Processing Fee
  • Manual Processing Fee Reimbursement
  • MarketplaceFacilitatorTax-Giftwrap
  • MarketplaceFacilitatorTax-Other
  • MarketplaceFacilitatorTax-Principal
  • MarketplaceFacilitatorTax-Shipping
  • MISSING_FROM_INBOUND
  • MISSING_FROM_INBOUND_CLAWBACK
  • MULTICHANNEL_ORDER_LOST
  • NonSubscriptionFeeAdj
  • POS_NOSKU
  • Previous Reserve Amount Balance
  • Principal_Promotion
  • RefundCommission
  • RemovalComplete
  • REMOVAL_ORDER_LOST
  • RestockingFee
  • Return Adjustment
  • ReturnShipping
  • REVERSAL_REIMBURSEMENT
  • SalesTaxServiceFee
  • Shipping
  • Shipping label purchase
  • Shipping label purchase for return
  • Shipping Reimb.
  • ShippingChargeback
  • ShippingHB
  • ShippingTax
  • Storage Fee
  • StorageRenewalBilling
  • Subscription Fee
  • Tax
  • TaxDiscount
  • Unplanned Service Fee - Barcode label missing
  • VariableClosingFee
  • WarehousePrep
  • WAREHOUSE_DAMAGE
  • WAREHOUSE_DAMAGE_EXCEPTION
  • WAREHOUSE_LOST
  • WAREHOUSE_LOST_MANUAL

Refunds

Refunds are also imported from the settlement report. By default, we import these against the corresponding orders in NetSuite. But if preferred, we can bring in one summary transaction for all the refunds combined. If the transactions span two months, by default we will split the summary transaction into two.

Service Fees

Service fees in the settlement report that are not associated with specific transactions in NetSuite are imported as new summary transactions (cash sale if positive or cash refund if negative). These summary transactions include line items for all the service fees on the settlement report. If the transactions span two months, by default we will split the summary transaction into two.

Other Transactions

Likewise, other transactions in the settlement report that are not associated with specific transactions in NetSuite are imported as new summary transactions (cash sale if positive or cash refund if negative). These summary transactions include line items for all the other transactions on the settlement report. If the transactions span two months, by default we will split the summary transaction into two.

Testing and Enabling Your Settlement Report Processing Sync

After you have read through the above sections and created all the SKU's that FarApp requires to sync Settlement Reports, please open a ticket with us. You will need to provide an order that FarApp has synced to NetSuite for you that Amazon has also already generated settlement data for. Because of these two requirements, customers often set up Settlement Report processing several weeks after going live with FarApp. When you do provide us with an order, we will post the order fees and other adjustments to the order in your NetSuite and have you confirm that the fees have posted as you expect. After that we will post all the fees and adjustments for the settlement period that are not associated with a specific order, such as compensation for lost of damaged FBA items. We will then have you confirm that thees fees have posted as you expect. After that, FarApp will activate your Settlement Report processing sync. This entire set up and testing processing can take several weeks.

To access your Settlement Settings in FarApp, please follow this link: https://app.farapp.com/settings#/marketplace_cart_settings/settlement_sync

Comments