Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

How to import data from excel to tally

CA Jenish Vira (Bureau Veritas) (75 Points)

29 March 2017

How can I import sales data from Excel to Tally ? The same should support Master & Ledger import.

If any one come across the solutions let me know.

Thanks in Advance.

Reply
Follow
Share

3 Replies

Ankeet (No) (118 Points)
Replied 19 April 2017

Hi Jenish,
You can import your Excel Sales Data and Masters from Excel to Tally with EazyAUTO4 Excel to Tally Data Converter.
You can DOWNLOAD this from https://www.exceltotally.in/download.php?id=Auto4Setup

Upgrade to CAclubindia Pro. Subscribe Now!

Dhaval Goradia (26 Points)
Replied 19 May 2017

Hi Jenish,

visit www.excel2tally.in and sign up for 30 Day's free trial.

it practically imports all masters & vouchers from Excel to Tally.

Listed by Tally Solutions Pvt Ltd

Shri Mathur (CA) (8 Points)
Replied 03 November 2022

There are many ways to import bank statements, vouchers and masters in Tally. Also there are different banks having different statement formats. You have to use third party tool utility to import Bank statements, vouchers and masters in Tally 9, ERP, Prime, from Excel or PDF.

You can use this Free Utility Click - www.nikash.in | www.xltally.in | www.xltool.in

How to import data in Tally -

Voucher and Master in the XML format can be imported into Tally using the Import Vouchers and Master option. You can import vouchers from one company to another in Tally. Some of the scenarios are: