GSTR-1 Mismatch in Tally: Complete Guide to Identify and Resolve Discrepancies

GSTR-1 mismatches in TallyPrime occur when invoice data doesn't align with filed GST returns. Common causes include duplicate invoices, incorrect tax rates, HSN code errors, and manual data entry mistakes. Identify mismatches using GSTR-1 reports, fix underlying invoice records, and use GSTR-2B reconciliation to prevent future discrepancies.

What Is a GSTR-1 Mismatch and Why It Matters

A GSTR-1 mismatch occurs when the invoices you file in your monthly GSTR-1 return do not align with the actual invoice records in your TallyPrime system or with the data uploaded to the GST portal. This discrepancy can trigger notices from the GST department, delay input tax credit claims for your customers, and create compliance risks.

GSTR-1 is the outbound supply return filed by all GST-registered businesses. It contains details of all taxable supplies, exempt supplies, and nil-rated supplies made during a month. When the data in your Tally system doesn't match what you filed, the GST authorities can cross-check with GSTR-2B (inbound invoices) filed by your customers and flag inconsistencies. This leads to show-cause notices, penalties, and reputational damage.

Understanding and resolving GSTR-1 mismatches is essential for maintaining clean GST compliance and avoiding costly amendments.

Common Causes of GSTR-1 Mismatches in TallyPrime

Several factors lead to GSTR-1 mismatches. Identifying the root cause is the first step toward prevention.

Duplicate Invoice Numbers

If you create two invoices with the same invoice number in TallyPrime, the system may file both, or the second one may overwrite the first. This creates confusion when the GST portal processes the data. Always use unique, sequential invoice numbers.

Invoice Number Gaps or Discontinuities

If you skip invoice numbers (e.g., 101, 102, 104 instead of 101, 102, 103), the GST department may question whether invoice 103 exists. Gaps must be explained or the missing invoices must be filed.

Incorrect HSN or SAC Codes

Products and services are classified under Harmonized System of Nomenclature (HSN) or Services Accounting Code (SAC). If you use the wrong code, the tax rate may be incorrect, leading to a mismatch in tax amount.

Wrong Tax Rate Applied

Applying 5% GST instead of 18%, or vice versa, is a common error. This affects the total tax amount in GSTR-1 and creates a mismatch with what customers claim in GSTR-2B.

Deleted or Voided Invoices

If you delete an invoice in TallyPrime after filing GSTR-1, the data no longer exists in your system, but it remains in the filed return. This creates a discrepancy that is hard to explain.

Manual Invoice Creation Outside Tally

Invoices created in Excel or other software and not recorded in TallyPrime will not appear in your GSTR-1 report, even if you filed them manually on the GST portal. Always create invoices in Tally.

Data Entry Errors

Typos in customer names, GSTIN, invoice amounts, or dates cause mismatches. These errors are often caught during GSTR-2B reconciliation when customers file their returns.

How to Identify GSTR-1 Mismatches in TallyPrime

Follow these steps to identify mismatches between your TallyPrime data and filed GSTR-1 returns.

Step 1: Generate GSTR-1 Report in TallyPrime

Open TallyPrime and navigate to Gateway of Tally > Display More Reports > GST Reports > GSTR-1. Alternatively, press Alt+G and select GSTR-1. Choose the relevant month and financial year. This report shows all invoices TallyPrime will file for that period.

Step 2: Download GSTR-1 from GST Portal

Log into the GST portal (gst.gov.in), go to Services > Returns > GSTR-1, and download the JSON file or view the filed return. Compare the invoice count, total taxable value, and total tax amount with your TallyPrime report.

Step 3: Cross-Check Invoice Details

Create a list of all invoices in TallyPrime GSTR-1 report. Compare invoice numbers, dates, customer GSTIN, HSN/SAC codes, quantities, amounts, and tax rates against the GST portal data. Use a spreadsheet to track differences.

Step 4: Check for Duplicates and Gaps

Look for duplicate invoice numbers or missing numbers in the sequence. If invoice 105 is missing, verify whether it was created, deleted, or never issued.

Step 5: Review GSTR-2B Reconciliation

Use TallyPrime's GSTR-2B reconciliation feature to cross-check outbound invoices against inbound claims. If a customer claims an invoice in their GSTR-2B that you didn't file in GSTR-1, or with different details, you have a mismatch.

Step-by-Step Process to Fix GSTR-1 Mismatches

Once you identify a mismatch, follow this process to resolve it.

Correct Invoice Data in TallyPrime

If the mismatch is due to incorrect data in TallyPrime (wrong tax rate, HSN code, or amount), edit the original invoice. Go to Gateway of Tally > Transactions > Invoices > Sales, find the invoice, and press Alt+E to edit. Correct the error and save. TallyPrime will automatically update the GSTR-1 report.

Delete and Recreate if Necessary

If the invoice is severely corrupted or has multiple errors, delete it (press Alt+D) and recreate it with correct data. Ensure the invoice number remains the same to maintain continuity.

Use Data Repair for Corruption

If TallyPrime shows data inconsistencies, use the data repair feature. Go to Alt+Y (Data) > Repair or F1 (Help) > Troubleshooting > Repair. Always back up your company data before running repair.

File GSTR-1A Amendment

If you have already filed GSTR-1 and discovered a mismatch, you cannot directly correct the original return. Instead, file GSTR-1A (amendment) in the next month. Correct the invoice data in TallyPrime, regenerate the GSTR-1 report, and file the amendment on the GST portal. Include details of what was corrected and why.

Using GSTR-2B Reconciliation to Prevent Mismatches

GSTR-2B is the inbound supply return that shows invoices filed by your suppliers. TallyPrime 6.x includes a built-in GSTR-2B reconciliation feature that helps you cross-check your outbound invoices against customer claims.

Download GSTR-2B from the GST portal and upload it to TallyPrime. The system will compare your filed invoices with what customers claim they received. If a customer claims an invoice with a different amount or tax rate than what you filed, the reconciliation report will highlight it. This allows you to identify and correct mismatches before they become compliance issues.

Role of GST Configuration in Preventing Mismatches

Proper GST setup in TallyPrime is critical to prevent mismatches. Enable GST under F11 (Company Features) and ensure the following are configured correctly:

• Company GSTIN and registration type (regular, composition, or unregistered)
• HSN/SAC codes for all items and services
• Tax rates (5%, 12%, 18%, 28%) for each item category
• Exemption flags for exempt supplies
• Customer and supplier GSTIN details
• Place of supply rules for inter-state and intra-state transactions

Incorrect configuration leads to wrong tax calculations and automatic mismatches. Review these settings regularly.

E-Invoicing as a Mismatch Prevention Tool

E-invoicing eliminates manual data entry errors and ensures accuracy. When you enable e-invoicing in TallyPrime, each invoice generates a unique IRN (Invoice Reference Number) and QR code. The invoice is automatically reported to the IRP (Invoice Registration Portal) and flows directly to your GSTR-1 without manual intervention. This reduces the risk of duplicate invoices, missing invoices, or data entry errors.

To enable e-invoicing, ensure your TSS (Technical Support Services) is active. E-invoicing is mandatory for businesses with turnover above Rs 20 crore and optional for others. It is highly recommended to avoid GSTR-1 mismatches.

Worked Example: Identifying and Fixing a GSTR-1 Mismatch

Let's work through a real scenario to illustrate how to identify and fix a GSTR-1 mismatch.

Scenario: You are a goods supplier in Purnea, Bihar. You filed GSTR-1 for March 2026 showing total taxable supplies of Rs 5,00,000 and total GST of Rs 90,000. Your customer in Delhi claims an invoice for Rs 1,50,000 with GST of Rs 27,000 in their GSTR-2B. However, in your TallyPrime GSTR-1 report, that invoice shows Rs 1,50,000 with GST of Rs 22,500 (at 15% instead of 18%). This is a mismatch.

Root Cause: When you created the invoice, you accidentally selected 15% tax rate instead of 18%.

Fix:

1. Open TallyPrime and go to Gateway of Tally > Transactions > Invoices > Sales.
2. Find the invoice dated March 2026 for Rs 1,50,000.
3. Press Alt+E to edit.
4. Correct the tax rate from 15% to 18%. The GST amount will auto-update to Rs 27,000.
5. Save the invoice.
6. Generate the GSTR-1 report again. The total taxable supplies remain Rs 5,00,000, but total GST now increases to Rs 94,500.
7. File GSTR-1A (amendment) on the GST portal for March 2026, showing the corrected invoice with Rs 27,000 GST.
8. Your customer's GSTR-2B claim of Rs 27,000 now matches your filed GSTR-1 amendment.

This resolved the mismatch and ensured compliance.

Reconciliation Table: GSTR-1 vs. TallyPrime Report

Use this table to systematically compare your GSTR-1 filed data with TallyPrime records:

Field	TallyPrime GSTR-1 Report	GST Portal GSTR-1 Filed	Match (Yes/No)	Action if Mismatch
Total Invoice Count	125	124	No	Find the extra invoice in Tally or the missing one on portal
Total Taxable Value	Rs 25,00,000	Rs 25,00,000	Yes	No action
Total CGST	Rs 2,25,000	Rs 2,20,000	No	Check tax rates on individual invoices
Total SGST	Rs 2,25,000	Rs 2,20,000	No	Correct HSN/SAC codes or tax rates
Intra-State Invoices	95	95	Yes	No action
Inter-State Invoices	30	29	No	Verify place of supply and GSTIN of customers

Best Practices to Prevent Future GSTR-1 Mismatches

Implement these practices to avoid GSTR-1 mismatches going forward:

• Use Sequential Invoice Numbers: Never skip numbers or reuse them. Maintain a clear sequence.
• Verify HSN/SAC Before Invoicing: Ensure every product and service has the correct HSN or SAC code in your item master.
• Double-Check Tax Rates: Confirm the applicable GST rate (5%, 12%, 18%, or 28%) before creating an invoice.
• Validate Customer GSTIN: Verify that the customer's GSTIN is correct and matches their registration.
• Create All Invoices in Tally: Never create invoices outside TallyPrime. Always use TallyPrime for invoice generation.
• Reconcile Monthly: Before filing GSTR-1, reconcile your TallyPrime report with your manual invoice records.
• Enable E-Invoicing: Use e-invoicing in TallyPrime to eliminate manual entry errors.
• Review GSTR-2B: Download GSTR-2B and reconcile it with your GSTR-1 to catch mismatches early.
• Keep Audit Trail: Document all corrections and amendments. Maintain records of why changes were made.
• Regular Data Backup: Back up your TallyPrime data weekly to prevent data loss or corruption.

When to Seek Professional Help

If you encounter complex mismatches, multiple errors, or data corruption that TallyPrime's repair feature cannot fix, consult a Tally-certified professional. Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar since 2010, offers expert support for GSTR-1 reconciliation, data repair, and GST compliance troubleshooting. We help businesses resolve mismatches quickly and implement preventive measures.

Summary: Key Takeaways

GSTR-1 mismatches in TallyPrime stem from duplicate invoices, incorrect tax rates, HSN code errors, data entry mistakes, and deleted invoices. Identify mismatches by comparing your TallyPrime GSTR-1 report with the GST portal data and using GSTR-2B reconciliation. Fix them by correcting invoice data in Tally, using data repair if needed, and filing GSTR-1A amendments. Prevent future mismatches by maintaining sequential invoice numbers, verifying HSN/SAC codes, using e-invoicing, and reconciling monthly. Proper GST configuration in F11 and regular backups are essential. If issues persist, seek help from a certified Tally partner.

GSTR-1 mismatches can be resolved quickly with the right approach and tools. If you are struggling with GSTR-1 discrepancies or need help setting up GST compliance in TallyPrime, reach out to Global IT Care, a Tally 3 Star Certified Partner serving Purnea, Bihar and surrounding regions since 2010. We provide end-to-end support for GSTR-1 filing, GSTR-3B filing, e-way bill integration, and complete GST compliance. Contact us today at +91 75469 00951 on WhatsApp for a free consultation and expert guidance on resolving your GSTR-1 mismatches.