Excel Download Table 8A | Details of GSTR-9



Quick Summary
You can now download the details for Table 8A of your GSTR-9 from the GST portal in Excel format. This feature, populated from GSTR-2A, helps you reconcile the Input Tax Credit (ITC) shown in Table 8A with what's available in GSTR-2A. The downloaded Excel file contains several sheets, including B2B invoices and credit/debit note amendments, providing a comprehensive view of your supplier data.

Now you can download the document details from auto-populated from GSTR-2A in Table 8A of GSTR-9 in excel format.

How does it help?

You can reconcile the difference in ITC shown in Table 8A and available in GSTR-2A.

How to navigate in GST portal?

Services > Returns > Annual Returns > Form GSTR-9 (Prepare Online) > Download Table 8A Document Details.

Generated excel will be downloaded as a zip file, in case of less documents or else in multiple chunks.

Data saved/submitted in GSTR-1/5/6 by supplier will be shown in Form GSTR-2A, but will not be shown in excel file of Table 8A of Form GSTR-9.

Document reported after cut-off date are not accounted for ITC. Such documents are not part this excel life.

Download GSTR-9 Table 8A Excel: Reconcile ITC

What the contents are in the excel file?

Sheet-1: Read Me - Instructions on using the functionality
Sheet-2: B2B Invoices - Details uploaded by suppliers
Sheet-3: B2BA - Amendment of B2B invoices
Sheet-4: CDNR - Details of Credit/Debit notes issued by supplier
Sheet-5: CDNRA - Amendment of Credit/Debit notes

What are the reasons for non-availability of ITC?

  1. Reverse charge document: When the supplier has filed the document in GSTR-1 indicating the supply as reverse charge.
  2. POS lies in supplier's State: When the supplier's State code and POS lie in the same State, but recipient's State is different.
  3. GSTIN is amended: When the supplier has amended the GSTIN, credit shall be available to amended GSTIN only.
  4. Invoice date is after supplier's cancellation: When the document date is after the effective date of cancellation of supplier.
  5. ITC showing in GSTR-2A but not available in table 8A of GSTR-9 for FY 2018-19: Check if your supplier has filed GSTR-1 or GSTR-5 after the cut-off date, 31st October 2019.
 

Disclaimer: This article or blog or post (by whatever name) is based on the writer's personal views. The writer does not accept any liabilities for any loss or damage of any kind arising out of information and for any actions taken in reliance thereon. This article has been published for knowledge sharing purpose only.

 

The author is a practicing Chartered Accountant with an overall 20 years' experience in both Industry as well as an independent practice and can also be reached at cacafe4you@gmail.com.

Source: GST Tech

FAQ :

Navigate to Services > Returns > Annual Returns > Form GSTR-9 (Prepare Online) on the GST portal and select 'Download Table 8A Document Details'.

It helps you reconcile the Input Tax Credit (ITC) shown in Table 8A of GSTR-9 with the details available in GSTR-2A, identifying any differences.

The Excel file includes a 'Read Me' sheet with instructions, details of B2B invoices, amendments to B2B invoices, credit/debit notes, and amendments to credit/debit notes.

This can happen if the supplier filed their GSTR-1 or GSTR-5 after the cut-off date (31st October 2019 for FY 2018-19), or if the document date is after the supplier's GSTIN cancellation date.

No, documents reported after the cut-off date are not accounted for in the Table 8A Excel download and therefore not considered for ITC.


8007 Views Comment   Share GST   Report


About the Author

Chartered Accountant in Practice

KIRANKUMAR R N CO a CA firm was set up in 2018 by CA. KIRANKUMAR R N after having worked for 18 years in one of BIG 4 Tax Consulting Firm, top MNC Bank and held various senior leadership positions in these companies KIRANKUMAR R N CO. is a reputed Chartered Accountants Firm duly established under the Indian Charte ... Read more

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article