Many accountants, Chartered Accountants (CAs), GST practitioners, and businesses using TallyPrime Edit Log encounter a situation where the GSTR-1 Excel export works perfectly, but the JSON export either fails, freezes, or does not generate the file.
This issue can be frustrating because:
Since GST Portal accepts only JSON files for offline uploads (or APIs through GSPs), resolving this issue becomes critical before filing returns.
This article explains every possible technical reason, diagnostic procedure, and solution.
Although both exports originate from the same GSTR-1 report, internally they work differently.
Excel export is primarily a reporting function.
It simply extracts transaction data into spreadsheet format.
Excel export generally tolerates:
Hence Excel export is relatively forgiving.
JSON export is much stricter.
Before generating JSON, Tally validates numerous GST rules including:
If any internal validation fails, JSON generation may stop.
Users generally experience one of the following:
In this case:
This usually indicates that the issue is not basic GST data entry.
Even though Exception Report is clean,
one voucher may contain:
Excel ignores it.
JSON does not.
Sometimes only one section fails.
Examples:
Recommendation:
Export individual sections separately.
This immediately identifies the problematic section.
Recent GSTN schema updates have made HSN validation stricter.
Possible issues:
Excel may still export.
JSON may reject.
Recent GST schema revisions require proper document summary generation.
Incorrect:
can interrupt JSON generation.
If vouchers are:
Marked for Deletion on GST Portal
they may interfere with JSON generation in some releases.
Verify these transactions.
Internal database corruption may affect:
Even if vouchers appear normal.
Run:
Verify Company Data
and repair if required.
Companies upgraded across multiple Tally versions may contain legacy GST objects.
Especially if migrated from:
These objects sometimes fail newer JSON schema validation.
Custom TDL may interfere with:
Disable all TDLs temporarily.
Test JSON export again.
Some endpoint security software monitors:
Temporarily disable antivirus.
Retry export.
Export only to:
C:\GST\Avoid:
Try:
Run TallyPrime as Administrator.
Sometimes Controlled Folder Access blocks JSON creation.
Sometimes:
Latest GST Portal
changes schema before software vendors release updates.
Result:
Excel works.
JSON fails.
Always install latest Tally release.
Transactions outside return period may still affect:
Occasionally,
certain TallyPrime releases contain bugs affecting JSON export.
Symptoms:
Usually resolved through hotfix updates.
Update TallyPrime.
Check:
GSTR-1
No Exceptions
Verify Company Data.
Disable TDL.
Export to:
C:\GST\Run as Administrator.
Disable antivirus temporarily.
Export individual GST sections.
Check whether:
HSN Summary
causes failure.
Check:
Marked for Deletion
transactions.
Test with another company.
If another company exports successfully,
problem is company-specific.
Create a new sample company.
Generate one invoice.
Export JSON.
If sample company works,
existing data requires investigation.
Check:
inside Tally installation folder.
These logs sometimes indicate:
When Excel export works but JSON export fails, the problem is rarely simple GST data entry. It is usually related to stricter JSON validation, internal voucher inconsistencies, HSN or document summary issues, company data integrity, TDL interference, folder permissions, antivirus restrictions, or release-specific bugs.
A systematic troubleshooting approach—verifying company data, exporting section-wise, testing with a sample company, disabling custom TDLs, checking export permissions, and reviewing internal logs—helps identify the exact cause quickly. Following these steps minimizes filing delays and ensures smooth GSTR-1 JSON generation in TallyPrime Edit Log.
#TallyPrime #TallyEditLog #TallyGST #GSTR1 #GST #GSTReturn #GSTPortal #JSONExport #ExcelExport #Accounting #Bookkeeping #CharteredAccountant #CA #TaxConsultant #GSTCompliance #GSTIndia #GSTFiling #BusinessAccounting #AccountingSoftware #Finance #Taxation #GSTN #HSN #Invoice #GSTAudit #GSTTroubleshooting #TallySupport #TallySolutions #GSTSoftware #GSTUpdate #AccountingTips #BusinessSolutions #FinancialManagement #IndirectTax #IndiaBusiness #CompanyAccounts #TaxReturn #OfficeAutomation #ERP #DataValidation #SoftwareSupport #TaxProfessional #TallyPrimeHelp #GSTExpert #ExportError #JSON #Excel #BusinessIndia #FinanceTechnology #EnterpriseSoftware