Monday, January 18, 2021

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.

From Gateway of Tally select  Display
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 CutkeyAlt+F2)
Enter Required Month Start and End Date
Eg:From 1.10.2020 To 31.10.2020

Two Types of Views GSTR-3B is available in Tally

  • 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
Press Enter

Save this excel file

gstr-3b exported excel file in tally


2 comments:

  1. Very informative article..

    Get the best term insurance plan in India 2021 at an affordable price with easy online process.

    ReplyDelete
  2. 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/

    ReplyDelete

Copyright © 2015 accounting tally taxation tutorials All Right Reserved
Subscribe by Email Get Free Updates
Don't Forget To Join US Our Community
×
blogger