Overview
Typically, Amazon will settle accounts every 14 days. However, there are cases when Amazon will not include every order in the 14-day period in a new settlement. Up to several cycles may be required to settle all orders.
When settlement is complete, a settlement report is posted and Amazon initiates a transfer to the merchant’s bank account. The settlement report details all the order payments and deductions for orders in that settlement.
Merchant Fulfilled (MFN), Amazon Fulfilled (AFN), and Multi-Channel Fulfillment (non-Amazon) orders are all included in one settlement report. Orders are labeled by their abbreviations.
Sellercloud will query Amazon for the new report, and when available, will pull in the new report. The deductions in the file – commissions, fees, etc. – will be applied to the orders.
Amazon Settlement Report
To open Amazon report files:
- Go to Settings > Companies > Manage Companies > Open a company > Toolbox > Channels > Amazon Settings > Reports.
- From the Reports drop-down menu, select Settlement V2 Report Data Flat File, and press Search.
To view a summary and details of the entire settlement report:
- Go to Settings > Companies > Manage Companies > Open a company > Toolbox > Settlement > Settlement.
- Choose 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.
- Click on an 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.
Amazon Settlement Data
Settlement data is categorized into four types:
- Transaction type — Typically, this is either Order or Refund, but there are many other types.
- Shipment Fee Type — Shipping-related fees charged to the merchant. For example, FBA Transportation Fee for orders shipped by FBA (Multi-Channel Fulfillment).
- Price Type — Payment exchanges between the buyer and Amazon.
- Credits to the merchant account, such as Principal and Shipping, paid by the customer.
- Debits to the merchant account to credit back the customer, such as Goodwill charges.
- Item Related Fee Type — Payment exchanges between Amazon and the seller:
- Debits to the merchant account, such as commissions and FBA fees.
- Credits to the merchant account, such as Refund Commission.
See all Amazon fee types.
Amazon Payments and Credits
TERM | DESCRIPTION |
Principal | Customer payment for base sale price. |
Tax | Tax paid on the principal. |
Shipping | Customer payment for shipping charges. |
Gift Wrap | Payment for an optional accessory. |
Gift Wrap Tax | The tax on the gift wrap price. |
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
TERM | DESCRIPTION |
Commission | Percentage of payments Amazon deducts as a referral fee for the sale. Commissions for the item price, gift wrap, and other accessories. Check this article for more information. |
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 dissatisfied customers. This charge is debited from the Price Type column. |
Merchant Fulfilled (MFN), Amazon Fulfilled (AFN), and Multi-Channel Fulfillment (non-Amazon) orders are all included in one settlement report. Orders are labeled by their abbreviations.
Sellercloud will query Amazon for the new report, and when available, pulls in the new report. The deductions in the file – commissions, fees, etc. – will be applied to update P&L on the orders.
- The actual report file is available in Amazon Settings > Reports as the Settlement V2 Data Flat File report.
- On the order’s P&L tab, click the Amazon arrow to open a settlement window to see itemized payments and charges. Also, hovering over the Shipping Cost value will show a breakdown of shipping costs.
- To view a summary and details of the entire settlement report
- Click Company Settings > Toolbox > Settlements > Settlements.
- Choose Amazon as the channel. Select filters if applicable and press Search. Settlements will display in a grid with Start Date, End Date, Deposit Date, and Deposit Amount.
- Click 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 into four types:
- Transaction type – Typically, this is either Order or Refund, but there are many other types.
- Shipment Fee Type – Shipping-related fees charged to the merchant. For example, “FBA Transportation Fee” for orders shipped by FBA (Multi-Channel Fulfillment).
- Price Type – Payment exchanges between the buyer and Amazon.
- Credits to the merchant account, such as “Principal” and “Shipping” paid by the customer.
- Debits to the merchant account to credit back the customer, such as Goodwill charges.
- Item Related Fee Type – Payment exchanges between Amazon and the seller:
- Debits to the merchant account, such as commissions and FBA fees.
- Credits to the merchant account, such as Refund Commission.
See all Amazon fee types.
Amazon Payments and Credits
TERM | DESCRIPTION |
Principal | Customer payment for base sale price. |
Tax | Tax paid on the principal. |
Shipping | Customer payment for shipping charges. |
Gift Wrap | Payment for an optional accessory. |
Gift Wrap Tax | The tax on the gift wrap price |
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
TERM | DESCRIPTION |
Commission | Percentage of payments Amazon deducts as a referral fee for the sale. Commissions for the item price, gift wrap, and other accessories. Check this article for more information. |
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 dissatisfied customers. This charge is debited from the Price Type column. |