Convert GSTR2A to Excel file

※ Download: How to download gstr 2a

Double click on the excel file to open, after extracting it. GSTR 2A Return Meaning — Reconciliation of Input Tax Credit in GST What is GSTR 2A Return? These sheets contain the input tax credit ITC received from the various types of persons.

Firstly How to Download from? GSTR-2A fetches the details of the outward supplies as mentioned by your supplier in their returns, which you can use to file your own GSTR-2. Step 2: You will land in your Dashboard of GST Portal. It is a read-only form that will be available in your dashboard and that you can use as a reference to fill your own GSTR-2 Form.

Convert GSTR2A to Excel file - Please Follow the below Steps to GSTR 2A — JSON File to Excel File 1.

GSTR 2A Return Meaning — Reconciliation of Input Tax Credit in GST What is GSTR 2A Return? GSTR 2A is an auto-populated statement. GSTR 2A data is meant for a recipient of the goods and services or both. GSTR 2A captures the data automatically from the GSTN database. On the other hand, the receiver can take input tax credit on the goods or services he receives from the supplier on the basis of documents. The details of outward supplies by the supplier becomes available to the recipient for view and download in excel and JSON format. The details are updated incrementally as and when supplier taxpayer upload or change details in their respective Form GSTR, for the given tax period. GSTR 2A return filing due date GSTR 2A means a statement of Input Tax credit and you need not have to file GSTR 2A legally. Hence there is no gstr 2a due date of filing. When Can a Receiver View data in GSTR 2A file? View GSTR 2A on GST Portal a Login into GST portal www. Now you will see GSTIN wise supplier Details, Supplier Name and Counter Party Submit Status. Download GSTR 2a format in excel from GST portal Learn how to download gstr 2a in excel format from below steps. After going through the entire steps you will learn how to download gstr 2a in excel from gst portal. These are easy and simple steps to download gstr 2a reconciliation format in excel. This excel file will be in the compressed file. Open GSTR-2a downloaded file in Excel and JSON format Follow below steps to know how to open gstr-2a downloaded file. A Open Excel file — Extract the above-downloaded zip file. Double click on the excel file to open, after extracting it. This is how to view gstr 2a in excel format. B Open JSON File — You need a gstr 2a reconciliation software to open this file. First, you need to upload this file in the software like tally and then you can view the existing records in the file. You can easily do gstr 2a reconciliation in tally software. You can not open this file and view the records by just double-clicking on it. GSTR 2A Reconciliation in Excel Reconcile GSTR2 A data with your Input Tax credit Availed in GSTR 3B. There are total 10 sheets in this excel file. These sheets contain the input tax credit ITC received from the various types of persons. Also, it contains a type of ITC received, such as IGST, SGST, CGGST, and cess. With the help of these details, you can reconcile your input tax credit already availed and utilized for doing setoff. There may be chances that supplier did not upload the invoices still and you took the ITC on such input invoices. In such case, you need to ask your supplier to upload the invoices.

GSTR 2 Return, Prepare Online & Reconciliation with GSTR 2 A
GSTR-2A will not generate until your supplier files his GSTR 1 Form. You also need to provide the details of any advances paid by you on supplies, whether reverse charges or not. Octa GST will solo the contents of file and extract the data. Click on the tile to see supplier wise details. We are not responsible for any harm that may occur beca of any information or news article present on this website. It is useful to view the data in a spreadsheet such as Piece or Open Office. GSTR 2A is an auto-generated read only document which is for information purpose only. Step 3: In the Return Dashboard, select the financial year and month for which you need to download GSTR-2A.