Common Errors Encountered in Saving the Data to GSTN Through Excel | H&R Block | Blog
Government Extends Date of Filing for Composition Scheme till 16th August 2017
August 9, 2017
The Process of Reconciliation under GST
August 9, 2017

Common Errors Encountered in Saving the Data to GSTN Through Excel

This article delineates the common errors which are encountered while uploading and saving the data on invoices to GSTN through the Offline Excel Utility.  GSTN has released the user manual, addressing the solutions for errors encountered. In this article, we will look at the commonly faced errors and the precautions to be taken while entering/saving the data.

Here is a list of some commonly faced errors and the precautions that you need to take in order to avoid them:

1) Error – Date format

Precaution – Please ensure you are entering the date in the correct format. Expected formats are dd-mm-yyyy.

2) Error – Value less than Rs 2,50,000/- in case B2CL interstate supply to unregistered person

Precaution – Invoice Upload/Download 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 an error is displayed. 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.

3) Error – HSN and SAC field error

Precaution – If anything is entered other than the numeric value in the HSN/SAC of supply field, then the tool displays an error.

4) Error – Dates and formatting errors

Precaution – 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:

  • If date of invoice is after the date of tax period
  • Receiver GSTIN is same as supplier
  • No invoice exists against corresponding credit/debit note in case of supplies to registered taxpayers or interstate large customers
  • Shipping bill date is prior to the date of invoice.

The taxpayers shall take care of the above mentioned commonly faced errors while uploading and saving the invoice data on GSTN common portal using excel offline tool.

  • Share: 
Ankita Mathur
Ankita Mathur
Ankita is a CA by qualification and works as a GST Expert at H&R Block. She specialises in matters of Indian GST. Her job involves helping people understand GST in the most simplified ways and helping with compliance of GST Laws.

2 Comments

  1. Sandeep Mohile says:

    Ms.Ankita Ji

    I have tried several times to upload GSTR 1 for Aug 17 by using uploading excel file template option and every time got the same
    error – “Error Encountered while uploading the file”
    I have check the Format in template is shows correct – format- dd-mm-yyyy . My All Invs are B2 To B2 , No Inv Number has been repeated, Viewed Summary and then create JSON file,.
    Even then also we are getting Error ” Error encountered while Uploading”
    Kindly guide in this regards by sending e mail.

    Thanks & Regards,

    Sandeep Mohile

    Thanks

  2. MANJUNATHA REDDY says:

    I am manjunatha gst registered in 2017 July but I have not sale last 6 months now my gst number is inactive so what can I do now

Leave a Reply

Your email address will not be published. Required fields are marked *