Amazon Settlements

Typically, Amazon will settle accounts every 14 days. When settlement is complete, a settlement report is posted and Amazon initiates a transfer to the merchants bank account. The settlement report will detail all the order payments and deductions for orders in that settlement.
Merchant Fulfilled (MFN), Amazon Fulfilled (AFN) and Multi-Channel Fulfillment (non Amazon) orders will all be included in the one settlement report. Orders are labeled by their abbreviations.

SellerCloud will query Amazon for the new report. When it becomes available, the new report will be pulled into SellerCloud. The deductions in the file - commissions, fees, etc.. - will be applied to update P&L on the orders.

Please Note: Orders not included in a settlement will not have any commission or fees applied. Those P&L items will display as N/A.
Please Note: Sometimes, Amazon will not include every order in the the 14 day period in the new settlement. It may take up to several cycles before all orders are settled.

View Settlement Data

  • The actual report file can be found in the Amazon Settings > Reports as the Settlement V2 Data Flat File report.
  • On the order's P&L tab, click on the Amazon arrow to open a settlement window to view the itemized payments and charges. Also, hovering over the Shipping Cost value will reveal a break down of shipping costs.
  • To view a summary and details of the entire settlement report:
    1. Navigate Company Settings > Toolbox > Settlements > Settlements. 
    2. Select Amazon as the order source. Select filters if applicable and press Search.
    3. Settlements will display in a grid. with Start Date, End Date, Deposit Date and Deposit Amount. 
    4. Press on an Amazon Settlement ID. The settlement summary will display, as well as the settlement details in full. The summary summarizes all the fees in the settlement based on "fee type". 

Understanding Amazon Settlement Data

Settlement data is categorized by 4 types:
  1. Transaction type - Typically, this is either Order or Refund. But there are any many other types.
  2. Shipment Fee Type - Shipping related fees charged to the merchant. For example, "FBA Transportation Fee" for orders shipped via FBA (Multi-Channel Fulfillment).
  3. Price Type - Payment exchanges between the buyer and Amazon. 
    • Credits to the merchant account like "Principal" and "Shipping" paid by the customer.
    • Debits to merchant account to credit back the customer, such as Goodwill charges.
  4. Item Related Fee Type - Payment exchanges between Amazon and the seller. 
    • Debits to merchant account like commissions and FBA fees.
    • Credits to merchant account like Refund Commission.
List of all Amazon Fee Types can be found here.

Amazon Payments and Credits

 Principal   Customer payment for base sale price
 Tax  tax paid on principal
Shipping  Customer payment for shipping charges
 Gift Wrap  Payment for optional accessory 
 Gift Wrap Tax  
 Restocking Fee   Percentage of the item's price, depending on the type of item and the condition in which it is returned.

Amazon Fees and Debits

 Commission    Percentage of payments which Amazon deducts as a referral fee for the sale. Commissions for item price, gift wrap and other accessories. Check this article for more info.
 Shipping HB  Shipping holdback, commission on shipping payments.
 FBAPerOrderFulfillmentFee  Order Handling per order
 FBAPerUnitFulfillmentFee  Pick & Pack per unit
 FBAWeightBasedFee  Weight Handling
 FBATransportationFee  Shipping charges incurred for using Amazon's UPS shipping account to send inventory to the Amazon Fulfillment Center. This fee is  entered under the Shipment Fee Type column.
 Shipping Chargeback  For FBA orders. Amazon credits your account with the customer's payment for shipping. The credit is then reversed with the shipping  chargeback.
 Gift Wrap Chargeback  For FBA orders. Amazon credits your account with the customer's payment for gift wrapping. The credit is then reversed with the Gift wrap  chargeback.
 Restocking Fee Chargeback  For FBA orders. Amazon credits your account with the customer's payment of the Restocking fee. The credit is then reversed with the restocking fee  chargeback.
 Goodwill  Compensation that Amazon pays to disgruntled customer. This charge is debited from the Price Type column.

How did we do?