1
Study Circle Meeting on VAT Audit E-Filing
CA. Abhay Mukesh SharmaManaging Partner, Abhay M. Sharma & Co.
2
Form 217Online Utility
3
You should have Windows XP or Later Version
It is recommended that you use Internet Explorer
You should have Microsoft Excel Use of any other version may hamper the
working of the Macros
Basics
4
After Login Select Audit Report
Selection of Audit Report
5
Download the template
6
Use of Latest Template
7
Extract the File and Enable Macro
8
9
Alphanumeric
Alphabets
Numbers
Date
Dropdown
Few Basics of Template
10
Select the Sheet Form 217 You would notice that the TIN No. entered is
automatically prefilled in all the columns in the next Sheets.
Step 1
11
You want to form audit opinion based on Certain Observations and Comments where should you enter the same?
Issue 1
12
Select the Statement of Particulars that is applicable to you
Particulars A- Only for Traders Local Particulars B- Only for Traders having Both
Local and Interstate transactions Particulars C- For Others(E.g.
Manufacturing)
Step-2
13
Fill Up the required details as per the statement of particulars as per the instructions
Step 3
14
Validate the sheetSolve errors if anyError Sheet would be generated and if you link on the hyperlink it would fetch to the same location where error exist
Step 4
15
After solving of all the errors File would be generated for the purpose of upload
The said file would end with “_upload”
Step 5
16
Upload the Excel Generated Form 217 upload file first
After you Upload the _upload file. Other options would open up.
Step 6
17
18
Upload the Scanned Copy of◦ Audit Certificate◦ Statement of Particulars◦ Scanned Copy of list of statutory forms◦ SOFT Copy of List of Statutory Forms◦ Statutory Audit Report along with Observations
Step 7
19
For Scanned copy of statutory audit report and statement of observations, comments and notes, you can upload multiple file parts which can be combined to generate final PDF. To generate a valid and legible PDF, please make sure following :1. You are uploading file parts of PDF file only. 2. You are using 7ZIP software and selected 'Zip' Archive Format to generate file parts2. You are uploading file parts in ascending sequence(e.g. Audit Report.zip.001,Audit Report.zip.002 etc).3. File size doesn't exceed 5 MB and document is scanned with 180 dpi. 4. All file parts have been uploaded.
Uploading Guidelines
20
What is Audit Certificate?
Issue 2
21
What is Difference between Scanned Copy of List of Statutory Forms and Soft Copy of Statutory Forms?
Issue 3
22
What is Undertaking from Dealer or Authorized Person?
Issue 4
23
I have tried to upload PDF file of the Stautory Audit Report but the following error is generated?
Issue 5
24
You need to Create a ZIP File You then need to name it ending on .zip.001And 001 should be increased for more file parts
You need to mention the total no of Parts you need to upload
Solution
25
Click on Generate PDF
26
An Acknowledgment would be generated Showing the Attachments
Post Submission
27
28
No Right to Review the output Generated Currently the attachments that are upload
are not getting downloaded No clear cut guidelines with respect to
scanning of Other Documents except those mentioned in the list.
Low level of security regarding the authenticity of the Report uploaded
Other Issues as on 11/02/2015
29
In Nutshell itsnot tough we need little flexibility and Clarity
Life is very intersting….in the end, some of your greatest pains become your
greatest strengths-Drew Barrymore
30
Thank You
The views that are expressed as personal views and not of Abhay M. Sharma & Co. and no legal opinion is formed on them. The sole purpose of this presentation is to start an academic discussion only
Abhay Mukesh SharmaAbhay M. Sharma & Co.
abhay @taxmukesh.com