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

How to import vouchers, transactions excel into tally erp.

Manjunath (Articleship completed) (54 Points)

17 December 2015

i have stored full invoices, bank statements list, reciepts, payments inforamtion in excel format. we have to create or update in tally erp. it takes us time of days

i heard that possible by convertinginto into X M L or excel special format can be import to tally erp. manually.. ready made softwares suggested some of them, can possible without ready made softwares.

please give me any information if anybody have regarding above query.

thank you..dear friends & professionals.

Reply
Follow
Share

4 Replies

Manjunath (Articleship completed) (54 Points)
Replied 17 December 2015

Originally posted by : Manjunath
	i have stored full invoices, bank statements list, reciepts, payments inforamtion in excel format. we have to create or update in tally erp. it takes us time of days i heard that possible by convertinginto into X M L or excel special format can be import to tally erp. manually.. ready made softwares suggested some of them, can possible without ready made softwares. please give me any information if anybody have regarding above query. thank you..dear friends & professionals.

Upgrade to CAclubindia Pro. Subscribe Now!

PRASHANT JAGTAP (TAX CONSULATANT) (24 Points)
Replied 05 January 2016

Dear Manjunath,

You will need to buy a third party software, which will help you import excel data into tally erp.The said third party softwares are available at https://www.exceltotally.in/ site.

Excel Intally (1 Points)
Replied 14 February 2016

Hello,

It is possible and very easy. We have developed excel based utility to import all voucher types from Excel to Tally.

Plz visit www.excelintally.in to download free demo.

Regards

Hitesh Khandhadia

EXCELINTALLY.in

Work Smart, Work Excellently

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: