Understanding your Limeroad Payout Statement
- Payal Mehndiratta (Unlicensed)
- Rita Saini (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 seller account on Limeroad. Understanding payout statement will help you to know, how to:
Download the payout statement
Read a payout statement
How Eshopbox reconcile Limeroad payout
Download the payout Statement
Login to Limeroad seller panel using your credentials
Click on the payments summary
In the payment summary , page click on “Click here to view payment details created after 1st January 2017”.
Payments are settled in multiple reports, download all reports by clicking on the amount.
Limeroad settles Transactions in 3 sheets
Item report
Non- item adjustment report
Incentive / Penalty report
Limeroad settles payment bi-monthly, Payments for transactions from (1 -15th of month) settled together and payments of (16 - rest of the month) is settled together.
For Limeroad payment reports are to be uploaded in a pre-defined template which could be downloaded from Eshopbox app
Merge all the reports in a template and upload it.
Reading a payout statement
Limeroad payout statement contains three sheets. Following table describe there usage:
Item Report: Contains a summary of all transactions related to the orders received for your products. It includes the information about the Final payable amount. Each row in the Item report 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 that is deducted or reversed to your account against Payable relevant to an Order.
Non Item Adjustment report : This sheet contains a summary of all the adjustment transactions related to the Packaging & other fees / charges.
Incentive / Penalty report : It contains information of all the penalty & incentive related transactions charged on the products against the Order Id’s . Each row in the report represents the amount charged corresponding to a particular item in an order.
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 same as the sum of '' Adjustment amount , Total payment amount made to the vendor , Incentive/penalty “column in the payout statement.
How Eshopbox reconciles Limeroad Payouts
For Limeroad , the Eshopbox app considers Order ID & style code as a unique reference number. eshopbox will scan through each row in all the sheets & perform actions as per the details below:
For each row eshopbox will record a payment against the receivables corresponding to a particular order. Payment will be sum of positive values in ' Item report' sheet , column ‘total payment amount made to the vendor’ , ‘Non item adjustment report’ sheet , column ‘sum of adjustment amount' and ‘Incentive & Penalty report sheet’ , column 'penalty/incentive amount’.
For each row eshopbox will record a refund against the receivables corresponding to a particular order. Payment will be sum of negative values in ' Item report' sheet , column ‘total payment amount made to the vendor’ , ‘Non item adjustment report’ sheet , column ‘sum of adjustment amount' and ‘Incentive & Penalty report sheet’ , column 'penalty/incentive amount’.
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 given below:
Column Name | Reconciled Against |
|---|---|
Cancellation fee | Cancellation fee |
Penalty/Incentive | Penalty/Inventive |
Return QC failed | Return QC failed |
TCS amount for IGST + TCS amount for SGST + TCS amount for CGST | TCS |
LG margin amount after discount borne by Limeroad | Commission |
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 Item report column “Total payment amount made to the vendor” and and sum of all the fields mentioned in the above table under column name.
Glossary
Fields | Description |
|---|---|
Cycle date | The date on which the transaction is settled |
Entry Type | defines whether item is sale , return or RTO |
Unique Item ID | ID generated on channel's panel for each item |
Payment Mode | whether prepaid or postpaid(COD) |
Order ID | unique order ID for that particular order |
Order Date | date on which order is placed on channel's panel |
Total Payment amount made to the vendor | amount obtained from deducting LR Margin Discount and Reversal on return/cancellation from summation of sale amount and return amount |
Sub-order state | whether an order is delivered or returned |
Vendor Invoice number | invoice number against that specific order |
Invoice date | date on which invoice is generated |
Customer city | city in which order is delivered |
Customer state | state in which order is delivered |
UI Product ID | unique product ID as listed on the channel portal |
Transporter | courier services assigned for that item delivery |
AWB | air way bill number generated at the time of invoicing to keep track of product |
Item MRP (A) | maximum retail price of the product |
Item Disc by vendor (B ) | discount given by vendor of the product |
Item Disc by Limeroad | discount given by channel on that product |
Scrap Discount | miscellaneous discount on that product |
Cart discount by Limeroad | Extra event discount offered for a specific time period |
Cart discount by Vendor | Event discount offered by Vendor for a event period |
Cashback discount by vendor |
|
Cashback discount by Limeroad |
|
Taxable amount | total amount on which further fee and taxes will be imposed |
Tax 2 rate |
|
Tax 2 amount |
|
HSN code | listing ID code on channel panel for that item |
Order Type | whether it follows interstate or same state type |
IGST Rate | integrated GST rate |
IGST Amount | integrated GST amount |
CGST rate | center GST rate |
CGST amount | center GST amount |
SGST rate | state GST rate |
SGST Amount | state GST amount |
GST Adjustment amount | Adjustment in GST(if any) |
Taxable shipping charge paid by the customer |
|
Taxable COD charge paid by the customer |
|
Shipping charge paid by customer |
|
COD charge paid by customer |
|
Total supply taxable amount |
|
Total supply tax amount |
|
TCS Rate for IGST |
|
TCS rate for CGST |
|
TCS rate for SGST |
|
TCS amount for IGST |
|
TCS amount for CGST |
|
TCS amount for SGST |
|
Vendor NSP |
|
LR Margin % | limeroad commission percentage imposed on that product |
Weight mapping to Vendor cost |
|
Transporter cost recovered from Vendor |
|
COD cost recovered from Vendor |
|
LR margin amount after discount borne by Limeroad (M = I*J%-C - E - H + K + L + N + O + P) | limeroad commission amount imposed on that product |
Return Delivery date | delivery date of returned product |
Transporter cost recovered from vendor on Return |
|
Reversal of shipping charge on return/cancellation |
|
Reversal of COD charge on return/cancellation |
|
Reversal of margin on Return/cancellation | amount reversed on return/cancellation of product |
TCS amount reversal for IGST |
|
TCS amount reversal for CGST |
|
TCS Amount reversal for SGST |
|
Total Adjustment | total adjustment amount |
Lost in Transit | whether the item was lost in transit (yes/no) |
Style code | item SKU code as per eshopbox listing |
Short Shipment | whether it is local or national shipment |
Total Entry tax calculated |
|
Total local body tax calculated |
|
Total Octroi tax calculated |
|
Sale amount (S = A - B - F - G - C - E - H) | order item value |
Return amount (T = A - B - F - G - C - E - H) | Amount returned to customer |
Variant ID | Unique Product variant ID |
Remarks for adjustment (if any) | Specify in case of any new adjustments |
Non - Item adjustment report
Fields | Description |
|---|---|
Packaging (Packaging charge) |
|
Others (TCS) |
|
Penalty /Incentive report
Fields | Description |
|---|---|
Return QC failed |
|
Revoked Penalty Return QC failed |
|
Extra Penalty return QC failed |
|
Suborder cancel |
|
SLA |
|
Short shipment |
|
Related Articles
https://auperator.atlassian.net/wiki/spaces/IO/pages/929596477
https://auperator.atlassian.net/wiki/spaces/IO/pages/937492605