Unable to write values in the header row of Karnataka e-VAT annexure template

Cause

The input fields in header row of Karnataka e-VAT annexure templates are not default excel sheet cells, but are text boxes inserted on top of the cell. Hence, an external application will fail to identify these fields and fail to post data into them.

Thus, Tally.ERP 9 is unable to post data to the fields - Enter your Tin (11 digits) , Enter Return Year , Enter Filing Type , Enter Month , Enter Quarter , and Transaction Type . However, data is exported to other columns.

This is a problem with the excel template, and needs to be looked into by the department.

Solution

To resolve this issue

Export data from Tally.ERP 9 to the excel template, and enter the header row information manually. Convert the files to xml after filling in the header information, and upload the returns.

OR

Export the return details in xml format from Tally.ERP 9. Use this xml to upload the returns.