Countries
Read only
Help understanding 'amount-description' in All Statements Payment Report Flat File V2
Hey guys,
Hopefully, this hasn't been answered before. I'm looking for some help from those who know what each of these actually means. I'm sure this post will help not just myself but also others wondering the same.
The list of 'charges' is quite extensive, and whilst I can probably work out what some of these are; no doubt we're all super busy and a proper description of what each of these transaction lines means would be helpful.
Those that are self-explanatory you can ignore. I've copied this list from my report export. Others may have more 'types' in their own.
-- Principal
-- Commission
-- DigitalServicesFee
-- FBAPerUnitFulfillmentFee
-- Shipping
-- ShippingHB
-- Tax
-- MarketplaceFacilitatorVAT-Shipping
-- MarketplaceFacilitatorVAT-Principal
-- ShippingChargeback
-- RefundCommission
-- DisposalComplete
-- StorageRenewalBilling
-- Previous Reserve Amount Balance
-- Shipping label purchase
-- ShippingTax
-- Current Reserve Amount
I think we'll all appreciate the comments and input that follow from those of you who do know the meanings.
Best,
Jason
3 replies
Seller_i6S8knzW6zU6Z
Hey @Seller_EdMkiu5XTXkvU
I searched online for 'payment settlement report + "shipment-fee-amount"' to find definitions in the developer documentation and came across an Excel file with the information. Since Excel files can pose security risks, I decided not to link directly to it but instead copied the definitions here for your reference.
Here's a detailed breakdown:
----
Field Name: settlement-id
Definition: Amazon's unique identifier for the settlement being reported. This is a numeric value. The minimum number of digits is 1 and the maximum number of digits is 20.
Example: 236628501
----
Field Name: settlement-start-date
Definition: The start date of the settlement period being reported. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-03T16:00:00-07:00
----
Field Name: settlement-end-date
Definition: The end date of the settlement period being reported. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-10T16:00:00-07:00
----
Field Name: deposit-date
Definition: The date that the funds from the settlement period will be deposited into the merchant's bank account. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-15T16:00:00-07:00
----
Field Name: currency
Definition: The currency for the transaction - USD, GBP, EUR, CAD, JPY. All order, adjustment, fee, and event data will have the same currency.
Example: USD
----
Field Name: transaction-type
Definition: The type of transaction - Order, Adjustment, OtherFee, or MiscEvent
Example: Order
----
Field Name: order-id
Definition: Amazon’s unique, displayable identifier for an order. This is a numeric value. Total number of characters is 19. The value is represented as 3 numbers, a dash (-), 7 numbers, a dash (-) followed by another 7 numbers.
Example: 058-7987646-0553626
----
Field Name: marketplace-name
Definition: The name of the Marketplace where the order was placed. This value is a string with a maximum length of 50 characters.
----
Field Name: order-fee-type
Definition: The type of fee charged in the order-fee-amount column.
Example: Commission
----
Field Name: order-fee-amount
Definition: The amount of a particular fee charged for this order. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 0.34
----
Field Name: posted-date
Definition: The date that the item (order, adjustment, misc, or other) was debited or credited to the merchant's account. This is an alphanumeric value. Total number of characters is 25. See example for how the value is represented.
Example: 2003-10-03T21:11:10-07:00
----
Field Name: order-item-code
Definition: Amazon’s unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14.
Example: 63043395314814
----
Field Name: sku
Definition: A merchant-defined unique identifier for a product. This is an alphanumeric value. The minimum number of characters is 1 and the maximum number of characters is 40.
Example: 1012
----
Field Name: quantity-purchased
Definition: The number of this item that were purchased. This is a numeric value. The maximum number of digits is 12.
Example: 1
----
Field Name: price-type
Definition: The type of price specified in the price-amount column.
Example: GiftWrapTax
----
Field Name: price-amount
Definition: The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.36
----
Field Name: item-related-fee-type
Definition: The type of fee charged in the item-related-fee-amount column.
Example: Commission
----
Field Name: item-related-fee-amount
Definition: The amount of a particular fee charged in relation to this item. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.68
----
Field Name: misc-fee-amount
Definition: The amount of miscellaneous charges/credits to the account. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 6.39
----
Field Name: promotion-id
Definition: Merchant-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50.
Example: 90103summer
----
Field Name: promotion-type
Definition: The type of promotion referred to by the values in the promotion-id and promotion-amount columns.
Example: Shipping
----
Field Name: promotion-amount
Definition: The amount of promotional discount applied to the item due to the promotion specified in the promotion-id column. This is a numeric value. Maximum number of digits are a number with up to 18 digits to the left of the decimal point and 2 digits to the right of the decimal point.
Example: 5.16
----
Field Name: other-amount
Definition: Additional charges/credits that do not fall under one of the other amount types. The transaction type for this amount will be specified in the transaction-type column.
Example: 5.99
----
Seller_EdMkiu5XTXkvU
Okay guys, so I managed to get this info out of ChatGPT. Don't know exactly how accurate this is, if anyone has some insight with regards to its accuracy that might help, so feel free to add what you know down below.
In Amazon Seller Central’s All Statements Payment Report Flat File V2, the amount-description column provides a detailed breakdown of all transaction types that affect your account’s financial balance. Here’s an explanation of each of the transaction lines you've mentioned:
Principal: The total sale price for items sold, excluding other fees. This is the primary amount for your item sales.
Commission: The referral fee Amazon charges on the sale, based on the product category and price. Amazon takes this fee as a percentage of the sale price.
DigitalServicesFee: A fee applicable when digital goods or services (like eBooks) are sold. This is relevant mainly if you sell digital products.
FBAPerUnitFulfillmentFee: The fulfillment fee Amazon charges per unit for FBA (Fulfillment by Amazon) orders. It covers picking, packing, and shipping the item.
Shipping: The shipping fee collected from the customer. This amount will be passed on to you to cover the shipping costs if you handle fulfillment yourself.
ShippingHB: The shipping fee Amazon charges for handling buyer returns. "HB" usually stands for “Handling and Buyer,” which covers handling costs when customers return items.
Tax: The sales tax collected from customers based on regional or international tax obligations. Amazon may remit this tax to the relevant authority on your behalf.
MarketplaceFacilitatorVAT-Shipping: The VAT collected on shipping fees when Amazon acts as a marketplace facilitator in certain regions where they are required to remit VAT for you.
MarketplaceFacilitatorVAT-Principal: The VAT collected on the principal sale amount for marketplace-facilitated sales. Like the previous entry, Amazon collects and remits this VAT in certain regions.
ShippingChargeback: An adjustment when shipping fees are credited back to your account, often related to returns or other reconciliations.
RefundCommission: A partial commission refund when an order is refunded. Amazon reimburses a portion of the original commission fee in these cases.
DisposalComplete: A fee for the disposal of your inventory. This is relevant if you choose to dispose of unsellable or unneeded FBA inventory.
StorageRenewalBilling: Monthly storage fees for your FBA inventory. This amount is charged based on how much space your items occupy in Amazon's fulfillment centers.
Previous Reserve Amount Balance: The amount Amazon withheld in the previous settlement period as a reserve to cover any potential returns or chargebacks.
Shipping label purchase: Costs associated with purchasing shipping labels through Amazon for items you fulfill directly.
ShippingTax: The tax collected on shipping fees, separate from the marketplace facilitator VAT. This may apply in regions where Amazon collects taxes on shipping independently.
Current Reserve Amount: The amount Amazon withholds from your current balance as a reserve for potential refunds, chargebacks, or other adjustments in the future.
Each of these transactions contributes to the final balance reflected in your payment reports. Understanding these items can help you track exactly where your money is going and how fees are impacting your revenue.
Similar Discussions
