You may have forgotten to record a purchase. 5. Use Pivot Tables for Summary
Open a new Excel workbook and create two worksheets: gstr 2a reconciliation in excel
Once your Excel reconciliation is complete, classify the mismatches into three categories: You may have forgotten to record a purchase
If the invoice exists in 2A, Excel will return the Match Key. If it does not exist, it will show #N/A . gstr 2a reconciliation in excel
Use this formula structure in your Purchase Register tab: =VLOOKUP(Invoice_Number, GSTR_2A_Range, Column_Index, 0)