LIVE GST Audit Course by CA Sachin Jain. Register Now!!

Excise dealer return

Jivan (Office-Assistant) (59 Points)

23 December 2011

How to use ACES_DealerReturn_schema for Dealer Excise Return

Pl help....

....Jivan

Reply
Follow
Share

15 Replies

CA Prabhat Gupta (Manager (Indirect Taxes)) (821 Points)
Replied 23 December 2011

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.

Attached File : 483027 892406 aces efiling dlr.zip downloaded: 2395 times

3 Like

Jivan (Office-Assistant) (59 Points)
Replied 23 December 2011

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.

CA Prabhat Gupta (Manager (Indirect Taxes)) (821 Points)
Replied 23 December 2011

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

CA Prabhat Gupta (Manager (Indirect Taxes)) (821 Points)
Replied 23 December 2011

Ensure whether the accounting software used by you provides the facility to generate E – returns in XML format.
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.
After necessary changes to units & formats you can export the e-return using your software in XML format.
A few licenced accounting packages have option to validate the return. After validation follow the procedure to upload the return.

CA Prabhat Gupta (Manager (Indirect Taxes)) (821 Points)
Replied 23 December 2011

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.

Attached File : 483027 892532 aces dealerreturn schema.zip downloaded: 644 times

Jivan (Office-Assistant) (59 Points)
Replied 23 December 2011

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.

Rupesh Vardam (CEO) (23 Points)
Replied 03 January 2012

Hi,

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

We have complete solution on this.

anshul heda (ceo) (25 Points)
Replied 25 January 2012

now for convert .xml of dealer return & other return a solution available in the market XD-excise a software of SAG Infotech so can visit https://www.saginfotech.com/

keshav (Marketing) (38 Points)
Replied 20 March 2012

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

1 Like

Amit Balasaheb Sawant (studant ) (21 Points)
Replied 24 March 2012

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?

Krishna (na) (21 Points)
Replied 25 March 2012

Udyog Software (https://www.udyogsoftware.com) has a solution for ACES efiling at an affordable cost. It is already being used by customers throughout India. You can contact them by sending a mail to ezeefile @ udyogsoftware.com

Originally posted by : Jivan

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.