Self Help Knowledgebase and Trouble Shooter

How to Export GSTR-2 data in MS Excel?

To export GSTR-2 returns Data in the MS Excel follow the steps below :

Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2

Make sure that there are no items under the section Not included in returns due to incomplete information

            


If you have tried to do the reconciliation of purchase invoices in Tally, reset the status of all invoices to New. To do this, open the invoices in B2B section, select all invoices and click on Set Status button on the right.

            

Click Export Return and select Excel export format and set Export unreconciled invoices to Yes.

            



Hope this helps.
    • Related Articles

    • How to Export GSTR-1 Return in MS Excel?

      To export GSTR-1 returns in the MS Excel follow the steps below : Steps 1 : Gateway of Tally > Display > Statutory Reports > GST > GSTR-1. Alternatively, Press Alt+G (Go To) > Type Here or Search GSTR-1 > Press Enter. Step 2 : F2: Period: Select the ...
    • Invoice & other data upload for creation of GSTR 1

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. B2B B2B Supplies ...
    • How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

      Solution: Step 1: Login on GST Software Application. Step 2: Select Company, Financial Year, Filing Type as GSTR-1 and Tax Period and then Go to Proceed.              Step 3: Here Click on - Download Sample Template.              Step 4: Once the ...
    • Invoice & other data upload for creation of GSTR 2 in Express GST | GST Filing

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. b2b B2B Supplies - ...
    • XML Tally Data Import - Tally Prime

      To import Trial Balance using XML Tally through Tally Prime, you are requested to please export the Trial Balance and List of account from Tally Prime application and then import the same in Zen IT Software. To Export Trial Balance using Tally Prime ...