Select Your Language :

Generating e-Returns from Tally.ERP 9 [Excise for Importer]

By meeting all the requirements of e-returns, Tally.ERP 9 now provides the option to generate the quarterly return with a click of a button.

Prior to generation of e-returns validate the data to correct the errors if any.

E-Return Validation

The E- Return Validation screen appears as shown below:


E-return Validation screen displays the Type of Error with the Error Count. To rectify the error, select the error type and press Enter. The following types of errors are displayed in this report:

  1. Tariff/HSN Code Validation

  • If this error is displayed, select No/Invalid Tariff /HSN Code and press Enter to view Tariff/HSN Code Validation screen

  • Tariff/HSN Code Validation report displays the details of Name of Tariff, HSN Code and Remarks.

  • Remarks display the reason for validation. All the Tariff classification for which the HSN Code is less/more than 8 digits gets displayed here.

Once the correction is made, the errors and remarks are removed from the report

Note: Tally.ERP 9 looks only for 8 digits/numbers and ignores the dot or space between the numbers.

  1. Party Excise Registration (ECC) No. Validation

  2. If this error is displayed, select No/Invalid Excise Registration (ECC) No. of Party and press Enter to view Party Excise Registration (ECC) No. validation screen

  3. Party Excise Registration (ECC) No. validation report displays the details of Name of Party, Excise Registration (ECC) No. and Remarks.

  4. Remarks displays the reason for validation.  For all the registration numbers which less than 15 digits or of invalid structure, remarks are displayed. . Once the correction is made, the errors and remarks are removed from the report.

Filing E-returns

  1. Go to Gateway of Tally > Display > Statutory Reports >Excise Reports > Dealer/Importer> E-Return > press Enter to view Exporting Importer E-Return screen

  2. Press Backspace to select the excise unit and provide the Return period, Place and Date for generating e-return

  3. Excise Unit: As creation and maintenanceof accounts for multiple units in a single company is allowed with the flexibility to generate Excise Unit-wise e-return ,the Excise Unit field is provided. Select the excise unit for which e-return needs to be generated

  4. Language: Cursor will skip this field as Language is fixed to Restricted (ASCII Only)

  5. Format: Cursor will skip this field as Format is fixed to XML (Data Interchange)

  6. Export Location: By default, Export Location displays the path where Tally.ERP 9 is installed. This path can be changed if required

  7. Output File Name: The Output File Name is displayed in the Format specified under E-Return Requirements.

As per the E-Return Requirement, the E-Return File Format is - 15 Digit ECC Number_ Month Date Year Hour Minutes Seconds AM/PM.xml

Example: ACCEP4589SXD001_10012010162655PM.xml

Note: The Output File Name can be changed while generating e-return in XML format. To upload the E-Return, assessee has to follow the file name structure as specified under E-Returns Requirement. If the file name structure is different, the ACES application will not allow the Assessee to upload the e-return.

  • From: In this field enter the date from which the return needs to be generated.

  • To: In this field enter the date till which return needs to be generated the return

  • Place: In this field enter the placewhere e-return is generated

  • Date: In this field enter the Date on which e-return is generated

  • Remarks: In this field enter the required details. For example, Quarterly Return for 1-4-2014 to 30-6-2014

Note: From and To period, Place, Date and Remarks are mandatory fields.

The completed Exporting Importer E-Return screen is displayed as shown:


The Configuration screen displays the following three options

  •  Show All Items: Enable this option to view all stock items purchased in an invoice

  • Show Excise Duty Amount Round Off: By default, this option will be set to Yes because, the Dealer E-Return Requirement clearly states that all the duty amount has to rounded off to the nearest Rupee.

  •  Round Off Quantity to TWO decimals: By default, this option will be set to Yes. If more than two decimals provided for the stock item has to be captured in the e-return, set it to No.


The exported file will be placed in the Tally.ERP 9 Directory with the file name as specified above and ready for upload.

Note: Users can verify the correctness of e-returns generated from Tally.ERP 9. The Excise department has provided XSD file using which the xml has to be validated and then uploaded to the department website.

To compare the data structure of file generated from Tally.ERP 9 to the data structure provided by the Excise Department:

  • Copy ACES_DLR.xsd file into the Tally.ERP 9 folder

  • Open the e-return generated form Tally.ERP 9 in any of the XML validation tools like EditiX 2010, StylusStudio etc. (tool which is used to check the correctness of the XML files)

  • Click the option Validate, the tool compares the structure to ACES_DLR.xsd file available in Tally.ERP9 folder and gives the Output as Valid (if there are no errors) or will display the errors found in the document.

Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
GST using Tally.ERP9
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications