• Nov
  • 01
  • 2010

Filing VAT Return Ver.1.2.2 – How to handle uploading errors?

Posted In GST | | 22 Comments »

CA Lalit Munoyat

FILING VAT RETURN Ver.1.2.2?. How to handle uploading errors

It is the time for e-filing your VAT Return. My staff prepared Form no 231 using Excel-2007 and validated the file creating the .rem file. However when they tried to upload the file it did not upload but threw a message like:

FROM ERRORS REPORT
Sr No. Line No. Box No. Error Description
1 0 0 Error In Start Routine Unable to recognize OLE stream

I tried many variations to get it uploaded but nothing succeeded. I visited many website to get a solution for this but instead of getting a solution I found many visitors were asking the facing the same problem and no answer was available. Eventually I visited the departmental site to find out the solution. On the Home Tab of the site Mahavat.gov.in, I came across the following:-

Instruction sheets for eServices

Know everything about e- Enrollment and e-Returns

(F) Probable Queries

Q. 9-Whether I can use MS office 2007 for preparing electronic templates?.

Ans : No. You have to use MS office 2003 version.

What a pity. Many of us have shifted to Office-2010, but the site does not support the contents of even MS office 2007. Many of us have already discarded MS Office 2003. What is the solution?

1) Either keep two hard discs with dual booting. One for booting with Office-2003 and another for booting with advanced MS Office-2007.( I did it and got even more problems than solutions) OR

2) Try the following procedure:

a. Prepare Form 231 using MS Excel- 2007 and while saving, save it as “Save as Excel 97-2003 workbook” which is compatible with Excel 97-2003.

b. Validate and create the .Rem file. Now if you try to upload this file you will get the above error message. Instead try this:

c. Open the Rem file. Before opening the file the program will display the following message:

“The file you are trying to open (name of the rem file, say “abcd-rem.xls”) is in different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”

d. Say yes and open the file.

e. Immediately after opening it and without doing anything to it save it as “Save as Excel 97-2003 workbook” which is compatible with Excel 97-2003. This will remove the advanced features of Excel-2007 which are not compatible with Excel 97-2003.

f. Now try uploading it. I hope it will now upload properly without any error message.

Compiled by:

CA LALIT MUNOYAT


B.Com.(Hons.), CS, FCA, DISA

munoyat@gmail.com

98201 93508

Sandeep Kanoi

22 Responses to “Filing VAT Return Ver.1.2.2 – How to handle uploading errors?”

  1. Anonymous says:

    Thank you Sir.

    I was tring to upload c form application but the same error is encountered. With ur procedure I added little bit. While saving in excel 97-2003 workbook I added in the given name “-Rem.xls” after the file name. This flie I uploaded on Mahavat site.

    But I must say without ur procedural aspect it couldn’t be possible.
    Thanks once again

  2. punam says:

    thanks it works

  3. ALPESH MORAKHIA says:

    FANTASTIC  ITS WORKS,I WOULD HAVE NOT DONE ,IF I DO NOT GONE FOR UR ADVISE
    THANK YOU VERY VERY MUCH

  4. Jay says:

    Thanks a lot for solving my problem…..

  5. CA PRIYESH says:

    THANKS SIR

  6. Sahil says:

    Thank you Mr. Lalit..
    it helped me to upload my return

    Regards
    Sahil Maniyar

  7. Sanjay Divekar says:

    Your guidance has helped me a lot. Thanks & Regards

    Sanjay

  8. ketan deshpande says:

    Thanks a lot…

    :)

  9. Shobhit Jain says:

    Very very useful.Thanks so much

  10. Deepak Pawar says:

    Thanks,
    It works.

  11. PANKAJ PALLOD says:

    THANKS

    IT WORKS

  12. Ashwini says:

    Thanks a lot sir

  13. Ashwini says:

    thank you sir it relly work

  14. SAVITA says:

    Your advise help me to upload successfully CST Application

    thanks
    regards
    savita

  15. Kadam S says:

    Thank You. My problem is solved

  16. Vaidehi says:

    Thank you very much Sir, uploaded C-form application.

  17. Anand R says:

    Thank U Very Much Sir……

  18. kanchan says:

    Thank you very much sir.

    Now i can easily apply for C-form .

  19. kanchan says:

    Thanks

  20. Ganesh says:

    Thanks a lot….it really worked

  21. Rajesh Sharma says:

    Thank you, Sir, Your Advice solved my problem of “Uploading my return”. Tanks again.

    Regards
    Rajesh Sharma

  22. Bipin Sidhpura says:

    Thanks a lot sir,

    Your advise help me to upload successfully Form231

    Regards,
    Bipin

Leave a Reply

GET FREE EMAIL UPDATES

CHECK OUR UPDATES ON FACEBOOK - LIKE US