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 ...