! Advertisements !

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.

Go to Index or search here


GST Reconciliation with Books of Accounts: How to Avoid Mismatch Notices

⬟ Intro :

A small MSME trading company in Surat, Gujarat received a GST scrutiny notice eighteen months after filing its annual GSTR-9 return. The notice identified a discrepancy of Rs. 3.8 lakh between the output tax declared in GSTR-3B and the actual sales recorded in the books for FY 2021-22. The difference had two causes. First, an advance receipt had been recorded in the books but the GST on the advance had not been declared in GSTR-3B in the month received. Second, three credit notes had been entered in the books but not reported in GSTR-1, causing output tax in the returns to be overstated relative to net sales. Resolution required a month-by-month reconstruction of original entries, correspondence with the GST officer, and payment of the tax shortfall with interest. The exercise took three months and cost Rs. 68,000 in interest, professional fees, and management time. A monthly reconciliation routine taking less than two hours would have identified both issues in the month they occurred.

GST reconciliation is the process of verifying that figures reported in GST returns match those in the books of accounts. When they do not match, the business faces two risks. The first risk is a scrutiny notice. The GSTN system automatically flags discrepancies between GSTR-1, GSTR-3B, GSTR-9, and corresponding returns filed by buyers and sellers. When the system detects a mismatch, it can issue an automated notice under Section 61 or initiate assessment under Section 73 or 74 of the CGST Act. The second risk is incorrect ITC claims. If ITC claimed in GSTR-3B is not supported by invoices in GSTR-2B, the excess ITC is at risk of reversal with interest and can attract penalties. For a growing MSME, clean GST reconciliation is not a year-end exercise. It is a monthly discipline that prevents small discrepancies from compounding into large compliance problems.

This article covers the three critical GST reconciliation checks every MSME must perform, how to identify and categorise common mismatch types, the resolution process for different mismatch causes, and how to structure a monthly GST reconciliation routine.

⬟ What Is GST Reconciliation :

GST reconciliation is the cross-checking of figures in GST returns against figures in the books of accounts to confirm consistency and to identify and resolve any differences. There are three primary reconciliation checks every GST-registered MSME should perform. The first is GSTR-1 versus books reconciliation. This checks that total sales declared in GSTR-1 for each month match sales recorded in the books for the same month. Invoices entered in books but not in GSTR-1, or credit notes in GSTR-1 but not in the books, create mismatches. The second is GSTR-3B versus books reconciliation. This checks that output tax liability in GSTR-3B matches the GST payable calculated from the books, and that ITC claimed in GSTR-3B matches eligible ITC in the books. The third is GSTR-2B versus purchase register reconciliation. This checks that ITC the business intends to claim is supported by invoices in GSTR-2B (auto-populated from supplier GSTR-1 filings). ITC can only be validly claimed on invoices reflected in GSTR-2B. The annual GSTR-9 reconciliation consolidates these monthly checks across the full financial year and adds a comparison of reported turnover against audited turnover.

A small auto parts distributor in Pune, Maharashtra performs the monthly GST reconciliation for March. Sales as per books: Rs. 42,60,000. Sales as per GSTR-1: Rs. 41,90,000. Difference: Rs. 70,000. Investigation reveals one invoice for Rs. 70,000 was raised on March 29 and entered in Tally but the accountant filed GSTR-1 on March 30 before entering the invoice. The invoice was not included in the March GSTR-1. Resolution: the invoice is included in the April GSTR-1 as a prior-period correction. The output tax of Rs. 12,600 (18% GST) is declared in April's GSTR-3B. ITC as per books (purchase register): Rs. 6,84,000. ITC as per GSTR-2B: Rs. 6,51,000. Difference: Rs. 33,000. Investigation reveals two supplier invoices worth Rs. 33,000 in purchases have not appeared in GSTR-2B because the suppliers have not yet filed their GSTR-1 for March. Resolution: ITC on these two invoices is deferred to April, when the supplier invoices are expected to appear in GSTR-2B.

⬟ Why GST Reconciliation Is Critical for a Growing Small MSME :

Maintaining monthly GST reconciliation delivers four specific protections for a growing small MSME. The first protection is prevention of scrutiny notices. The GSTN system matches GSTR-1, GSTR-3B, and GSTR-9 automatically. Mismatches persisting into the annual return are flagged for departmental action. Monthly reconciliation identifies and corrects mismatches in the same period or the next, preventing them from reaching the annual return. The second protection is clean input tax credit. Claiming ITC on invoices not in GSTR-2B, claiming ITC on ineligible expenses, or failing to reverse ITC on credit notes all create reconciliation mismatches. A monthly GSTR-2B check ensures ITC claims are always supported. The third protection is accurate tax payment. If output tax is underdeclared due to missing invoices, the shortfall must be paid later with interest at 18% per annum under Section 50 of the CGST Act. Monthly reconciliation catches underpayments in the same month. The fourth protection is simpler GSTR-9 filing. Businesses that reconcile monthly find annual return preparation straightforward. Businesses that have not reconciled monthly spend weeks resolving accumulated differences during the annual filing period.

A small pharmaceutical distributor in Hyderabad, Telangana implemented a monthly GST reconciliation routine after receiving a GSTR-3B versus GSTR-1 mismatch notice for FY 2020-21. The notice had been triggered by invoices entered in Tally after the GSTR-1 filing date, creating a cumulative output tax mismatch of Rs. 1.2 lakh. After implementing the routine, no further notices were received. GSTR-9 filing time reduced from three weeks to three days. A small construction materials supplier in Ahmedabad, Gujarat was claiming ITC on GTA transport invoices. GTA services to a registered recipient are subject to reverse charge: the recipient pays GST directly, not the supplier. The monthly GSTR-2B reconciliation identified that these invoices were appearing in GSTR-2B but the tax was a reverse charge liability rather than eligible ITC. Correcting the error before the annual return avoided a potential ITC reversal demand of Rs. 94,000.

For small MSME owners, GST reconciliation is the single most effective preventive measure against GST notices and penalties. For chartered accountants and GST practitioners handling MSME compliance, implementing a monthly reconciliation routine for clients reduces the volume of notice responses and assessment work significantly. For the business's banker and credit relationships, clean GST filings with no outstanding notices or demands signal financial discipline and reduce friction in working capital and loan assessments.

⬟ How Most Small MSMEs Currently Handle GST Reconciliation :

Most small MSMEs in India perform GST reconciliation infrequently, typically only at GSTR-9 filing time or in response to a notice. Monthly reconciliation is the exception. The standard practice is to file GSTR-1 and GSTR-3B each month based on data prepared by the accountant or CA, without verifying whether returns match the books. This works without incident when entries are clean and complete. It fails when invoices are missed from GSTR-1, when credit notes are not reflected in both records, when ITC is claimed without checking GSTR-2B, or when advances create timing differences. Mismatches tend to compound over time. A small April discrepancy uncorrected grows as subsequent months add new entries referencing the original mismatch. By GSTR-9 filing, the cumulative difference may be large enough to attract a notice.

⬟ How GST Reconciliation Is Evolving :

The GST system is becoming increasingly automated in detecting mismatches. GSTN's data analytics capabilities have improved significantly since 2020, and the department uses risk-based analysis to identify taxpayers with persistent discrepancies between GSTR-1, GSTR-3B, and GSTR-9. The likelihood of receiving a notice for a mismatch is materially higher today than in 2018. E-invoicing, which automatically populates GSTR-1 for businesses above the turnover threshold, is reducing one category of mismatch by eliminating manual data entry errors. However, GSTR-3B is still prepared separately and requires reconciliation against auto-populated GSTR-1 data. Tally and Zoho Books are developing reconciliation dashboards that compare GSTR-1 data with books data and highlight differences. These tools will make monthly reconciliation significantly faster for MSMEs using accounting software.

⬟ How to Perform Monthly GST Reconciliation :

Monthly GST reconciliation involves three sequential checks. The total time for a small MSME with up to 150 monthly invoices is typically 90 minutes to two hours. The first check is GSTR-1 versus sales register reconciliation. Export the GSTR-1 data from the GST portal for the month. Extract sales totals from the books for the same period. Compare the figures at both gross turnover level and GST amount level. Differences indicate invoices missing from GSTR-1, invoices in GSTR-1 but not in the books, or credit notes treated differently in the two records. The second check is GSTR-3B output tax versus calculated output tax. The output tax liability in GSTR-3B should match the sum of GST amounts on all invoices in the books minus credit notes. If the first check identified missing invoices, GSTR-3B output tax will need adjustment. The third check is GSTR-2B versus purchase register reconciliation. Download the GSTR-2B statement from the GST portal (typically available by the 14th of the following month). Compare it against the purchase register. For each purchase invoice in the books, check whether a corresponding entry appears in GSTR-2B. Invoices absent from GSTR-2B indicate the supplier has not yet filed their GSTR-1: defer the ITC claim until the invoice appears. Document each difference with a specific reason: timing difference, missing entry, supplier non-filing, credit note discrepancy, or ineligible ITC. This documentation supports resolution actions and GSTR-9 preparation.

● Step-by-Step Process

After the GSTR-1 filing date each month, download the filed GSTR-1 summary from the GST portal. Generate the sales register for the same month from accounting software. Compare total taxable value and total GST. Note any difference and identify its cause. For invoices in the books but missing from GSTR-1, include them in the following month's GSTR-1 as prior-period corrections. For credit notes in the books but missing from GSTR-1, add them to the following month's GSTR-1. Compare output tax liability in GSTR-3B against calculated output tax from the sales register after applying the corrections identified in the first check. Download GSTR-2B for the month once it is available. Compare each purchase invoice in the books against GSTR-2B entries. Identify invoices present in the books but absent from GSTR-2B. For invoices absent from GSTR-2B, contact the relevant supplier to request they file their GSTR-1. Defer the ITC claim to the month when the invoice appears in GSTR-2B. Document each reconciliation check with the date performed, differences identified, causes determined, and resolution actions taken. Maintain this in a dedicated monthly GST reconciliation file.

● Tools & Resources

The GST portal at gst.gov.in provides GSTR-1, GSTR-3B, GSTR-2B, and GSTR-9 data downloads in Excel format for reconciliation. Tally Prime at tallysolutions.com provides GST reconciliation reports comparing GSTR-1 data with sales register data and GSTR-2B with purchase register data within the software. Zoho Books at zoho.com/books provides a GST filing section with reconciliation views comparing booked data against filed returns. ClearTax at cleartax.in provides a dedicated GST reconciliation tool that imports GSTR-2B data and compares it against uploaded purchase data. The GSTN helpdesk at 1800-103-4786 provides technical assistance for portal-related issues. The Institute of Chartered Accountants of India at icai.org connects MSMEs with GST practitioners who can conduct or review monthly reconciliation.

● Common Mistakes

Claiming ITC on invoices not yet in GSTR-2B is the most common and most consequential reconciliation error. Under amended Section 16 of the CGST Act, ITC can only be claimed on invoices appearing in GSTR-2B. Claiming ITC before the invoice is in GSTR-2B creates an excess claim subject to reversal with interest. The monthly GSTR-2B check makes this error visible before GSTR-3B is filed. Not reporting credit notes in GSTR-1 is the second most common error. Credit notes must be reported in GSTR-1 in the same month or the following month. Unreported credit notes cause GSTR-1 output tax to be overstated relative to the books, creating a systematic mismatch that accumulates and attracts scrutiny. Filing GSTR-3B before completing the GSTR-1 versus books check is the third common mistake. If output tax is understated due to a missing invoice, the GSTR-3B liability is also understated. The shortfall attracts interest from the original due date. Completing the GSTR-1 check before finalising GSTR-3B data prevents this.

● Challenges and Limitations

Supplier non-filing creates an unavoidable timing difference in GSTR-2B reconciliation. When a supplier fails to file GSTR-1, their invoices do not appear in the buyer's GSTR-2B and ITC cannot be claimed for that period. The practical response is to monitor GSTR-2B monthly for missing supplier invoices and follow up directly with suppliers who consistently fail to file on time. Amendment provisions under GST allow corrections to prior-period mismatches, but only up to the GSTR-1 filing deadline for November of the following financial year. After this deadline, corrections to prior periods are no longer accepted and the mismatch must be resolved through payment of differential tax or assessment proceedings. Monthly reconciliation is the window within which corrections can be made without formal proceedings. For businesses with high transaction volumes, manual reconciliation is time-consuming. Accounting software reconciliation tools and dedicated GST platforms reduce the time required but need initial setup.

● Examples & Scenarios

A small MSME printing and packaging company in Chennai, Tamil Nadu was claiming ITC on canteen and food expenses provided to employees as a welfare benefit. Under Section 17(5)(b) of the CGST Act, ITC on food and beverages is specifically blocked and cannot be claimed. The monthly GSTR-2B reconciliation showed these invoices appearing in GSTR-2B, but they were ineligible ITC under Section 17(5). After identifying the error in the reconciliation, the ITC claims on these invoices were reversed. The total amount of ineligible ITC that had been claimed over eight months was Rs. 1.17 lakh, which was voluntarily reversed with interest before a notice was issued. A small MSME wholesale fruits and vegetables distributor in Nagpur, Maharashtra was receiving purchase invoices from some unregistered suppliers. Purchases from unregistered dealers are subject to reverse charge mechanism in certain categories. The monthly purchase register review identified that reverse charge had not been calculated and declared in GSTR-3B for these purchases. The accountant calculated the outstanding reverse charge liability, paid it in the following month's GSTR-3B, and the situation was regularised before any notice was received.

● Best Practices

Perform the GSTR-1 versus books reconciliation check before filing GSTR-1 each month, not after. The check takes 20 to 30 minutes for a business with up to 100 invoices and ensures that all invoices in the books for the month are included in GSTR-1 before the return is filed. Download and review GSTR-2B within two days of its availability each month (typically the 14th of the following month) and compare it against the purchase register before filing GSTR-3B. Any ITC claims that cannot be matched to GSTR-2B entries should be deferred rather than claimed and risked for reversal. Maintain a monthly GST reconciliation file documenting the three checks, the differences found, and the resolution actions. This file is the most useful document to have when responding to a GST notice or preparing GSTR-9, as it provides the complete explanation of every reconciliation difference across the year.

⬟ Disclaimer :

This content is intended for informational and educational purposes only and does not constitute professional tax, legal, or accounting advice. GST reconciliation requirements, eligible ITC categories, assessment timelines, and correction procedures are subject to change through GST Council notifications, CBIC circulars, and judicial interpretations. The information in this article reflects the regulatory position as understood at the time of the most recent update. MSME owners should consult a qualified chartered accountant or GST practitioner for reconciliation guidance and notice response specific to their business and GST registration category.


⬟ How Desi Ustad Can Help You :

After this month's GSTR-1 and GSTR-3B are filed, take two hours to compare the figures against the sales register and purchase register in your accounting software. Download GSTR-2B for the same month and check whether all ITC claimed in GSTR-3B is supported by entries in GSTR-2B. If you find differences, document them and discuss the resolution with your chartered accountant. If you are not currently doing this check monthly, starting now prevents the accumulation of mismatches that create scrutiny risk at the annual return stage. If you would like to implement a structured monthly reconciliation routine, ask your CA or GST practitioner to set one up at the next available opportunity.

Register your business with our online directory or join our bidding platform.

Frequently Asked Questions (FAQs)

Q1: What is GSTR-2B and how is it different from GSTR-2A?

A1: The key practical difference is that GSTR-2B is fixed on the 14th of each month and represents the ITC available for the previous month's GSTR-3B filing. GSTR-2A continues to update after the 14th as suppliers file late or amend their returns. For claiming ITC in a specific return period, the rule now requires that the ITC claimed in GSTR-3B should not exceed the ITC reflected in GSTR-2B for that period. Any excess ITC claim over the GSTR-2B amount is technically ineligible and subject to reversal. This means the monthly GSTR-2B reconciliation should be completed before

Q2: How do I fix a mismatch between GSTR-1 and my books of accounts?

A2: The amendment and addition mechanism in GSTR-1 allows corrections to prior-period invoices up to the filing deadline for November of the following financial year. To add an invoice missed in a prior month, include it in the current month's GSTR-1 with the original invoice date. The system will treat it as a late-reported invoice. To correct an invoice that was reported with the wrong amount or wrong GSTIN, use the amendment column in GSTR-1 to submit the corrected version. When an invoice is added or corrected in GSTR-1, the corresponding output tax must also be

Q3: What happens if I claim ITC that is not in GSTR-2B?

A3: The practical risk of excess ITC claims has increased significantly because GSTN now compares every taxpayer's GSTR-3B ITC claims against their GSTR-2B data automatically and flags cases where GSTR-3B claims exceed GSTR-2B ITC by more than the permitted tolerance. When a supplier eventually files their delayed GSTR-1 and the invoice appears in GSTR-2B in a subsequent month, the ITC becomes eligible at that point. The correct approach is to reverse the excess ITC in the period when it was claimed, then re-claim it in the period when it first appears in GSTR-2B. For small amounts

Q4: What is the time limit for correcting GST return mismatches?

A4: The time limit creates a practical urgency for identifying and correcting mismatches within the same financial year where possible. A mismatch identified in the annual reconciliation that crosses the November deadline can only be resolved through a voluntary payment under Section 73 or through assessment, both of which are more complex and potentially more costly than a return amendment. For businesses that perform monthly reconciliation, mismatches are almost always identified and corrected well within the amendment window. For businesses that only reconcile annually at GSTR-9 time, some mismatches may already be outside the amendment window

Q5: How do I handle ITC on invoices where the supplier has not filed their GSTR-1?

A5: A supplier's persistent failure to file GSTR-1 has a direct financial cost to their buyers: the ITC that would otherwise be available is deferred or permanently lost if the supplier fails to file within the amendment deadline. For significant purchase volumes, this deferral has a real working capital impact. The most effective practical measure is to include GSTR-1 filing compliance as a supplier evaluation criterion, particularly for high-value suppliers. Checking a supplier's GSTR-1 filing history on the GST portal before placing significant orders is a straightforward due diligence step. Suppliers who are consistently late or

Q6: What are blocked ITC categories under Section 17(5) of the CGST Act?

A6: The most commonly misunderstood blocked ITC categories in MSME practice are food and beverages and motor vehicles. Food and beverages provided to employees as a welfare benefit are blocked under Section 17(5)(b), meaning canteen expenses, meals provided on-site, or food purchased for staff are not eligible for ITC even if the supplier is GST-registered and has filed their GSTR-1. Motor vehicles used for transporting passengers are blocked unless the business itself is in the business of transporting passengers. Cars purchased for use by the owner or managers for business travel are therefore typically blocked. However,

Q7: How does the monthly GST reconciliation relate to GSTR-9 annual return filing?

A7: The GSTR-9 form requires disclosure of several reconciliation items including the difference between turnover declared in monthly GSTR-1 filings and the audited annual turnover, the difference between ITC claimed in monthly GSTR-3B filings and the total eligible ITC per the books, any additional tax paid or ITC reversed during the year as a result of reconciliation, and amendments to prior-period invoices made during the year. For businesses with a clean monthly reconciliation record, each of these items is readily available from the monthly reconciliation files. For businesses reconciling for the first time at GSTR-9 stage,

Q8: Can accounting software like Tally Prime perform GST reconciliation automatically?

A8: To use Tally Prime's GST reconciliation feature, download the GSTR-2B JSON file from the GST portal for the relevant month and import it into Tally using the GST Reconciliation option under the GST menu. Tally will match each entry in the GSTR-2B against the corresponding purchase voucher in the books and display a reconciliation report showing matched entries, entries in GSTR-2B but not in the books, and entries in the books but not in GSTR-2B. For each category of difference, the accountant can drill down to the specific invoices and take corrective action. Zoho Books

Q9: What triggers a GST mismatch notice and how should I respond to one?

A9: When a GST mismatch notice is received, the first step is to identify the specific discrepancy cited in the notice and compare it against the books of accounts and filed returns for the period in question. If the discrepancy is due to a legitimate timing difference or amendment that has since been corrected, the response to the notice should explain the specific entries that caused the difference and how they were resolved. If the discrepancy reflects a genuine tax shortfall, the differential tax should be paid along with applicable interest before responding, and the payment

Q10: How often should a small MSME perform GST reconciliation?

A10: The monthly reconciliation routine should be structured as a standard month-end closing task alongside the other financial close activities such as bank reconciliation and outstanding payables and receivables review. If the same person handles daily accounting and the monthly GST filing, the reconciliation adds approximately 90 minutes to two hours to the month-end close. If GST filing is handled by an external CA or GST practitioner, the reconciliation should be completed by the internal accountant and shared with the practitioner before the GSTR-3B is finalised. Businesses with fewer than 50 invoices per month can complete
Please submit any questions via the 'suggestions' window. We are committed to enhancing the user experience by remaining fair, transparent, and user-friendly.



! Advertisements !
! Advertisements !

These sections are reserved for advertisements. While our in-house advertising system is under development, Third party Ad-sense will be displayed here. For more information, please refer to our “Advertisements” insight.