ca. abhay mukesh sharma managing partner, abhay m. sharma & co. 1
TRANSCRIPT
![Page 1: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/1.jpg)
1
Study Circle Meeting on VAT Audit E-Filing
CA. Abhay Mukesh SharmaManaging Partner, Abhay M. Sharma & Co.
![Page 2: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/2.jpg)
2
Form 217Online Utility
![Page 3: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/3.jpg)
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
![Page 4: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/4.jpg)
4
After Login Select Audit Report
Selection of Audit Report
![Page 5: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/5.jpg)
5
Download the template
![Page 6: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/6.jpg)
6
Use of Latest Template
![Page 7: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/7.jpg)
7
Extract the File and Enable Macro
![Page 8: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/8.jpg)
8
![Page 9: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/9.jpg)
9
Alphanumeric
Alphabets
Numbers
Date
Dropdown
Few Basics of Template
![Page 10: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/10.jpg)
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
![Page 11: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/11.jpg)
11
You want to form audit opinion based on Certain Observations and Comments where should you enter the same?
Issue 1
![Page 12: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/12.jpg)
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
![Page 13: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/13.jpg)
13
Fill Up the required details as per the statement of particulars as per the instructions
Step 3
![Page 14: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/14.jpg)
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
![Page 15: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/15.jpg)
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
![Page 16: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/16.jpg)
16
Upload the Excel Generated Form 217 upload file first
After you Upload the _upload file. Other options would open up.
Step 6
![Page 17: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/17.jpg)
17
![Page 18: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/18.jpg)
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
![Page 19: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/19.jpg)
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
![Page 20: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/20.jpg)
20
What is Audit Certificate?
Issue 2
![Page 21: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/21.jpg)
21
What is Difference between Scanned Copy of List of Statutory Forms and Soft Copy of Statutory Forms?
Issue 3
![Page 22: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/22.jpg)
22
What is Undertaking from Dealer or Authorized Person?
Issue 4
![Page 23: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/23.jpg)
23
I have tried to upload PDF file of the Stautory Audit Report but the following error is generated?
Issue 5
![Page 24: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/24.jpg)
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
![Page 25: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/25.jpg)
25
Click on Generate PDF
![Page 26: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/26.jpg)
26
An Acknowledgment would be generated Showing the Attachments
Post Submission
![Page 27: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/27.jpg)
27
![Page 28: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/28.jpg)
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
![Page 29: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/29.jpg)
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
![Page 30: CA. Abhay Mukesh Sharma Managing Partner, Abhay M. Sharma & Co. 1](https://reader037.vdocuments.us/reader037/viewer/2022102622/56649c9b5503460f9495a070/html5/thumbnails/30.jpg)
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