With Unicommerce integration with GST Compliant Tally (Supported version Tally ERP 9 version 6.0.1 and above) you can now seamlessly manage sales (B2B* and B2C), returns, cancel invoices and inventory.
Other features also include:
Bulk item creation with HSN code
Payment reconciliation with the bifurcation of channel’s deduction
Management of Purchase entries in Tally from Uniware
For this, you need to create all the ledger name in tally according to GST format (as per client’s tax classification).
Steps to Integrate Tally:
a. Create a company in Tally with the name of Unicommerce to import all the data. As soon as the TCP is updated, the Import for Unicommerce is created.
b. Create SKU alias sheet for inventory management perspective in Tally and save in the folder path, which will be used in the configuration steps later.
c. Product mapping is done to associate – item name- tally name, item alias – uniware SKU codes as uniware only handle simple sku not bundle or combo sku in tally.
Below mentioned are the Four Key Steps required to be followed to complete the one-click tally Integration:
A. Configure TDL/TCP file in Tally
B. Configure Import module
C. Export data from Unicommerce
D. Import downloaded data into Tally
Note: To know how to replace the existing Tally TCP with a new TCP file, click here.
Let us now begin with these steps:
A) TDL configuration in Tally.ERP9-
Perform the following steps in the given order:
Go to the Gateway of Tally and Press F12 (To Configure).
Select Product & Features or, press “T”. Then press F4 (Or click “Manage local TDLs”).
To enable the TDL select YES.
Copy the path of TCP file. (The TCP file is provided by Unicommerce, scroll down to find the attachment).
Please note that by accepting the changes TDL name will become active and TDL name will reflect in black which shows that TDL is successfully installed:
After successful uploading of TDL, You can check the Unicom_Menu after the Quit Option.
B) Configure the Import-Module:
There are two types of importing features we provide:
b. Accounting with inventory
To enable the Excel import module, Go to the gateway of Tally and press F11 (to select Features)
Next step, select the “Accounting Features” or just press “A”.
In the next menu, refer to the “Other features” and type “YES” in “Excel Import Module”.
There are two fields:
a. Use only accounts (YES for accounting only and NO for accounting with inventory)
b. Use Batch Field for IMEI (Mark YES if you need IMEI number in the description field of items)
C) Generation of Excel from Unicommerce:
At Uniware you can export a Tally report or schedule it for every day. Follow these simple steps to get the report:
1.On the main menu, select Dashboard. Click on “Other Reports”. There are three types of exports:
a. Tally GST Report (Sales) (contains dispatched sales)
Newly added filters in the Report to help you manage and compare data efficiently:
Channel Created: Using this filter you will get to know the invoiced date of the channel order which can be different from Original Invoice Date filter which is Uniware invoiced date.
Tax Verification: Double-check the tax rate levying by marketplaces before importing data in Tally by a newly added column of Tax Verification. It will show value as 0 if tax rate in Unicommerce is not same as marketplace invoice.
b. Tally GST return Report (contains returned sales)
c. Tally GST cancel Report (all canceled invoices)
d. Tally Reco Report New
e. Item Master
2. Select the columns required in the report. Apply any filters like channels and date range and then create the export job. If required, and then type in the email ID to send export the report to.
3. Select invoice date
4. Click on “Create Export Job”. On successful report creation, the following message is seen on the screen:
5. You can download the report from view export option
You have to save the downloaded file in the folder with name “excel” at tally ERP 9 installed location with some meaningful name.
D) Import from excel to tally ERP 9
Go to Gateway of Tally, “Unicom_Menu”
And then Select the option:
1. ItemImport: Bulk Item creation in tally with HSN Code. Uniware only handle simple sku not bundle or combo sku in tally.
2. Sales Import: Sales and return invoice import
3. Cancel Invoice: For Cancel invoice import
4. Receipt Import: For you receipt import with channel deduction.
To check the import data follow the path:
Gateway of Tally > Display > Daybook
Always remember that the Cancelled invoices will be created as an optional type invoice which you can later alter into sales or cancel, as per the requirements.