Reconciling Tata Cliq Payments

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

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’.

Note: 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’.

Frequently Asked Questions

Why are some orders for Tata Cliq partially paid?

Some of your Tata Cliq orders might be in awaiting payment status with a partial tag. A partial tag means that you have not received full payment for those orders. Please note if the different amount is INR 49 or INR 79, this can be because the Tata Cliq levy `shipping charges to the customer. Earlier Eshopbox workspace was creating orders by adding this shipping amount. As the shipping amount is not to be recovered by you, the payment received from Tata Cliq will be the invoice amount excluding the shipping amount.

Let’s understand with the help of an example:

Here you can see for an order dated 22nd Mar 2020 of Tata Cliq, you have received INR 998, and the invoice amount is INR 1047. The difference amount is INR 49.

You can see below that Tata Cliq issues two invoices for this order. One is for the seller, and the other one is for the shipping fee charged to the customer. The shipping charge is INR 49, which is the difference amount in the invoice amount and paid amount in the Eshopbox workspace.

From 1st July 2020, in the Eshopbox workspace, the shipping amount is not added to the invoice amount. As the shipping amount is not to be recovered by the seller, so you can ignore the difference of INR 49 and INR 79 in payment Tata Cliq orders.

Knowledge Base