As a business owner or accountant in India, you're likely familiar with the Goods and Services Tax (GST) and the importance of filing returns. GSTR 2A is a crucial return that outlines the details of purchases made by your business. However, reconciling GSTR 2A data can be a daunting task, especially when done manually. In this article, we'll walk you through a step-by-step guide on how to perform GSTR 2A reconciliation in Excel.
If the formula returns #N/A , it means the supplier has not uploaded that specific invoice. 4. Identify Discrepancies gstr 2a reconciliation in excel
April 14, 2026 | Reading Time: 6 minutes As a business owner or accountant in India,
=B2&"_"&C2
A: GSTR-2A is a dynamic view that updates as suppliers file returns. GSTR-2B is a static, finalized document generated for a specific return period. While 2B is used for filing returns, reconciling with 2A helps you catch suppliers who file after the due date but before the next cycle. In this article, we'll walk you through a
If you claim ITC based on a purchase invoice that is missing from your supplier’s GSTR-1 (and subsequently, your GSTR-2A), you are liable to pay back that credit along with interest. To prevent this, you must reconcile your purchase register (books) with the government’s GSTR-2A data.