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.settlement.
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:
- Navigate Company Settings > Toolbox > Settlements > Settlements.
- Select Amazon as the order source. Select filters if applicable and press Search.
- Settlements will display in a grid. with Start Date, End Date, Deposit Date and Deposit Amount.
- 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:
- Transaction type - Typically, this is either Order or Refund. But there are any many other types.
- Shipment Fee Type - Shipping related fees charged to the merchant. For example, "FBA Transportation Fee" for orders shipped via FBA (Multi-Channel Fulfillment).
- Price Type - Payment exchanges between the buyer and Amazon.
Item Related Fee Type - Payment exchanges between Amazon and the seller.
- 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.
- Debits to merchant account like commissions and FBA fees.
- Credits to merchant account like Refund Commission.
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.|
| Commission || Percentage of payments which Amazon deducts as a referral fee for the sale. Commissions for item price, gift wrap and other accessories.|
| 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.|