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


  1. Very informative article..

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

  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.

  3. Camel milk is high in a variety of nutrients that are beneficial to one's general health.
    Camel 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.

  4. one can easily get profit from share market, we have written a complete article about Benefits of Investing in Stock Market

  5. Interesting 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


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