Welcome, Guest Login

Support Center

Implementation of GST in Tally ERP 9

Last Updated: Nov 15, 2017 05:43PM IST
  • Note: Implementation of GST in Tally is supported for Tally ERP 9 version 6.0.1+

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

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

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, two option will come on the dark green right sided ribbon.


B)  Configure the Import Module:
are two types of importing features we provide:

a. Accounting
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 VerificationDouble 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)

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, in 'Utilities'  and to import the sales and return click on “Import Excel data” or “ALT+s” and to import canceled invoices “Import Cancel data” or “ALT+x”
  •  All the files from the folder named "Excel" will be visible here, just select your file and click enter.

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.

Contact Us

seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found