All You Need to Know About GST Reconciliation

Every GST-registered business in India eventually faces the same challenge. If you file monthly GST returns, you have likely encountered this: the figures in your books do not match those on the GST portal. The Input Tax Credit (ITC) amount appears as one figure in your purchase register, another in GSTR-2B, and a third in GSTR-3B. Even a minor discrepancy can reduce your ITC, trigger a notice, or lead to the burden of additional tax, interest, and penalties. This is why GST reconciliation is a crucial aspect of GST compliance in India. It helps you avoid these issues. 

This guide explains what GST reconciliation is and how to perform it step-by-step. It covers key types, examples, statement formats, Excel-based methods, common discrepancies and their resolutions, notices, and details regarding annual GSTR-9 and GSTR-9C reconciliation.

What is GST Reconciliation?

GST reconciliation is a process where you match your accounting records (sales, purchases, tax paid, and credit claimed) with the data available on the GST portal and your filed GST returns. The objective is to promptly identify and rectify any discrepancies or errors, thereby avoiding future financial losses or compliance-related issues.

It addresses four practical questions:

• Have the details of every sale been accurately reported in GSTR-1 and GSTR-3B?

• Is every purchase claimed as Input Tax Credit (ITC) actually eligible and available?

• Does the tax paid match the tax liability (the tax actually due)?

• Do the monthly returns align with the annual returns and financial statements?

GST Reconciliation: Explained Simply

Think of it as bank reconciliation for GST. Just as you reconcile your cash book with your bank statement, here you reconcile your sales and purchase records with the data captured by the government's system from both you and your suppliers.

Why is GST reconciliation important?

Safeguards your Input Tax Credit: Credit is generally available only when the invoice appears in your auto-drafted statement, GSTR-2B.

Prevents notices: The system automatically compares GSTR-1, GSTR-2B, and GSTR-3B, and may issue a notice if discrepancies exceed the prescribed limits.

Avoids interest and penalties: Incorrect or excess credit claims and underpayment of tax can lead to interest charges and other consequences.

Improves cash flow: Timely claiming of every eligible rupee of credit reduces the tax payable in cash.

Ensures accurate accounts: Well-maintained records simplify audits, loan processing, and the filing of annual returns.

Promotes supplier discipline: Regular invoice matching identifies suppliers who file late or incorrectly, enabling you to take appropriate action.

How often should GST reconciliation be done?

Monthly: After the generation of GSTR-2B and before filing GSTR-3B.

Quarterly: To review pending mismatches, especially for QRMP taxpayers.

Annually: Comprehensive reconciliation before filing GSTR-9 (and GSTR-9C, where applicable).

GST Returns and Data Used in Reconciliation

GSTR-2A vs. GSTR-2B: What is the difference?

GSTR-2A is a dynamic statement. It changes whenever suppliers upload, modify, or delete invoices. GSTR-2B is a static, auto-drafted statement generated once for each tax period, and it serves as a reference for claiming credit in GSTR-3B.

For ITC reconciliation, treat GSTR-2B as the primary basis and use GSTR-2A solely for following up with suppliers.

Types of GST Reconciliation

5.1 Purchase Register vs. GSTR-2B (ITC Reconciliation)

This is the most critical step. Compare the purchases recorded in your books with the invoices available in GSTR-2B. This helps identify:

Invoices present in your books but missing from GSTR-2B (not filed or reported by the supplier)

Invoices present in GSTR-2B but missing from your books

Discrepancies in GSTIN, invoice number, date, taxable value, or tax amount

This Input Tax Credit (ITC) reconciliation determines the amount of credit you can safely claim.

5.2 GSTR-2B vs. GSTR-3B (ITC Claimed vs. ITC Available)

Compare the credit claimed in GSTR-3B with the credit available in GSTR-2B. Claiming more credit than what is available is a primary reason for receiving an ITC mismatch notice.

5.3 Sales Register vs. GSTR-1

Compare your sales register with GSTR-1 to ensure that every invoice, debit note, and credit note has been reported exactly once with the correct GSTIN, value, rate, and place of supply.

5.4 GSTR-1 vs. GSTR-3B (Liability)

Compare the tax liability declared in GSTR-1 with the tax paid in GSTR-3B. Any discrepancy here indicates a mismatch between GSTR-1 and GSTR-3B.

5.5 E-invoice vs. GSTR-1

If you fall under the ambit of e-invoicing, every invoice reported on the e-invoice portal flows into GSTR-1. Reconcile the two to ensure that nothing has been missed, duplicated, or cancelled without adjustment in your books.

5.6 E-way Bill vs. GSTR-1 and GSTR-3B

The movement of goods recorded in e-way bills should broadly align with the outward supplies declared in your returns. Reconciling these helps identify unreported supplies and incorrect values, preparing you for any departmental queries. 5.7 Reconciliation of Reverse Charge (RCM). Reconcile the tax paid under Reverse Charge in GSTR-3B with your RCM register and ledger, and ensure that the corresponding credit—where applicable—has been claimed in a timely manner.

5.8 Reconciliation of Import ITC

Reconcile the IGST paid on imports with the 'Bill of Entry' data reflected in GSTR-2B, and retain proof of payment for audit purposes.

5.9 Reconciliation of Electronic Ledgers

Reconcile the electronic credit ledger, cash ledger, and liability register with your books of accounts to ensure that tax paid, credit utilized, and balances all align.

5.10 Books of Accounts vs. GST Returns

Compare the turnover, tax payable, and ITC recorded in your books of accounts (general ledger and financial statements) with the filed returns. This constitutes the GST reconciliation of books and serves as the basis for the annual statement.

5.11 Reconciliation of GSTR-9 and GSTR-9C

The annual return must be reconciled with the monthly returns, and the reconciliation statement bridges the annual return with the audited financial statements. This is covered under Section 17.

Invoice Management System (IMS) and Reconciliation

The IMS allows you to review invoices, credit notes, and debit notes submitted by your suppliers before they are reflected in GSTR-2B. For each record, you can choose to accept, reject, or mark it as pending. Records on which no action is taken are deemed accepted, and your action can be modified until the GSTR-3B is filed.

Accepted: The record is included in GSTR-2B as ITC.

Rejected: The record is removed and marked as rejected.

Pending: The record is excluded from GSTR-2B and GSTR-3B for the time being and remains within the IMS.

GSTR-2B is generated on the 14th of the following month. If you take any action in the IMS after that date but before filing GSTR-3B, you should recompute GSTR-2B to ensure updated figures are used in your return. Essentially, the IMS is the first step in GSTR-2B reconciliation: review, take action, recompute, and then reconcile with your purchase register.

How to Perform GST Reconciliation: A Step-by-Step Process

1. Create a monthly schedule: Perform reconciliation after GSTR-2B is generated but before filing GSTR-3B.

2. Gather data: Download purchase and sales registers, GSTR-1, GSTR-2B, and GSTR-3B, as well as credit and debit notes for the relevant period.

3. Review IMS: Accept correct records, reject incorrect or duplicate records, and mark suspicious records as pending. Recalculate GSTR-2B if necessary.

4. Reconcile purchases with GSTR-2B: Compare GSTIN, invoice number, invoice date, taxable value, tax type, and amount.

5. Classify discrepancies: Categorize them into groups: present in books but not in 2B, present in 2B but not in books, and differences in value or tax.

6. Follow up with suppliers: Request filing or corrections in writing and maintain records.

7. Check eligibility: Exclude blocked, ineligible, and reversal-linked credits.

8. Reconcile sales with GSTR-1: Ensure that every invoice, debit note, and credit note has been reported once.

9. Reconcile GSTR-1 with GSTR-3B: Rectify errors in outward supplies via GSTR-1A before filing GSTR-3B.

10. Claim ITC based on GSTR-2B: After verifying eligibility and reconcile the figure with your books.

11. Prepare a statement: Record every discrepancy along with the reason and the action taken.

12. Carry forward pending items: Track unresolved invoices from month to month.

How to Reconcile GSTR-2B with Books (Worked Example)

Suppose your purchase register shows ITC of ₹5,00,000 for the month, while GSTR-2B shows ₹4,40,000.

The analysis of the difference is as follows:

Result: Claim ITC of ₹4,40,000 (or a lower amount if any portion is found ineligible), and carry forward the amounts of ₹35,000 and ₹10,000 as pending items so that they can be claimed within the stipulated timeframe once they appear in GSTR-2B in a subsequent month.

How to reconcile GSTR-1 and GSTR-3B (with an example)

In this scenario, the liability reflected in GSTR-3B appears lower than that in GSTR-1. Common reasons for this include omitting an invoice reported in GSTR-1 from GSTR-3B, incorrect adjustment of credit notes, or timing differences. The solution involves identifying the specific invoices causing the discrepancy. If the shortfall is valid, the outstanding amount should be paid along with applicable interest, and the data corrected for future filings. If the error pertains to outward supply details, use GSTR-1A before filing GSTR-3B.

GST Reconciliation Statement Format

GST Reconciliation Statement is a simple document that shows your figures as per the books, the difference between them, reasons and action taken as per the GST portal. Use the same GST reconciliation format every month so that differences are easy to identify and explain to the auditor or officer.

The statement consists of three parts: outward supplies and tax liability, input tax credit, and tax payments along with ledgers. Thus, Part A shows GSTR-1 and GSTR-3B mismatch, Part B shows ITC mismatch, and Part C shows payment difference.

Part A: Outward Supplies and Tax Liability 

Part B: Input Tax Credit (ITC) 

Part C: Tax Payment and Ledgers 

Filled Example (Sample Figures)

The figures below are only for illustration, to show how each column is used.

Part A

Part B 

Part C 

How to read the statement

In this example, Part A shows that there is ₹36,000 less tax in GSTR-3B than GSTR-1, which is the kind of difference that could lead to a notice. Part B shows that there is ₹45,000 more credit in the books than in GSTR-2B, hence only the eligible amount available in GSTR-2B should be claimed. Part C confirms that the payment through ITC and cash agrees with the ledger and highlights the ₹36,000 that still needs to be paid.

Second sheet: Unmatched challan list

Add a second sheet that lists each unmatched invoice, so that each difference in detail can be traced to a specific document:

Keep one statement per month, save supporting invoices and supplier communications with it, and carry over pending items to the next month until they are resolved. Such a clean statement makes it much easier to respond to GST notices for mismatches or prepare year-end GSTR-9C reconciliation statements.

GST Reconciliation Solution in Excel

GST solution in Excel works well for small and medium invoice volumes.

1. Export your purchase register and GSTR-2B invoice-level data in two sheets.

2. Clean up both remove spaces, use capital letters for invoice numbers and make the GSTIN format consistent.

3. Create a matching key in both the sheets by adding GSTIN and invoice number, for example GSTIN|Invoice Number.

4. Use a lookup (VLOOKUP, XLOOKUP or COUNTIF) to check if each key in your register exists in GSTR-2B, and the reverse. 

5. For matched keys, compare the taxable value and tax amounts and mark the difference up to a small tolerance (for example ₹1 for rounding off).

6. Tag each row as matching, missing in 2B, missing in books or value mismatch.

7. Filter unmatched rows, specify reason and follow-up dates.

Excel becomes slow and error-prone as invoice volume increases. At those times, accounting software or reconciliation tools are more reliable, although human review of exceptions is still required.

Common GST Mismatches and How to Fix Them

How to correct GSTR-2B mismatch

Identify the type of difference (missing, excess, value, date, GSTIN).

Check the original invoices and your books.

Contact the supplier in writing for filing or amendment.

Use IMS to approve, reject or retain records.

Recalculate GSTR-2B if you have changed the IMS action.

Claim credit only for what is available and eligible.

Can I claim ITC if the supplier has not filed the return?

Generally, no. Credit is allowed when the invoice is reflected in your GSTR-2B. Place the invoice in the pending list, contact the supplier and claim it within the allowed time frame once it appears. If a supplier repeatedly defaults, consider changing suppliers or adjusting payment terms.

ITC Rules to Remember While Reconciling

1. Section 16 conditions: You need a valid tax invoice or debit note, receipt for goods or services, tax paid by the supplier, a filed return, and the details must be reflected in GSTR-2B.

2. Time limit under section 16(4): Credit must be claimed by the prescribed date, generally 30th November after the end of the financial year or the date of filing of the annual return, whichever is earlier.

3. Credit blocked under section 17(5): Items like certain motor vehicles, food and beverages, club memberships and goods for personal use are not eligible, even if they appear in GSTR-2B.

4. 180-day rule: If you do not pay the supplier within 180 days of the invoice date, the credit must be reversed with interest, and can be reclaimed after payment.

5. Normal credit reversal: Where you make both taxable and exempt supplies, proportionate ITC reversal is required.

6. Credit Note: When a supplier issues a credit note, reduce your ITC accordingly.

Claiming excess ITC: What to do?

If you've claimed more credit than allowed, correct it immediately.

Identify the excess amount and the period in which it was claimed.

Reverse it in your next GSTR-3B (ITC Reversal Section) or make the payment through the prescribed route.

Calculate interest and make payments.

Document the cause and correction.

Example: You claimed excess ITC of ₹60,000 in your October return and used it to pay tax. If it is corrected after 30 days, the interest at 24% will be approximately ₹60,000 × 24% × 30 ÷ 365, which is approximately ₹1,184. Where credit was wrongly claimed but not used, the situation on interest varies, so confirm with a professional.

GST notice for mismatch

The portal automatically compares your returns.

1. DRC-01B: Issued when the liability declared in GSTR-1 (or IFF) exceeds the amount paid in GSTR-3B beyond a specified limit. This is based on Rule 88C, and you answer in Part B of the form.

2. DRC-01C: Issued when the ITC claimed in GSTR-3B exceeds the ITC available in GSTR-2B beyond the predefined limit. This rule is based on 88D. You can pay the difference using DRC-03, settle it with the options provided, or do both. If you do not respond, you cannot file GSTR-1 or IFF for the next period.

3. ASMT-10: Inquiry notice from an officer if the return data appears to be inconsistent. You must respond with explanations and supporting documents.

4. Show cause notice and demand proceedings: If the differences have not been clarified, proceedings can be taken under the relevant provisions (section 73 or 74 for earlier years, and section 74A for later years).

How to Reply to a GST Notice for Mismatch

1. Read the notice carefully and note down the duration and amount.

2. Prepare a solution statement explaining the differences and reasons.

3. Gather supporting documents: invoices, proof of payment, supplier communications and bookkeeping.

4. Pay any actual shortfall with interest, or make up the legitimate difference.

5. File the reply within the time limit specified in the notice.

A clean monthly reconciliation file makes this much easier.

Interest, Late Fees and Penalties

• Interest on delayed tax payments: Generally 18% per annum.

• Interest on wrongly availed and utilized ITC: 24% per annum.

• Late fee: Applicable per day on delayed GSTR-1, GSTR-3B and annual returns, subject to limit.

• Penalty: In cases of false claims, penalty may be imposed depending on the facts and applicable provisions.

Rates, limits and rules are subject to change, so confirm current data on the GST portal.

Annual Reconciliation: GSTR-9 and GSTR-9C

GSTR-9 Solution

GSTR-9 is the annual return. Before filing, match this with the monthly return:

• Compare the outward supplies in GSTR-9 with the total of GSTR-1 and GSTR-3B.

• Compare the ITC claimed with GSTR-3B and GSTR-2B data for the year.

• Check reversals, blocked credits, import and RCM statistics.

• Check tax paid in cash and through credit in ledger.

GSTR-9 is mandatory if the total turnover exceeds ₹2 crore, and optional below that. The due date is normally 31 December following the financial year (31 December 2026 for FY 2025–26, unless extended). Annual returns generally cannot be amended once filed, so be careful before filing.

GSTR-9C Reconciliation Details

GSTR-9C is the reconciliation statement between the annual return and the audited financial statements. This is applicable where the total turnover exceeds ₹5 crore and is self-certified. These generally include:

Matching of turnover as per financial statements with turnover in GSTR-9

reconciliation of tax paid

Reconciliation of ITC as per books with claimed ITC

Due to any irreconcilable differences

Common Mistakes and Best Practices

Mistakes to Avoid 

• Reconciliation only once a year

• Claiming ITC on the basis of books instead of GSTR-2B

• Ignoring IMS and not recalculating GSTR-2B

• Not following up with suppliers

• Section 16(4) deadline missed

• Claiming Blocked Credit

• Not recording credit notes and debit notes

• Not maintaining any written solution file

Best Practices

• Perform monthly reconciliation before GSTR-3B

• Keep GSTIN, invoice number and date formats clean in your books

• Give suppliers clear filing deadlines

• Maintain a pending invoice tracker

• Reconcile books of accounts with returns each quarter

• Keep documents ready for any notice

Monthly GST Reconciliation Checklist

• GSTR-2B generated and downloaded
• IMS reviewed, GSTR-2B recomputed if needed
• Purchase register matched with GSTR-2B
• Missing invoices followed up with suppliers
• Blocked and ineligible credit removed
• RCM and import credit checked
• Sales register matched with GSTR-1
• E-invoice and e-way bill data cross-checked
• GSTR-1 liability matched with GSTR-3B
• Credit and debit notes accounted
• ITC claimed does not exceed GSTR-2B
• Ledgers reconciled
• Reconciliation statement saved with reasons

GST Reconciliation Services in India

Many businesses prefer to outsource GST reconciliation services, especially when the invoice volume is high or mismatches occur frequently. A professional GST Solution Consultant can:

1. Reconcile monthly GSTR-2B and generate a reconciliation statement

2. Help you take action on IMS and take action on missing invoices

3. Review ITC eligibility, reversal and blocked credit

4. Support GST filing and reconciliation services simultaneously for clean returns

5. Prepare data for GSTR-9 and GSTR-9C

6. Help with GST notice replies for discrepancies

Paytaxs provides GST solution online support for businesses across India, and for businesses looking for GST solution services in Jaipur, our team is based in Jaipur, Rajasthan. Share your requirement and our team will get in touch to understand your situation.

Final Thoughts

GST resolution is not a year-end task. It's a monthly discipline that protects your input tax credits, keeps your returns accurate, and reduces the risk of notices and interest. Use IMS to control what is entered in GSTR-2B, reconcile purchases and sales every month, quickly correct discrepancies and keep documents ready. GST rules, limits and due dates change from time to time. Always confirm the current status on the GST portal or with a qualified professional before acting.