| Type of ITC | Amount (₹) | |-------------|-------------| | 4(A)(1) – Import of goods | 0 | | 4(A)(2) – Import of services | 0 | | 4(B) – inward supplies from registered (other than reverse charge) | | | 4(C) – inward supplies from registered (reverse charge) | 0 | | 4(D) – inward supplies from unregistered | 0 | | Total ITC Claimed (3B) | ₹ Y |
: Large data sets can take up to 20 minutes to generate on the official portal before they are ready for download. gstr 2a and 3b reconciliation in excel format download
Use the ROUND function to ignore small differences (like ₹1 or ₹2) that occur due to decimal points. | Type of ITC | Amount (₹) |
=SUMIF(GSTR2A_RAW!H:H,"Yes",GSTR2A_RAW!E:E) gstr 2a and 3b reconciliation in excel format download