Itc reconciliation with 2b

is there any short way to reconcile Itc of 2b with books . It take 3-5 days for gst reconciliation
Replies (2)
Quick Summary
This discussion explores efficient methods for reconciling Input Tax Credit (ITC) with GSTR-2B, aiming to reduce the typical 3-5 day processing time. It suggests leveraging the GST portal's matching tool, using Excel with VLOOKUP or Power Query, and utilising accounting software that automates the process. Monthly reconciliation is strongly advised to simplify year-end procedures.

Import to excel both accounts data and 2B data and use Vlook up using GSTIN

Faster 2B reconciliation:

• Use the GST portal's "GSTR-2B vs purchase register" matching tool (in offline utilities), or download GSTR-2B in Excel or JSON and match it with your purchase register by GSTIN plus invoice number plus taxable value (use VLOOKUP or Power Query in Excel).

• Many accounting tools (Tally Prime's GSTR-2B reconciliation, Zoho, ClearTax, and others) automate this.

• IMS (from October 2024) allows accepting or rejecting invoices before 2B generation. Doing this monthly reduces year-end work.

• Practical: reconcile monthly (not yearly). Then the year-end is quick.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details