Excise dealer return

Mr. Jivan,

Dealers return in Excel Utility is attached below. You are required to:

1. Extract the file.

2. Fill in basic details. The first Sheet of the return contains basic details & list of invoices issued by the dealers & list of documents on the basis of which Credit was availed & transferred. Details of individual items are required to be filled. Validate the sheet after filling the details & click next.

3. Return is basically divided in two parts. First part (Sheets named Invoice (1), Invoice (2) & so on in the return) is for details of Excise Invoices issued by the dealer. Second part (Sheets named Document (1), Document (2) & so on in the return) contains the details of documents on the basis of which CENVAT credit was availed & transferred. Validate the sheet after filling the details & click next.

4. Last page is the declaration page. Validate the sheet after filling the details and click Validate Return & submit.

5. An XML file will be generated, named as your Dealers registration No. followed by date of return & a number. Now you are required to log in to you ACES ID. Goto RET > E filing > upload File > browse the file & upload.

6. Check the status of return filed by using Status option just below the upload option after the return is uploaded. Filed denotes that the return uploaded by you is acctpted.

Mr.Prabhat Gupta

Thanks for the same. I have prepared the same for last 02 quarters but now i have huge data to uplod.

Aces provided another another zip file i.e.ACES_DealerReturn_schema for huge data so i could not know how to use it.

Again thanks for the help, if you know pl help asap.

Please let me know the software used by you for keeping your records & generating the XML forthe same.

1. Ensure whether the accounting software used by you provides the facility to generate E – returns in XML format. 
2. Ensure that units & formats used in the accounting package is same as in the E – returns. The zipped file downloaded contains a doc file & xls file giving details of formats & units accepted. If a different is used, the XML will not be validated.
3. After necessary changes to units & formats you can export the e-return using your software in XML format.
4. A few licenced accounting packages have option to validate the return. After validation follow the procedure to upload the return.

For reference zip file referred in above reply is attached below.

You can also validate the return by copying the file with extension "xsd" in the software's folder. Software normally provide option to check hte correctness of the generated XML file. Open the file using this option, which will automatically display whether the return is valid or not.

Presently i am not using the software, i have prepared previous returns in file which was downloaded from aces but the said file was locked & you have to enter data one by one.

Due to huge data i want to prepare the same in normal excel file & convert it into xml format which is uploadable on aces.

I have already downloaded the ACES_DealerReturn_schema file but i don't know how to use this one in excel.

Thanks for helping.

Hi,

for more information please visit to https://manasinfotech.in/

We have complete solution on this.

I'll Provide e-fiiling solution. Only you have to sales and purchase details in excel Formate From your any software. 

No double enty........

Pls cal me @ +91 9986186819, 

keshava Poojary

Hi,

Please let me know  if any dealer import some goods then can he take the CENVAT credit on that import goods when he is filing his returns? 

In the column of issued by what is fille in it ?

whether in that salers status or purchasers status appeared?

In the column of issued by what is fille in it ?

whether in that salers status or purchasers status appeared?

Dear Sir,

Please let me know, is document to be submit to department after excise dealer return? if Yes, then what documents?

Kindly revert me urgently