how to save or export gstr 3b purchase and ITC details in excel format
After filing the GSTR-3B returns, you must save the Total Month Purchase details in excel file. Because After filing GSTR-3B returns, by mistake if you will make any the following changes in tally, the TAXABLE VALUE & INPUT VALUE also change in Monthly GSTR-3B Reports.
- If purchase entry passed in the previous date.
- If purchase entry date/month changed.
- If any stock items/stock group GST Percentage changed.
- If Supplier GST Registration Type changed
- If Supplier State Name changed
- If any Debit Note issued in a previous date etc.,
Follow the following steps to export GSTR-3B ITC details.
From Display: Select StatutOry Reports
From Statutory Reports: Select GST
From GST Reports: Select GSTR-3B
From Right Side Panel Click on F2: Period (Short Cutkey: Alt+F2)
Enter Required Month Start and End Date:
Eg:From 1.10.2020 To 31.10.2020
- GSTR-3B Summary View in tally
- GSTR-3B Return Format View in tally
Select Return Format View from Left side panel
Clcik on F1: Detailed from Left side panel
Clcik on 4 Eligible ITC, then click on (5) All other ITC and also others (Eg: 1 to 4 if you have any ITC)
![]() |
gstr-3b ITC details in tally |
Now tally shows Selected Month details i.e Invoice date, supplier name and GST No, Taxable Value, IGST, CGST, SGST, CESS, Total Tax.
![]() |
gstr-3b ITC details in tally |
click on E: Export button on TOP Panel.
click on backspace and set as follows:
![]() |
gstr-3b exported excel file configuration in tally |
- Language : Default (All Languages)
- Format: Excel (Spredsheet)
- Export Location: Enter Export Location
- Out file Name: GSTR-3B OCT.xlsx
- Output sheet name:Voucher Register
- Update existing file: No
- Excel (Spreadsheet) formatting: Yes
- with colour: No
- Open Exported File: Yes
Save this excel file
![]() |
gstr-3b exported excel file in tally |
Very informative article..
ReplyDeleteGet the best term insurance plan in India 2021 at an affordable price with easy online process.