In Purchase Register sheet, add a column: In GSTR-2A?
To simplify the reconciliation process, we have created an Excel format that can be downloaded and used by businesses. The format includes the following sheets: gstr 2a and 3b reconciliation in excel format download
With the introduction of of the CGST Rules (allowing only 5% excess ITC over available GSTR-2A/2B), reconciliation has shifted from “good practice” to “mandatory legal requirement.” In Purchase Register sheet, add a column: In GSTR-2A
=VLOOKUP(A2, 'GSTR-2A'!A:H, 5, 0) – To pull taxable value from 2A. In Purchase Register sheet
Not all Excel downloads are created equal. When searching for a format, look for these essential functionalities: