Understanding your Flipkart Payout Statement
- Rita Saini (Unlicensed)
- Mayur Karwa
Payout statement provides a detailed breakdown of your account activity for a given settlement period. Payout statement is generated regularly, and you can download them from seller account on Flipkart. Understanding payout statement will help you to know, how to:
Download the payout statement
Read a payout statement
How Eshopbox reconcile Flipkart payout
Download the Payout Statement
Log in to the Flipkart seller account using your credentials.
Go to Payments in the top menu.
From the dropdown, click on the previous payments option.
All the settled payments “Prepaid” and “Postpaid” will be displayed.
Select the month for which you want to download the payout statement. All the transactions will be available on this page.
Click on the transaction you want to download payment report for and click on “Request Download”.
Download the reports and upload this to add a payout in Eshopbox App.
Reference link: https://seller.flipkart.com/LearningCenter/node/448393
Flipkart provides payout in two types of report:
Prepaid: The mode of payment by the customer for this payout was credit card, debit card, UPI, etc.
Postpaid: The mode of payment by the customer for this payout was cash, credit card, debit card, etc.
Reading a payout statement
Flipkart’s payout statement contains seven sheets. Following table describes their usage:
Report Help: This sheet helps you in understanding the contents of the payout statement.
Orders: Contains a summary of all transactions related to orders received for your products. It includes information about settled payments only. Each row in the Orders Sheet represents the amount settled corresponding to a particular item in an order. The amount settled may include
Amount paid to you or refunded from your account against Receivable for the item in the order.
Amount deducted or reversed to your account against Payables relevant to the item in the order.
Non-Order SPF: This contains a summary of all settled protection fund transactions related to items lost in the fulfillment center.
Storage & Recall: This sheet contains a summary of all settled transactions related to storage and removal services availed by you. This sheet will only have data if you are availing Flipkart service for storing your product.
Ads: Contains a summary of all settled ad transactions.
TDS: This sheet contains a summary of all settled transactions against TDS claims filed by you.
Tax Detail: It contains information about which service was taxed, which fee was taxed, what was the state, and the unique ID to identify the order, listing, or ads campaign.
All the fields available in any of the above sheets are explained in the Glossary section of this article.
The amount that you receive in your bank account should be the sum of the settlement value (Rs.) column from Order sheet, Non-order SPF sheet, Storage & recall, and Ads sheet.
How Eshopbox reconciles Flipkart Payouts
For Flipkart, the Eshopbox app considers order Id and seller 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:
For each row, Eshopbox app will record a payment against the receivable for the order. The paid amount will be the sum of the sale amount, total offer amount, and my share.
for each row, Eshopbox app may record a refund against the receivable for the order. The refund amount will be the sum of the refund
For each row, Eshopbox app will create a new payable for each order. It will then reconcile it with various fees created in your workspace according to the table below:
Column name | Reconciled against |
|---|---|
Commission + Commission fee waiver | Commission fee |
Collection Fee + Collection Fee Waiver | Collection Fee |
Fixed Fee + Fixed Fee Waiver | Fixed Fee |
Pick And Pack Fee + Pick And Pack Fee Waiver | Pick and Pack Fee |
Shipping Fee + Shipping Fee Waiver | Shipping Fee |
Reverse Shipping Fee | Reverse Shipping Fee |
Taxes | Taxes |
Tax collected at source | TCS |
If the payable was already created, Eshopbox will adjust the payable amount accordingly and reconcile again.
4. Eshopbox app will create a suspense record if there is a difference in the settlement amount and sum of the sale amount, total offer amount, my share, protection fund, refund, and all field mentioned in the above table under column name.
GLOSSARY
Order Sheet:
Field name | Description |
|---|---|
NEFT ID | NEFT reference number is an acknowledgment number given after a bank transaction take place in order to identify that transaction. |
Date | Date of settlement |
Settlement Value | Amount paid as the final payment for the product. The amount was settled after the deduction of taxes and marketplace fees charged on the sale amount. |
Order ID | An order ID is a unique number which you'll need to identify and track your orders. |
Order Item ID | An order item id is a unique number which you'll need to identify and track different item in the same order. |
Sale Amount | A sale amount is the final value of the product received by you after the sale. The buyer gets the goods in exchange for a specific amount of money. |
Total Offer Amount | The total offer amount is a value which is calculated when any offer or discount is applied to the product. |
My Share | Offer amount contribution for your side |
Customer Shipping Amount | Shipping charged applied to the customer |
Marketplace Fee | The marketplace fee is a percentage of revenue that is taken out of all items in order like pick pack fee, shipping fee, commission fee, fixed fee, and Reverse shipping fee. |
Tax collected at source | Under Section 52 of GST Act, TCS refers to the tax which is collected by the Electronic Commerce Operator (ECO) and to be remitted to your SGST, CGST or IGST accounts when you supply goods or services through your portal and the payment for that supply is collected by the ECO. |
Taxes | A tax is a compulsory financial charge or some other type of levy imposed upon you by a governmental organization in order to fund various public expenditures. This field contains the total taxes charged. |
Protection fund | Seller Protection fund is a fund that protects you from losses incurred due to customer returns or courier returns received in an unacceptable state via compensation from the Seller Protection Fund (SPF), thus ensuring that you do not get impacted. Furthermore, this program has been designed to safeguard your interests and make Flipkart a secure medium to conduct business. |
Refund | Refund amount is money that is given back to the customer who has returned a product. As you have received payment for this product, this is charged from you, and the product is returned to you. |
Order date | The date on which order is placed |
Dispatch Date | The date on which order is dispatched |
Order Type | The mode through which payment is made. It can be prepaid or postpaid |
Fulfillment Type | Fulfillment type defines how is the order fulfilled i.e the fulfillment model which you have selected. These can be the following: Seller fulfillment: You are responsible for processing and managing your orders and inventory. Once you have packed your orders and marked RTD, a Flipkart logistic partner will collect this package and deliver it to the respective customer. Smart fulfillment: This is a program wherein you get help from Flipkart for systematically arranging your warehouse, easily maintaining your inventory and getting it smoothly delivered to your customer via a Flipkart logistics partner. Flipkart fulfillment: Flipkart Fulfilment is a type that allows sellers to use Flipkart's 3rd party warehousing and shipping services. Self-ship or drop-ship fulfillment: This is a type of product fulfillment that occurs directly from the manufacturer or wholesaler to the customer when the order is placed. |
Seller SKU | A unique alphanumeric identifier of the product. |
Quantity | Number of items in an order |
Product Subcategory | Category to which the product belongs. |
Additional Information | Additional Information if any |
Return Type | In case the product is returned, these fields tell whether the product was returned by customer or courier |
Item Return Status | Status whether the product returned by the customer/courier is delivered to you or not. |
Sale Amount | A sale amount is the final value of the product received by you after the sale. The buyer gets the goods in exchange for a specific amount of money. |
Total Offer Amount | The total offer amount is a value which is calculated when any offer or discount is applied to the product. |
My Share | Offer amount contribution for your side |
Tier | Seller tiering is a measure of your performance against Flipkart standards. It ranks your performance against other sellers on the specified metrics and helps you understand your position on the marketplace. This field can have one of the following value: Gold, silver, bronze |
Commission Rate | According to the category of the product, a certain percentage of commission is charged. This field depicts the percentage of commission charged. |
Commission (Rs.) | The commission fee charged according to the category of the product by the portal. It is calculated as a percentage of the order item value |
Commission Fee Waiver(Rs.) | Waiver received on commission fee because of any promotion, campaign, etc. |
Collection Fee (Rs.) | Payment collection charges for orders placed on Flipkart's platform and varies for prepaid and COD orders |
Collection Fee Waiver(Rs.) | Waiver received on collection fee due to any promotion, campaign, etc. |
Fixed Fee (Rs.) | This fee is charged on every successful sale on Flipkart's platform that is an order which is not returned or cancelled. |
Fixed Fee Waiver(Rs.) | Waiver received on fixed-fee due to any promotion, campaign, etc. |
No Cost EMI Fee Reimbursement(Rs.) | When the product is purchased on EMI, 0% interest is applied. But there is a relation with you because you receive a regular payout and reimbursement of the refund is done in one go. |
Installation Fee (Rs.) | The fee to charged to install the product once the shipment is delivered to the buyer. For example- Electronic items (AC, Machine). |
Uninstallation Fee (Rs.) | In case of replacement and return the product like electronic item was uninstalled from the customer’s place. This fee is charged to you and product is delivered to you. |
Tech Visit Fee (Rs.) | It's a type of fee when some issue with the product after it was delivered to the customer. |
Uninstallation & Packaging Fee (Rs.) | In case of replacement and return the product like electronic item was uninstalled, and packed again, a fee is charged to you. The product is delivered to you. |
Pick And Pack Fee | Pick and Pack fee charge by the Flipkart portal. |
Pick And Pack Fee Waiver(Rs.) | Waiver received on pick and pack fee due to any promotion, campaign, etc |
Customer Shipping Fee Type | Eshopbox app does not consider this column. |
Customer Shipping Fee | When the shipping fee applied to customers under the product range. |
Shipping Fee (Rs.) | This fee is charged for shipping order items to the customer. It is calculated based on the higher of volumetric weight or dead weight of the product when measured with secondary packaging. |
Reverse Shipping Fee (Rs.) | Charged for reverse pick-up and shipping when customers return a product and vary based on chargeable weight and shipment zone. |
Shipping Fee Waiver(Rs.) | Waiver received on shipping fee due to any promotion, campaign. |
Franchise Fee (Rs.) | Payments to franchisees held liable to TDS us 194C not 194J. The modus operandi for collection of the fees as well as of the revenue sharing cannot determine whether the amount remitted by the assessee to the franchisee is subject to tax deduction at source u/s 194J |
Product Cancellation Fee (Rs.) | This fee is charged when you cancel an order. It varies based on whether the order was cancelled before or after marking an order ready for dispatch. Auto-cancellations due to multiple failed pick-up attempts and SLA breach are also considered Seller cancellations. |
Service Cancellation Fee(Rs.) | If the fault is on the part of the seller on non-delivery of the product, Flipkart considers it as seller cancellation. The seller cannot cancel such a product from the system himself. The same is initiated by Flipkart itself. In such a case, the seller's account is charged a cancellation fee in addition to related taxes. The same is much higher than the charge on the seller for cancellation before marking a product RTD. |
Fee Discount (Rs.) | Discount received in any fee |
Service Cancellation Charge(Rs.) | If the fault is on the part of the seller on non-delivery of the product, Flipkart considers it as seller cancellation. However, the seller cannot cancel such a product from the system himself. In such a case, the seller's account is charged a cancellation fee in addition to related taxes. |
Multipart Shipment? | If there are multiple items in an order, there is a possibility that the order is shipped in multiple shipments. This field depicts if the order was shipped in single or multiple shipments |
Profiler Dead Weight | If your product weight was provided incorrectly on the listing, the team will check the weight of the product. Then compare on the system and feed the weight according to the inspection. |
Seller Dead Weight | The weight of the product you have provided for the product on the listing. |
Length*Breadth*Height | The weight of the product you have provided for the product on the listing. Weight is the exact weight of the shipment as per the weighing machine. |
Volumetric Weight(In Kgs) | Length, breadth, and height of the product. |
Chargeable Weight Type | The volumetric weight of the product in kgs. Weight is calculated with the help of the dimension of the product (L*B*H). |
Chargeable Wt. Slab (In Kgs) | Type of weight that is considered: Dead: Weight is the exact weight of the shipment as per the weighing machine. Volumetric: Weight is calculated with the help of the dimension of the product (L*B*H). |
Shipping Zone | Zone to which order is shipped. |
ID | Unique Id to identify invoice. |
Date | The date on which invoice is generated. |
Amount | Amount of invoice. |
Non SPF Order Sheet:
Column Name | Description |
|---|---|
NEFT ID | NEFT reference number is an acknowledgment number given after a bank transaction takes place in order to identify that transaction. |
Date | Date of settlement. |
Settlement Value | Settlement amount is the net amount paid corresponding to the claim id. |
Claim ID | Unique id to identify the claim raised for products. |
Protection Reason | The reason why the protection claim is raised by you |
Seller SKU | A unique alphanumeric identifier of the product. |
FSN | FSN Stands For Flipkart Serial Number. Every product listed on Flipkart is assigned a unique FSN. |
Selling Price (Rs.) | Selling Price of the product. |
Warehouse ID | Unique id to identify the warehouse from which order was shipped. |
Storage & Recall
Field Name | Description |
|---|---|
NEFT ID | NEFT reference number is an acknowledgment number given after a bank transaction takes place in order to identify that transaction. |
Date | Date of settlement. |
Settlement Value | Settlement amount is the amount charged for using Flipkart’s warehouse. |
Service Name | Name of service used. |
Listing ID | A listing is the complete information of a product that buyers view before placing an order. It contains details such as stock, price, delivery period, and so on. It is identified by a listing ID, which is mapped to the SKU ID. |
Recall ID | A unique number to identify products that are recalled. |
WareHouse State Code | Warehouse is in which state. Every state can be identified by a unique code. |
FSN | FSN Stands For Flipkart Serial Number. Every product listed on Flipkart is assigned a unique FSN. |
MarketPlaceFees(Rs.) | The marketplace fee is a percentage of revenue that is taken out of all items in order like pick pack fee, shipping fee, commission fee, fixed fee, and Reverse shipping fee. |
Taxes(Rs.) | A tax is a compulsory financial charge or some other type of levy imposed upon you by a governmental organization in order to fund various public expenditures. This field contains the total taxes charged. |
Removal Fee Units | Number of units removed from Flipkart warehouse. |
Removal Fee | Fee charged by Flipkart for removing your product(s) from their warehouse. |
Storage Fee Units | Number of units stored in Flipkart warehouse. |
Storage Fee (upto Jun 30, 2016) | The fee charged for using Flipkart warehouse space. |
Sellable Regular Storage Units | Number of product units that are available for sale. |
Sellable Regular Storage | This fee is charged for storing inventory in Flipkart's warehouses. It varies based on the weight and age of the inventory. Weight is calculated as the volumetric weight or dead weight, whichever is higher when measured with primary packaging. And this is the product which was in a sellable condition and there is demand from the buyer side. Age slabs for Sellable inventory Regular: < 4 months Note it will be applied according to Flipkart rate card. |
Unsellable Regular Storage Units | Inventory that cannot be made available for sale. It is rejected during the inspection. The inspection could be during various activities at FC - receiving the consignment, receiving returns, etc. |
Unsellable Regular Storage | This fee is charged for storing inventory in Flipkart's warehouses. It varies based on the weight and age of the inventory. Weight is calculated as the volumetric weight or dead weight, whichever is higher when measured with primary packaging. And the same this order was damage, diffracting and no order was placed for the Flipkart buyer. Age slabs for UnSellable inventory Regular: < 1 month Note it will be applied according to Flipkart rate card. |
Sellable Longterm 1 Storage Units | The number of sellable units in Flipkart’s warehouse from 4-6 months. |
Sellable Longterm 1 Storage | The fee that is charged for sellable units in Flipkart’s warehouse from 4-6 months. |
Unsellable Longterm 1 Storage Units | The number of units that are unsellable (can be because of QC failure or other reasons) and is in Flipkart’s warehouse from 1-2 months. |
Unsellable Longterm 1 Storage | Fee that is charged for unsellable items (can be because of QC failure or other reasons) and is in Flipkart’s warehouse from 1-2 months. |
Sellable Longterm 2 Storage Units | The number of sellable units in Flipkart’s warehouse for more than 6 months. |
Sellable Longterm 2 Storage | Fee that is charged for sellable units in Flipkart’s warehouse for more than 6 months. |
Unsellable Longterm 2 Storage Units | The number of units that are unsellable (can be because of QC failure or other reasons) and is in Flipkart’s warehouse for more than 2 months. |
Unsellable Longterm 2 Storage | Fee that is charged for unsellable items (can be because of QC failure or other reasons) and is in Flipkart’s warehouse for more than 2 months. |
Product Sub Category | Category to which the product belongs. |
Dead Weight (In Kgs) | The weight of the product you have provided for the product on the listing. Weight is the exact weight of the shipment as per the weighing machine. |
Length*Breadth*Height | Length, breadth, and height of the product. |
Volumetric Weight(In Kgs) | The volumetric weight of the product in kgs. Weight is calculated with the help of the dimension of the product (L*B*H). |
Chargeable Wt. Slab (In Kgs) | Type of weight that is considered: Dead: Weight is the exact weight of the shipment as per the weighing machine Volumetric: Weight is calculated with the help of the dimension of the product (L*B*H). |
Chargeable Weight Type | There are different slabs for weight according to which fee is charged. This field depicts the range in which the product falls. |
Ads
Column Name | Description |
|
|---|---|---|
NEFT ID | NEFT reference number is an acknowledgment number given after a bank transaction takes place in order to identify that transaction. |
|
Date | Date of settlement. |
|
Settlement Value | Amount paid as the final payment for the product. The amount was settled after the deduction of taxes and marketplace fees charged on the sale amount. |
|
Type | Type of transaction: RESERVE = Money allocated to campaign |
|
Campaign / Transaction ID | Unique Id to identify each campaign/ transaction. |
|
Wallet Redeem (Rs.) | Amount used from wallet for campaign. |
|
Wallet Redeem Reversal (Rs.) | Amount reversed to wallet. |
|
Wallet Topup (Rs.) | Amount which you have added to your wallet to manage your campaign. |
|
Wallet Refund (Rs.) | Refund that you receive in your wallet from flipkart. |
|
Taxes (Rs.) | Total taxes charged. |
|
TDS
Column Name | Description |
|---|---|
NEFT ID | NEFT reference number is an acknowledgment number given after a bank transaction takes place in order to identify that transaction. |
Date | Date of settlement. |
Settlement Value | The commission that you pay Flipkart includes the TDS amount. This field contains field amount deducted as TDS for corresponding claim id. |
Id | Claim Id to uniquely identify any claim. |
Date | Claim date |
Tax Details
Column Name | Description |
|---|---|
Service Type | Type of service for which tax is deducted: Order item, Ads, etc |
Order Item ID/ Listing ID/ Campaign ID/Transaction ID | Unique id to identify the product for which tax is charged. |
Recall ID | A unique number to identify products that are recalled. |
Warehouse State Code | Warehouse is in which state. Every state can be identified by a unique code. |
Fee Name | Name of fee for which tax is charged. |
Fee Amount (Rs.) | Total fee amount charged. |
CGST Rate | Central Goods & Services Tax rate that is applicable. |
SGST/UTGST Rate | State Goods & Services Tax/Union Territory Goods and Service Tax rate that is applicable. |
IGST Rate | Integrated Goods & Services Tax rate that is applicable. |
CGST Amount | Amount applicable according to CGST rate. |
SGST/UTGST Amount | Amount applicable according to SGST/UTGST rate. |
IGST Amount | Amount applicable according to IGST rate. |
Fee Amount (Rs.) | Total fee amount charged. |
Fee Waiver (Rs.) | The fee waiver given, if applicable. |
Service Tax Rate | Tax charged for using Flipkart services. The service tax rate is 18%. The service tax rate is subject to change basis subsequent notifications from the government of India. |
KKC Rate | Krishi Kalyan Cess is a levy/tax imposed by the Union Government on all services, which are liable to service tax, at the rate of 0.5% for financing improvement of agriculture and welfare of farmers. This field contains the rate charged under KKC. |
SBC Rate | Swachh Bharat Cess is a levy/tax imposed by the Union Government on all services, which are liable to service tax, for raising funds for the Sanitation campaign of the Government known as Swachh Bharat Abhiyan. This field contains the rate charged under SBC. |
Service Tax Amount | Amount charged according to service tax rate. |
KKC Amount | Amount of Krishi Kalyan cess charged. |
SBC Amount | Amount of Swachh Bharat cess charged. |
Amount (Rs.) | Total tax amount. |