Eshopbox helps you reconcile fees charged and payments received from Flipkart against your Flipkart orders. Eshopbox helps you in payment reconciliation of multiple business models in Flipkart:

  • Flipkart

  • Flipkart Smart

In this article, you will learn:

  • How to configure Flipkart fees and payment terms in Eshopbox

  • How to upload Flipkart payment report in Eshopbox

  • How Eshopbox reconciles Flipkart fees

  • How Eshopbox reconciles Flipkart payments

Follow the below steps to reconcile Flipkart fees and payments in Eshopbox:

1. Configure fees

The first step is to configure your Flipkart fee in the Eshopbox workspace. Learn how to configure fees in Eshopbox.

2. Configure Flipkart payment cycle

You need to configure Flipkart’s payment (remittance) cycle in Eshopbox. The frequency at which Flipkart makes payments to you would be based on your agreement with Flipkart and your seller tier. Learn how to configure payment terms.

3. Book payments

You need to upload Flipkart payment reports in Eshopbox to initiate the reconciliation by following the below instructions:

  • Log into the Flipkart seller account using your credentials.

  • Navigate to Payments > Previous payment.

  • Here, you will be able to see all the settled payments "Prepaid" and "Postpaid."

  • Select the ‘Month’ for which you want the payment report.

  • Note the ‘Payment date,’ ‘NEFT ID,’ and ‘payment amount.' This will be used while uploading the payment report in the Eshopbox workspace.

  • Click on the transaction that you want to download, and click on ‘Request Download.’

  • Now, navigate back to the Eshopbox workspace > Payments.

  • Click on ‘Add payment’ on the top right corner of your screen and upload the payment report.

Reading payment report

If you wish to read the Flipkart payment report, you need to use Microsoft excel. Flipkart's payment report contains the following seven sheets:

  • Report Help: This sheet provides the introduction of Flipkart’s payment report.

  • Orders: This sheet contains payment transactions corresponding to the order. Each row in the orders sheet represents the amount settled against a particular item in an order. The transactions include
    - Amount paid to you against the order or refunded from your account against the returned order.
    - Expenses incurred to your account against the order.

  • Non-Order SPF: This contains protection fund transactions related to products lost or damaged.

  • Storage & Recall: This sheet summarizes all settled transactions related to storage and removal services availed by you.

  • Ads: This contains a summary of all settlements against ads campaign.

  • TDS: This sheet contains settled transactions against TDS claims filed by you.

  • Tax Detail: It contains information about which taxes are charged for service, fee, and the unique ID to identify the order, listing, or ads campaign.

For Flipkart payment reconciliation, Eshopbox considers a combination of customer order ID & ESIN as unique reference ID. All transactions are recorded against this unique reference ID. Eshopbox will create a ‘suspense’ record if there is a difference between the settlement amount and the sum of payment and expenses calculated by Eshopbox from the payment report.

4. Reconcile expenses

Eshopbox will match the provisional fee with the actual fee deducted by Flipkart, and assign it one of the following fee statuses:

  • If the fee deducted by Flipkart is the same as the provisional fee. The fee status will be ‘Reconciled’.

  • If the fee deducted by Flipkart is more than the provisional fee, the fee status changes to ‘Disputed’.

  • If for any reason Eshopbox is not able to calculate the provisional fee and Flipkart has deducted this fee, the fee status changes to ‘Failed'.

5. Reconcile payments

Eshopbox will match the expected payment (invoiced amount) with the actual payment received from Flipkart, and assign it one of the following payment statuses:

  • If the payment received is equal to the provisional amount, the payment status will be ‘Paid’.

  • If payment received is less than the provisional amount, the payment status will be ‘Awaiting payment’. When no payment is received against an order, the payment status will be ‘Awaiting payment’ with a partial tag.

  • If you receive payment and then the same amount is refunded, the payment status will be ‘Refunded’.

Did this answer your question?