Understanding your Paytm Payout Statement
- Payal Mehndiratta (Unlicensed)
- Rita Saini (Unlicensed)
- Sauharda Rawat (Unlicensed)
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 the seller account on Paytm. Understanding payout statement will help you to know, how to:
Download the payout statement
Read a payout statement
How Eshopbox will reconcile Paytm payouts
Download the Payout Statement
Login into the Paytm seller account using your credentials
Go to the payments on the side panel and click on Payouts from the dropdown
Select Settlements
When you have UTR ID and Warehouse ID
Click on the select filter and select UTR from the dropdown. Provide UTR ID in the “Enter UTR column” and click on search. Settlements for that particular year will appear.
When you do not have UTR ID or Warehouse ID
Click on Payment creation date field
Select the date range and click apply.
Click on the download button on the right. File will get downloaded in recent files section available on the same screen.
In recent file click on the download button corresponding the file you want to download
Payout report will be downloaded in the zip folder & will consist of following reports
Merchant payout report
Order summary report
Here we consider the Order summary report
Download the Order summary report and upload this to add a payout in Eshopbox app.
A sample of order summary report is shown in the image
Reference link: https://gobig.paytmmall.com/payments/
Reading a payout statement
Each column in the Paytm payout statement represents the amount settled corresponding to a particular order. In every row, detail about a single Order ID is provided.
Amount that is paid to you or refunded from your account against Receivable for an order
Amount that is deducted or reversed to your account against Payable relevant to an Order.
All the fields available in the above reports are explained in the Glossary section of this article.
The amount that you receive in your bank account should be the sum of the ‘Payable amount’ column in the order summary report.
How Eshopbox reconciles Paytm Payouts
For Paytm, the Eshopbox app considers order Id and Merchant 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 may record a refund against the receivable corresponding to a particular order. The amount under column “payable amount” will be recorded with a negative sign i.e. as deduction if the value in the column “order item status” is “returned” or ”rto_initiated” or ”rto delivered” or ”liquidated” or ” item return lost” or ” item lost”.
For each row, Eshopbox will record a payment against the receivable corresponding to a particular order. The amount under the column “payable amount” will be recorded with a positive sign i.e. as payment received if the value in the “order item status” is not “merchant cancelled” or“returned” or ”rto_initiated” or ”rto delivered” or ”liquidated” or ” item return lost” or ” item lost”.
The Eshopbox app will create a new payable for each order. It will then reconcile it with various fees created in your workspace. There can be the following scenarios:
If Eshopbox app is recording a payment against a receivable corresponding to a particular order all fees will be recorded with a negative sign i.e. as a deduction.
The reverse shipping fee will be calculated by adding 18% tax to the amount deducted. To illustrate: if INR 100 is charged as a reverse shipping fee, it will be recorded as INR 118 in Eshopbox app.
If Eshopbox app is recording a refund against the receivable then all fees expect reverse shipping will be recorded with a positive sign i.e. as a refund.
If the payable was already created, Eshopbox will adjust the payable amount accordingly and reconcile again.
The Eshopbox app will create a suspense record using the following formula: Suspense amount = Total price - payable amount - sum of all fields mentioned in the below table under the column name.
Column Name | Reconciled Against |
|---|---|
Logistic Charges | Shipping Fee |
Marketplace commission | Commission Fee |
PG Commission | Payment Gateway Commission |
Cancellation Penalty - Logistics Amount | Reverse Shipping Fee |
TCS CGST + TCS SGST + TCS IGST | TCS |
mp_commission_cgst + mp_commission_igst + mp_commission_sgst + pg_commission_cgst + pg_commission_igst + pg_commission_sgst + logistics_cgst + logistics_igst + logistics_sgst + merchant_cancel_pg_penalty_cgst +merchant_cancel_pg_penalty_sgst +merchant_cancel_pg_penalty_igst |
Taxes |
Net Adjustment | Penalty |
For Paytm, the Eshopbox app considers order Id and Merchant 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 will record a payment against the receivable corresponding to a particular order. Payment will be the sum of positive values in a column ‘Payable Amount’ if column “Order Item status” includes one of the following values: Delivered, Return rejected.
For each row, Eshopbox app may record a refund against the receivable corresponding to a particular order. The refund amount will be the sum of negative values in the column ‘Payable Amount.
The 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 |
|---|---|
Cancellation penalty | Cancellation penalty |
Commission fee | Commission fee |
Courier Fee Adjustment | Courier Fee Adjustment |
Damaged Return claim | Damaged Return claim |
PG Commission | Payment Gateway Commission |
Reverse Shipping Fee + Logistic Penalty | Logistic Penalty |
PG Penalty | PG Penalty |
TCS CGST + TCS SGST + TCS IGST | TCS |
mp_commission_cgst + mp_commission_igst + mp_commission_sgst + pg_commission_cgst + pg_commission_igst + pg_commission_sgst + logistics_cgst + logistics_igst + logistics_sgst + CANCELLATION PENALTY IGST adjustment + SLA BREACHED PENALTY IGST adjustment + Merchant Cancellation PG Penalty IGST adjustment + Marketplace Logistics Charges IGST adjustment |
Taxes |
SLA Penalty | SLA Penalty |
Shipping Fee | Shipping Fee |
Seller Cancellation Fee | Seller Cancellation Fee |
If the payable was already created, Eshopbox will adjust the payable amount accordingly and reconcile again.
4. The Eshopbox app will create a suspense record if there is a difference in the ‘Payable amount’ and all fields mentioned in the above table under the column name.
GLOSSARY
Merchant Payout report
Field name | Description |
|---|---|
Merchant ID | Unique code provided to the merchants against the Paytm account |
Payment Type | The type of payout whether
|
Settlement Date | The date on which amount for a specific transaction is settled |
Payment Date | Date on which payout is released |
Payment Mode | The mode by which a payment is made
|
Unique Transaction Reference Number | Number visible on the received transfer |
Payment status | Status that shows whether the payment is paid or rejected |
Payment amount | The amount paid to you |
Bank account number | It is the primary identifier for the bank account. The payable amount gets transferred to the same. |
Beneficiary name | Name of the Party |
Order summary report
Field Name | Description |
|---|---|
Order Creation date | The day on which the order was placed by a customer |
Order Id | Unique ID for your order |
Order item ID | Unique ID for your items in an order |
Product Name | Name of the product in your order |
Merchant SKU | Unique alphanumeric ID for your product-provided by you |
Current Item status | View status of your order whether shipped, delivered, returned |
Total price | Selling price of your products |
Product ID | Product identification number |
Payable amount | The amount payable to you post deductions |
Payment Type - The type of payout |
|
Payment details | Detailed information on payment type with respect to courier charges, commission revision, penalty, recovery |
Payment status |
|
Payment date | Date on which payout is released to you via
|
Relevant Information | Information related to the order Example: order is delivered/ Returned/ SLA breach of ship by data etc. |
Relevant Event date | Event date on which relevant information status is updated |
Customer Payment | Amount paid by the customer for the order |
Marketplace commission | Marketplace commission charged to you for the order |
Marketplace Commission GST details | GST charged on the marketplace commission for the order |
Payment Gateway fees | Payment gateway fee charged to you for the order |
Payment gateway fees GST | Details GST charged on the payment gateway fee |
Marketplace Logistics charges | In case you are using Paytm Mall courier service, then the logistics fee is charged to you for the order |
Marketplace Logistics charges GST | GST charged on marketplace logistics charges |
TCS GST details | TCS (Tax Collected at Source) charged on the base price |
Other charges | Penalty or other fee is charged to you for the order |
Other charges GST details | GST charged on the other charges |
Customer payment PG | amount paid by the customer via the Online/Wallet payment mode |
Customer payment COD | Amount paid by the customer via the cash on delivery payment mode |
Customer payment wallet | Amount paid by the customer via the wallet payment mode will reflect in the customer Payment PG column |
HSN code | The HSN code of the product |
Shipping Fee | Shipping amount paid by the customer for the order |
Shipping Fee GST detail | GST charges on the shipping amount paid for the order |
Shipping TCS GST details | TCS charged on the base value of shipping amount paid by the customer |
GST | Goods & service tax applicable as per the rate |
CGST |
|
Source State | Name of the state of your warehouse |
GST Destination state | Name of the state of the customer |
Source Pincode | Pincode of the state of your warehouse |
GST destination Pincode | Pincode of the state of the customer |
Invoice Generation date | Date on which the invoice is generated for the order |
Invoice Number | The invoice number of the generated invoice for the order |
Merchant GSTIN |
|
IMEI (International Mobile Equipment Identity) number | In case this is an electronic product, then you can check IMEI or serial number of the product here |
Applicable customer GST | GST charge paid by the customer for the order |
Customer Company name | The company name of the customer |
Customer Billing address | The address of the customer |
Customer GSTIN | The GSTIN details of the customer |
Closing Fee | A fee paid at the time of closing of a transaction |
Closing Fee IGST | Amount applicable according to IGST rate |
Closing fee CGST | Amount applicable according to CGST rate |
Closing Fee SGST | Amount applicable according to SGST rate |
Related Articles
https://auperator.atlassian.net/wiki/spaces/IO/pages/929596477
https://auperator.atlassian.net/wiki/spaces/IO/pages/937492605