ITC reconciliation is the process of matching Input Tax Credit (ITC) claimed in GST returns (GSTR-3B) with ITC available as per the GST portal (GSTR-2B) and ITC recorded in the books of accounts. It is one of the most critical compliance activities for any GST-registered business. A robust reconciliation workflow ensures that every rupee of eligible ITC is claimed, ineligible ITC is reversed, and mismatches are identified and rectified before they trigger departmental notices.
This comprehensive guide provides a practical workflow for ITC reconciliation between books and the GST portal, covering step-by-step process, tools, and best practices.
Why ITC Reconciliation Is Critical
Compliance Requirement
Reconciling ITC is essential to ensure that the ITC claimed in GSTR-3B matches the ITC available in GSTR-2B and the books of accounts.
Avoiding Notices
Mismatches between ITC claimed and ITC available trigger ITC mismatch notices from the GST department.
Avoiding Interest and Penalties
Claiming excess ITC attracts interest at 24% per annum and penalties.
Optimising Cash Flow
Claiming full eligible ITC reduces tax liability and improves cash flow.
The ITC Reconciliation Workflow: Step-by-Step
Step 1: Download GSTR-2B from GST Portal
Action: Log in to the GST portal and download GSTR-2B for the relevant month.
Why: GSTR-2B is the static ITC statement that contains details of ITC available based on invoices uploaded by suppliers.
How:
- Navigate to Services ā Returns ā Returns Dashboard
- Select the relevant financial year and month
- Download GSTR-2B in Excel format
Step 2: Extract Purchase Register from Books
Action: Export the purchase register from your accounting software (Tally, SAP, Oracle, etc.).
What to Include:
- All purchase invoices for the period
- Debit notes
- Credit notes received
- RCM invoices
Step 3: Prepare Reconciliation Spreadsheet
Action: Create a reconciliation spreadsheet with the following columns:
- Invoice Number
- Invoice Date
- Supplier Name
- Supplier GSTIN
- Invoice Value (excluding GST)
- GST Amount
- ITC Amount
- Status in GSTR-2B (Matched / Missing / Mismatch)
- Remaining Days to 180 Days
- Action Required
Step 4: Match Invoice by Invoice
Action: Compare each invoice in the purchase register with GSTR-2B.
Matching Criteria:
- Invoice Number
- Invoice Date
- Supplier GSTIN
- ITC Amount
Categorisation:
- Matched: Invoice present in both PR and GSTR-2B ā Claim ITC
- Missing in GSTR-2B: Invoice in PR only ā Follow up with supplier
- Missing in PR: Invoice in GSTR-2B only ā Verify if genuine purchase
- Value Mismatch: ITC amount differs ā Follow up with supplier
Step 5: Calculate ITC to be Claimed
Action: Based on the reconciliation, calculate:
- ITC eligible to be claimed (matched invoices)
- ITC to be reversed (ineligible ITC, if any)
- ITC to be tracked (missing invoices, pending follow-up)
Step 6: Claim ITC in GSTR-3B
Action: Claim the eligible ITC in GSTR-3B.
Remember: ITC can only be claimed for invoices that are reflected in GSTR-2B.
Step 7: Follow Up with Vendors
Action: For invoices missing in GSTR-2B, follow up with vendors to upload the invoices.
Follow-up Frequency:
- Weekly for the first month
- Monthly thereafter
Step 8: Reconcile Reversed ITC
Action: Ensure that ITC reversed (e.g., 180-day rule, exempt supplies) is properly documented and tracked.
Step 9: Document the Reconciliation
Action: Maintain a record of the reconciliation for audit purposes.
Documentation to Maintain:
- Reconciliation spreadsheet
- Follow-up records
- Claimed ITC details
- Reversed ITC details
ITC Reconciliation: Practical Example
Scenario: ABC Traders has a purchase register with 100 invoices for July 2026.
Step 1: ABC Traders downloads GSTR-2B for July 2026.
Step 2: ABC Traders extracts the purchase register from Tally.
Step 3: ABC Traders matches each invoice.
Result:
- 80 invoices matched ā ITC claimed: ā¹8,00,000
- 15 invoices missing in GSTR-2B ā Follow-up initiated
- 5 invoices with value mismatch ā Follow-up initiated
Step 4: ABC Traders claims ITC of ā¹8,00,000 in GSTR-3B.
Step 5: ABC Traders follows up with vendors for the 20 mismatched invoices.
ITC Reconciliation: Common Challenges
1. Data Volume
Large volumes of invoices make manual reconciliation difficult.
Solution: Use reconciliation tools or software.
2. Data Quality
Incorrect invoice numbers, GSTINs, or dates.
Solution: Implement data validation at the time of invoice entry.
3. Vendor Non-Responsiveness
Vendors who do not respond to follow-ups.
Solution: Escalate to senior management or consider vendor replacement.
4. Time Constraints
Reconciliation takes time and effort.
Solution: Perform reconciliation monthly, not quarterly or annually.
ITC Reconciliation: Best Practices
1. Reconcile Monthly
Don't wait for the end of the year. Reconcile every month before filing GSTR-3B.
2. Use Automation
Use reconciliation tools or software to automate the matching process.
3. Maintain Vendor Relationships
Build strong relationships with vendors to ensure timely upload of invoices.
4. Document Everything
Maintain detailed records of all reconciliations and follow-ups.
5. Review Reversed ITC
Regularly review ITC reversed (180-day rule, exempt supplies) and reclaim when eligible.
ITC Reconciliation: Checklist
- GSTR-2B is downloaded from the GST portal
- Purchase register is extracted from accounting software
- Each invoice is matched individually
- GSTINs are validated
- Missing invoices are identified
- Vendors are followed up for missing invoices
- ITC is claimed only for matched invoices
- Reversed ITC is tracked and reclaimed when eligible
- Reconciliation is documented for audit purposes
Need help with ITC reconciliation? Our expert team provides comprehensive reconciliation services to ensure accurate ITC claims and compliance.
Contact Anuj Desai & Associates: š§ Email: office@anujdesaiassociates.com š Phone: 9619456656 š Website: https://anujdesaiassociates.com š LinkedIn: linkedin.com/in/ca-anuj-desai-122547230