Fall ResetAmazon USFall reset deals: check better picks before checkoutAmazon US: today's deals, useful picks and quick comparisons.Check DealsClean PCRecommendedOne scan can reveal what keeps slowing WindowsLook for cleanup and repair opportunities.Run ScanFall ResetAmazon USWork and home upgrades are worth comparing todayAmazon US: today's deals, useful picks and quick comparisons.See Picks×
Skip to content
Blog

How to File GSTR-1 Using Tally.ERP 9: JSON Export, GST Portal Upload and Error Fixes

By TheFinanceBase Team8 min read
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.

Short answer: Tally.ERP 9 usually supports an export-and-upload workflow for GSTR-1. You review the return in Tally, export JSON (or Excel/CSV for the GST Offline Tool), upload it through gst.gov.in, complete sections that did not transfer, then submit and verify the return. This is different from the connected, direct-filing workflow documented for newer TallyPrime releases.

GSTR-1 reports outward supplies; it is not the tax-payment return. Validate every classification yourself—successful file processing does not prove that the underlying GST treatment is correct.

Before you begin

This procedure suits a registered Indian taxpayer that records sales in Tally.ERP 9 and needs to prepare a monthly or quarterly GSTR-1. Have the following ready:

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
  • Active GST registration and the correct GSTIN selected in Tally.
  • Company GST details, return period and filing frequency configured correctly.
  • Sales invoices, exports, SEZ supplies, advances, credit notes, debit notes and amendments entered in Tally.
  • Accurate customer GSTIN/UIN, registration type, place of supply, intra-State/inter-State treatment, tax rate, taxable value and tax ledgers.
  • HSN/SAC, quantity and UQC information where applicable.
  • GST portal credentials, internet access and—if using the spreadsheet route—Microsoft Excel 2007 or later, subject to the current GST Offline Tool requirements.

Tally can prepare data, but the taxpayer remains responsible for checking the return and complying with current GST rules. Release 6.x menus, validations and file formats may differ from later Tally.ERP 9 builds.

1. Review GSTR-1 in Tally.ERP 9

Open Gateway of Tally → Display → Statutory Reports → GST → GSTR-1. Press F2: Period and choose the month or quarter you intend to file.

Review Included in Returns, Not Relevant for Returns and any exceptions or mismatches. Drill down to invoices rather than relying only on totals. Look for:

  • B2B: GSTIN, invoice number/date, taxable value, rate, tax, place of supply and recipient category. Tally may map these to tables such as 4A–4C, 6B and 6C depending on the transaction.
  • B2C: registration status, State, supply type and the current portal’s invoice-level or consolidated reporting rules. Do not assume older turnover thresholds still apply.
  • Credit/debit notes: original invoice reference, recipient category, note date/number, taxable value, tax and whether it is an amendment.
  • Exports and SEZ: payment-of-tax versus LUT/bond treatment, shipping-bill and port details, and place of supply.
  • HSN/SAC summary: code, description where required, quantity, UQC, taxable value and tax. Reconcile the summary to invoices.

Legacy Tally.ERP 9 instructions indicate that Nil Rated Supplies and Documents Issued may need to be entered manually on the portal after import. Treat the behavior as release-specific.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

2. Method 1: Export JSON directly from Tally.ERP 9

  1. From the GSTR-1 report, press F12: Configure. If your release offers an HSN/SAC summary export setting, enable it when required.
  2. Press Ctrl+E.
  3. Set Format to JSON (Data Interchange). Where offered, enable export of HSN/SAC details even when UQC is unavailable if those transactions must be included.
  4. Press Enter and save the file in a clearly named folder, for example GSTIN_GSTR1_2026-07_TallyERP9_R6.x.

Keep an untouched backup and record the company, GSTIN, period and Tally release. Older Tally guidance refers to compressing JSON into a ZIP, while later pages describe uploading generated JSON. Follow the file type currently accepted by the GST portal or its offline utility; do not assume one extension is universal.

All Vouchers or Only New Vouchers?

Some releases offer both options when exporting spreadsheet data. All Vouchers includes transactions already exported or filed and can create duplicates. Only New Vouchers reduces re-exporting but can omit corrections or previously rejected records. It is a risk-reduction setting, not a guarantee of acceptance. Keep upload logs and use a new filename for each controlled attempt.

3. Upload JSON through the GST portal

  1. Sign in at gst.gov.in.
  2. Go to Services → Returns → Returns Dashboard, choose the financial year and period (and registration, if applicable), then select Search.
  3. Open GSTR-1’s Prepare Offline route. Portal labels and monthly/quarterly prompts can change.
  4. Choose the Tally JSON or ZIP file accepted by the current screen and wait for processing.
  5. Open upload status and download the error report, if any. Correct source vouchers in Tally where possible, refresh the GSTR-1 report and generate a new file.

After import, manually complete the sections identified by your Tally release and the live portal—commonly Tables 8A–8D for nil-rated/exempt supplies and Table 13 for documents issued. Then review invoice counts, taxable value, IGST, CGST, SGST/UTGST, notes, exports, HSN/SAC, amendments and any portal-added records.

Finally click Submit and complete the required EVC or DSC verification. Retain the ARN/acknowledgment, exported file, error reports and reconciliation. A generated, uploaded or processed file is not necessarily a filed return.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

4. Method 2: Export Excel or CSV and use the GST Offline Tool

Use this route when direct JSON is rejected, your release cannot create a compatible file, or you need the government’s validation utility.

  1. Open the same GSTR-1 report, select the period and press Ctrl+E.
  2. Choose MS Excel or CSV. CSV may create separate files for applicable tables.
  3. Download the current Returns Offline Tool from the GST portal’s official Downloads area—not an old third-party copy.
  4. In the tool choose NEW, enter taxpayer/return details and click PROCEED.
  5. Choose IMPORT FILES, then IMPORT EXCEL (or the relevant CSV option), select the Tally export and resolve warnings or invalid records.
  6. Open VIEW SUMMARY, then click GENERATE FILE to create portal JSON.
  7. Upload that JSON through GSTR-1’s Prepare Offline flow and follow the review, manual-entry, submission and verification steps above.

If Excel displays a dollar sign or corrupt values, try CSV. Tally’s Trust Center workaround is a legacy fix and may not apply to current Excel or utility versions.

5. Manual entry as a fallback

For very few transactions, use the Tally GSTR-1 report as a reconciliation reference and enter data on the portal. Manual entry is usually impractical for high-volume invoices and increases transcription risk.

Rank #3
Fast Invoicing, Accounting, GST Returns w AI. #1 Indian App for Small Businesses
  • 1. India's 1st AI enabled Online Accounting for SMEs
  • 2. 41% less clicks needed to operate than other Apps / Online Software
  • 3. Probably Only 'App' in India that does GSTR-1/3B/2A ...
  • 4. Easiest to understand. No accounting knowledge required.
  • 5. Drill-down reporting across the App to know from Balance Sheet to individual transactions and much more

Monthly, quarterly and QRMP cases

Filing frequency depends on eligibility and the taxpayer’s selection. General FY 2026–27 signals are the 11th of the following month for monthly filers and the 13th after a quarter for QRMP filers, but extensions and category-specific notices can change dates. Verify the due date displayed on the portal or in a current government notification.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Under QRMP, the Invoice Furnishing Facility (IFF) is optional and can furnish eligible invoices in the first two months of a quarter; the quarterly GSTR-1 covers the quarter. Current direct IFF workflows documented by Tally are primarily TallyPrime guidance and should not be assumed to exist in Tally.ERP 9.

Common errors and recovery

JSON rejected

Check for an outdated Tally release or offline tool, invalid GSTIN, invoice date/number, tax amount, place of supply, HSN/SAC, UQC, shipping-bill data, duplicate records or negative HSN quantities. Download the error report, fix the underlying voucher, refresh the report and export again. Do not repeatedly upload an unchanged file.

Tax amount is invalid

Compare rate, taxable value, rounding, tax ledgers and any manual alteration. Tally’s legacy guidance expects reported tax to be at least the computed amount; confirm the current portal validation and correct the voucher rather than forcing a number in the file.

Invoices are missing

Check the selected GST registration and period, Included in Returns versus Not Relevant, incomplete GST details, portal processing status and whether Only New Vouchers excluded records marked previously filed. Reconcile Tally’s included-in-returns list with the portal’s processed summary.

Free tools Windows power users keep installed

One-click scans. No signup required.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Nil-rated or Documents Issued sections are blank

For the documented Tally.ERP 9 workflow, enter these sections manually on the portal after upload.

Negative HSN quantity

Some older Tally documentation describes removing a negative sign from the qty value in the hsn section of the generated JSON and restoring the correct negative quantity in the portal afterward. Preserve the original file and use this only if the documentation for your release and current GSTN format confirms it; update Tally and the offline tool first.

E-commerce GSTIN appears incorrectly

For the specific legacy e-commerce-operator scenario, Tally Release 6.6 guidance refers to clearing an inapplicable E-Commerce GSTIN, setting the relevant B2CS worksheet type to OE and regenerating JSON. Confirm that these fields still apply to your release and current GSTN schema.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Advance receipts: a release-specific warning

Some Tally.ERP 9 documentation describes a default treatment for advance receipts tied to a turnover setting, including a ₹1.5 crore threshold in that release. This is software behavior, not a universal statement that advances below that amount are never taxable. Confirm the applicable GST law and your current configuration with a qualified tax professional.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Final pre-filing checklist

  • Correct GSTIN, registration and return period.
  • Invoice, credit-note and debit-note counts agree with books.
  • Taxable value and IGST/CGST/SGST totals reconcile.
  • B2B/B2C, exports, SEZ, amendments and recipient GSTINs are classified correctly.
  • HSN/SAC, UQC and quantities are valid.
  • Nil-rated/exempt supplies and Documents Issued are completed.
  • Upload status shows accepted data, not merely a submitted file.
  • Return is submitted, EVC/DSC-verified and ARN saved.

Tally.ERP 9 versus TallyPrime

Do not copy TallyPrime instructions such as Alt+Z → Exchange, API connectivity, in-product reconciliation or direct EVC/DSC filing into Tally.ERP 9. TallyPrime may reduce offline-file handling for businesses with frequent filings or multiple registrations, while Tally.ERP 9 plus the GST Offline Tool can remain suitable for low-volume or compatibility-constrained users. Neither product corrects incorrectly recorded transactions automatically.

For current utility instructions, use the GSTN Returns Offline Tool documentation and the official GST portal.

Frequently Asked Questions

Can Tally.ERP 9 file GSTR-1 without the GST portal?

No. Tally.ERP 9 can prepare and export return data, but the return must be uploaded, submitted and verified through the GST portal or the applicable government workflow.

Can I use TallyPrime GSTR-1 instructions in Tally.ERP 9?

Not automatically. TallyPrime’s connected menus and direct-filing features are version-specific; use the legacy Tally.ERP 9 export-and-upload path unless your release documentation says otherwise.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

What does a successful JSON upload mean?

It means the file was uploaded or processed. You still need to review data, complete missing sections, submit, complete EVC/DSC verification and retain the ARN.

Can QRMP taxpayers file through Tally.ERP 9?

They can prepare quarterly GSTR-1 data for upload, but do not assume Tally.ERP 9 provides TallyPrime’s direct IFF integration. Confirm the current portal and utility workflow.

The Bottom Line

Tally.ERP 9 remains usable for GSTR-1 when its GST data is accurate and you follow the controlled export, portal review, manual-completion and verification sequence. Keep backups, fix errors in the source vouchers, and check current GSTN file requirements and deadlines before every filing.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Written by TheFinanceBase Team

The Team behind TheFinanceBase.

Add your note

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

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Recommended PC Tool
Recommended PC Tool
Crashes, No Sound, or Screen Glitches?Free driver scan
PC Slower Than It Used to Be?Free scan - under a minute

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.