Issue Importing GSTR1_Excel_Workbook_Template_V2.1 into GST Offline Tool V3.2.2 - Date Format Error

479 views 2 replies

Navin

CEO

22 Points Joined July 2017

Hi all,

I'm facing an issue while importing the GSTR1_Excel_Workbook_Template_V2.1 Excel file into the GST Offline Tool Version V3.2.2.

When I try to import the file, I receive the following error:

Error Message:

Following documents contain invalid inputs:
Possible Reasons:
• Invalid date format provided for the inputs
• Did not provide values for required fields
• Given 0 value for invoice number
• Given 0 value for gross advance received (Gross Advance Received can be saved as 0 only in tool)
• Given 0 value for taxable value (Taxable value can be saved as 0 only in tool)
• Given negative value for invoice/note value or taxable value or tax amounts
• The HSN code mentioned is not present in GST HSN master
Please check for mandatory fields, validations, date formats (dd-mmm-yyyy) and invoice/note number

Error Rows:

B2B, SEZ, DE - Row: 5

EXP - Row: 5, 6, 7, 8

EXPA - Row: 5

I have checked all the data and found correct. I think it might be issue with date format?! The date format in the Excel sheet is dd-mmm-yy, but I am unable to change it to dd-mmm-yyyy because the date fields are locked in the template.

Has anyone else encountered this issue? Is this the issue with date? Is there a workaround to fix the date format, or a way to unlock and correct the fields?

Would really appreciate any guidance from the experts here.

Thanks in advance!

Replies (2)

Rama chary Rachakonda

Master in Accounts & high court Advocate

8756 Points Joined December 2011

Here are some potential solutions:

Possible Causes and Solutions -

*Invalid Date Format*: The GST Offline Tool expects dates in `dd-mmm-yyyy` format, but your template has `dd-mmm-yy`. You can try copying the data into a new Excel sheet and formatting the date columns manually to `dd-mmm-yyyy`. -

*Locked Date Fields*: Since the date fields are locked, you can attempt to unlock them by: -

*Copying data to a new sheet*: Copy your data into a new Excel sheet, and then format the date columns as required. -

*Using a workaround*: Some users have reported success by changing the date format in the Excel sheet before importing it into the GST Offline Tool. -

*Other potential issues*: - *Missing or incorrect values*: Ensure all required fields are filled correctly, especially invoice numbers, taxable values, and HSN codes. -

*HSN code validation*: Verify that the HSN codes used are valid and present in the GST HSN master. Additional Tips -

*Download the latest GST Offline Tool*: Ensure you're using the latest version of the GST Offline Tool, as updates may resolve existing issues. -

*Check error reports*: If you encounter errors, download the error report from the GST portal to identify specific issues. -

*Manual entry for certain sections*: Note that some sections, like Exempt sheet and Doc sheet, may require manual entry on the GST portal.

If you're still facing issues, consider consulting the GST support team or a tax professional for personalized assistance.

sudhakar kulkarni

2 Points Joined May 2021

Steps to resolve Date Format error

Copy your column of Dates in a separate (New) Excel Sheet

Go the corresponding row in a separate Column of the sheet & Apply Formula to the same row of preceding Date Column as

=TEXT(Original Cell Address,"DD-MMM-YYYY")

Press Enter,

In this way all your earlier dates will be converted into the desired format (DD-MMM-YYYY).

Copy this Date Column of Excel Sheet and paste the same by applying Paste Special command (with Value & Source Formatting) to the Date column of the GSTR1_Excel Template V2.1

This will solve the validation error.

Regards.

by Sudhakar S.Kulkarni, C.A.