How to export data in new annexures for Tamilnadu in Tally ERP 9 Release 5 ?

How to export data in new annexures for Tamilnadu in Tally ERP 9 Release 5 ?

by Kapil Sharma » Sat Apr 23, 2016 1:21 pm

How to export data in new annexures for Tamilnadu in Tally ERP 9 Release 5 ?

 
Posts: 1
Joined: Sat Apr 23, 2016 1:20 pm

Re: How to export data in new annexures for Tamilnadu in Tally ERP 9 Release 5 ?

by Dilip Churiwal » Sat Apr 23, 2016 1:31 pm

To export data into new annexures follow the steps mentioned below:-

From Tally.ERP 9 Release 5.3.2 onwards:-

1. Copy respective excel template of annexures to the Tally.ERP 9 installed folder.

2. From Gateway of Tally Display à Statutory reports à VAT à e-C TAX
e-C-Tax.jpg
e-C-Tax.jpg (9.96 KiB) Viewed 67 times

3. Click on Annexure ready
VAT-Form-I.jpg
VAT-Form-I.jpg (14.38 KiB) Viewed 67 times

4. Click on particular annexure

5. PressControl + E: Export Annexures

Ø SelectExport location (where XL template is saved)

Ø SelectOutput file name

Ø Mentionfrom and to date

6. Note: - Kindly add number of rows in the XL template as shown in the export screen. By default XL template will have 5 rows. Add required rows in XL template and then export the annexure.
e-VAT-annexures.jpg
e-VAT-annexures.jpg (14.02 KiB) Viewed 67 times

7. The data gets exported to relevant fields of annexures.
Exporting.jpg
Exporting.jpg (18.18 KiB) Viewed 67 times

8. Validate the annexure and generate XML file.

9. Upload validated XML into e-C TAX Tamilnadudepartment portal.

From Tally.ERP 9 Release 5.2 till 5.3.1:-

To export data to new annexures

1. Copy respective excel template of annexures to the Tally.ERP 9 installed folder.

2. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I (New).

3. Click on Annexure ready
VAT-Form-I.jpg
VAT-Form-I.jpg (14.38 KiB) Viewed 67 times

4. Click on particular annexure
e-VAT-annexures.jpg
e-VAT-annexures.jpg (14.02 KiB) Viewed 67 times

5. Press Control + E: Export Annexures

> Select Export location (where XL template is saved)

> Select Output file name

Note: - While exporting TN New E-VAT Annexure template output file name shows with V1.5. The department has changed the version of E-VAT Templates to V 1.0. Hence change the Output file Name from V 1.5 to 1.0 and export the data on to relevant E-VAT Annexure Templates and upload it.

> Mention from and to date
Exporting.jpg
Exporting.jpg (26.28 KiB) Viewed 67 times

6. The data gets exported to relevant fields of annexures.
Annexure-list-of-1st-shedule.jpg
Annexure-list-of-1st-shedule.jpg (36.27 KiB) Viewed 67 times

7. Validate the annexure and generate XML file.

8. Upload validated XML into e-C TAX Tamilnadudepartment portal.
 
Posts: 2
Joined: Thu Apr 07, 2016 5:37 pm


Who is online
Users browsing this forum: No registered users and 1 guest
cron