How to Reconcile ITC in GST Using an Sepfust ITC Reconciliation Cockpit

Your purchase register shows ITC of ₹18 lakh, but GSTR-2B shows only ₹16.50 lakh. Before filing GSTR-3B, the finance team must find out where the remaining ₹1.50 lakh has gone.

The supplier may not have uploaded an invoice. The invoice number may be different. A credit note may be missing from the books. There may also be ITC in GSTR-2B that cannot be claimed.

This comparison is called ITC reconciliation.

If you want to know how to reconcile ITC in GST, start by matching your purchase register with GSTR-2B at the invoice level. After matching, check the eligibility of each credit and calculate the final amount to be reported in GSTR-3B.

Businesses with a large number of invoices can use our SEPFUST ITC Reconciliation Cockpit to handle this work directly from their ERP data.

What Is ITC Reconciliation in GST?

ITC reconciliation means comparing the GST credit recorded in the company’s books with the credit available in GSTR-2B.

The matching is done using details such as:

• Supplier GSTIN
• Invoice number
• Invoice date
• Taxable value
• IGST
• CGST
• SGST
• Debit note details
• Credit note details
• Place of supply

The purpose is to find out whether the ITC booked in the ERP is supported by the supplier’s GST filing.

However, matching with GSTR-2B is only one part of the process. The business must also check whether the credit is eligible under GST rules.

An invoice appearing in GSTR-2B does not automatically make the complete ITC eligible.

Why Is ITC Reconciliation Required?

A business may receive hundreds or thousands of purchase invoices every month. These invoices are booked in SAP, Oracle, Tally or another ERP.

Suppliers report the same invoices in their GSTR-1. The reported details then become available to the recipient through GSTR-2B.

Differences can arise when:

• The supplier does not file GSTR-1 on time
• The supplier misses an invoice
• The wrong GSTIN is entered
• The invoice number is entered differently
• The taxable value is incorrect
• IGST is reported instead of CGST and SGST
• A credit note is not recorded in the books
• An invoice is booked twice
• The supplier reports an amendment
• The invoice belongs to another GST registration

If these differences are not checked before filing GSTR-3B, the company may claim excess ITC or miss eligible credit.

Regular reconciliation helps the tax team keep the claim correct and maintain proper invoice-level records.

Which Records Are Required for ITC Reconciliation?

Keep the following data ready before starting the reconciliation.

1 Purchase Register

Download the purchase register from the ERP for the relevant period. It should contain the complete invoice details, including vendor GSTIN, invoice number, invoice date, taxable value and tax amount.

2 GSTR-2B

GSTR-2B is the main GST statement used for checking the ITC available for a tax period. It contains supplier invoices, debit notes, credit notes, ISD credit and available import information.

3 Previous-Period Pending Report

Some invoices may have been booked earlier but reported by suppliers in a later period. These invoices should remain in the pending report until they are matched, rejected or become time-barred.

4 Debit Notes and Credit Notes

Debit notes may increase the ITC amount, while credit notes may require ITC reduction. Both should be checked against the original transaction.

5 RCM and Import Data

Reverse charge transactions, Bill of Entry records and supplies from SEZ units may require separate reconciliation and eligibility checks.

How to Reconcile ITC in GST Step by Step

Here is a practical process for businesses that want to understand how to reconcile ITC in GST.

Step 1: Download Purchase Data From the ERP

Start with the purchase register for the tax period.

The report should include:

• Company code
• Vendor code
• Supplier GSTIN
• Invoice number
• Invoice date
• Posting date
• Taxable value
• GST rate
• IGST, CGST and SGST
• Document type
• Payment status

Also include unmatched invoices carried forward from previous months.

Step 2: Download GSTR-2B

Download the GSTR-2B file for the same tax period.

GSTR-2B is a period-based statement. GSTR-2A is dynamic and keeps changing when suppliers upload or amend invoices. GSTR-2A may be used for investigation, but GSTR-2B should form the main base for the monthly ITC working.

Step 3: Clean the Invoice Data

Invoice numbers are not always recorded in the same format.

For example:

These may be the same invoices, but a simple Excel formula may show them as unmatched.

Before matching, remove unnecessary spaces, special characters and leading zeros. GSTIN formats, dates and tax values should also be standardised.

Step 4: Match the Invoices

Compare the purchase register with GSTR-2B using:

• Supplier GSTIN
• Invoice number
• Invoice date
• Taxable value
• GST amount

Invoices that match on all major fields can be placed under the matched category.

Where the GSTIN and invoice number match but there is a small difference in value, the record should be shown separately for review.

Step 5: Classify the Results

After matching, divide the invoices into clear categories.

This classification tells the tax team what action needs to be taken for each invoice.

Step 6: Review Books-Only Invoices

A books-only invoice is present in the purchase register but missing from GSTR-2B.

Possible reasons include:

• Supplier has not filed GSTR-1
• Supplier forgot to report the invoice
• Supplier used the wrong GSTIN
• Invoice was reported after the GSTR-2B cut-off
• Supplier entered the wrong invoice number

Send these details to the supplier and ask for correction. Keep the ITC in the pending report until it appears in GSTR-2B and meets the other eligibility conditions.

Step 7: Review GSTR-2B-Only Invoices

A GSTR-2B-only invoice appears on the GST Portal but is missing from the company’s books.

Check whether:

• The invoice belongs to your business
• Goods or services were received
• The invoice is pending for accounting
• The supplier reported the wrong GSTIN
• The invoice belongs to another plant or business unit
• The entry was already booked under another invoice number

Do not claim the credit without checking the underlying invoice and receipt of goods or services.

Step 8: Check ITC Eligibility

After matching the invoices, check whether the credit can legally be claimed.

The business should confirm that:

• A valid tax invoice or prescribed document is available
• Goods or services have been received
• The purchase is related to business activities
• The invoice has been correctly reported by the supplier
• The credit is not blocked under Section 17(5)
• The credit has not been claimed earlier
• Payment conditions have been met
• RCM tax has been paid, where applicable
• The claim is within the time limit under Section 16(4)

Expenses such as personal purchases, certain motor vehicles, club memberships and other blocked categories may appear in GSTR-2B. They still require an eligibility check.

Step 9: Check the 180-Day Payment Rule

Where supplier payment, including tax, is not made within 180 days from the invoice date, the related ITC may need to be reversed along with applicable interest.

Once the supplier is paid, the credit may be reclaimed subject to the prescribed conditions.

For this reason, ITC reconciliation should also be connected with vendor payment data.

Step 10: Review IMS Actions

Invoices reported by suppliers become available in the Invoice Management System.

The recipient can take one of the following actions:

• Accept: Invoice details are correct.
• Reject: The invoice does not belong to the recipient or contains an error.
• Pending: The invoice requires further checking.
• No action: The record may be treated as deemed accepted during GSTR-2B generation.

IMS action should be taken only after checking the invoice against the ERP purchase register.

Credit notes also require careful review. Accepting a credit note can reduce the ITC available to the business. The team should verify whether the related ITC was originally claimed and how much reversal is required.

Step 11: Calculate the ITC for GSTR-3B

The ITC recorded in the books should not be copied directly into GSTR-3B.

A simple calculation may look like this:

The final calculation may also include RCM credit, import ITC, ISD credit, credit notes, Rule 42 and Rule 43 reversals and earlier-period reclaims.

Step 12: Save the Reconciliation Report

Keep a proper reconciliation file for every tax period.

The file should include:

• Purchase register
• GSTR-2B data
• Invoice-level matching report
• Books-only invoice list
• GSTR-2B-only invoice list
• Mismatch report
• Blocked ITC working
• Reversal and reclaim details
• Vendor follow-up status
• IMS action details
• Final GSTR-3B working
• Reviewer approval

These records are useful during GST audits, annual return preparation and departmental queries.

Problems With Manual ITC Reconciliation

Excel can work when the number of invoices is small. It becomes difficult when the business has several GSTINs, plants and thousands of vendors.

The team may face problems such as:

• Large files taking time to open
• Different invoice formats
• Repeated manual matching
• Duplicate records
• Previous-period invoices getting missed
• Separate vendor follow-up sheets
• Incorrect formulas
• No clear approval history
• Difficulty tracking ITC reversals and reclaims
• Different reports maintained by different team members

These issues can delay GSTR-3B filing and make the final ITC figure difficult to verify.

How the SEPFUST ITC Reconciliation Cockpit Works

Our SEPFUST ITC Reconciliation Cockpit automates the comparison of ERP purchase data with GSTR-2B.

1) ERP Integration

Purchase data can be taken from SAP, Oracle, Tally or a custom ERP. This reduces manual file preparation and repeated data entry.

2) Automated Invoice Matching

The cockpit matches invoices using GSTIN, invoice number, invoice date, taxable value and GST amount.

It can also handle common formatting differences such as slashes, hyphens, spaces and leading zeros in invoice numbers.

3) Clear Reconciliation Status

Every invoice receives a clear status, such as:

• Matched
• Books only
• GSTR-2B only
• Value mismatch
• Tax mismatch
• Duplicate
• Ineligible
• Pending

The tax team can work only on exceptions instead of checking every invoice.

4) Previous-Period ITC Tracking

Unmatched invoices are carried forward automatically. If the supplier reports the invoice in a later month, the cockpit matches it with the earlier pending entry.

This helps the company track eligible ITC without maintaining a separate Excel file.

5) Vendor-Wise Reports

The cockpit shows which vendors have:

• Not reported invoices
• Reported incorrect values
• Used the wrong GSTIN
• Filed invoices late
• Created repeated ITC mismatches

The finance team can send targeted follow-ups instead of checking each vendor manually.

6) Vendor Payment Control

Based on the company’s internal policy, a payment hold can be configured for non-compliant vendors or invoices.

The hold applies to the vendor or invoice payment. It does not mean that the company’s GST payment is stopped.

7) Reversal and Reclaim Tracking

Temporary ITC reversals are recorded separately. When the reason for reversal is resolved, the credit can be reviewed for reclaim.

The cockpit also helps prevent the same ITC from being reclaimed more than once.

8) GSTR-3B Working

The final GSTR-3B ITC working can be prepared using:

• Matched eligible ITC
• Ineligible ITC
• Current-period reversals
• Previous-period reclaims
• RCM credit
• Import ITC
• Credit note adjustments

This gives the reviewer a clear basis for the amount being claimed.

9) Complete Audit Trail

Our cockpit maintains a record of invoice status, user action, remarks, corrections and approvals.

If a question comes up later, the tax team can check how an invoice was treated and who approved the action.

A SEPFUST implementation for a listed chemical company reported approximately 40 hours of monthly time savings and close to a 98% purchase-invoice match within three months. Read the SEPFUST ITC reconciliation case study

Manual Process vs ITC Reconciliation Cockpit

Monthly ITC Reconciliation Checklist

Before filing GSTR-3B, check that:

• The complete purchase register has been considered
• GSTR-2B has been matched with the books
• Previous-period invoices have been reviewed
• Books-only invoices are kept pending
• GSTR-2B-only invoices are verified
• Duplicate invoices are removed
• Blocked ITC is identified
• Credit notes are accounted for
• RCM transactions are checked
• The 180-day payment rule is reviewed
• IMS actions are verified
• Reversals and reclaims are correctly reported
• The final ITC amount is approved
• Reconciliation reports are saved

Conclusion

Understanding how to reconcile ITC in GST is simple. Managing thousands of invoice-level differences every month is the difficult part.

The SEPFUST ITC Reconciliation Cockpit connects ERP purchase data with GSTR-2B, identifies mismatches, tracks vendor corrections, carries forward pending ITC and prepares the final reconciliation working for GSTR-3B.

This reduces manual checking and gives the finance team a clear record behind every ITC claim.

Book a demo and Automate ITC Reconciliation With SEPFUST.

Frequently Asked Questions

Q1 Should ITC be reconciled with GSTR-2A or GSTR-2B?

GSTR-2B should be used as the main statement for monthly ITC reconciliation. GSTR-2A may be used as a supporting report to check later supplier uploads and amendments.

Q2 Can ITC be claimed if the invoice is missing from GSTR-2B?

The invoice should be followed up with the supplier and kept in the pending report. The claim must meet the conditions under Section 16 and other applicable GST provisions.

Q3 Is all ITC shown in GSTR-2B eligible?

No. The business must separately check blocked credits, receipt of goods or services, business use, payment conditions, duplicate claims and the ITC claim time limit.

Q4 What happens to previous-period unmatched ITC?

It should be carried forward. When the supplier reports the invoice later, it can be matched and reviewed for claim, subject to eligibility and the applicable time limit.

Q5 How often should ITC reconciliation be done?

ITC reconciliation should be completed for every tax period before filing GSTR-3B. Businesses with high invoice volumes can also run an interim reconciliation before month-end.

Q6 Can the cockpit reconcile multiple GSTINs?

Yes. The SEPFUST ITC Reconciliation Cockpit can provide GSTIN-wise, company-wise, plant-wise and vendor-wise reconciliation for businesses operating through multiple registrations.