• Nov
  • 01
  • 2010

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

Article ID 36480 | Posted In GST | | 22 Comments » Print Friendly and PDF

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

Click here to Read Other Articles of CA Lalit Munoyat


  • Anonymous

    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

  • punam

    thanks it works

  • ALPESH MORAKHIA

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

  • Jay

    Thanks a lot for solving my problem…..

  • CA PRIYESH

    THANKS SIR

  • Sahil

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

    Regards
    Sahil Maniyar

  • Sanjay Divekar

    Your guidance has helped me a lot. Thanks & Regards

    Sanjay

  • ketan deshpande

    Thanks a lot…

    :)

  • Shobhit Jain

    Very very useful.Thanks so much

  • Deepak Pawar

    Thanks,
    It works.

  • PANKAJ PALLOD

    THANKS

    IT WORKS

  • Ashwini

    Thanks a lot sir

  • Ashwini

    thank you sir it relly work

  • SAVITA

    Your advise help me to upload successfully CST Application

    thanks
    regards
    savita

  • Kadam S

    Thank You. My problem is solved

  • Vaidehi

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

  • Anand R

    Thank U Very Much Sir……

  • kanchan

    Thank you very much sir.

    Now i can easily apply for C-form .

  • kanchan

    Thanks

  • Ganesh

    Thanks a lot….it really worked

  • Rajesh Sharma

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

    Regards
    Rajesh Sharma

  • Bipin Sidhpura

    Thanks a lot sir,

    Your advise help me to upload successfully Form231

    Regards,
    Bipin