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. 

1. If purchase entry passed in the previous date.
2. If purchase entry date/month changed.
3. If any stock items/stock group GST Percentage changed.
4. If Supplier GST Registration Type changed
5. If Supplier State Name changed
6. If any Debit Note issued in a previous date etc.,

Follow the following steps to export GSTR-3B ITC details.

• 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

Posted by Accounting & Taxation at 1:11 AM

Labels: Tally, Tally GSTR-3B