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/
ReplyDeleteInteresting stuff guys. Now almost in all the countries of world prefer to buy products online to save time as well as the money. I also prefer digital portals for saving time instead of visiting the market. To carry out diagnostics, it is worth using a set of available guts(.)pk/ auxiliary tools: statistics and web analytics, financial and accounting reports, balanced scorecard, SWOT analysis. Thanks for it
ReplyDelete