How to file GST returns offline using uKnowva Invoices

1. Click on “Settings”

 

 

2. Click on “GST Tax Report”

 

 

3. Select “Offline GST Report”

 

 

4. Select the required Month and Year and then click on “Download”

 

 

5. Once the file is downloaded click on “Extract Files”. Once you extract these files, a folder will be created which will have the download date and time “GST-OFFLINE-REPORTS-10-05-2017-12-13-31”

 

 

6. Visit website https://www.gst.gov.in/download/returns and click on “Download”. Install the tool so that you can file GST returns.

 

 

7. Open the downloaded tool and click on “New”

 

 

8. Fill up the required data and then click on “Proceed”

 

 

9. Click on “Import Files”

 

 

10. Select the required data

 

11. After selecting the required data click on “Import CSV”

 

 

12. Select the required file and click on “Open”. Repeat the procedure if you want to add more files with different categories. 

 

 

13. Click on “Yes”

 

 

14. You can view the details of the uploaded file by clicking on “View Summary”

 

 

 

15. You can view the files which you imported here. Then Click on “Generate File”

 

 

16. “Save” the generated file.

 

 

17.  Access the https://gst.gov.in/ URL. The GST Home page is displayed.

18.  Login to the GST Portal with valid credentials.

19. Click the Services > Returns > Returns Dashboard command.

20. The File Returns page is displayed.

21.  In the Financial Year drop-down list, select the financial year for which the return has to be uploaded. In this example, you will select this as 2016-17.

 

22.  In the Return Filing Period drop-down list, select the return filing period for which the return has to be uploaded. In this example, you will select this as April.

23. Click the SEARCH button.

 

 

24. Applicable returns of the selected tax period is displayed. In the Outward Supplies made by the Taxpayer GSTR1 tile, click the Prepare offline button.

 

 

25. The Upload page is displayed. Click the Choose File button.

 

 

26. Browse and navigate the file to be uploaded from your computer. Click the Open button.

 

 

 

27. Reference ID Number is generated displaying a message that the uploaded invoices are being processed.

 

 

28. Go to the B2B invoices in the GSTR1 tile. Notice the B2B invoices are uploaded.

 Similarly, you can add and upload invoices for other sections as well.

 

 

29. In case data uploaded through JSON on the portal (invoice data or other record) fails validation as defined in the portal, an Error File will be created on the online portal for only those records which failed. The error file will be available in a hyperlink as given in the below screen on the upload off line page in the portal. Initially the Status of the error file will be shown as In-Progress.

 

 

30. After some time, the Status will be changed to Processed or Processed with Error. In case of the error, the Error Report column will display a link to Generate error report.

 

 

 

31. Once the error report is generated, the Error Report column will display a link to Download error report.

 

 

32. The error file can be downloaded from the link and viewed in the Offline tool to correct the same. After making required corrections, a JSON file needs to be prepared following the same process as that for regular invoice data upload and submit the JSON file on the GST portal. The JSON file will be validated again and will be taken in by the system after the due validations. Let us take an example where error file is already generated and you need to open it using the Returns Offline tool.

 

33. To open error file using the Returns Offline tool, perform the following steps : When you double click the Offline tool icon on your desktop, the Offline tool Home Page will be displayed. In the Open Downloaded Error file from GST portal tab, click the OPEN button.

 

 

34. Browse and select the downloaded error file in zip format and click the OPEN button.

 

 

35. Details of the file which have you have downloaded from the GST Portal is displayed. Click the PROCEED button.

 

 

36. The sections where there are errors are only populated in the select section drop down list. From the Select Section drop-down list, select the desired section and proceed to rectify the erred out invoice/other data.

 

37. Notice that the error message is displayed against each Invoice number. Read each error message carefully and then click the EDIT button to edit the invoices and make the required corrections in the invoices/details.

 

 

38. After you have modified the invoices, click the SAVE button. Note: You can click the Delete button to delete the  invoice.

 

 

39. To modify the details or records at rate level, click on the’ +’ button and navigate to the rate level records. Do the necessary corrections and click the UPDATE button.

 

 

40. A success message is displayed. The status of the error message is changed to Modified (M). Similarly, you can modify the other invoice data from other sections.

 

 

41. Once all the corrections are done, click the VIEW SUMMARY button.

 

 

42. The Summary page is displayed, click the GENERATE FILE button.

 

 

43. The GST Compliant file generated by the Returns Offline tool (JSON format) will have to be saved in your computer for uploading the same on GST portal. Click the Save button.

 

 

44. Browse and select the path to save the .json file which needs to be uploaded in the GST Portal.

 

 

 

Open Downloaded Return File – GSTR-1

 

The GSTR-1 return file can be downloaded from GST portal and viewed in the Offline tool to modify, add or delete invoice details uploaded earlier by you on GST Portal. After making required changes, a JSON file needs to be prepared following the same process as that for regular invoice data upload and submit the JSON file on the GST portal. The JSON file will be validated again and will be taken in by the system after the due validations.

 

1. Login to the GST Portal with valid credentials.

2. Click the Services > Returns > Returns Dashboard command.

 

 

 The File Returns page is displayed.

 

3. In the Financial Year drop-down list, select the financial year for which the GSTR-1 return has to be downloaded.

4. In the Return Filing Period drop-down list, select the return filing period for which the GSTR-1 return has to be downloaded.

5. Click the SEARCH button.

 

 

6. Applicable returns of the selected tax period are displayed. In the Details of outward supplies of goods or services GSTR1 tile, click the PREPARE OFFLINE button. 

 

 

 

7. The Offline Upload and Download for GSTR1 page is displayed. Click the DOWNLOAD tab.

 

 

8. Click the GENERATE FILE button.

 

A message is displayed that the request has been accepted and will take 20 minutes to generate the file.

 

9. Click the Click here to download link. Return file is downloaded in the zip format.

 Let us take an example where GSTR-1 return file is already downloaded from the GST Portal and you need to open it using the Returns Offline tool. To open downloaded return file from GST Portal using the Returns Offline tool, perform the following steps:

10. When you double click the Offline tool icon on your desktop, the Offline tool Home Page will be displayed.

11. In the Open Downloaded Return file from GST portal tab, click the OPEN button.

 

 

12. Browse and select the downloaded return file in zip format and click the OPEN button.

 

13. Details of the file which have you have downloaded from the GST Portal is displayed. Click the PROCEED button.

 

 

14. The Summary page is displayed. Select the link for the desired Section Name to modify, add or delete invoice details.

 

 

 Modify Invoices Details

 

 1. Click the EDIT button to edit the invoices and make the required corrections in the invoices/details uploaded/added earlier by you in GST Portal.

 

 

 2. To modify the details or records at rate level, click on the’ +’ button and navigate to the rate level records. Note: You can make the changes at field level and click the SAVE button to save the invoice details.

 

 

3. Do the necessary corrections and click the UPDATE button.

 

 

4. A success message is displayed. The status is changed to Modified (M). Similarly, you can modify invoice and other returns data from other sections.

 

 

Add Invoices Details

 

1. Enter the invoice details. Click the ADD button.

 

2. Add the necessary details and click the SAVE button.

 

3. A success message is displayed and invoice details are added. Similarly, you can add the invoice and other returns data from other sections. Note: You can also click the IMPORT FILES button to import the invoice data using the Excel and CSV import as discussed above.

 

 

Delete Invoices Details

 

1. Select the checkbox for the invoice to be deleted. Click the DELETE button.

 

 

2. A success message is displayed. The status is changed to Deleted (D).Similarly, you can delete the other invoice and other returns data from other sections.

 

3. You can select the checkbox as shown in the screenshot below to select all invoices to delete at one go. Click the DELETE button to delete all invoices.

 

 

4. Once all the corrections are done, click the VIEW SUMMARY button.

 

 

5. The Summary page is displayed, click the GENERATE FILE button.

 

 

6. The GST Compliant file generated by the Returns Offline tool (JSON format) will have to be saved in your computer for uploading the same on GST portal. Click the Save button.

 

 

7. Browse and select the path to save the .json file which needs to be uploaded in the GST Portal.

 

Login to the GST Portal with your credential and upload the JSON file as discussed in the above section.

 

 

Open Downloaded Return File – GSTR2A

 

The GSTR2A return file can be downloaded from GST portal and viewed in the Offline tool. The downloaded file can be opened in Offline tool to view invoices and credit/debit notes uploaded by your supplier in his GSTR-1. You would not be able to take any action on the data populated as GSTR-2A is view only return

 

1. Login to the GST Portal with valid credentials.

2. Click the Services > Returns > Returns Dashboard command.

 

The File Returns page is displayed.

3. In the Financial Year drop-down list, select the financial year for which the GSTR2A return has to be downloaded.

4. In the Return Filing Period drop-down list, select the return filing period for which the GSTR2A return has to be downloaded.

5. Click the SEARCH button.

 

 

6. Applicable returns of the selected tax period are displayed. In the Auto Drafted details GSTR2A tile, click the DOWNLOAD button.

 

 

7. The Invoice Download page is displayed. Click the GENERATE FILE button. Return file is downloaded in the zip format.

 

A message is displayed that the request has been accepted and will take 20 minutes to generate the file.

 

 

Let us take an example where GSTR2A return file is already downloaded from the GST Portal and you need

 

to open it using the Returns Offline tool.

To open downloaded return file from GST Portal using the Returns Offline tool, perform the following steps:

8. When you double click the Offline tool icon on your desktop, the Offline tool Home Page will be displayed.

9. In the Open Downloaded Return file from GST portal tab, click the OPEN button.

 

 

10. Browse and select the downloaded return file in zip format and click the OPEN button.

 

 

11. Details of the file which have you have downloaded from the GST Portal is displayed. Click the PROCEED button.

 

 

12. The Summary page is displayed. Select the link for the desired Section Name to view the details.

 

13. The details for the section selected is displayed. To view the details or records at rate level, click the ’ +’ button and navigate to the rate level records.

  

14. The rate level details are displayed. Click the BACK button to go back to the previous page.

 

 15. Similarly, you can view details for other sections as well.

 

 Troubleshooting Common Errors Encountered

 

Offline tool validates the uploaded data while saving and displays errors if any based on the validations implemented in the Returns Offline tool. Some of the validations and error messages are explained and shown in the screenshots below. 

 

1. Please ensure you are entering the date in correct format. Expected formats are dd-mm-yyyy. If you are facing errors in selecting dates in given format, then you can refer the below word document to change the format of date.

2. Invoice value should be greater than INR 2,50,000 in case of B2CL (interstate supply to Unregistered person}. In case invoice value is less than INR 2, 50,000, then an error is displayed. In such cases, enter the amount more than INR 2, 50,000 in case of B2CL.

 

 3. Wrong input of GSTIN or Duplicate Invoice Number. Returns Offline tool may not be able to validate the GSTIN whether the same is active or inactive on the day of data entry but an error is displayed in case the same is not in the standard format. Similarly, if an invoice is uploaded twice in the same tax period in the Tool, then the earlier details get overwritten. However, if the same invoice is existing in the earlier tax period then the Tool may not be able to identify the duplication and error message will be populated only when the return is uploaded to the GST Portal

 

4. If anything is entered other than numeric value in the HSN/SAC of Supply field, then the Tool displays an error. 

5. If excel or csv files contain future dates or if the format of the data is not correct, then the Tool displays an error.

 

Some other general mistakes done by Users in filling the details resulting in errors are:

A. Date of invoice is after the date of Tax Period

B. Receiver GSTIN is same as of Supplier. This may arise if the taxpayers enters the details of self-invoices of purchases/inward supplies from unregistered persons. These need to be reported in

GSTR 2.

C. No Invoice exists against corresponding Credit/debit note in case of Supplies to Registered Taxpayers or Interstate Large Customers

D. Shipping bill date is prior to date of invoice.

E. Selection of wrong section while importing csv or copy excel feature.

F. While entering multi rate in b2b, b2cl, cdnr, cdnur, exp sections using excel or csv, other than rate, taxable value and cess all entry should be repeated in consecutive row. 

G. For invoice type SEZ supplier with/without payment and Deemed Exp, E-Com GSTIN is not allowed.

{jcomments on}