UniReco-Optimize Payment Reconciliation and Streamline Returns with Ease

What is UniReco?

UniReco is the advanced reconciliation tool provided by Unicommerce. It allows you to track your expected and actual sales and you can get returns data along with the summary of reconciled and disputed transactions.

Furthermore, UniReco allows for greater control, enhanced efficiency, cost savings, and greater insight into your financial data.

Bundle of Features

Channels: Myntra PPMP, Flipkart.com(Dropship) and Amazon_in (easyship), Amazon FBA IN, Amazon Flex WI.

Applicability

Version: Any Uniware seller can take this service from a separate panel known as UniReco.

How to Access UniReco?

To access UniReco, you have a two options:

1. Website Access: You can visit the UniReco website directly by going to https://unireco.unicommerce.com/
2. Uniware WMS: Alternatively, you can access UniReco through Uniware WMS. Simply navigate to the Reconciliation section within Uniware WMS, and it will redirect you to your UniReco account.

Choose whichever method is more convenient for you, and you should be able to access UniReco seamlessly.

Screen Navigation:

 

Unireco comprises the following tabs:

Enabling the Channel

To enable any Channel in UniReco, navigate to the following path:

Settings > Channel > enable the Sync toggle to yes, in the Reconcilation section,

Channel Configuration

To add Channel in UniReco, navigate to the following path:

UI Navigation > Channel > Click the button “Channels”.

Channel Category Creation

1- To add channel category in UniReco using UI, navigate to the following path:

UI Navigation > Channels> Channels> Click on the Channel name against which you want to add category details, then go in the “Channel Category” section.

Here you can add categories that are listed on channels for reconciliation purposes.

2- You can also do this action by bulk using import file: Ref:

Tools > Import > In the Import Type, choose the file Channel Category.

Click on Download CSV Format.

Enter the details in the CSV file and save it. Click on Choose File and upload your CSV file.

Channel Category Updation

1- UI Navigation > Channels> Channels> Click on the Channel name against which you want to update the category details, then go in the “Channel Category” section.

Here you can update the categories that are listed on channels for reconciliation purposes.

Note: You can use the edit button to update the name, or enable/disable the category.

2- You can do this action by bulk using import file: Ref:

Follow the same steps used in creation of the cateory, and edit/update is accordingly.

Channel Category Export

To obtain the export file for all the channels that you have added in in UniReco, navigate to the following path:

Channels > Channel Category > Click on the export icon from the top right corner.

All Channel Category View

To check  all channels categories in single place, navigate to the following path:

UI Navigation > Channels > Channel Category

Here you can tale filter to see the specific category that are listed on channels for reconciliation purposes.

Channel Listings & Category Mapping

To check the channel product listings in UniReco, navigate to the following path:

UI Navigation > Uniware SKUs, here you can get all the channel listings and category mapping details.

To map the channel category with the category created for channels, you can export the file from “Uniware SKUs” then fill the details as per import template available in uniware as “Map channel category with channel item type“.

Download the Template file.and fill in the details. Once you are done with the mapping as per format, You can upload category mapping details in the Unireco.

Channel Rate Card | Create and Update

To add or to update channel rate card in UniReco, navigate to the following path:

UI Navigation > Configurations >  Rate Card > Click on the “Add Channel Rate Card” button.

PARAMETER	DESCRIPTION/VALUES
Channel Code	Select the Channel Code from the dropdown.
Code	Rate Card Code for specific channel code.
Valid from	Rate Card Validity from date.
Valid to	Rate Card Validity to date.
Payment Expected In Days	Payment expected days for specific channel.
TDS Percentage	TDS Percentage
TCS Percentage	TCS Percentage
MarketPlace Discount Share	MarketPlace Discount Share

Now you can add or update the various kinds of fees under the channel rate card as mentioned below.

• Commission Fee
• Commission Override Fee
• Payment Gateway Collection Fee
• Shipping Fee
• Fixed Fee
• Pick and Pack Fee
• Refund Commission Fee
• Technology Fee

To add the respective Fee in UniReco, navigate to the following path:

UI Navigation > Configurations >  Rate Card > Click on the channel for which you want to add the Fee.

1- Commission Fee

Click on the “ADD COMMISSION FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Type	Select the type as Warehouse/Dropship/Store.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Commission Percentage Rate	Commission Percentage Rate.
Tax Percentage	Tax Percentage

2- Commission Override Fee

Click on the “ADD COMMISSION OVERRIDE FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Product Id	Select the Channel Product Id from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Commission Percentage Rate	Commission Percentage Rate.
Tax Percentage	Tax Percentage.

3- Payment Gateway Collection Fee

Click on the “ADD PAYMENT GATEWAY COLLECTION FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Fee Type	Fee Type.
Payment Mode	Payment Mode.
Fixed Fee	Fixed Fee
Tax Percentage	Tax Percentage
Minimum Fee	Minimum Fee

4- Shipping Fee

Click on the “ADD SHIPPING FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Shipping Type	Select the shipping type as FORWARD/REVERSE.
Zone type	Select the zone type as LOCAL/ZONAL/NATIONAL.
Shipping Fee	Shipping Fee.
Tax Percentage	Tax Percentage.
Shipping Level	Shipping Level.
Unit Number	Unit Number.

5- Fixed Fee

From the MORE dropdown, select Fixed Fee. Click on the “ADD FIXED FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Fixed Fee	Fixed Fee.
Tax Percentage	Tax Percentage

6- Pick and Pack Fee

From the MORE dropdown, select Pick and Pack Fee. Click on the “ADD PICK PACK FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Pick Pack Fee	Pick Pack Fee.
Tax Percentage	Tax Percentage.

7- Refund Commission Fee

From the MORE dropdown, select Refund Commission Fee. Click on the “ADD REFUND COMMISSION FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Refund Commission Fee	Refund Commission Fee.
Tax Percentage	Tax Percentage.

8- Technology Fee

From the MORE dropdown, select Technology Fee. Click on the “ADD TECHNOLOGY FEE” button.

PARAMETER	DESCRIPTION/VALUES
Channel Category	Select the Channel Category from the dropdown.
Start Selling Price	Start Selling Price.
End Selling Price	End Selling Price.
Technology Fee	Technology Fee.
Tax Percentage	Tax Percentage.

Payment Reconciliation

Here, you will get the complete overview of the Payment Reconcilation tab from the dashboard in UniReco.

1- Forward Payments

For Forward Payments, navigate to the following path:

UI Navigation: Payment Reconcilation > Forward Payments

On the Forward Payments screen, you will now see the data which is bifurcated into the following sections:-

1. AWAITING PAYMENT- This section contains all the transactions & details for which the payment report is awaited from the marketplace.
2. PAYMENT OVERDUE- This section contains all the payments for which the settlement is overdue from the marketplace.
3. RECONCILED- This section contains all the transactions for which payment can be verified and accepted by the seller.
4. RECONCILED BY DELTA- This section contains all the payments which are matched through Delta. (At the time of setup, delta (buffer) value can be added in Uniware, which helps to reconcile the data with some tolerance value).
5. RECONCILED MANUALLY- This section contains all the payments which are manually reconciled from PAYMENT DISTRIBUTED section.
   Note: You can reconcile only disputed orders.
6. PARTIAL PAYMENT- This section contains all the partially received payments.
7. PAYMENT DISPUTED- This section contains all the payments which are disputed/not matching. The dispute in these payments can be handled through manual reconciliation, by following these steps:Click on the check box(s) to select the order(s)  > Click on the ACTIONS button > Click on      Reconcile Manually
8. CANCELLED- This section contains all the cancelled orders. The payments for these orders            cannot be reconciled.

2- Return Payments

For Return Payments, navigate to the following path:

UI Navigation: Payment Reconcilation > Return Payments

On the Return Payments screen, you will now see the data which is bifurcated into the following sections:-

1. AWAITING PAYMENT- This section contains all the transactions & details for which the payment report is awaited from the marketplace.
2. PAYMENT OVERDUE- This section contains all the payments for which the settlement is overdue from the marketplace.
3. RECONCILED- This section contains all the transactions for which payment can be verified and accepted by the seller.
4. RECONCILED BY DELTA- This section contains all the payments which are matched through Delta. (At the time of setup, delta (buffer) value can be added in Uniware, which helps to reconcile the data with some tolerance value).
5. RECONCILED MANUALLY- This section contains all the payments which are manually reconciled from PAYMENT DISTRIBUTED section.
   Note: You can reconcile only disputed orders.
6. PARTIAL PAYMENT- This section contains all the partially received payments.
7. PAYMENT DISPUTED- This section contains all the payments which are disputed/not matching. The dispute in these payments can be handled through manual reconciliation, by following these steps:
   Click on the check box(s) to select the order(s)  > Click on the ACTIONS button > Click on Reconcile Manually. You can check these manually reconciled orders under the Reconciled Manually section, as mentioned above.
8. RTO- This section contains al the payments for the RTO orders.
9. SPF RECEIVED- 

3- Failed Payments

For Failed Payments, navigate to the following path:

UI Navigation: Payment Reconcilation > Failed Payments

On the Failed Payments screen, you will now see the data which is bifurcated into the following sections:-

1. ALL- This section contains all the payments that have failed due to any reason.
2. MISSING CHANNEL CATEGORY- This section contains all the payments that have failed due to the unmapped sku or channel category missing for any sale order.
3. MISSIG RATE CARD- This section contains all the payments that have failed due to rate card missing for any sale order.
4. MISSING COMMISSION FEE- This section contains all the payments that have failed due to the commission fee missing in the rate card for any sale order.
5. MISSING SHIPPING FEE- This section contains all the payments that have failed due to the shipping fee missing in the rate card for any sale order.
6. MISSING PAYMENT COLLECTION FEE- This section contains all the payments that have failed due to the payment collection fee missing in the rate card for any sale order.
7. MISSING FIXED FEE- This section contains all the payments that have failed due to the fixed fee missing in the rate card for any sale order.
8. MISSING PICK AND PACK FEE- This section contains all the payments that have failed due to the pick and pack fee missing in the rate card for any sale order.
9. FACILITY NOT ALLOCATED- This section contains all the payments that have failed due to facility not being allocated for any sale order.

4- Returns

For Returns, navigate to the following path:

UI Navigation: Payment Reconcilation > Returns

On the Return screen, you will now see the data which is bifurcated into the following sections:-

1. ALL- This section contains all the orders that have been returned, expected to be returned, have been delivered, lost, or any claim is raised against those orders at the seller end.
2. RETURN EXPECTED- This section contains the orders that that have been returned by the customer, and is expected at the seller end.
3. DELIVERED- This section contains the orders that have been returned from the customer and successfully received at the seller end.
4. LOST- This section contains the orders that have been returned from the customer, but not received at the seller end.
5. CLAIM RAISED- This section contains the orders that have been lost and any claim is raised by the seller end.
6. 90 DAYS+ RETURNS- This section contains the orders that have been returned after 90 days.

5- Order Summary

For Order Summary, navigate to the following path:

UI Navigation: Payment Reconcilation > Order Summary

On the Order Summary screen, you will now see the data which is bifurcated into the following sections:-

1. CREATED- This section contains the status of the order when it is created.
2. PROCESSING- This section contains the status of the order when it is processing state.
3. RECONCILED- This section contains the status of the order when it is reconciled.
4. DISPUTED- This section contains the status of the order when it is disputed.
5. FAILED- This section contains the status of the order when it has failed.
6. CANCELLED- This section contains the status of the order when it is cancelled.

6- Rebate

For Rebate, navigate to the following path:

UI Navigation: Payment Reconcilation > Rebate

On the Rebate Payments screen, you will now see the data which is bifurcated into the following sections:-

1. AWAITING PAYMENT- This section contains all the transactions & details for which the payment report is awaited from the marketplace.
2. PAYMENT OVERDUE- This section contains all the payments for which the settlement is overdue from the marketplace.
3. RECONCILED- This section contains all the transactions for which payment can be verified and accepted by the seller.
4. RECONCILED BY DELTA- This section contains all the payments which are matched through Delta. (At the time of setup, delta (buffer) value can be added in Uniware, which helps to reconcile the data with some tolerance value).
5. RECONCILED MANUALLY- This section contains all the payments which are manually reconciled from PAYMENT DISTRIBUTED section.
   Note: You can reconcile only disputed orders.
6. PAYMENT DISPUTED- This section contains all the transactions where there is a visible difference in settlements, for which the seller can raise a dispute with the marketplace.
7. RETURNED- This section contains all the transactions for which the order has been returned.

If you want to check your payment reconcilation for any particular order through forward payments, return payments, failed payments, return, order summary, and rebate, navigate to the following path:

UI Navigation: Payment Reconcilation > Choose the particular payment from the payment reconcilation tab > Click on the order code which you want to process.

You will now see the data which is bifurcated into the following sections:-

• FORWARD:

PARAMETER	DESCRIPTION/VALUES
Channel Item Code	Channel Item Code
Invoice Code	Invoice Code
Status	Reconcilation Status
Summary Status	Summary Status
Expected Channel Fee	Fee calculated by the rate card
Actual Channel Fee	Fee deducted by the channel/marketplaces
Expected Settlement	Settlement calculated by the rate card
Actual Settlement	Settlement received from channel/marketplace
Difference	Difference between the expected settlement and actual settlement

• RETURN:

PARAMETER	DESCRIPTION/VALUES
Channel Item Code	Channel Item Code
Invoice Code	Invoice Code
Status	Reconcilation Status
Summary Status	Summary Status
Expected Channel Fee	Fee calculated by the rate card
Actual Channel Fee	Fee deducted by the channel/marketplaces
Expected Settlement	Settlement calculated by the rate card
Actual Settlement	Settlement received from channel/marketplace
Difference	Difference between the expected settlement and actual settlement

• TRANSACTION:

PARAMETER	DESCRIPTION/VALUES
UTR Number	UTR Number
Channel Item Code	Channel Item Code
Channel Code	Channel Code
Transaction Type	FORWARD/REVERSE
MarketPlace Fee	Fees deducted by marketplace
Bank Settlement Amount	Bank Settlement Amount
Payment Date	Payment Date

• REBATES:

PARAMETER	DESCRIPTION/VALUES
Channel Item Code	Channel Item Code
Status	Reconcilation Status
Summary Status	Summary Status
Expected Rebate	Rebate calculated by the rate card
Actual Rebate	Rebate deducted by the channel/marketplaces
Difference	Difference between the expected rebate and actual rebate

• TIMELINE:

This section contains the complete activity for any order.