Data Error in Offline Utility of GSTR1
This query is : Resolved
08 July 2025
Dear All,
I am getting below error in Offline GSTR1 Utility
Following documents contain invalid inputs:Possible Reasons:•Invalid date format provided for the inputs
•Did not provided the 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,DateFormats(dd-mmm-yyyy) And invoice/note number
B2B,SEZ,DE - Row: 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30
I am getting below error in Offline GSTR1 Utility
Following documents contain invalid inputs:Possible Reasons:•Invalid date format provided for the inputs
•Did not provided the 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,DateFormats(dd-mmm-yyyy) And invoice/note number
B2B,SEZ,DE - Row: 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30
12 August 2025
Common Causes and Fixes for Offline GSTR-1 Utility Errors
Date Format
Make sure all dates (invoice date, note date, etc.) are in the correct format: DD-MM-YYYY (e.g., 15-07-2025).
Check for blank or invalid dates.
Mandatory Fields
Ensure all required fields are filled for each invoice/note.
Fields like invoice number, taxable value, GST rate, etc., cannot be blank.
Invoice Number
Invoice number should be a valid non-zero, non-negative value.
No special characters or blank spaces.
Taxable Value & Gross Advance
Taxable value and gross advance received should be ≥ 0.
Zero value is allowed only where applicable (like gross advance can be 0).
No negative values allowed.
Negative or Invalid Amounts
Check for any negative values in invoice amount, taxable value, or tax amount fields — these are invalid.
Correct any such entries.
HSN Code
Verify the HSN code against the latest GST HSN master list.
Use valid HSN codes applicable for your goods/services.
HSN codes not listed in GST system will cause errors.
Excel Sheet Validation
Do not delete columns or headers in the offline utility.
Use only the provided templates without structural changes.
Check Rows Mentioned
The error message says rows 5 to 30 have issues — carefully check these rows in your Excel sheet for the above points.
Date Format
Make sure all dates (invoice date, note date, etc.) are in the correct format: DD-MM-YYYY (e.g., 15-07-2025).
Check for blank or invalid dates.
Mandatory Fields
Ensure all required fields are filled for each invoice/note.
Fields like invoice number, taxable value, GST rate, etc., cannot be blank.
Invoice Number
Invoice number should be a valid non-zero, non-negative value.
No special characters or blank spaces.
Taxable Value & Gross Advance
Taxable value and gross advance received should be ≥ 0.
Zero value is allowed only where applicable (like gross advance can be 0).
No negative values allowed.
Negative or Invalid Amounts
Check for any negative values in invoice amount, taxable value, or tax amount fields — these are invalid.
Correct any such entries.
HSN Code
Verify the HSN code against the latest GST HSN master list.
Use valid HSN codes applicable for your goods/services.
HSN codes not listed in GST system will cause errors.
Excel Sheet Validation
Do not delete columns or headers in the offline utility.
Use only the provided templates without structural changes.
Check Rows Mentioned
The error message says rows 5 to 30 have issues — carefully check these rows in your Excel sheet for the above points.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- TDS 194-T applicability
- GST ITC REVERSE
- Fixe term employment
- TDS on TRUST
- Section 50-fixed asset-->building ceases to exist
- Withdrawal in cash from partners capital account by partner
- TDS on Complimentary "Desi Ghee and Gold Coin" Provided to KBC Contestants
- RCM ISSUE ON RENT AND TRANSPORTATION CHARGES
- Consolidated financials
- Tds on commission charges
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
