Eshopbox helps you reconcile fees charged and payments received from Tata Cliq against your Tata Cliq orders.

In this article, you will learn:

  • How to configure Tata Cliq fees and payment terms in Eshopbox

  • How to upload Tata Cliq payment report in Eshopbox

  • How Eshopbox reconciles Tata Cliq fees

  • How Eshopbox reconciles Tata Cliq payments

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

1. Configure fees

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

2. Configure Tata Cliq payment cycle

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

3. Book payments

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

  • Log in to the Tatacliq seller account using your credentials.

  • You will land on a page with topics of all the information available in the account.

  • Click on Payment dashboard.

  • From the left bar, click on the Payment history.

  • Select the Date range for which you want to download the payment report with a limit of 15 days.

  • Click on Search. Now, you will be able to see all the transactions made within your defined timeline.

  • Click on Detailed report to get complete details of your selected transaction.

  • Clicking on Detailed report automatically triggers two downloads - a ‘Payment history report’ and a ‘Commission invoice’.

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

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

  • Upload the ‘payment history report’.

💡The amount transferred in your bank account should be equal to the total of the “Net Payable” column in the payment report.

Reading a payment report

If you wish to read the Tatacliq payment report, you need to use Microsoft excel. Each row in the ‘orders sheet’ represents the payment transaction settled against an order. For any ordered item, the amount settled includes:

  • Payment received against the delivered order.

  • Payment refunded to the customer for a returned order.

  • Expenses incurred against the applicable fees charged by Tatacliq.

For Tatacliq payment reconciliation, Eshopbox considers transactions ID as a 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 Tata Cliq, and assign it one of the following fee statuses:

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

  • If the fee deducted by Tata Cliq 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 Tata Cliq 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 Tata Cliq, 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?