To download GSTR-2A in Excel, log in to the GST Portal, navigate to Services > Returns > Returns Dashboard, select the financial year and period, and click "View" under GSTR-2A. Click "Download" to generate an Excel file (or JSON), wait for the request to process (approx. 20 minutes), and download the zip file containing the Excel data.
Step 1: Log in to the GST portal with your username and password. Step 2: After logging, select 'Returns Dashboard' as shown below. Step 3: Select the month & financial year for which you want to download GSTR-2A in excel. Click on the 'Download' tab appearing in the 'Auto Drafted details' box.
How to Use Tool
Step 1 – Click on the 'Download' button on the GSTR-2A tile. Step 2 – Click on the 'Generate JSON file to download' or 'Generate an Excel file to download' button to generate data in the JSON or Excel formatted file.
Start by comparing the total ITC claimed in GSTR-3B Table 4A with the total eligible ITC shown in GSTR-2A for the same period. Create a comparison worksheet that includes key fields: supplier GSTIN, invoice number, invoice date, taxable value, CGST, SGST, IGST, and total tax amount.
Click the Services > Returns > Returns Dashboard option. 2. The File Returns page is displayed. Select the Financial Year & Return Filing Period for which you want to view Form GSTR-2A from the drop-down list.
Yes, you can download individual table wise details in Form GSTR-2B by clicking Download Excel link available in document details. Such link will be available only when the total number of documents across all tables is upto 1000 documents.
If number of invoices is more than 500, then you need to download the invoices in Form GSTR-2A to view it in Returns Offline Tool. Once the file is generated, the link will appear to download.
GSTR 2A Due Date
Since it is a reflection of the current transactions, businesses must check GSTR 2A at regular intervals during the month to avoid missing any ITC-related compliance requirements.
Verification of ITC Claims: GSTR 2A enables groups to cross-test the ITC to be had on their purchases. Since this data is automobile-populated, it minimizes mistakes in ITC claims. Matching Purchase Data with Suppliers' Returns: ITC is granted best if the provider has filed GSTR 1 successfully.
Watch video tutorial for GSTR-2A Reconciliation in GSTHero
Our GSTR 1 JSON to Excel converter simplifies the process, allowing you to quickly and efficiently convert your files for easy analysis.
Converting from JSON to Excel
GSTR-2A is an auto-generated statement showing purchase invoices uploaded by suppliers. It updates dynamically whenever suppliers modify or upload invoices. Helps businesses verify eligibility for Input Tax Credit (ITC). No filing is required for GSTR-2A; it is only for viewing and reconciliation.
Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)
GSTR 2A is an auto-generated statement for verifying input tax credit (ITC). GSTR 2 was a manually editable return for reporting inward supplies but is now suspended. GSTR 2A helps in ITC reconciliation by reflecting suppliers' reported data. GSTR 2A ensures transparency and simplifies GST compliance for businesses.
If your GST turnover is below the $75,000 threshold, you may choose to register. But if you do, regardless of your turnover, you must: include GST in the price of most goods and services you sell. claim GST credits for most business purchases you make.
GSTR-2A is a purchase-related tax return automatically generated for every business registered under the Goods and Services Tax (GST). It is a statement that captures details of all your purchases for a particular month.
GSTR-2A is a dynamic purchase-related tax statement, while GSTR-2B is a static monthly ITC statement. GSTR-2B helps businesses identify eligible ITC, whereas GSTR-2A keeps updating as suppliers upload invoices. ITC claims should be aligned with GSTR-2B, not GSTR-2A.
How to do annual GSTR 2a download?
GSTR 2A helps you track supplier behavior and timely filing. GSTR 2B is essential for the final ITC claim while filing GSTR-3B. Filing based on GSTR 2A may cause errors as it is not final. Using GSTR 2B ensures you claim only valid and eligible ITC.
Export GSTR-1 in Excel format
In the drop-down click on Returns > Returns Dashboard. Step 3 – Select the Financial Year and the Return Filing Period from the drop-down. Click on the 'Search' button. Step 4 – Click on the 'View' button in the tile GSTR-2A.
Accordingly, a taxpayer can claim ITC only if the same appears appears in their GSTR-2B. Hence, no provisional ITC can be claimed from 1st January 2022 onwards. Hence, matching of the purchase register with the GSTR-2B is crucial for ITC claims.
The different slabs for GST are 5%, 12%, 18% and 28%. GST calculation can be explained by a simple illustration : If a goods or services is sold at Rs. 1,000 and the GST rate applicable is 18%, then the net price calculated will be = 1,000+ (1,000X(18/100)) = 1,000+180 = Rs. 1,180.