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.
I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. https://www.buyyoutubesubscribers.in/
ReplyDeleteGreat Article !! Compare Best Trading App in India 2021 list of top 10 best Stock Trading App review of Top 10 Best online Stock Trading App providers in India
ReplyDeleteCamel milk is high in a variety of nutrients that are beneficial to one's general health.
ReplyDeleteCamel milk is equivalent to full cow's milk in terms of calorie, protein, and glucose content. It does, however, have a reduced saturated fat content and provides more vitamin C, B vitamins, calcium, iron, and potassium.
It's also high in beneficial fats including long-chain fatty acids, linoleic acid, and unsaturated fatty acids, all of which can help with brain and heart health.