Understanding your Amazon Payout Statement
- Rita Saini (Unlicensed)
- Jyoti Budhiraja (Unlicensed)
- Mayur Karwa
Payout statements provide a detailed breakdown of your account activity for a given settlement period. Payout statements are generated regularly, and you can download them from the Seller account. The study of this article will help you to know
How to download Amazon payout statements and upload in Eshopbox app
How to read Amazon payout statements
How Eshopbox reconciles Amazon payouts
Download the Payout Statement
Log in using the amazon seller account.
Go to reports from the top menu section from the drop-down, select payments.
Select electronics transaction or COD transaction and non-transaction fees and then click on all Statements.
Click on download flat file v2 corresponding to the transaction you want to download the report. This will be downloaded as a text file.
Upload the file in payment booking screen of workspace.
Reference link: https://pay.amazon.com/help/201212310
Amazon provides payout in two types of report:
Electronic transaction (Credit card/ Net banking/ GC): Payment is made by the customer when the placed the order. This can be a credit card, debit card, UPI, etc.
COD Transaction and Non-Transactional Fees: Payment was made when the order was received by the customer. This can be cash, credit card, debit card, etc.
Reading a payout statement
Each row in Amazon payout statement represents the amount settled corresponding to a particular order. The amount settled may include
Amount paid to you or refunded from your account against Receivable for an order.
Amount deducted or reversed to your account against Payables relevant to to order.
All the fields available in the above sheet are explained in the Glossary section of this article.
The amount that you receive in your bank account should be the same as the 'total amount' column in the payout statement.
How Eshopbox reconciles Amazon Payouts
For Amazon, the Eshopbox app considers order Id and SKU as a unique reference number. Eshopbox app will scan through each row in all of the sheets and perform actions as per the details below:
The Eshopbox app may record a payment against the receivable corresponding to an order ID and SKU mentioned in the columns 'order-id' and 'sku' respectively. The payment will be the sum of positive values in the column ‘amount’ if column ‘amount-description’ includes one of the following values:
Principal, Product Tax, Product tax discount
Shipping, Shipping tax, Shipping discount, Shipping tax discount,
Promo rebates.
Gift wrap, Gift Wrap Tax,
If the value in the “amount” column is negative, the Eshopbox app will record a refund.
Eshopbox will also record a payment for ‘amount-description’ includes one of the following values:
CS_ERROR_ITEMS,
REMOVAL_ORDER_DAMAGED,
WAREHOUSE_DAMAGE,
MULTICHANNEL_ORDER_LOST,
MULTICHANNEL_ORDER_DAMAGED,
Reimbursement for Lost packages,
SAFE-T Reimbursement. All such payments will be tagged as Reimbursement amount.
Eshopbox will then create a new payable and reconcile it with various fees created in your workspace according to the table below:
Row values of column ‘amount-description’ | Fee name it is reconciled with |
|---|---|
Order Cancellation Charge | Cancellation |
Commission + Shipping commission + Refund commission | Commission Fee |
Amazon Easy Ship Charges | Easy Ship Fee |
Fixed closing fee | Fixed closing fee |
MFNPostagePurchaseCompleteIGST + OrderCancellationChargeIGST | Other Taxes |
Shipping Chargeback | Shipping Chargeback |
Commission IGST + FBA Weight Handling Fee CGST + FBA Weight Handling Fee SGST + Fixed closing fee IGST + Shipping Chargeback CGST + Shipping Chargeback SGST + Shipping commission IGST + Technology Fee IGST + Refund commission IGST + Commission SGST + Commission CGST + Fixed closing fee SGST + Fixed closing fee CGST + Technology Fee CGST + Technology Fee SGST | Taxes |
TCS-CGST + TCS-IGST + TCS-SGST | TCS |
Technology Fee | Technology Fee |
FBA Weight Handling Fee | Weight Handling Fee |
If the payable was already created, Eshopbox will adjust the payable amount accordingly and reconcile again.
4. The Eshopbox app may create a suspense record if there is a difference in the settlement amount and sum of amount for payment, refund, reimbursement as described in 1st and 2nd point and all field mentioned in the above table under Row values of column ‘amount-description’ corresponding to an order ID and SKU mentioned in the columns 'order-id' and 'sku' respectively.
GLOSSARY
Columns of payout statement:
Column Name | Description |
|---|---|
settlement-id | 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 is 20. |
settlement-start-date | The start date of the settlement period. This is an alphanumeric value. Total number of characters is 25. |
settlement-end-date | The end date of the settlement period. This is an alphanumeric value. Total number of characters is 25. |
deposit-date | The date that the fund transfer for the settlement period will be sent to the seller's bank account. This is an alphanumeric value. Total number of characters is 25. |
total-amount | The sales amount to be deposited into the seller's bank account. |
currency | The currency for the transaction. All order, adjustment, fee and event data will have the same currency. |
transaction-type | Text description of transaction type |
order-id | Amazon's unique, displayable identifier for an order. This is an alphanumeric value. |
order-item-id | Amazon's unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14. |
merchant-order-id | ID assigned by Amazon or sellers |
adjustment-id | Transaction ID for Adjustments |
shipment-id | Order transaction type ID |
marketplace-name | The name of the marketplace where the order was placed. This value is a string with a maximum length of 50 characters. |
delivery-fee-type | The type of delivery fee as "Order", "Adjustment" or "MiscEvent". |
delivery-fee-amount | The amount of the delivery fee |
order-fee-type | The type of fee charged in the order-fee-amount column. |
order-fee-amount | The amount of a particular fee charged for this order. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
fulfillment-id | Fulfilment type such as Merchant (MFN) or Amazon |
posted-date | The date on which the item (order, adjustment, misc or other) was debited or credited to the seller's account. This is an alphanumeric value. Total number of characters is 25. |
order-item-code | Amazon's unique, displayable identifier for an item within the order. This is a numeric value. Total number of digits is 14. |
merchant-order-item-id |
|
merchant-adjustment-item-id |
|
sku | A seller-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. |
quantity-purchased | The number of these items that were purchased. This is a numeric value. The maximum number of digits is 12. |
item-promotion-id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. |
shipping-promotion-id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. |
promotion-id | Seller-specified promotion ID. This is an alphanumeric value. The maximum number of characters is 50. |
promotion-type | The type of promotion referred to by the values in the promotion-id and promotion-amount columns. |
Row values of column 'amount-description':
Row value | Description |
|---|---|
CS_ERROR_ITEMS | This is an error adjustment, related to or performed by customer service department. Most often it's a positive deposit to your account, made after Amazon overcharges you on something. To correct previous charges, they issue a deposit to you which shows up in other transactions |
CS_ERROR_NON_ITEMIZED | This is an error adjustment, related to or performed by customer service department. Most often it's a positive deposit to your account, made after Amazon overcharges you on something. To correct previous charges, they issue a deposit to you which shows up in other transactions |
Incorrect_fee_item | This fee is exactly what it says - Amazon adjustments for incorrect fees |
Reversal reimbursement |
|
INCORRECT_FEES_NON_ITEMIZED | This is a clawback where error adjustments should not have happened |
FREE_REPLACEMENT_REFUND_ITEMS | Refund against the items of free replacement |
PAYMENT_RETRACTION_ITEMS | Payment retraction is done as a clawback where reimbursement should not have happened in first place |
REMOVAL_ORDER_DAMAGED |
|
WAREHOUSE_DAMAGE | Refund against damages happened at Amazon warehouse |
MULTICHANNEL_ORDER_LOST | Adjustment against lost order |
MULTICHANNEL_ORDER_DAMAGED | Adjustment against damaged order |
Commission | The commission fee charged according to the category of the product by the portal |
Commission IGST | IGST on commission |
Fixed closing fee | The fee which is charged on all successful orders |
Fixed closing fee IGST | IGST on fixed closing fee |
Refund commission | Weight handling fee for products delivered by Easy Ship |
Refund commission IGST | IGST on refund commission |
FBA Weight Handling Fee | Weight handling fee for FBA products |
FBA Weight Handling Fee CGST | CGST on FBA Weight Handling Fee |
FBA Weight Handling Fee SGST | SGST on FBA Weight Handling Fee |
Technology Fee |
|
Technology Fee IGST | IGST on technology fee |
Shipping Chargeback | The amount Amazon retains towards shipping charges paid by the buyer in case of Amazon fulfilled orders |
Shipping Chargeback CGST | CGST on shipping chargeback |
Shipping Chargeback SGST | SGST on shipping chargeback |
Shipping commission | Commission charged on shipping cost in case seller charge shipping from customers additionaly |
Shipping commission IGST | IGST on shipping commission |
Principal |
|
Product Tax | The Product Tax is the tax amount that you must remit to the GST authorities as tax on the products or services you sell. |
Shipping | Shipping charges paid by buyer in case of Amazon fulfilled orders |
Shipping Tax | Tax on shipping |
Goodwill | Amount refunded to buyer which will be paid from Amazon. This expense is reimbursed under FBA inventory reimbursement |
TCS-CGST | Tax |
TCS-SGST | Tax |
TCS-IGST | Tax |
Promo Rebates Tax IGST | Tax |
Reimbursement of lost package | Refund for packages lost |
SAFE-T Reimbursement | claim reimbursement from Amazon for losses incurred due to Easy Ship and MFN Gold program. Products that are damaged by Amazon during onward or return transit are covered under this |
Previous Reserve Amount Balance | Funds held over from the previous statement that are being added back into the current statement. |
Current Reserve Amount | Funds held over between statements, usually due to pending A-to-z Guarantee claims or chargebacks. |
Misc Adjustment |
|
Storage Fee | Fee charges for using the space in fulfillment centers. Storage fees are charged for all Units stored in an Amazon fulfillment center based on calendar month and your daily average volume (measured in cubic feet). |
Storage fee tax | Tax |
Tax Withholding Reimbursement | Reimbursement against the settlement of Tax Withholding |
StorageRenewalBilling | Renewal of storage fee |
StorageRenewalBilling CGST | Tax |
StorageRenewalBilling IGST | Tax |
MFN postagepurchasecompleteIGST | This is Amazon Easyship charges IGST |
Amazon easyship charges | Easy ship fee which will be charged based on dimensions and weight of the product |
Commission correction | Adjustments for commission fee |
RemovalComplete | charged when a removal order is created and completed |
RemovalCompleteCGST | Tax |
RemovalCompleteSGST | Tax |
NonSubscriptionFeeAdj | Adjustment for the monthly charges for your selling plan and other prorated amounts for new subscriptions added mid-cycle. |
Product tax discount | This is promo rebate IGST |
Promo rebates | Rebates are given by Amazon under FBA inventory |
Shipping discount | Discount is given on shipping under FBA inventory |
Shipping tax discount | Discount is given on shipping tax under FBA inventory |
Order cancellation | 8.5% of the value of items in an order as Cancellation Charge for self-fulfilled orders that are canceled |
OrderCancellationChargeIGST | Tax |
PAYMENT_RETRACTION_ITEMS | Payment retraction is done as a clawback where reimbursement should not have happened in first place |
Goodwill | Amount refunded to the buyer which will be paid from Amazon. This expense is reimbursed under FBA inventory reimbursement |
Promo Rebates Tax IGST | IGST on promo rebates |
Commission correction | Adjustments for a commission fee |
RemovalComplete | charged when a removal order is created and completed |
RemovalCompleteCGST | Tax |
RemovalCompleteSGST | Tax |
NonSubscriptionFeeAdj | Adjustment for the monthly charges for your selling plan and other prorated amounts for new subscriptions added mid-cycle. |
price-type | The type of price specified in the price-amount column. |
price-amount | The amount that the buyer paid for the type of price specified in the price-type column. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
item-price-credit | The amount that the buyer paid for the item. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
item-tax-credit | The amount, if any, that the buyer paid in tax on the item. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
shipping-price-credit | The amount that the buyer paid for shipping. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
shipping-tax-credit | The amount, if any, that the buyer paid in tax on shipping. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
gift-wrap-price-credit | The amount that the buyer paid for gift wrap. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
gift-wrap-tax-credit | The amount that the buyer paid for tax on gift wrap. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
item-related-fee-type | The type of fee charged in the item-related-fee-amount column. |
item-related-fee-amount | The amount of a particular fee charged in relation to this item. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
order-related-fees | The amount of fees charged for this order, usually commission. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
other-fees | The amount of miscellaneous charges/credits to the account. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
misc-fee-amount | No longer used |
other-fee-amount | The amount of miscellaneous fees charged to your seller account. |
other-fee-reason-description | Miscellaneous fees that are not related to the monthly selling plan. |
promotion-amount | The amount of promotional discount applied to the item in accordance with the promotion specified in the promotion-id column. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
item-promotion-discount | The amount of promotional discount applied to the item's principal. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
shipping-promotion-discount | The amount of promotional discount applied to shipping. This is a numeric value, with a maximum of 18 digits to the left of the decimal place and 2 digits to the right of the decimal place. |
other-amount | Additional charges or credits that do not fall under the Order or Adjustment transaction types. The transaction type for this amount will be specified in the transaction-type column. |