How to Connect Tally with Excel to Get GST Summary | Tally to Excel GST Summary | Tally Prime to Excel Data Import | Tally to Excel Power query

Spread the love

Always required Excel in a business or accounting to maintain books of income, expenses and taxes etc. Excel is most usable software for calculations/presentations for a business. And also lots of businesses use Tally to maintain books properly. If it possible to connect Tally with Excel to fetch Tally Data into Excel then our most of  problems will be solved. This Tally to Excel data import method will be “Sanjeevani” for CA and accountants. 
So this can possible through Excel Power Query and Tally ODBC connectivity. To Import Tally Data into Excel most powerful and fastest way is Excel Power BI. We can import any report of Tally directly into excel through this Power BI method. 
After reading this post you will be able to import GST summary from Tally to Excel and can refresh it every time after any changes.

Required Tools/Codes to connect Tally with Excel:
Follow below Steps to Import Data from Tally to Excel:
  • Open Tally and Excel
  • Go to Excel Data Tab – New Query – From Other Source – Blank Query
  • We can change Query Name in properties section at right hand side.
  • Go in Home Tab and in Advance Editor
  • Paste Below Code in Advance Editor:
    url = "http://localhost:9000",
    _body = "<ENVELOPE>
    FromDate = Date.ToText(#date(2022, 04, 01)),
    ToDate = Date.ToText(#date(2022, 04, 02)),
    body = Text.Replace(Text.Replace(_body, "DATE1", FromDate), "DATE2", ToDate),
    Source = Csv.Document(Text.Replace(Text.FromBinary(Web.Contents(url, [Content=Text.ToBinary(body, TextEncoding.Utf16), Headers=[#"Content-Type"="text/xml;charset=utf-16"]]), TextEncoding.Utf16), ",#(cr,lf)", "#(cr,lf)"), { "Particulars", "GSTIN", "Invoice Number","Date", "Document Type", "Invoice Value","Place of Supply", "Note Number", "Note Date","Status","Taxable Value","IGST Amt","IGST Eligible Amt","CGST Amt","CGST Eligible Amt","SGST Amt","SGST Eligible Amt","Cess Amt","Cess Eligible Amt"})
  • After pasting above code in advance editor press Done
  • Now you can see Tally reports in Excel Power query home
  • Go to Home Tab – Click on “Close and Load” or “Close and Load to…”
  •  If select Close and Load to… then you can choose Excel reference sheet and cell to show Data.
  • Now you will find all your Tally data to related reports in Excel.
  • Refresh Excel sheet to recollect data from Tally
  • Change Date in Power query Advance editor code as per your requirement.

Watch above video for more details.
How to See and enable Tally ODBC Port : Click Here

  • Ultimate Ecommerce Reconciliation

    Spread the loveWith this automatic Ultimate Ecommerce Reconciliation utility we can reconcile all type E-commerce platforms (Amazon, Flipkart, Meesho, Myntra etc.) sales with there payments. We can reconcile all data order wise and stock item wise with one click. Also try Excel to Tally Ultimate Ecommerce Import This Ultimate Ecommerce Reconciliation utility has below features: … Read more

  • 2023 Best Tally TDL to See Party Wise and Product Wise Sale Report

    Spread the loveThis Tally TDL to See Party Wise and Product Wise Sale Report will help to see which item you sold more and which item you sold less. And same also can see which customer buy which items more and which customer buy which item less. We all know Tally is a popular accounting … Read more

  • 7 Most Innovative Business Ideas (2023) You Can Start with Rs. 1 Lakh | 7 Best Businesses That Can be Started in 1 Lakh

    Spread the loveStarting a business can be a daunting task, especially if you don’t have a lot of money to invest. But don’t let that discourage you. You need capital, an idea, and most importantly, the willingness to take risks and make mistakes. If you have the necessary resources, Rs. 1 lakh can be enough … Read more